Oracle Golden Gate DBA L3

Dallas, IA - USA

Monthly Salary: Not Disclosed

Posted on: 3 hours ago

Vacancies: 1 Vacancy

Job Summary

Essential Skills and Competencies:

Minimum 8 Yrs. relevant experience on Oracle 18c/19c Database Administration

Candidate should be able to quickly understand and resolve issues mitigate risks and dependencies and the ability to drive projects and resources to completion

Excellent verbal and written communication presentation and documentation skills.

Strong hands-on experience with Oracle Golden Gate installation configuration monitoring and troubleshooting in production environments.

Willing to work in 24x7 environment with Rotational Shifts.

Actively participate in service improvement plans.

Should be able to drive the critical issues and effectively communicate over the calls.

Should be ready to work as On-call as per the requirement.

Responsibilities:

Install configure and administer Oracle Golden Gate (Classic and Microservices architecture) for real-time data replication synchronization and database migrations across on-premises and hybrid environments.

Manage Golden Gate deployments using the Administration Server Service Manager and Performance Metrics Service within the microservices framework.

Monitor troubleshoot and optimize Golden Gate processes to resolve issues such as replication lag data conflicts and process failures.

Implement performance tuning and parallel replication strategies to enhance throughput and replication efficiency.

Collaborate closely with Oracle database environments including RAC ASM Data Guard Exadata and OEM to ensure high availability and consistency of replicated data.

Utilize AWR ADDM and other performance tools to analyze and improve database and replication performance.

Implement configure and maintain Data Guard and RAC environments handling day-to-day administration and troubleshooting.

Use Data Pump (Export/Import) utilities for database migration and data management tasks.

Develop and maintain shell scripts for reporting automation and Golden Gate monitoring.

Design and implement heterogeneous replication between Oracle and non-Oracle databases using Golden Gate Microservices.

Contribute to performance optimization troubleshooting and capacity planning of high-volume replication systems.

Required Skills:

Strong experience with Oracle Golden Gate (Classic and Microservices architectures).

Expertise in replication setup tuning conflict resolution and parallel processing.

In-depth understanding of Oracle RAC ASM Data Guard Exadata and related technologies.

Proficiency in database performance tuning (AWR ADDM) and exposure to OEM monitoring.

Hands-on experience with Oracle 18c/19c installation and administration.

Knowledge of shell scripting and automation frameworks.

Experience working in heterogeneous database environments.

Technical Skills Secondary:

Prior experience of working in a DevOps / Agile environment will be an advantage.

Working knowledge on tool JIRA.

Essential Skills and Competencies: Minimum 8 Yrs. relevant experience on Oracle 18c/19c Database Administration Candidate should be able to quickly understand and resolve issues mitigate risks and dependencies and the ability to drive projects and resources to completion Excellent ver...