← Back to jobs

Avance Consulting Logo
Oracle DBA

Avance Consulting

 

Pittsburgh, PA, USA

Posted On: Just posted
Experience: 10+ years
Availability: Onsite
Openings: 1
Category: Oracle DBA
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

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

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs