Job Description
Skill: Oracle DBA
- The Oracle DBA role focuses on administering, securing, optimizing, and supporting enterprise-scale Oracle database environments, with strong emphasis on high availability, disaster recovery, performance, and production reliability.
Core Technical Requirements
- Oracle Database: 12c, 19c and/or 21c
- High Availability: Oracle RAC, Clusterware, ASM
- HA/DR: Data Guard, Active Data Guard, failover and switchover
- Performance: AWR, ADDM, ASH, execution plans, SQL tuning, indexing and optimizer statistics
- Backup & Recovery: RMAN, point-in-time recovery, restoration and DR testing
- Security: TDE, encryption, auditing, privileges, roles and database hardening
- Migration/Replication: GoldenGate, Data Pump and RMAN cloning
- Automation: Shell scripting, Python and/or Ansible
- Monitoring: Oracle Enterprise Manager (OEM)
- Platform: Strong Linux/Unix skills
- Preferred: Oracle Exadata and exposure to OCI, AWS RDS for Oracle, or Oracle workloads on Azure
Key Responsibilities
- The DBA will manage Oracle databases across development, test, staging and production, including:
- Installation, configuration, patching and upgrades
- RAC, ASM and Data Guard administration
- Backup, recovery and disaster-recovery management
- Database and SQL performance tuning
- Capacity, storage, tablespace and archive-log management
- Security, auditing, encryption and privileged-access controls
- Database refreshes, cloning, migration and replication
- Critical production troubleshooting and RCA
- HA/DR testing and recovery exercises
- DBA task automation
- Cross-functional collaboration with application, infrastructure, storage, network, security and cloud teams
- 24x7/on-call production support where required
- Maintaining standards, runbooks and architecture documentation
- Mentoring less-experienced DBAs and conducting technical/design reviews
Salary Range - $100,000-$120,000 a year
Location
Pittsburgh, PA
Function
TECHNOLOGY
Role
Engineer
ID
439590
Skills
Oracle
Salary Range
$100,000 - $120,000
Desired Candidate Profile
Qualifications BACHELOR OF COMPUTER SCIENCE
|