Oracle DBA - Part-time

Revel It - Columbus, OH

Part-time - Mid Level

Columbus, OH

Professional, Scientific, and Technical Services

About the position

The Oracle Database Administrator (DBA) position is a part-time contract role focused on managing and supporting Oracle databases in a mixed technology environment. The DBA will work collaboratively with both technical and business teams to deliver data products that support decision-making for the organization. The ideal candidate should be self-motivated, eager to learn, and capable of handling various database administration tasks, including troubleshooting, performance tuning, and ensuring data integrity.

Responsibilities

• Deploy, configure, patch and upgrade database servers and client installs, focusing on Oracle server production support.
• Troubleshoot and fix problems, providing root cause analysis in a timely manner.
• Perform preventive maintenance and system copies.
• Automate system maintenance tasks.
• Develop, manage and test backup and recovery plans.
• Ensure storage and archiving processes are functioning correctly.
• Write database documentation, including data standards, procedures, and data dictionary.
• Carry out capacity planning.
• Manage security and disaster recovery aspects of a database.
• Evaluate SQL Server performance and take appropriate steps for performance improvement.
• Provide 24/7 on-call support, including after hours and weekend work as needed.
• Relational database design and development.
• Design OLTP and OLAP environments, monitoring, detecting, and tuning performance.
• Complete other tasks as required.

Requirements

• 5-6+ years of experience building and administering production level high performance, high transaction volume, and highly available OLTP databases (Oracle and/or SQL Server).
• 5-6+ years of experience developing, maintaining, and implementing logical and physical data models and PL/SQL or T-SQL solutions in support of complex software development projects.
• 5-6+ years of experience designing and implementing large-scale ETL processes, including data initialization, loading, and conversion.
• 5-6+ years of experience creating and maintaining database documentation and diagrams.
• 3+ years of experience conducting performance monitoring and tuning operations.
• 3+ years of experience administering database security protocols.
• Knowledge of current DBMS products, primarily Oracle 11g and 12c and SQL Server 2014+, as well as knowledge of related technologies, applications, and processes.
• Ability to write clear, concise, efficient, and effective DDL, DML, and PL/SQL or T-SQL.
• Knowledge of relational database internals, objects, and processes, as well as best practice principles regarding availability, performance, and security.
• Experience working with high availability tools, particularly DataGuard or AlwaysOn.
• Experience installing OEM and configuring to monitor Oracle instances.
• Experience writing shell scripts to automate database activities.
• Demonstrated skill using database backup and recovery models, utilities, and best practices.
• Bachelor's Degree in Computer Science or a related technical discipline, or the equivalent combination of education, technical training, and work experience.
• Familiar with Agile development methodology.
• Excellent analytical skills.
• Excellent interpersonal skills and proficiency to meet face to face with internal business customers.
• Ability to manage multiple, shifting-priority projects.

Nice-to-haves

• Safe, LeSS, or Modern Agile experienced individuals (Culture of Lean/Scrum/XP methods).
• Ability to work in the context of waterfall IT controls.
• Familiar with InfoSec control levels.