Database Administrator (DBA) – Oracle atlanta, dallas

ESRhealthcare and EXEC STAFF RECRUITERS•Atlanta, GA

6d•Onsite

About The Position

This role is for an L2 Database Administrator (DBA) with a focus on Oracle databases. The position requires hands-on experience in administering Oracle databases in production environments, covering instance startup/shutdown, parameter tuning, and routine operational maintenance. The DBA will be responsible for RMAN backups, restore operations, archive log management, optimizer statistics gathering, and scheduled health checks. They will also perform diagnostics and remediation for common availability and performance issues, and execute approved Oracle changes following documented procedures. Experience with ITSM processes using ServiceNow, performance monitoring and tuning (AWR/ASH analysis, slow SQL identification), and supporting Oracle security and audit activities are key aspects of this role. The position involves supporting backup validation, restore activities, and disaster recovery exercises under L3 guidance.

Requirements

Hands-on experience administering Oracle databases in production environments.
Experience with instance startup/shutdown, parameter tuning, and routine operational maintenance.
Strong working knowledge of RMAN full and incremental backups, restore operations, and archive log management.
Experience with optimizer statistics gathering and scheduled health checks.
Ability to perform routine Oracle health diagnostics and remediation.
Ability to execute approved Oracle changes (installations, upgrades, PSU/patch application, configuration updates) by following documented runbooks, validation steps, and rollback procedures.
Working understanding of ITSM processes using ServiceNow, including Incident, Problem, Change, and Request Management.
Accurate ticket documentation and timely escalation to L3 Oracle DBAs.
Practical experience with Oracle performance monitoring and basic tuning, including AWR/ASH analysis, slow SQL identification, wait-event diagnostics, and monitoring CPU, memory, and I/O contention.
Ability to package and escalate complex SQL, optimizer, and performance issues to L3 DBAs with relevant diagnostics and supporting analysis.
Hands-on execution of Oracle backup validation and restore activities.
Experience supporting Oracle security operations, including user and role management, privilege administration, password and profile enforcement, and execution of approved security controls.
Experience supporting audit and compliance activities for Oracle environments, including evidence collection, remediation execution, and controlled documentation updates.

Nice To Haves

Support for recovery and disaster recovery exercises under L3 guidance.

Responsibilities

Administer Oracle databases in production environments, including instance startup/shutdown, parameter tuning, and routine operational maintenance.
Perform RMAN full and incremental backups, restore operations, and archive log management.
Gather optimizer statistics and conduct scheduled health checks.
Perform routine Oracle health diagnostics and remediation, identifying and addressing risks related to tablespace and storage growth, database integrity, availability, and performance.
Execute approved Oracle changes (installations, upgrades, PSU/patch application, configuration updates) by following documented runbooks, validation steps, and rollback procedures.
Utilize ITSM processes in ServiceNow for Incident, Problem, Change, and Request Management, ensuring accurate ticket documentation and timely escalation to L3 Oracle DBAs.
Monitor Oracle performance and perform basic tuning, including AWR/ASH analysis, slow SQL identification, wait-event diagnostics, and monitoring CPU, memory, and I/O contention.
Package and escalate complex SQL, optimizer, and performance issues to L3 DBAs with relevant diagnostics and supporting analysis.
Execute Oracle backup validation and restore activities, supporting recovery and disaster recovery exercises under L3 guidance.
Support Oracle security operations, including user and role management, privilege administration, password and profile enforcement, and execution of approved security controls.
Support audit and compliance activities for Oracle environments, including evidence collection, remediation execution, and controlled documentation updates.