Job Description

About the Role: We are seeking a skilled and experienced Database Administrator (DBA) to join our team. The ideal candidate will have 3+ years of hands-on experience with MySQL, ProxySQL, and PostgreSQL, specializing in database administration, performance tuning, query optimization, high availability, backup, and archival. This role involves managing and supporting database systems, ensuring uptime, performance, and scalability for mission-critical applications. What You'll Do: Database Management & Support: Manage and support MySQL, ProxySQL, and PostgreSQL databases in production and staging environments. Administer Group Replication clusters and maintain high-availability database architectures. Ensure database environments are optimized for both performance and reliability. High Availability & Clustering: Design, implement, and maintain Group Replication for MySQL databases, ensuring database high availability and disaster recovery. Monitor and troubleshoot database cluster health and replication lag issues. Administer ProxySQL to optimize query routing and provide high availability and load balancing. Query Optimization: Analyze and optimize slow-running queries and troubleshoot performance bottlenecks. Apply best practices for query performance tuning, including indexing strategies and query rewriting. Monitor database performance and recommend tuning adjustments to ensure efficient database operations. Backup and Archival: Implement and manage database backup strategies, ensuring data consistency and integrity. Automate and monitor backup processes for MySQL, ProxySQL, and PostgreSQL systems. Develop and manage archival strategies to comply with data retention policies and ensure efficient storage utilization. Maintenance & Upgrades: Perform regular database patching and version upgrades with minimal downtime. Carry out health checks and maintenance tasks to optimize database performance and security. Ensure all security patches are applied and maintain databases in a secure, compliant state. Troubleshooting & Support: Provide 24x7 support for production database environments on three shifts, including on-call support for critical incidents. Diagnose and resolve database-related issues, including replication failures, performance problems, and data integrity issues. Collaborate with developers and other teams to resolve database-related application issues. Documentation & Reporting: Maintain comprehensive documentation for database configurations, backup/restore procedures, and troubleshooting guides. Prepare regular reports on database health, performance, and incident resolutions for management. We'd Love for You to Have: 3+ years of experience in database administration with a strong focus on MySQL, ProxySQL, and PostgreSQL. Strong understanding and hands-on experience with Group Replication, high availability, and failover solutions for MySQL databases. Solid experience in query optimization, indexing strategies, and performance tuning. Expertise in backup strategies (full, incremental, and differential backups) and data archival solutions. Proficiency with ProxySQL for high availability and load balancing. Experience with PostgreSQL administration, including performance tuning, replication, and clustering (e.g., using Patroni or pgpool). Experience with database monitoring tools (e.g., Prometheus, Grafana, Percona Monitoring and Management). Familiarity with scripting languages (e.g., Bash, Python) for automation tasks. Excellent problem-solving skills and the ability to troubleshoot complex database-related issues. Strong attention to detail and ability to work independently and as part of a team. Good understanding of networking, storage architectures, and cloud-based database solutions (e.g., AWS RDS, Azure Database Services). Familiarity with NoSQL databases (e.g., MongoDB, Redis). Experience with containerized environments (e.g., Docker, Kubernetes). Experience with DevOps practices and database automation tools (e.g., Ansible, Terraform). Knowledge of data security best practices, including encryption, user roles, and access controls. Qualifications: Bachelor's degree in engineering (CS/IT) or equivalent degree from well-known Institutes/ Universities. Certification in MySQL DBA or PostgreSQL DBA is a plus.