Need Local to New York or New Jersey only.
Role: Oracle DBA with GoldenGate experience
Location : 4 Irving Place New York, New York 10003 (Hybrid)
Position type : Contract
Project Duration : Long Term
Detailed JD :
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.
Looking forward to work with you!
Thanks & Regards
Lokesh Yadav
Sr. Technical Recruiter
CloudThink Tech Inc
