MySql Dba With Automation

Job description

• 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.

Required Skill Profession

Computer Occupations