Database Administrator

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.