Description

Install| configure| administer| upgrade and maintain MySQL databases across development| testing and production environments.Monitor database availability| health| capacity and performance and proactively address issues.Perform SQLquery optimisation| index tuning and database performance tuning.Manage database backup| restoration and recovery| including point-in-time recovery and periodic recovery validation.Configure and manage MySQL replication| High Availability (HA) and Disaster Recovery (DR) solutions.Troubleshoot production issues including slow queries| deadlocks| locking| replication failures| connectivity and resource utilisation.Manage database users| roles| privileges| authentication and security controls.Perform database patching| version upgrades and migrations with appropriate planning and validation.Support database deployments and production releases| including database scripts and schema changes.Monitor database growth and perform capacity planning| storage management and housekeeping.Automate repetitive DBA activities using Shell| Python| Ansible or similar automation tools.Work closely with application| infrastructure| DevOps and development teams to resolve database-related issues.Perform Root Cause Analysis (RCA) for critical database incidents and implement preventive measures.Maintain operational documentation| configuration details| recovery procedures and DBA runbooks.Participate in 24x7 production supporton-call activities as required and ensure timely resolution of critical incidents Essential Skills: Strong hands-on experience in MySQL Database Administration in production environments.Installation| configuration| upgrade| patching and maintenance of MySQL databases.Strong knowledge of MySQL architecture| storage engines| indexing| locking and transactions.Expertise in SQL query optimisation| performance tuning and troubleshooting.Experience with backup| restore and recovery| including point-in-time recovery.Hands-on experience with replication| including setup| monitoring and troubleshooting.Knowledge of High Availability (HA) and Disaster Recovery (DR) solutions such as MySQL InnoDB Cluster| Group Replication or similar technologies.Database monitoring| capacity planning| space management and performance analysis.Experience troubleshooting slow queries| blocking| deadlocks| CPUmemory utilisation and database connectivity issues.Strong understanding of database security| userrole management| privileges| authentication and auditing.Experience with database migration| version upgrades and production deploymentsupport activities.Working knowledge of LinuxUnix administration and shell scripting.Automation experience using ShellPythonAnsible is desirable.Exposure to cloud-hosted MySQL services such as AWS RDSAurora or Azure Database for MySQL is an advantage.Ability to support 24x7 production environments| incident management| root-cause analysis and problem resolution

Key Skills

Education

Bachelor's degree