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 productive 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
📌 Database Administrator (Pune)
🏢 PubMatic
📍 Pune
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.