We are seeking a highly skilled Oracle DBA with strong GoldenGate expertise to support mission-critical enterprise data replication, database administration, and cloud integration initiatives..
Key Responsibilities
Lead deployment, administration, tuning, and troubleshooting of Oracle GoldenGate (19.x / 21.x) in large-scale production environments.
Configure and manage Extract, Pump, and Replicat processes for uni-directional and bi-directional replication.
Design and maintain full-load + CDC pipelines from Oracle to GCS and BigQuery.
Implement file-based ingestion using Avro, Parquet, JSON and manage MERGE operations.
Support Zero-Downtime Migration (ZDM) strategies and GoldenGate HA architecture.
Administer Oracle databases (11gR2, 12c, 19c) including:
Grid Infrastructure
RAC
ASM / ACFS
Performance tuning
Production support
Manage backups and recovery using ZDLRA, RMAN, incremental-forever strategies.
Analyze performance using AWR, ASH, ADDM, trace files, logs, JVM diagnostics.
Configure and troubleshoot replication between Oracle and MS SQL Server.
Support DR planning and testing across on-prem and hybrid environments.
Prepare dashboards, metrics, and performance trend analysis.
Collaborate with infrastructure, cloud, networking, and application teams.
Participate in on-call rotation for production support.
Required Experience
5+ years Oracle DBA experience in production environments.
3+ years hands-on Oracle GoldenGate (19.x / 21.x).
Strong CDC-based replication and high-availability architecture expertise.
Experience delivering GoldenGate data into GCS and BigQuery.
Strong knowledge of ZDLRA, RMAN, enterprise backup & recovery.
Strong SQL / PL-SQL and Linux/Unix administration skills.
Experience troubleshooting large-scale distributed replication environments.
Excellent communication and documentation skills.
Preferred Qualifications
Experience with OCI GoldenGate or cloud-managed replication services.
Knowledge of hybrid architectures (On-Prem, OCI, Google Cloud Platform).
Experience contributing to architecture/design discussions.
Experience in continuous improvement initiatives.