Mysql Database Administrator

Solverminds Solutions And Technologies; Chennai District; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Solverminds Solutions And Technologies is seeking a skilled Database Administrator to manage MySQL environments across Production, UAT, QA, and Development. You will install, configure, upgrade, and maintain servers, implement provisioning, cloning, and environment setup, and manage users, roles, and security.

The role emphasizes high availability, replication health, backup and PITR strategies, and ongoing performance tuning with an emphasis on query optimization, indexing, and resource

Responsibilities

• Install, configure, upgrade, and maintain MySQL database servers.
• Administer Production, UAT, QA, and Development database environments.
• Perform database provisioning, cloning, and environment setup.
• Manage database users, roles, and privileges.
• Ensure high availability and database reliability.
• Monitor database performance and identify bottlenecks.
• Optimize SQL queries, stored procedures, and indexing strategies.
• Analyze execution plans and improve query performance.
• Configure MySQL parameters for optimal performance.
• Monitor CPU, memory, disk I/O, and database resource utilization.
• Design and manage backup and recovery strategies.
• Perform regular backup validation and restoration testing.
• Implement point-in-time recovery (PITR) procedures.
• Maintain disaster recovery readiness and documentation.
• Configure and manage MySQL Replication.
• Administer MySQL Group Replication or InnoDB Cluster (where applicable).
• Monitor replication health and resolve synchronization issues.
• Support failover and disaster recovery operations.
• Implement database security best practices.
• Manage user authentication and authorization.
• Encrypt sensitive data where required.
• Perform database security audits and vulnerability assessments.
• Ensure compliance with organizational security policies.
• Implement database monitoring and alerting.
• Monitor database health, replication, backups, and storage.
• Automate routine DBA tasks using Shell, Bash, Python, or PowerShell.
• Maintain operational dashboards and health reports.
• Support database deployments during application releases.
• Execute schema changes and data migrations.
• Review database scripts before deployment.
• Coordinate release activities with development and DevOps teams.
• Troubleshoot database issues and resolve production incidents.
• Perform root cause analysis (RCA) for database-related outages.
• Implement preventive measures to avoid recurring issues.
• Participate in on-call support for critical production environments.
• Maintain database architecture and operational documentation.
• Document backup, recovery, maintenance, and monitoring procedures.
• Create and update standard operating procedures (SOPs).

Job description

Database Administration

• Install, configure, upgrade, and maintain MySQL database servers.
  
• Administer Production, UAT, QA, and Development database environments.
  
• Perform database provisioning, cloning, and environment setup.
  
• Manage database users, roles, and privileges.
  
• Ensure high availability and database reliability.
  

Performance Tuning

• Monitor database performance and identify bottlenecks.
  
• Optimize SQL queries, stored procedures, and indexing strategies.
  
• Analyze execution plans and improve query performance.
  
• Configure MySQL parameters for optimal performance.
  
• Monitor CPU, memory, disk I/O, and database resource utilization.
  

Backup and Recovery

• Design and manage backup and recovery strategies.
  
• Perform regular backup validation and restoration testing.
  
• Implement point-in-time recovery (PITR) procedures.
  
• Maintain disaster recovery readiness and documentation.
  

High Availability & Replication

• Configure and manage MySQL Replication.
  
• Administer MySQL Group Replication or InnoDB Cluster (where applicable).
  
• Monitor replication health and resolve synchronization issues.
  
• Support failover and disaster recovery operations.
  

Database Security

• Implement database security best practices.
  
• Manage user authentication and authorization.
  
• Encrypt sensitive data where required.
  
• Perform database security audits and vulnerability assessments.
  
• Ensure compliance with organizational security policies.
  

Monitoring & Automation

• Implement database monitoring and alerting.
  
• Monitor database health, replication, backups, and storage.
  
• Automate routine DBA tasks using Shell, Bash, Python, or PowerShell.
  
• Maintain operational dashboards and health reports.
  

Release & Change Management

• Support database deployments during application releases.
  
• Execute schema changes and data migrations.
  
• Review database scripts before deployment.
  
• Coordinate release activities with development and DevOps teams.
  

Incident & Problem Management

• Troubleshoot database issues and resolve production incidents.
  
• Perform root cause analysis (RCA) for database-related outages.
  
• Implement preventive measures to avoid recurring issues.
  
• Participate in on-call support for critical production environments.
  

Documentation

• Maintain database architecture and operational documentation.
  
• Document backup, recovery, maintenance, and monitoring procedures.
  
• Create and update standard operating procedures (SOPs).