Team Lead - Database Administrator

Summary: Lead and manage enterprise-scale Oracle and MySQL database environments, ensuring high availability, performance, security, and disaster recovery for mission-critical banking applications. Act as the L3 escalation point for complex database issues, drive database optimization, automation, monitoring, backup and recovery, and support 24x7 production operations while collaborating with application and infrastructure teams to ensure reliable and efficient database services. This role requires to work in rotational shifts, excluding Night Shift.

Education: Any Graduate

Experience: 6+ Years of experience

Knowledge:

1. 6-8+ years of experience in administering and supporting enterprise-scale MySQL and Oracle databases in 24x7 mission-critical environments.
2. Strong expertise in production support, performance tuning, troubleshooting, High Availability, and Disaster Recovery for complex database infrastructures.
3. Hands-on experience with MySQL InnoDB Cluster, Group Replication, Oracle RAC, Data Guard, and GoldenGate technologies.
4. Proven ability to diagnose and resolve critical database issues related to performance, replication, availability, and scalability.
5. Extensive experience in database upgrades, patching, migrations, backup & recovery, and environment management across Production, UAT, and DR environments.
6. Strong focus and hands on database security, hardening, encryption, compliance, and operational best practices.
7. Experienced in driving automation initiatives using Ansible, Shell Scripting, and Python to improve reliability and operational efficiency.
8. Excellent problem-solving, Root Cause Analysis (RCA), stakeholder management, and communication skills with the ability to work independently in high-pressure environments.

Skills: MySQL, Oracle, Performance Tuning, InnoDB Cluster, Replication, Oracle RAC, Data Guard, Security & Hardening, Automation (Ansible), High Availability, Disaster Recovery, Production Support, and RCA.

 1. Lead the administration, maintenance, and support of Oracle and MySQL databases across Development, UAT, Production, and Disaster Recovery environments.  

2. Serve as the L3 escalation point for complex database incidents, ensuring timely resolution of critical production issues and conducting root cause analysis for major incidents.
3. Manage and optimize database performance through proactive monitoring, troubleshooting, SQL tuning, execution plan analysis, index optimization, and capacity planning.
4. Design, implement, and support high availability and disaster recovery solutions using Oracle RAC, Oracle Data Guard, MySQL Replication, Group Replication, InnoDB Cluster, PostgreSQL Streaming Replication, and Oracle GoldenGate.
5. Plan and execute database installations, upgrades, patching, migrations, cloning, refreshes, and environment provisioning activities while ensuring minimal service disruption.
6. Develop and maintain backup, recovery, and disaster recovery strategies, including failover and failback testing, to ensure business continuity and data protection.
7. Implement database security, auditing, encryption, and hardening controls to meet organizational compliance and security requirements.
8. Drive automation and operational efficiency through Ansible, Shell Scripting, and Python, including automated health checks, monitoring, alerting, backup validation, and compliance verification.
9. Create and maintain monitoring dashboards, operational runbooks, SOPs, and documentation to support stable and efficient database operations.
10. Collaborate with application, infrastructure, and development teams to support deployments, troubleshoot issues, and enhance the reliability, scalability, and performance of database platforms.
11. Will have to work in rotational shifts, excluding night shift.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.