Oracle DBA-GoldenGate Focus - Hybrid NYC

job summary:
Oracle DBA-GoldenGate Focus

JOB DESCRIPTION

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 Replicate 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.

location: New York, New York
job type: Contract
salary: $75 - 77 per hour
work hours: 9am to 5pm
education: Bachelors

responsibilities:
Oracle DBA-GoldenGate Focus

JOB DESCRIPTION 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.

qualifications:
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.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [email protected].


Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.