**Job Title:** PostgreSQL Database Administrator (DBA) / Database Engineer – Deloitte
**Location:** Bengaluru, Karnataka (Mandatory – On-site / Hybrid)
**Experience:** 7+ Years
**Salary / CTC:** ₹18,00,000 – ₹28,50,000 per annum
**Job Type:** Full-time
About the Opportunity
We are hiring an experienced **PostgreSQL Database Administrator (DBA) / Database Engineer** to join **Deloitte** in Bengaluru. In this role, you will manage mission-critical PostgreSQL and AWS-managed database environments, driving performance optimization, high availability, security, and database automation at scale.
Key Responsibilities
- Install, configure, upgrade, and maintain enterprise **PostgreSQL** database environments.
- Administer and manage cloud-native databases on **Amazon RDS for PostgreSQL** and **Amazon Aurora PostgreSQL**.
- Execute seamless database migrations, version upgrades, backup routines, and point-in-time recovery operations.
- Proactively monitor database health, capacity, and resource utilization to troubleshoot and resolve critical production incidents.
- Perform deep-dive query optimization, indexing, table partitioning, and end-to-end performance tuning.
- Architect and maintain replication, high availability (HA), automated failover, and disaster recovery (DR) solutions.
- Enforce database security best practices, role-based access controls, and data encryption.
- Automate routine DBA workflows and maintenance tasks using scripting and infrastructure automation tools.
- Partner closely with application development, infrastructure, and DevOps teams to support scalable deployments.
Required Skills & Qualifications
- **Experience:** 7+ years of hands-on experience in Database Administration.
- **Core Database:** Deep expertise in **PostgreSQL** administration, architecture, and internals.
- **Cloud Databases:** Proven production experience managing **AWS RDS PostgreSQL** and **Aurora PostgreSQL**.
- **Performance & Reliability:** Strong command over query tuning, indexing, partitioning, backup/recovery, replication, HA/DR, and major-version upgrades.
- **AWS Ecosystem:** Hands‑on proficiency with **Amazon RDS, Aurora, AWS CloudWatch, IAM, KMS, AWS Backup, and AWS Secrets Manager**.
- **OS & Scripting:** Strong **Linux/Unix** system administration skills along with automation experience in **Shell scripting** and **Python**.
- **Education:** B.E. / B.Tech / MCA or an equivalent degree in Computer Science or a related technical discipline.
Preferred Skills (Good to Have)
- Track record of managing high-throughput, large-scale production databases.
- Exposure to Infrastructure-as-Code (IaC) tools such as **Terraform** or **AWS CloudFormation**.
- Experience with observability and monitoring stacks including **Prometheus, Alertmanager, and Grafana**.
- Familiarity with **AWS CloudWatch Database Insights** and automated database diagnostics.
Important Candidate Details
- **Work Location:** Bengaluru (Candidates must be based in or willing to relocate to Bengaluru).
- **Compensation:** ₹18 LPA – ₹28.5 LPA Total CTC (commensurate with experience and technical evaluation)
Pay: ₹1,800,000.00 - ₹2,700,000.00 per year
Work Location: In person