AdTechTalent
Engineering2 months agoOn-site

PubMatic

Database Administrator

MySQLProxySQLPostgreSQLdatabase administrationperformance tuningquery optimizationhigh availabilitybackupreplicationLinuxBashPythonAnsiblePerconadisaster recoverydatabase security

Key details

Salary

Not specified

Employment type

Full-time

Seniority

Mid-level

Years experience

3-5

Location

Pune, India

Full job description

Seeking a Database Administrator with 3-5 years experience in MySQL, ProxySQL, and PostgreSQL. Responsibilities include managing MySQL databases in production, QA, and development; implementing MySQL Group Replication; deploying DML and DDL changes; on-call escalation for critical issues; query tuning and schema optimization; managing replication topologies; configuring ProxySQL; Linux administration; scripting in Bash/Python; maintaining backups and restorations; monitoring and capacity planning; incident response; and collaborating with DevOps and Engineering. Requirements include experience with MySQL v8.x, PostgreSQL knowledge, high availability clustering, InnoDB, Performance Schema, ProxySQL, disaster recovery, scripting, Linux, automation with Ansible, query optimization, replication, backups, Percona tools (advantage), database security, and a relevant bachelor's or master's degree.

What you'll do

  • Manage and maintain MySQL databases across production, QA, and development environments
  • Implement and manage MySQL Group Replication for failover and redundancy
  • Review and deploy DML and DDL changes to support application releases
  • Serve in on-call rotation for critical database production issues and drive escalation/resolution
  • Conduct query performance tuning, indexing strategies, and schema optimization
  • Setup and maintain master-slave replication topologies for high availability and scaling
  • Configure and maintain ProxySQL for load balancing and query routing
  • Monitor ProxySQL logs and troubleshoot database connection issues
  • Perform Linux system administration and shell programming for storage and performance tuning
  • Write Bash/Python scripts to automate administrative tasks
  • 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, or replication failures
  • Collaborate with DevOps and Engineering teams to resolve database-related challenges

Requirements

  • 3 to 5 years experience administering MySQL v8.x Servers
  • Knowledge of PostgreSQL
  • MySQL Server Installation, Upgrades, Migrations and Configuration
  • Experience with clustering solutions for High Availability
  • Advanced knowledge of InnoDB storage engine
  • Expert knowledge of Performance Schema
  • Knowledge of GR cluster and ProxySQL usage with MySQL
  • Experience in Disaster recovery planning and implementation
  • Good scripting skills (Bash/Python)
  • Well-versed with Linux systems
  • Understanding of automation concepts (Ansible)
  • Query and schema optimization skills
  • Deep understanding of replication setup and issues
  • Complete understanding of backups, restores, recovery, and database maintenance
  • Experience with Percona tools (advantage)
  • Advanced understanding of Linux OS
  • Experience in monitoring and issue detection
  • Experience in index/job fine tuning and query optimizations
  • Ability to troubleshoot and resolve MySQL server and replication issues
  • Experience with database security, compliance, and audit logging
  • Bachelor’s or master’s degree in computer science, Data Science, Statistics, Mathematics, Engineering, or related field

Tech stack

MySQLProxySQLPostgreSQLLinuxBashPythonAnsiblePercona tools

Apply now

Ready to take the next step in your career? Click the button below to continue to the application process.

Continue to applicationBrowse more jobs

Similar jobs

More roles worth a look

Related opportunities based on specialty and working model so candidates can keep momentum.