Oracle DBA

Polar IT Services•Elkridge, MO

5d•Hybrid

About The Position

The Oracle DBA installs, configures, and administers Oracle databases (11g, 12c, and 19c) across development, test, UAT, and production environments on Linux/Unix platforms. The role handles database creation, configuration, cloning, deletion, decommissioning, storage management, and routine maintenance. The DBA designs and executes backup and recovery strategies using RMAN, including restores and point-in-time recovery, and tests procedures to support disaster recovery readiness. The role monitors and tunes database performance using AWR, ADDM, ASH, OEM, and performance views, addressing issues involving CPU, memory, I/O, SQL, indexing, statistics, and initialization parameters. The position implements and supports Oracle RAC and Data Guard high-availability and disaster-recovery solutions, including failover and switchover operations, DR drills, and business continuity testing. It also manages database security and compliance, applies patches and upgrades, supports migrations, and provides production incident response and root-cause analysis. The DBA coordinates with application, infrastructure, system, and network teams; automates routine tasks with shell scripting where applicable; maintains operational documentation; and participates in 24x7 on-call support. The role is hybrid and requires the candidate to be in the Saint Louis area. The position must be on the employer's W-2.

Requirements

Experience administering Oracle databases, specifically versions 11g, 12c, and 19c.
Experience with Oracle databases on Linux/Unix platforms.
Experience using RMAN for backup, restore, and recovery, including point-in-time recovery.
Experience monitoring and tuning database performance with AWR, ADDM, ASH, and OEM.
Experience with Oracle RAC and Data Guard, including failover and switchover operations.
Knowledge of Oracle database security, including users, roles, profiles, privileges, auditing, password policies, and access controls.
Experience applying Oracle patches, CPUs, and PSUs and performing version upgrades and migrations.
Ability to troubleshoot production incidents and perform root-cause analysis.
Ability to participate in 24x7 on-call support and rotations.
Must be located in the Saint Louis area.
Must work on the employer's W-2.

Responsibilities

Install, configure, and administer Oracle databases (11g, 12c, and 19c) on Linux/Unix platforms across development, test, UAT, and production environments.
Create, configure, clone, delete, and decommission databases.
Manage tablespaces, datafiles, redo logs, archive logs, control files, storage growth, and routine housekeeping.
Monitor database health and availability and proactively identify and resolve issues.
Design and execute RMAN backup and recovery operations, including restores and point-in-time recovery, and regularly test procedures for disaster recovery readiness.
Manage archive log retention and ensure backup and recovery readiness.
Monitor and tune database performance using AWR, ADDM, ASH, OEM, and performance views; address CPU, memory, I/O, SQL, indexing, statistics, and initialization parameter issues.
Implement and support Oracle RAC and Data Guard high-availability and disaster-recovery solutions.
Perform planned and unplanned Data Guard failover and switchover operations, and support DR drills and business continuity testing.
Manage database users, roles, profiles, privileges, auditing, password policies, access controls, and security compliance.
Apply Oracle security patches, CPUs, and PSUs; perform version upgrades and platform or database migrations.
Troubleshoot production incidents, perform root-cause analysis, and implement preventive measures.
Provide 24x7 on-call support for critical production databases and participate in on-call rotations.
Coordinate with application, infrastructure, system, and network teams during releases, deployments, outages, and complex issue resolution.
Automate routine DBA tasks using shell scripting where applicable.
Maintain DBA documentation, SOPs, runbooks, and operational documentation.
Follow change-management and release processes.