About the Role

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.
- 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 Performance 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.
- Complete understanding of backups, restores, recovery, database maintenance operations.
- Experience in Percona tools is an advantage.
- Advanced understanding of Linux OS.
- Deep understanding of monitoring requirement to catch the related issues.
- Experience in Index/Jobs fine tuning and query optimizations.
- Troubleshoot and resolve MySQL server and replication issues of any complexity.
- Perform technical work that requires planning and scheduling to ensure the best possible solution is delivered on time.
- React on incidents and provide solutions aiming at maintained environments' improvements.
- Should have experience & ability to work with various teams to resolve DB/architecture issues.
- Work in a quick-paced environment where we are responsible for most critical systems.
- Experience with database security, compliance, and audit logging.

Qualification :

- Should have a Bachelor's or master's degree in computer science, Data Science, Statistics, Mathematics, Engineering, or a related field.

📌 Database Administrator (Pune)
🏢 PubMatic
📍 Pune