View all jobs
Pune, IN

Database Administrator

Department: Engineering

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, in three shifts and 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.

Additional Information:

Return to Office: PubMatic employees throughout the global have returned to our offices via a hybrid work schedule (3 days “in office” and 2 days “working remotely”) that is intended to maximize collaboration, innovation, and productivity among teams and across functions. 

Benefits: Our benefits package includes the best of what leading organizations provide, such as stock options, paternity/maternity leave, healthcare insurance, broadband reimbursement. As well, when we’re back in the office, we all benefit from a kitchen loaded with healthy snacks and drinks and catered lunches and much more!

Diversity and Inclusion: PubMatic is proud to be an equal opportunity employer; we don’t just value diversity, we promote and celebrate it. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

About PubMatic

PubMatic is one of the world’s leading scaled digital advertising platforms, offering more transparent advertising solutions to publishers, media buyers, commerce companies and data owners, allowing them to harness the power and potential of the open internet to drive better business outcomes.

Founded in 2006 with the vision that data-driven decisioning would be the future of digital advertising, we enable content creators to run a more profitable advertising business, which in turn allows them to invest back into the multi-screen and multi-format content that consumers demand.

APPLY FOR THIS JOB