14 Oct
|
Risosu Consulting
|
Mumbai
14 Oct
Risosu Consulting
Mumbai
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
- Solid 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.
Skills:- MySQL DBA, NOSQL Databases, PostgreSQL and MongoDB
📌 MySQL Database Administrator (Mumbai)
🏢 Risosu Consulting
📍 Mumbai