MySQL-DB Administration

Alike Thoughts

Hyderabad, Chennai District, Bengaluru

On-site

INR 1,200,000 - 2,100,000

Full time

14 days+

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Alike Thoughts is seeking a seasoned MySQL Database Administrator with 6 to 7 years of experience to manage, monitor, and optimize MySQL environments. The ideal candidate should handle installation, upgrades, performance tuning, backups, replication, and troubleshooting in production systems.

You will collaborate with application teams, implement robust security, plan capacity, automate routine tasks with Shell/Python, and document architectures and procedures to ensure maximum uptime and data

Qualifications

6–7 years of hands-on MySQL DBA experience in production environments.
Strong expertise in replication, partitioning, and clustering concepts.
Experience with backup and recovery strategies and tools.
Proficient in SQL, procedures, views and triggers; performance tuning.
Unix/Linux administration and experience with monitoring tools.

Responsibilities

Install, configure, upgrade, and maintain MySQL servers.
Monitor performance and proactively identify bottlenecks.
Tune queries and manage indexes for optimization.
Implement and manage backup and recovery strategies.
Configure and administer replication (Master-Slave/Master-Master).
Manage security, roles, privileges and access controls.
Troubleshoot issues ensuring high uptime and availability.
Assist application teams with design and performance improvements.
Perform capacity planning and health checks.
Automate DBA tasks using Shell/Python scripting.
Document architecture, processes, and procedures.

Skills

MySQL administration

Replication

Query optimization

Shell scripting

Python scripting

Unix/Linux

Backup and recovery

Security and access control

Monitoring

Education

Bachelor's degree in Computer Science/IT

MySQL Certification

Tools

MySQL Enterprise Backup

Percona XtraBackup

Nagios

Grafana

Prometheus

Job description

Role & responsibilities : MySQL-DB Administration

Preferred candidate profile :

Job Summary

We are seeking a skilled MySQL Database Administrator with 6 to 7 years of experience in managing, monitoring, and optimizing MySQL database environments. The ideal candidate should have hands-on experience in database administration, performance tuning, backup and recovery, replication, and troubleshooting production database issues.

Key Responsibilities

Install, configure, upgrade, and maintain MySQL database servers.
Monitor database performance and proactively identify bottlenecks.
Perform database tuning, query optimization, and index management.
Implement and manage backup and recovery strategies.
Configure and administer MySQL Replication (Master-Slave/Master-Master).
Manage database security, user roles, privileges, and access controls.
Troubleshoot database issues and ensure maximum uptime and availability.
Support application teams in database design and performance improvements.
Perform capacity planning and database health checks.
Automate routine DBA tasks using Shell/Python scripting.
Document database architecture, processes, and operational procedures.

Required Skills

Strong experience with MySQL 5.x/8.x administration.
Hands-on expertise in replication, partitioning, and clustering concepts.
Experience with backup tools such as MySQL Enterprise Backup, Percona XtraBackup.
Strong understanding of SQL, stored procedures, views, and triggers.
Expertise in query tuning and performance optimization.
Unix/Linux administration knowledge.
Experience in database migration and upgrade activities.
Knowledge of monitoring tools such as Nagios, Grafana, Prometheus, or OEM equivalents.
Familiarity with cloud databases (AWS RDS MySQL/Azure Database for MySQL) is preferred.

Preferred Skills