Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: Gurgaon; Pune; Coimbatore; Chennai; Hyderabad; Bangalore, India
We are seeking an experienced Lead PostgreSQL DBA to join our team and drive the automation, validation, and hardening of our critical database environments. In this role, you will design resilient recovery solutions across a diverse multi-database ecosystem while leveraging cloud platforms and modern DevOps practices to safeguard mission-critical data.
Responsibilities
Write and maintain Ansible playbooks and Jenkins pipelines to automate the end-to-end build-out of database recovery environments
Execute rigorous simulation drills to restore multi-terabyte databases into isolated cloud environments using cloud object storage (buckets)
Optimize and secure SQL Server, PostgreSQL, and Oracle instances against data loss scenarios
Harden MySQL, MongoDB, and CockroachDB environments to mitigate risk and ensure business continuity
Design and validate disaster recovery runbooks across heterogeneous database platforms
Collaborate with cross-functional teams to continuously improve cyber resilience and restoration strategies
Requirements
8-15 years of general IT experience, including at least 8 years of professional experience in database engineering and administration
Expertise in hands-on administration, replication, and recovery across SQL Server, Oracle, and PostgreSQL
Proficiency in managing and recovering MySQL, MongoDB, and CockroachDB
Background in working with at least two major cloud providers (GCP, AWS, or Azure)
Skills in managing, securing, and lifecycle-mapping cloud storage buckets
Production experience using Ansible for automated database deployments and configurations, alongside Jenkins for continuous integration and recovery jobs
Proven track record of building and executing complex disaster recovery (DR) or cyber resilience restoration runbooks
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?