Database Administrator - MySQL/MariaDB (7-10 yrs)

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