MySQL - Senior Lead Database Engineer

One97 Communications Limited; Dadri; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

Paytm, India's leading mobile payments and financial services distribution company, seeks a Database STL (Individual Contributor) with deep MySQL expertise and strong working knowledge of MongoDB, PostgreSQL, and Cassandra. The role combines hands-on database administration with strategic ownership of reliability, automation, and cloud adoption.

The candidate will lead by example, drive technical excellence, and collaborate with DevOps, SRE, and product engineering teams to deliver highly

Qualifications

• Must have deep MySQL expertise and strong working knowledge of MongoDB, PostgreSQL, and Cassandra.

Responsibilities

• Own end-to-end MySQL databases in production and staging.
• Architect and support MongoDB, PostgreSQL, and Cassandra clusters for scale and resilience.
• Define backup, recovery, HA, and DR strategies across all DB platforms.
• Tune queries, optimize schemas, indexing, and partitioning for high-volume workloads.
• Manage replication, clustering, and failover architectures for business continuity.
• Drive automation and AI-driven operations with self-healing scripts and predictive scaling.
• Collaborate with Cloud/DevOps on AWS DB services to optimize cost, security, and performance.
• Establish monitoring dashboards and alerts for slow queries, replication lag, and capacity planning.
• Lead incident management and on-call rotations to minimize MTTR.
• Contribute to database roadmaps and automation strategies as a technical partner.

Skills

MySQL

MongoDB

PostgreSQL

Cassandra

AWS

DB Automation

Job description

Paytm is India's leading mobile payments and financial services distribution company. Pioneer of the mobile QR payments revolution in India, Paytm builds technologies that help small businesses with payments and commerce. Paytm’s mission is to serve half a billion Indians and bring them to the mainstream economy with the help of technology.

Role Overview

We are seeking a Database STL (Individual Contributor) with deep expertise in MySQL and strong working knowledge of MongoDB, PostgreSQL, and Cassandra. This role combines hands‑on database administration and optimization with strategic ownership of database reliability, automation, and cloud adoption. The candidate will lead by example—driving technical excellence, influencing best practices, and partnering cross‑functionally with DevOps, SRE, and product engineering teams to deliver highly available, secure, and scalable database platforms.

Key Responsibilities

• End‑to‑end ownership of MySQL databases in production & staging—availability, performance, and reliability.
• Architect, manage, and support MongoDB, PostgreSQL, and Cassandra clusters for scale and resilience.
• Define and enforce backup, recovery, HA, and DR strategies across all critical database platforms.
• Drive database performance engineering—tuning queries, optimizing schemas, indexing, and partitioning for high‑volume workloads.
• Own replication, clustering, and failover architectures ensuring business continuity.
• Champion automation & AI‑driven operations—design self‑healing scripts, predictive scaling, and proactive monitoring solutions. Collaborate with Cloud/DevOps teams on AWS database services (RDS, Aurora, DynamoDB, EC2, S3) to optimize cost, security, and performance.
• Establish monitoring dashboards & alerting mechanisms for slow queries, replication lag, deadlocks, and capacity planning. Ensure compliance & security standards—encryption, auditing, and regulatory requirements.
• Lead incident management & on‑call rotations, ensuring rapid response and minimal MTTR.
• Act as a strategic technical partner, contributing to database roadmaps, automation strategy, and adoption of AI‑driven DBA practices.

Compensation

If you are the right fit, we believe in creating wealth for you.