Database Administrator - MySQL

We are seeking a skilled and motivated MySQL DBA to join our growing team! As a MySQL Database Administrator, you will be responsible for ensuring the performance, availability, and security of our database systems. If you have a passion for database management, optimizing performance, and troubleshooting complex issues, this is the role for you. Key Responsibilities : - Install, configure, and maintain MySQL database systems and instances, ensuring they meet both business and operational requirements. - Perform version upgrades and patch management to ensure the database is up to date with the latest features and security updates. - Monitor the performance of MySQL databases using various performance tools and log analysis. - Identify and resolve performance bottlenecks, queries, and indexing issues to ensure optimal efficiency. - Database query optimization for slow-running queries and long-running transactions. - Regularly analyze execution plans and recommend changes for improved performance. - Design and implement robust database backup strategies to ensure critical data is protected and can be restored in case of a failure. - Develop, test, and execute disaster recovery plans to ensure business continuity in the event of system failures. - Regularly test backup and restore processes to guarantee data integrity and recovery time objectives (RTO/RPO). - Set up and manage MySQL replication, ensuring high availability and data consistency across multiple systems. - Implement high-availability solutions, including clustering, load balancing, and failover systems to ensure database uptime. - Monitor and manage replication latency and troubleshoot replication issues, ensuring minimal downtime. - Plan, implement, and manage scalable database architectures to support growth, including horizontal scaling (sharding) and vertical scaling (upgrading hardware or resources). - Collaborate with other teams to plan and execute database scaling strategies as required by application growth or system demand. - Evaluate and implement tools that assist with scaling, such as proxySQL, MySQL Cluster, or cloud-based database services. - Manage database security, ensuring proper access controls, user roles, and data encryption are in place. - Implement regular security audits and ensure compliance with relevant data protection regulations. - Manage data access policies and ensure only authorized users have access to sensitive data. - Quickly identify, troubleshoot, and resolve database-related incidents, ensuring minimal disruption to production systems. - Maintain and resolve issues in multi-database environments such as multi-master setups or cross-regional deployments. Qualifications : - 3 years of experience in MySQL database administration in a production environment. - Strong understanding of MySQL performance tuning and using tools like MySQL Enterprise Monitor, Percona Monitoring and Management, or Nagios for performance monitoring. - Hands-on experience with MySQL replication (master-slave, master-master, etc.), cluster management, and load balancing. - Expertise in backup strategies, disaster recovery, and high-availability configurations. - Experience in query optimization, indexing strategies, and execution plan analysis. - Familiarity with cloud databases such as AWS RDS, Azure Database for MySQL, or Google Cloud SQL (a plus). - Solid understanding of database security principles, including encryption, user management, and role-based access control (RBAC). - Ability to troubleshoot database issues efficiently, including disk space management, network issues, and replication failures. - Experience with automation tools (e.g., Ansible, Chef, or Puppet) for database provisioning and configuration management. (ref:hirist.tech) Read more