Job Description

We are seeking a seasoned Lead Database Administrator to take full ownership of our database ecosystem. You will drive reliability, performance, and scalability across multiple database platforms on-premises and cloud while acting as the technical authority and mentor for our infrastructure team.

n

n

Key Responsibilities

n

n

Database Administration & Operations

n

n
- Administer and maintain multiple databases including MySQL, PostgreSQL, MongoDB, and Redis across production, staging, and development environments.
n
- Monitor database health, performance metrics, query execution plans, and system resources; resolve bottlenecks proactively.
n
- Design and enforce backup, recovery, replication, clustering, and failover strategies to guarantee high availability.
n
- Manage schema changes, DDL migrations, and version-controlled deployments in collaboration with engineering teams.
n
- Define and uphold database security standards including role-based access control, encryption, and audit logging.
n

n

n

Cloud Database Management

n

n
- Administer cloud-managed database services on AWS (RDS, Aurora, DynamoDB), GCP (Cloud SQL, Spanner), or Azure Database platforms.
n
- Architect cloud-native database solutions with a focus on scalability, resilience, and cost optimisation.
n
- Lead zero-downtime migrations from on-premises databases to managed cloud services.
n
- Continuously evaluate emerging cloud database technologies and recommend adoption where appropriate.
n

n

n

Performance Tuning & Capacity Planning

n

n
- Analyse slow queries, index strategies, and execution plans; implement targeted optimisations to meet SLA requirements.
n
- Conduct regular capacity planning and performance benchmarking across all environments.
n
- Collaborate with application engineers to review ORM usage and data models for performance at scale.
n

n

n





Leadership & Cross-Functional Collaboration

n

n
- Mentor junior DBAs and serve as the primary technical resource for all database-related decisions.
n
- Establish and maintain database standards, runbooks, and operational best practices documentation.
n
- Participate in on-call rotations and lead incident response for database outages.
n
- Partner with DevOps to integrate database management into CI/CD pipelines and IaC frameworks (Terraform, Ansible).
n

n

n

Required Qualifications

n

n
- 4–6 years of hands-on database administration experience across multiple database platforms.
n
- Deep expertise in two or more of: MySQL, PostgreSQL, MongoDB, Redis, Cassandra, or MS SQL Server.
n
- Proven experience managing cloud databases on AWS (RDS / Aurora), GCP (Cloud SQL), or Azure.
n
- Robust SQL proficiency — query optimisation, stored procedures, indexing, and execution plan analysis.
n
- Solid experience with replication, clustering, sharding, and high-availability architectures.
n
- Proficiency in Linux/Unix environments and shell scripting for automation and operations.
n
- Sound understanding of database security principles — encryption at rest/in transit, RBAC, and compliance.
n
- Experience with monitoring and observability tools such as Datadog, Prometheus/Grafana, or cloud-native monitors.
n

n

n

Preferred Qualifications

n

n
- Experience with Infrastructure-as-Code tools (Terraform, Ansible) for database provisioning
n
- and configuration.
n
- Knowledge of NoSQL data modelling patterns and distributed database architectures.
n
- Familiarity with automated schema migration tools such as Flyway or Liquibase in GitOps
n
- workflows.
n
- Relevant certifications: AWS Certified Database Specialty, Google Cloud Professional Data
n
- Engineer, or Oracle DBA.
n
- Prior experience working in a SaaS or high-scale product engineering environment.
n

📌 Lead Database Administrator (Bengaluru)
🏢 LeadSquared
📍 Bengaluru