Oracle Golden Gate DBA

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

Job summary

CTC in Dallas, TX is seeking an experienced Oracle Database Administrator to install, configure, and manage Oracle Golden Gate in both Classic and Microservices architectures. You will monitor replication, backfill changes, and optimize high-availability environments.

The role requires 8+ years in Oracle DB administration, hands-on experience with RAC/ASM/Data Guard, and scripting for automation. You will work in a 24x7 environment with rotating shifts and partner with application teams on data

Qualifications

• Minimum 8+ years of relevant experience in Oracle Database Administration.

Responsibilities

• Install, configure, and administer Oracle Golden Gate (Classic and Microservices architecture) for real-time data replication.

Skills

Oracle DB Administration

Oracle 19c

Golden Gate

Golden Gate installation

RAC

ASM

Data Guard

OEM monitoring

AWR

ADDM

Shell scripting

Automation frameworks

Communication skills

24x7 shift readiness

Issue resolution

Team collaboration

Tools

JIRA

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