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.
- Valuable scripting skills (Bash/Python) and well-versed with Linux systems.
- Understand the automation concept to speed up t
📌 Database Administrator (Pune)
🏢 PubMatic
📍 Pune