Database Administration

- Install, configure, upgrade, and maintain MySQL database servers.

- Administer Production, UAT, QA, and Development database environments.

- Perform database provisioning, cloning, and workplace 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).

📌 Mysql Database Administrator (Chennai)
🏢 Solverminds Solutions and Technologies
📍 Chennai