Key Responsibilities:
MySQL Database Management:
Install, configure, and maintain MySQL databases in a production environment.
Monitor database health, availability, and performance using tools like MySQL Enterprise Monitor, Percona Monitoring and Management (PMM), or similar.
Manage database instances and environments, including MySQL Cluster, Replication, and Master-Slave configurations.
Implement and support MySQL replication, including master-master and master-slave setups.
Ensure proper database backups, restore procedures, and disaster recovery plans are in place and tested regularly.
Troubleshoot and resolve database-related issues, including performance bottlenecks, deadlocks, and query optimization.
Perform regular health checks and security audits on MySQL systems to identify vulnerabilities and take corrective actions.
Database Performance Tuning:
Identify and resolve performance issues by analyzing and optimizing queries, indexes, and schemas.
Utilize query optimization techniques, EXPLAIN plans, and database profiling to improve performance.
Implement database partitioning and indexing strategies to enhance performance for large datasets.
Perform server tuning to optimize MySQL configurations for various workloads (OLTP, OLAP, etc.).
Automation of Database Tasks:
Develop and implement automated scripts for database backups, restores, data migrations, and other routine administrative tasks using tools like Ansible, Puppet, Chef, or Shell Scripting.
Automate database provisioning, configuration management, and patching using CI/CD pipelines or orchestration tools.
Set up monitoring dashboards and automated alerts for database health, performance, and capacity planning.
Implement self-healing scripts and automated failover mechanisms for high availability and disaster recovery.
Security & Compliance:
Implement and enforce database security policies to ensure data privacy and compliance with relevant regulations (e.g., GDPR, HIPAA).
Configure and maintain user roles, permissions, and encryption for data at rest and in transit.
Monitor and audit database activities for unauthorized access, breaches, or other security incidents.
Capacity Planning & Scaling:
Perform capacity planning and database sizing for both short-term and long-term growth.
Scale MySQL databases as needed, ensuring efficient scaling for increased load or data size.
Implement horizontal scaling and vertical scaling strategies based on business needs.
Design and implement sharding strategies for large datasets, ensuring optimal performance across multiple nodes.
Collaboration & Support:
Work closely with DevOps, Application Development, and Infrastructure teams to design, deploy, and manage MySQL databases in a cloud or hybrid environment (AWS, Azure, GCP, etc.).
Provide on-call support for MySQL databases in case of emergencies or incidents.
Assist developers with SQL optimization, database schema design, and data-related troubleshooting.
Support database migrations, version upgrades, and patch management.
Documentation:
Maintain up-to-date documentation for all database configurations, procedures, and automation scripts.
Document best practices, troubleshooting steps, and disaster recovery procedures.
Prepare and present reports for database performance, availability, and resource utilization.
Continuous Improvement:
Continuously evaluate new technologies, tools, and best practices in MySQL database administration.
Suggest and implement improvements for automation, efficiency, and scalability of MySQL environments.
Keep up-to-date with the latest MySQL releases, security patches, and industry trends.
Required Qualifications:
Bachelor's degree in Computer Science, Information Technology, or a related field.
3-5 years of experience in MySQL database administration.
Strong experience with MySQL performance tuning, query optimization, and indexing strategies.
Proficiency in database automation using scripting languages such as Shell, Python, or Bash.
Hands-on experience with database replication (Master-Slave, Master-Master) and high availability setups (e.g., Galera Cluster, MySQL Group Replication).
Experience with backup and recovery strategies, including point-in-time recovery and full database restores.
Familiarity with cloud platforms like AWS, Azure, or Google Cloud Platform and managing MySQL databases in these environments.
Experience with configuration management tools like Ansible, Puppet, or Chef.
Familiarity with CI/CD pipelines and DevOps practices.
Strong understanding of database security and best practices for securing MySQL environments.

MySql Dba With Automation

Job Description

Required Skills