Oracle DBA-GoldenGate Focus Hybrid NYC

Oracle DBA-GoldenGate Focus

We are seeking a highly skilled Oracle GoldenGate focused Oracle DBA Contractor to support mission-critical enterprise data replication database administration and cloud integration initiatives. This role centers heavily on GoldenGate engineering real-time data movement and high-availability operations across on-prem and cloud platforms including data delivery into Google Cloud Storage (GCS) and BigQuery. The contractor will also support Oracle database environments contribute to architectural improvements and participate in a scheduled on-call rotation to ensure 24 7 system support.

Responsibilities

- Lead the deployment administration tuning and troubleshooting of Oracle GoldenGate (19.x/21.x) in large-scale production environments.

- Configure and support GoldenGate Extract Pump and Replicat processes for uni-directional and bi-directional replication.

- Design and maintain full-load CDC data pipelines from Oracle to GCS and into BigQuery including file-based ingestion (Avro/Parquet/JSON) and MERGE operations.

- Support Zero-Downtime Migration (ZDM) strategies and GoldenGate high-availability architectures.

- Administer Oracle databases (11gR2 12c 19c) including Grid Infrastructure RAC ASM/ACFS performance tuning and production operations.

- Work with ZDLRA (Zero Data Loss Recovery Appliance) for backup recovery incremental-forever strategies and real-time redo transport.

- Analyze performance issues using AWR ASH ADDM trace files logs and JVM diagnostics (heap GC thread dumps).

- Configure and troubleshoot replication involving Oracle and MS SQL Server.

- Support DR planning and testing across on-prem OCI and hybrid environments.

- Prepare operational dashboards metrics charts and trend analysis for capacity and performance.

- Collaborate closely with infrastructure networking cloud and application development teams.

- Participate in an on-call rotation for production support during evenings/weekends.

Required Experience

- 5 years Oracle DBA experience supporting production environments.

- 3 years hands-on GoldenGate experience (19.x or 21.x).

- Strong expertise with CDC-based replication and high-availability architectures.

- Experience delivering Oracle GoldenGate data into GCS and BigQuery.

- Experience with ZDLRA RMAN and enterprise-grade recovery operations.

- Strong SQL/PLSQL Linux/UNIX and performance tuning skills.

- Experience troubleshooting large-scale distributed data replication environments.

- Excellent communication documentation and incident-response skills.

Preferred Skills

- Experience with OCI GoldenGate or cloud-managed replication services.

- Knowledge of hybrid data architectures involving On-Prem OCI and GCP.

- Experience contributing to design discussions and continuous improvement initiatives.

Required Skills :

Basic Qualification :

Additional Skills :

Background Check : No

Drug Screen : No