Oracle Golden Gate DBA

CTC; Dallas (TX); On-site; USD 115,000 - 170,000; Full time

Job summary

CTC is seeking an experienced Oracle DBA to install, configure, and manage Oracle GoldenGate (Classic and Microservices) for real‑time data replication in a high‑availability environment.

You will monitor, troubleshoot, and optimize GoldenGate processes, backfill modifications, and develop shell scripts for automation and reporting. Collaboration with application teams is essential to meet replication requirements and ensure performance targets.

Qualifications

• Minimum 8+ Yrs. relevant experience in Oracle Database Administration.

Responsibilities

• Install, configure, and administer Oracle GoldenGate (Classic and Microservices architecture) for real‑time data replication.

Skills

Oracle DBA

Golden Gate

Oracle 19c

RAC

Data Guard

Shell scripting

ADDM/AWR

OEM monitoring

DevOps

Communication

Tools

JIRA

Oracle OEM

Job description

Essential Skills and Competencies:

• Minimum 8+ Yrs. relevant experience in Oracle Database Administration
• Hands‑on experience with Oracle 19c installation and administration
• Strong experience with Oracle Golden Gate (Classic and Microservices architectures)
• Strong hands‑on experience with Oracle Golden Gate installation, configuration, monitoring, and troubleshooting in production environments
• Experience with Oracle database environments including RAC, ASM, Data Guard, Exadata, and OEM to ensure high availability and consistency of replicated data
• Strong experience with Oracle Data Pump (Export/Import) utilities
• Proficiency in database performance tuning (AWR, ADDM) and exposure to OEM monitoring
• Excellent verbal and written communication, presentation and documentation skills
• Willing to work in 24x7 environment with rotational shifts
• Knowledge of shell scripting and automation frameworks
• Candidate should be able to quickly understand and resolve issues, mitigate risks and dependencies and the ability to drive assignments to completion

Responsibilities:

• Install, configure, and administer Oracle Golden Gate (Classic and Microservices architecture) for real‑time data replication
• Monitor, troubleshoot, and optimize Golden Gate processes to resolve issues such as replication lag, data conflicts, and process failures
• Instantiate new tables and backfill table modifications in a replicated environment
• Develop and maintain shell scripts for reporting, automation, and Golden Gate monitoring
• Contribute to performance optimization, troubleshooting, and capacity planning of high-volume replication systems
• Utilize AWR, ADDM, and other performance tools to analyze and improve database and replication performance
• Implement performance tuning to enhance throughput and replication efficiency
• Implement, configure, and maintain Data Guard and RAC environments, handling day‑to‑day administration and troubleshooting.
• Coordinate with application teams on new data replication requirements and modifications to existing data replication processes
• Attend DBA team meetings and follow Oncor standard DBA practices

Secondary skills:

• Prior experience of working in a DevOps / Agile environment
• Working knowledge of JIRA is a plus
• Experience working in heterogeneous database replication environments is a plus
• Cloud experience is a plus