Oracle DBA - GoldenGate - New York, NY
Full Time • Fully Remote - US
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.
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.
This is a remote position.
Compensation: $60.00 per hour
About Us
AHU Technologies INC. is an IT consulting and permanent staffing firm that meets and exceeds the evolving IT service needs of leading corporations within the United States. We have been providing IT solutions to customers from different industry sectors, helping them control costs and release internal resources to focus on strategic issues.
AHU Technologies INC. was co-founded by visionary young techno-commercial entrepreneurs who remain as our principal consultants. Maintaining working relationships with a cadre of other highly skilled independent consultants, we have a growing number of resources available for development projects. We are currently working on Various projects such as media entertainment, ERP Solutions, data warehousing, Web Applications, Telecommunications and medical to our clients all over the world.
(if you already have a resume on Indeed)