MySQL DBA at IT MNC · Bengaluru (Bangalore), Chennai · 7 - 10 years · ₹1L - ₹10L / yr · Posted 26 May 2022

JD-
MySQL - DBA L3 Support
# 7 -10 years of experience in MySQL, handled multiple versions & flavors of MySQL servers both for standalone & enterprise version, Data center and VM/Cloud setup.
# Strong database Configuration and troubleshooting / problem solving skills.
# Strong knowledge of database backup and recovery concepts and practices.
# Enabling disabling scheduled Jobs on MySQL Server
# Work with Dev and DevOps engineers to ensure that all needed data is gathered and provided to them for any performance issues
# Experience in managing both on-prem DB as well as VM / cloud based DBs
# Maintenance of backups (perform backups, monitor backup, report obsolete backups)
# Maintenance of user access (creating user accounts, dropping user accounts, granting privileges)
# Maintenance of log and trace files (remove, initialize, archive them)
# Knowledge on SQL scripts
# Managing Database administration includes Daily health checks, Database tuning, Query optimization & Backup & Replication
# Experience in alert configurations using existing alerting tools or scripts

Similar jobs (1)
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.






