Database Administrator

Solverminds Solutions & Technologies Pvt Ltd; Chennai; Sur place; INR 1 200 000 - 2 500 000; Plein temps

Résumé du poste

Solverminds Solutions & Technologies Pvt. Ltd is seeking an experienced MySQL DBA in Chennai to design, optimize and secure production databases. You will manage replication, high availability, backups, and perform performance tuning across environments.

The role requires deep SQL expertise, experience with InnoDB, and strong scripting skills. Cloud service familiarity (Azure/AWS) is a plus; collaboration with DevOps and development teams is essential.

Qualifications

• Strong hands-on experience with MySQL 8.0+ and production support.
• Expertise in query optimization, indexing, and plan analysis.
• Experience with backup/recovery, replication, and HA/DR.
• Proficient with Linux, shell scripting, and monitoring tools.
• Knowledge of database security, auditing, and access controls.
• Familiarity with cloud managed MySQL services is a plus.

Responsabilités

• Design, implement, manage, and maintain MySQL databases across environments.
• Optimize complex SQL queries, joins, and stored procedures.
• Analyze execution plans (EXPLAIN, EXPLAIN ANALYZE) to fix bottlenecks.
• Design indexes, including composite and covering types, to speed queries.
• Identify and resolve slow queries, deadlocks, and resource bottlenecks.
• Monitor performance, CPU, memory, I/O, and connections.
• Maintain backup, recovery, replication, and HA/DR strategies.
• Plan upgrades, migrations, schema changes, and capacity planning.
• Ensure security, auditing, and data protection best practices.
• Collaborate with DevOps and developers; automate routine tasks.

Connaissances

MySQL 8.0+

Performance tuning

Query optimization

Backup and recovery

HA/DR implementations

Linux shell scripting

Monitoring

Replication

Indexing strategies

Database security

Formation

Bachelor's degree in Computer Science

Outils

Percona Toolkit

MySQL Enterprise tools

Azure Database for MySQL

AWS RDS for MySQL

Description du poste

Solverminds Solutions & Technologies Pvt. Ltd | Full time

We are looking for an experienced MySQL DBA to manage, optimize, secure, and maintain production MySQL databases. The candidate should have strong hands‑on expertise in SQL query optimization, performance tuning, indexing strategies, database architecture, backup and recovery, and high availability.

Key Responsibilities

Design, implement, manage, and maintain MySQL databases across development, testing, and production environments.

Optimize complex SQL queries, joins, subqueries, and stored procedures to improve application performance.

Analyze execution plans using EXPLAIN and EXPLAIN ANALYZE to identify performance bottlenecks.

Design and optimize indexes, including composite and covering indexes, to minimize query execution time and database resource utilization.

Identify and resolve slow queries, full table scans, locking, blocking, deadlocks, and inefficient database access patterns.

Monitor and optimize database performance, CPU, memory, disk I/O, connections, and storage utilization.

Implement and maintain backup, recovery, replication, high availability (HA), and disaster recovery (DR) strategies.

Perform database upgrades, migrations, schema changes, capacity planning, and data archiving.

Implement database security, access controls, auditing, and data protection best practices.

Establish database monitoring, alerting, maintenance, and performance-reporting mechanisms.

Troubleshoot critical production incidents and perform root‑cause analysis (RCA).

Collaborate with developers, architects, and DevOps teams to improve database design and application performance.

Automate routine DBA activities using shell scripting, Python, or other suitable tools.

Requirements

Required Skills

Strong hands‑on experience with MySQL 8.0+ , database administration, and production support.

Excellent SQL skills and expertise in query optimization and performance tuning.

Strong understanding of indexing strategies, index selectivity, composite indexes, and query execution plans.

Experience with MySQL InnoDB internals, transactions, locking, isolation levels, and concurrency management.

Expertise in identifying and resolving slow queries, deadlocks, blocking sessions, and resource bottlenecks.

Hands‑on experience with database backup, point‑in‑time recovery, replication, and HA/DR configurations.

Knowledge of database security, user privileges, encryption, and auditing.

Experience with database monitoring, capacity planning, performance baselining, and troubleshooting.

Familiarity with Linux administration and shell scripting.

Experience managing large databases and handling production workloads.

Preferred Skills

Experience with Azure Database for MySQL, AWS RDS for MySQL, or other managed MySQL services.

Knowledge of cloud database migration, cost optimization, and monitoring tools.

Experience with Percona Toolkit, MySQL Enterprise tools, or equivalent database diagnostic utilities.

Exposure to automation, CI/CD, infrastructure as code, and database change management.

Experience with high‑volume transactional applications and 24×7 production environments.