Job Description

Job Summary

Oracle Golden Gate DBA – L3\\r\\nEssential Skills and Competencies:\\r\\n• Minimum 8+ Yrs. relevant experience on Oracle 18c/19c Database Administration\\r\\n• Candidate should be able to quickly understand and resolve issues, mitigate risks and dependencies\\r\\nand the ability to drive projects and resources to completion\\r\\n• Excellent verbal and written communication, presentation and documentation skills.\\r\\n• Strong hands-on experience with Oracle Golden Gate installation, configuration, monitoring,\\r\\nand troubleshooting in production environments.\\r\\n• Willing to work in 24x7 environment with Rotational Shifts.\\r\\n• Actively participate in service improvement plans.\\r\\n• Should be able to drive the critical issues and effectively communicate over the calls.\\r\\n• Should be ready to work as On-call as per the requirement.\\r\\nResponsibilities:\\r\\n• Install, configure, and administer Oracle Golden Gate (Classic and Microservices\\r\\narchitecture) for real-time data replication, synchronization, and database migrations\\r\\nacross on-premises and hybrid environments.\\r\\n• Manage Golden Gate deployments using the Administration Server, Service Manager,\\r\\nand Performance Metrics Service within the microservices framework.\\r\\n• Monitor, troubleshoot, and optimize Golden Gate processes to resolve issues such\\r\\nas replication lag, data conflicts, and process failures.\\r\\n• Implement performance tuning and parallel replication strategies to enhance throughput and\\r\\nreplication efficiency.\\r\\n• Collaborate closely with Oracle database environments including RAC, ASM, Data Guard,\\r\\nExadata, and OEM to ensure high availability and consistency of replicated data.\\r\\n• Utilize AWR, ADDM, and other performance tools to analyze and improve database and\\r\\nreplication performance.\\r\\n• Implement, configure, and maintain Data Guard and RAC environments, handling day-to-day\\r\\nadministration and troubleshooting.\\r\\n• Use Data Pump (Export/Import) utilities for database migration and data management tasks.\\r\\n• Develop and maintain shell scripts for reporting, automation, and Golden Gate\\r\\nmonitoring.\\r\\n• Design and implement heterogeneous replication between Oracle and non-Oracle\\r\\ndatabases using Golden Gate Microservices.\\r\\n• Contribute to performance optimization, troubleshooting, and capacity planning of\\r\\nhigh-volume replication systems.\\r\\nRequired Skills:\\r\\n• Strong experience with Oracle Golden Gate (Classic and Microservices architectures).\\r\\n• Expertise in replication setup, tuning, conflict resolution, and parallel processing.\\r\\n• In-depth understanding of Oracle RAC, ASM, Data Guard, Exadata, and related technologies.\\r\\n• Proficiency in database performance tuning (AWR, ADDM) and exposure to OEM monitoring.\\r\\n• Hands-on experience with Oracle 18c/19c installation and administration.\\r\\n• Knowledge of shell scripting and automation frameworks.\\r\\n• Experience working in heterogeneous database environments.

Key Responsibilities

1. Adhere To Quality Standards And Regulatory Requirements While Implementing Company Policies In Oracle Exadata And Database Administration Environments.
2. Provide Advanced Support For Complex Incidents Escalated By Analysts, Conducting Thorough Root Cause Analysis, And Implementing Effective Solutions To Resolve Technical And Security Issues.
3. Engage In Knowledge Base Updates And Management By Documenting Solutions, Training New Team Members, And Coaching Analysts To Enhance Team Capabilities.
4. Resolve Complex Tickets Within Agreed Slas By Collaborating With Cross-Functional Support Teams, Ensuring Seamless Operations And Maintaining A Robust Security Posture.
5. Ensure A Positive Customer Experience And High Csat Scores By Achieving First Call Resolution, Minimizing Rejected Resolutions, And Proactively Addressing Potential Security Threats.

Skill Requirements

1. Advanced Proficiency In Oracle Exadata And Database Administration.
2. Strong Understanding Of Troubleshooting Methodologies And Root Cause Analysis Techniques.
3. Familiarity With Incident Management Tools And Ticketing Systems.
4. Excellent Communication And Interpersonal Skills To Facilitate Effective Collaboration With Team Members And Stakeholders.
5. Solid Knowledge Of Security Best Practices Related To Database Operations.

Other Requirements

1. Oracle Certified Professional (Ocp) In Oracle Database Administration Is Optional But Valuable