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 settings,
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.
📌 Database Administrator Bengaluru (India)
🏢 Zarthi
📍 India