Oracle DBA with Oracle GoldenGate (OGG)-ONSITE-W2 role

Oracle DBA- GoldenGate Focus

Location : New York, NY - ONSITE

We are currently able to consider Only W2 candidates for this role.

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 247 system support.

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 Google Cloud Platform.
• Experience contributing to design discussions and continuous improvement initiatives

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