Database Administrator

About the Role We are seeking a skilled and experienced Database Administrator (DBA) to join our team. The ideal candidate will have 3 to 5 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 Manage and maintain MySQL databases across production, QA, and development environments. Implement and manage MySQL Group Replication for seamless failover and redundancy. Review/deploy data-manipulation (DML) and data-definition (DDL) changes to support application releases. Serve in an on-call rotation as an escalation contact for critical database production issues and drive escalation/resolution of problems. Conduct query performance tuning, indexing strategies, and schema optimization to improve efficiency. Setup and maintain master-slave replication topologies for high-availability and write/read scaling. Configure and maintain ProxySQL for database traffic load balancing and query routing. Monitor ProxySQL logs and troubleshoot database connection issues. Linux system administration and shell programming skills such as storage capacity management, performance tuning. Write scripts using Bash/Python to automate manual administrative tasks. Monitor performance and tune databases to optimize for different workloads. Maintain backups and perform point-in-time restorations. Perform regular database health checks, monitoring, and capacity planning. Respond to P1/P2 incidents related to database downtime, performance issues, or replication failures. Collaborate with DevOps and Engineering teams to resolve database-related challenges. We'd Love for You to Have Minimum of 3 to 5 years' experience in administering MySQL v8.x Servers. Decent knowledge of PostgreSQL is required. MySQL Server Installation, Upgrades, Migrations and Configuration. Expertise and experience with clustering solutions for High Availability. Advanced knowledge on InnoDB storage engine. Expert knowledge of Performan ce Schema. Knowledge and expertise on GR cluster, Proxy SQL and operating systems, know how on Proxy SQL usage as it relates to MySQL. Experience in Disaster recovery planning and implementation. Good scripting skills (Bash/Python) and well-versed with Linux systems. Understand the automation concept to speed up the work: Ansible. Knows how to optimize queries/schema. Deep understanding of replication setup and replication-related issues.