MySQL Database administrator

Job Overview

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

Key Responsibilities:

1. Database Administration:

• Manage and administer MySQL, Maria, Mongo, and PostgreSQL, databases, ensuring high performance, scalability, and reliability.
• Implement and manage robust backup and recovery processes, ensuring minimal data loss in case of system failures.
• Familiarity with deploying and managing MySQL, Maria, PostgreSQL, SQL Server and MongoDB in cloud environments (e.g., AWS, Azure, GCP), preferably AWS
• Schedule and monitor regular backups, including full, incremental, and point-in-time recovery (PITR) strategies to meet RPO/RTO requirements.

2. Galera Cluster Management:

• Configure, deploy, and maintain Galera, Mongo 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.

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

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

JOB DESCRIPTION

My SQL and MariaDB Database Administrator (DBA)

• Work closely with development teams to optimize SQL queries and improve overall database performance.

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

6. 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/Mongo DBA, including experience with Galera and Mongo Cluster and ProxySQL.
• 2008 and Above SQL Server DB administration knowledge is highly preferred
• 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).