MySQL Database Administrator

Job Description (JD) for the MySQL Database Administrator role

Experience: 4-8 Years 

Location : Mumbai 

Job Title: MySQL Database Administrator 

Responsibilities 

• Provision and configure MySQL database instances in clustered and non-clustered environments. 
• Ensure database performance, security, availability, and reliability. 
• Prepare and maintain database documentation, technical specifications, and operational procedures. 
• Perform database upgrades, backups, restoration, recovery, and migrations. 
• Monitor database and server resource utilization and perform performance tuning and optimization. 
• Manage database users, access privileges, periodic access reviews, audits, and documentation. 
• Configure, monitor, and troubleshoot MySQL replication. 
• Collaborate with application, infrastructure, development, and other stakeholder teams to resolve database-related issues. 
• Provide database and application deployment support, as required. 
• Perform database backup and restoration validation, data integrity checks, and post-migration validations. 
• Follow database change management, security, and operational best practices. 

Skills and Qualifications 

• Strong hands-on experience in MySQL database administration. 
• Good working knowledge of recent MySQL versions, preferably MySQL 8.x. 
• Understanding of MySQL storage engines, including InnoDB and MyISAM. 
• Practical experience in configuring, monitoring, and troubleshooting MySQL replication. 
• Knowledge of MySQL administration best practices, security, and high availability. 
• Proficiency in writing, analyzing, and optimising SQL queries. 
• Experience with MySQL features such as the Event Scheduler, audit logging, and performance monitoring. 
• Ability to assess database resource requirements based on application workloads and technical specifications. 
• Familiarity with other SQL and NoSQL databases, such as PostgreSQL and MongoDB. 
• Understanding of MySQL limitations compared with other relational database platforms and the ability to identify suitable workarounds. 
• Working knowledge of version control tools such as Git, SVN, or CVS. 
• Graduate degree in a relevant discipline and good verbal and written communication skills. 

Good to Have 

• Basic Linux administration, command-line troubleshooting, and Bash scripting skills. 
• Familiarity with application server frameworks such as JBoss, GlassFish, and WildFly.