Mysql Database Administrator

We are seeking a skilled and proactive MySQL and MariaDB DBA to join our team. This role involves managing, monitoring, and optimizing MySQL and MariaDB databases, with a particular focus on high availability and performance in clustered environments using Galera and ProxySQL. The ideal candidate should have strong experience with Galera Cluster, ProxySQL configuration, query optimization, and a deep understanding of backup and recovery processes, as well as automation through shell scripting.

Key Responsibilities:

Database Administration:

• Manage and administer MySQL and MariaDB databases, ensuring high performance, scalability, and reliability.
• Implement and manage robust backup and recovery processes, ensuring minimal data loss in case of system failures.
• Schedule and monitor regular backups, including full, incremental, and point-in-time recovery (PITR) strategies to meet RPO/RTO requirements.

Galera Cluster Management:

• Configure, deploy, and maintain Galera Clusters for high availability and redundancy.
• Troubleshoot and resolve issues specific to Galera replication, including split-brain and quorum loss.
• Monitor cluster health, manage failover processes, and ensure data consistency across nodes.

ProxySQL Configuration and Management:

• Set up and manage ProxySQL as a high-performance middle layer for routing SQL queries and load balancing.
• Optimize ProxySQL configurations, including query caching, user management, and query rules.
• Ensure seamless connectivity between applications and database clusters, leveraging ProxySQL features for high availability.

Performance Tuning and Query Optimization:

• Analyze and optimize slow queries, indexing, and database schema design for better performance.
• Utilize monitoring tools and techniques to proactively identify and address performance bottlenecks.
• Work closely with development teams to optimize SQL queries and improve overall database performance.

Monitoring, Automation, and Scripting:

• Set up and maintain database monitoring solutions for real-time insights and alerts on database health.
• Automate routine DBA tasks such as backups, log rotation, and health checks using shell scripts.
• Experience with shell scripting, Ansible, or other automation tools is a strong advantage to improve efficiency and reduce manual workload.

Security and Compliance:

• Ensure databases are secure and compliant with data protection regulations and company policies.
• Implement and manage access controls, audit trails, and data encryption.
• Work with security teams to conduct periodic audits and vulnerability assessments.

Qualifications:

• Proven experience as a MySQL/MariaDB DBA, including experience with Galera Cluster and ProxySQL.
• Strong knowledge of SQL, performance tuning, and query optimization.
• Proficiency in database backup, restore, and disaster recovery strategies.
• Experience with Linux environments, shell scripting (a strong advantage), and automation tools.
• Excellent problem-solving skills and ability to work in a fast-paced environment.

Preferred Skills:

• Experience with ProxySQL version 2.5 or higher.
• Knowledge of other MySQL/MariaDB clustering solutions and replication strategies.
• Familiarity with cloud environments (AWS, Azure) and containerization (Docker, Kubernetes).