Database Administrator
- PubMatic
- 3 - 5 years
- Pune
- 1 month ago
- Email to a friend
- Report this job
Job Description
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 on three shifts, 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.
If interested, please visit the link below to apply:
https://pubmatic.com/job/?gh_jid=4612663***
Job Classification
Industry: InternetFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: PubMaticLocation(s): Pune
Keyskills: Postgresql MySql Bash Scripting Database monitoring Python
Similar positions
PubMatic
PubMatic is the automation solutions company for an open digital media industry. Featuring the leading omni - channel revenue automation platform for publishers and enterprise - grade programmatic tools for media buyers, PubMatic????s publisher - first approach enables advertisers to access premium ...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in