31 Aug
|
LeadSquared
|
Mumbai
31 Aug
LeadSquared
Mumbai
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.
Key Responsibilities
Database Administration & OperationsAdminister 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.
Cloud Database ManagementAdminister 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 PlanningAnalyse 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 CollaborationMentor 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 Qualifications4–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.Solid 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 QualificationsExperience with Infrastructure-as-Code tools (Terraform, Ansible) for database provisioningand configuration.Knowledge of NoSQL data modelling patterns and distributed database architectures.Familiarity with automated schema migration tools such as Flyway or Liquibase in GitOpsworkflows.Relevant certifications: AWS Certified Database Specialty, Google Cloud Professional DataEngineer, or Oracle DBA.Prior experience working in a SaaS or high-scale product engineering environment.
📌 Lead Database Administrator (Mumbai)
🏢 LeadSquared
📍 Mumbai