Senior Administrator - Oracle Exadata, Oracle DB (IN)
HCLTech
HCLTech
We are seeking a seasoned Oracle GoldenGate DBA (L3) with over 8 years of extensive experience in Oracle 18c/19c database administration. This role demands a proactive individual capable of rapidly resolving issues, mitigating risks, and driving projects to successful completion. Excellent communication, presentation, and documentation skills are essential. The position requires hands-on expertise in installing, configuring, monitoring, and troubleshooting Oracle GoldenGate in production environments. Flexibility to work in a 24x7 rotating shift pattern and participate in on-call duties is a must. You will actively contribute to service improvement initiatives and effectively manage critical issues.
The role involves ensuring adherence to quality standards and regulatory requirements within Oracle Exadata and database administration environments. You will provide advanced support for complex incidents, performing thorough root cause analysis and implementing effective solutions. Engagement in knowledge base updates, training new team members, and coaching analysts is expected to enhance team capabilities. Resolving complex tickets within agreed SLAs by collaborating with cross-functional teams will be a key responsibility, maintaining seamless operations and a robust security posture. Delivering a positive customer experience and high CSAT scores through first-call resolution and proactive threat management is paramount.
Install, configure, and administer Oracle GoldenGate (Classic and Microservices architecture) for real-time data replication, synchronization, and database migrations across on-premises and hybrid environments. Manage GoldenGate deployments using the Administration Server, Service Manager, and Performance Metrics Service within the microservices framework. Monitor, troubleshoot, and optimize GoldenGate 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 GoldenGate monitoring. Design and implement heterogeneous replication between Oracle and non-Oracle databases using GoldenGate Microservices. Contribute to performance optimization, troubleshooting, and capacity planning of high-volume replication systems.
Minimum 8 years of relevant experience in Oracle 18c/19c Database Administration. Ability to quickly understand and resolve issues, mitigate risks and dependencies, and drive projects to completion. Excellent verbal and written communication, presentation, and documentation skills. Strong hands-on experience with Oracle GoldenGate installation, configuration, monitoring, and troubleshooting in production environments. Willingness to work in a 24x7 environment with rotational shifts and be on-call as required. Actively participate in service improvement plans. Ability to drive critical issues and communicate effectively over calls.
Required skills include strong experience with Oracle GoldenGate (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 is crucial. Proficiency in database performance tuning (AWR, ADDM) and exposure to OEM monitoring are essential. Hands-on experience with Oracle 18c/19c installation and administration, along with knowledge of shell scripting and automation frameworks, is required. Experience working in heterogeneous database environments is also a plus. Familiarity with incident management tools and ticketing systems, strong understanding of troubleshooting methodologies and root cause analysis, solid knowledge of security best practices related to database operations, and excellent communication and interpersonal skills for effective collaboration are vital.
HCLTech
IT Consulting