Database Administrator - MySQL (3-5 yrs)

Job Title : DBA MySQL

Experience : 3-5 Years

Location : Chennai

Job Type : Full-Time (Onsite)

Notice Period : Immediate/15 Days

About the Role :

We are seeking a highly skilled and experienced MySQL Database Administrator to join our growing team. The ideal candidate will have a strong understanding of MySQL database administration, including installation, configuration, performance tuning, and backup and recovery. You will be responsible for ensuring the high availability, performance, and security of our MySQL databases.

Responsibilities :

Database Administration :

- Install, configure, and administer MySQL databases.

- Monitor database performance and proactively identify and resolve issues.

- Perform regular database backups and recoveries.

- Implement and maintain high availability and disaster recovery solutions.

- Ensure database security by implementing appropriate access controls and security measures.

Database Optimization :

- Optimize database performance through query tuning, indexing, and partitioning.

- Analyze query execution plans and identify areas for improvement.

- Implement strategies to improve database scalability and performance.

Automation & Scripting :

- Automate routine database tasks using scripting languages (e.g., Python, Shell).

- Develop and maintain database administration scripts.

Troubleshooting & Support :

- Troubleshoot and resolve database-related issues promptly and effectively.

- Provide technical support to application developers.

Required Skills :

Technical Expertise :

- Strong knowledge of MySQL (installation, configuration, and optimization).

- Hands-on experience with backup and recovery tools like mysqldump or Percona XtraBackup.

- Familiarity with replication techniques (master-slave, master-master) and clustering technologies.

- Experience with database monitoring tools such as Nagios, Zabbix, or MySQL Enterprise Monitor.

Query Optimization :

- Proficient in SQL query optimization and performance tuning.

- Understanding of indexing, partitions, and execution plans.

Scripting and Automation :

- Experience with automation tools to manage database tasks (e.g., scripting languages like Python, Shell).

Benefits :

- Competitive salary and benefits package.

- Opportunities for professional growth and development.

- A challenging and rewarding work environment.

- The chance to work on cutting-edge technologies.

- Collaboration with talented and experienced professionals.