Database Administrator

Zarthi; Dadri, Bengaluru; On-site; INR 900,000 - 1,800,000; Full time

Job summary

Zarthi in Dadri, Uttar Pradesh seeks an experienced MySQL Database Administrator to install, configure, and upgrade MySQL databases across development, testing, and production environments. You will manage clustering (master-slave and multi-node master-master), handle read/write replicas, and ensure high availability for scalable applications.

Responsibilities include monitoring cluster health, performing migrations/patching with minimal disruption, tuning performance, developing database

Qualifications

• Experience with MySQL in clustered environments and high-availability configurations.

Responsibilities

• Install, configure, and upgrade MySQL databases across development, testing, and production environments.
• Set up and maintain clustering configurations (master-slave and multi-node master-master) for high availability.
• Configure and manage read/write replicas supporting scalable workloads.
• Monitor and manage MySQL cluster nodes for healthy state and prompt failover.
• Plan and execute migrations, upgrades, and patching with minimal business impact.
• Analyze and optimize database performance including replication lag and query speed.
• Develop and maintain MySQL objects: tables, views, stored procedures, triggers, and functions.
• Implement and manage backup/recovery strategies and test recovery across cluster nodes.
• Automate administration tasks via scripts and tooling for routine checks.
• Support developers with complex queries and SQL optimization in clustered/non-clustered environments.
• Enforce security best practices (users, roles, privileges) in distributed setups.
• Maintain documentation on configurations, cluster setups, node roles, and procedures.
• Participate in 24/7 on-call rotations and perform weekend maintenance as needed.

Skills

MySQL

Database Clustering

SQL Tuning

Backup & Recovery

Replication

Job description

Key Responsibilities

• Install, configure, and upgrade MySQL databases across development, testing, and production environments.


• Set up and maintain clustering configurations (including master-slave and multi-node master-master set-ups) to deliver high availability and redundancy.


• Configure and manage read/write replicas supporting scalable, reliable application workloads.


• Monitor and manage MySQL cluster nodes, ensuring healthy state, prompt failover, and consistent data replication across all participating nodes.


• Plan and execute database migrations, upgrades, and patching in clustered environments, with minimal impact to business operations.


• Analyze and optimize database performance, including tuning node communication, replication lag, query speed, and overall cluster reliability.


• Develop and maintain MySQL database objects: tables, views, stored procedures, triggers, and functions.


• Implement and manage backup/recovery strategies, routinely test recovery using all cluster nodes.


• Automate administration tasks through scripts and available tooling, especially for routine checks across cluster nodes.


• Support application developers in writing complex queries, optimizing SQL code, and troubleshooting database issues within clustered and non-clustered environments.


• Enforce security best practices including management of user accounts, roles, and privileges within distributed setups.


• Maintain comprehensive documentation on all configurations, cluster setups, node roles, and operating procedures.


• Participate in 247 business-support rotations as required, providing timely incident response and resolution for critical and routine database issues.


• Perform planned and scheduled maintenance activities during weekends or night hours to minimize business disruption.