Lead Database Administrator

LeadSquared; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

LeadSquared is seeking a seasoned Database Administrator to manage diverse databases across production, staging, and development. You will optimize performance, implement HA patterns, and drive secure data practices.

You will collaborate with DevOps and engineering to migrate to cloud services, design scalable architectures, and participate in on-call incident response. Strong SQL, Linux scripting, and cloud experience are required.

Qualifications

• 4–6 years of hands-on database administration across multiple platforms.
• Deep expertise in two or more of: MySQL, PostgreSQL, MongoDB, Redis, Cassandra, or MS SQL Server.
• Experience managing cloud databases on AWS/GCP/Azure.
• Strong SQL proficiency including indexing and execution plans.
• Experience with replication, clustering, and HA architectures.
• Linux/Unix proficiency and shell scripting.
• Security principles: encryption, RBAC, auditing.
• Experience with monitoring/observability tools.

Responsibilities

• Administer and maintain databases across prod, staging, and dev environments.
• Monitor health, performance, queries, and resources; resolve bottlenecks.
• Design backup, recovery, replication, clustering, and failover strategies.
• Manage schema migrations and deployments with CI/CD/IaC.
• Uphold database security standards including RBAC and encryption.
• Work with cloud services (AWS RDS/Aurora, GCP Cloud SQL, Azure DB).
• Architect cloud-native database solutions for scalability and cost efficiency.
• Lead zero-downtime migrations to cloud services.
• Evaluate new cloud DB technologies and adopt as appropriate.

Skills

SQL proficiency

Cloud databases

Linux scripting

High availability

Security & RBAC

Performance tuning

NoSQL modelling

Monitoring & observability

Data replication

Capacity planning

Tools

Datadog

Prometheus/Grafana

Terraform

Ansible

Flyway/Liquibase

Job description

Key Responsibilities

Database Administration & Operations

• Administer and maintain multiple databases including MySQL, PostgreSQL, MongoDB, and Redis across production, staging, and development environments.
• Monitor database health, performance metrics, query execution plans, and system resources; resolve bottlenecks proactively.
• Design and enforce backup, recovery, replication, clustering, and failover strategies to guarantee high availability.
• Manage schema changes, DDL migrations, and version-controlled deployments in collaboration with engineering teams.
• Define and uphold database security standards including role-based access control, encryption, and audit logging.
• Administer cloud-managed database services on AWS (RDS, Aurora, DynamoDB), GCP (Cloud SQL, Spanner), or Azure Database platforms.
• Architect cloud-native database solutions with a focus on scalability, resilience, and cost optimisation.
• Lead zero-downtime migrations from on-premises databases to managed cloud services.
• Continuously evaluate emerging cloud database technologies and recommend adoption where appropriate.

Performance Tuning & Capacity Planning

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

Leadership & Cross-Functional Collaboration

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

Required Qualifications

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

Preferred Qualifications

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