Back to list

Vacancy description

Database Administrator in Pune, भारत

PubMatic

Pune, भारत

About the Role

We are seeking a skilled and experienced Database Administrator (DBA) to join our team. The ideal candidate will have 3 to 5 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

  • Manage and maintain MySQL databases across production, QA, and development environments.
  • Implement and manage MySQL Group Replication for seamless failover and redundancy.
  • Review/deploy data-manipulation (DML) and data-definition (DDL) changes to support application releases.
  • 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 fast-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.

Similar vacancies

More like this role

The Walt Disney Company

Sr Database Administrator

  • On-site
  • Full-time
... as a mentor and go-to resource for database-related issues. Required Qualifications: - Years Of Experience: 5+ years of relevant professional experience in database administration or closely related technical roles. - Skilled Sr Database Administrator with minimum 5 years of experience in database administration or related ...

Bangalore, भारत

NationsBenefits, LLC

Senior Database Administrator

  • Full-time
... and search indices (e.g., Redis, Elasticsearch) - Familiarity with Databricks or other modern data platforms - Experience with PostgreSQL or other relational databases - Microsoft Azure certifications (e.g., Azure Database Administrator Associate) [{"name": "full_time", "text": "Full time", "categoryName": "Type of employment"}]

Hyderabad, भारत

People10 Techno Soft

Senior Database Administrator

  • Remote
  • Full-time
This is a remote position. Senior Database Administrator @ PEOPLE10 Experience: 5 - 7 years Job Location: Remote (India) Graduation :Any (BE/Btech/MCA-Preferred) Job Overview: As part of a global enterprise tech team, you will manage enterprise scale databases through leading industry standards, automation and transformational ...

भारत

LANCESOFT INDIA PRIVATE LIMITED

MySQL Database Administrator

Job Description : We are seeking a highly skilled and experienced MySQL Database Administrator to join our dynamic team. In this pivotal role, you will be responsible for the architecture, deployment, management, and optimization of our critical MySQL database https://jobeax.com/link/dSfxfMeSKtZY7pT9 You'll Do : MySQL Expertise ...

Bangalore, भारत

  • Remote
  • Full-time
... world. Miratech retains nearly 1000 full-time professionals, and our annual growth rate exceeds 25%. Job Description We are looking for an experienced MySQL Database Administrator to join our growing cloud operations organization. In this role, you will work closely with Operations and Development teams to design, develop, ...

Hyderabad, भारत

  • Full-time
Oracle Database Administrator Unlock your potential with Dassault Systèmes, a global leader in Scientific Software Engineering as Oracle Database Administrator, Bangalore . We are looking for a motivated Oracle database administrator who will support multiple mission-critical production databases for Dassault Systemes online ...

Bangalore, भारत

  • Hybrid
  • Full-time
  • Contract
Agency : Havas Creative Job Description : The Senior Database Administrator is a hands-on senior technical role responsible for the reliability, availability, security, performance, recoverability, and lifecycle management of enterprise Microsoft SQL Server environments. The position owns operational and strategic administration ...

Chennai, भारत

  • Remote
  • Full-time
... world. Miratech retains nearly 1000 full-time professionals, and our annual growth rate exceeds 25%. Job Description We are looking for an experienced MySQL Database Administrator to join our growing cloud operations organization. In this role, you will work closely with Operations and Development teams to design, develop, ...

Calcutta, भारत

  • Remote
  • Full-time
... world. Miratech retains nearly 1000 full-time professionals, and our annual growth rate exceeds 25%. Job Description We are looking for an experienced MySQL Database Administrator to join our growing cloud operations organization. In this role, you will work closely with Operations and Development teams to design, develop, ...

Gurgaon, भारत

Durapid Technologies Pvt Ltd

PostgreSQL Database Administrator (DBA)

  • Hybrid
  • Full-time

Rs 80000 - Rs 110000 per month

Job Title: PostgreSQL Database Administrator (DBA) Location: Gurgaon (Hybrid) Experience: 3–4 Years Notice Period: Immediate to 7 Days Employment Type: Full-Time Job Summary: We are looking for a skilled PostgreSQL Database Administrator (DBA) with 3–4 years of hands-on experience in database administration, performance ...

Gurgaon, भारत

  • Remote
... Position Summary The Application Database Administrator provides shared Service Delivery Management (SDM) support across multiple enterprise applications and database platforms. The role helps ensure application availability, operational stability, database performance, and timely resolution of production issues supporting ...

Hyderabad, भारत