Cloud Database Administrator_PostgreSQL_Pune

Role -Cloud Database Administrator (PostgreSQL | Azure | AWS)

Skill Set -PostgreSQL (13.x to latest), Azure Database for PostgreSQL Flexible Server, AWS RDS/Aurora PostgreSQL, performance tuning, query execution plan analysis, cloud database migrations, PostgreSQL major version upgrades, backup/restore and disaster recovery, Linux, scripting (Shell/Python/PowerShell), IaC (Terraform/ARM/CloudFormation)

Experience-6–12 years

Location-Pune

Skills / Competencies

Must‑Have

• Strong hands-on experience with PostgreSQL (13.x to latest versions)

• Expertise in Azure PostgreSQL Flexible Server and AWS RDS / Aurora PostgreSQL

• Strong database performance tuning and optimization skills

• Query execution plan analysis, indexing, and troubleshooting expertise

• Proven experience in cloud database migrations and PostgreSQL major version upgrades

• Knowledge of backup/restore strategies, HA/DR implementations, and PITR

• Familiarity with Linux environments and database internals

• Strong analytical and troubleshooting skills

• Ability to work in high-pressure production environments

• Excellent communication and stakeholder management

Good‑to‑Have

• Experience with Kubernetes (AKS/EKS) and stateful workloads

• Knowledge of KEDA, HPA/VPA for DB-related workloads

• Exposure to encryption technologies (KMS, Key Vault, CMK)

• Experience with monitoring tools such as Prometheus and Grafana

• Exposure to multi-tenant architectures and cross-subscription/tenant setups

• Experience in cost optimization initiatives

• Documentation and reporting skills for RCA, audits, and compliance

• Preferred certifications: Microsoft Azure Database / Administrator, AWS Certified Database Specialty or Solutions Architect, PostgreSQL certifications

Responsibilities / Expectations from the Role

SN

Responsibility

1

Manage and support PostgreSQL databases on Azure Database for PostgreSQL (Flexible Server) and AWS RDS / Aurora PostgreSQL.

2

Perform database provisioning, configuration, monitoring, maintenance, backup/restore, and ensure HA/DR readiness.

3

Analyze and optimize database performance using query tuning, indexing strategies, execution plan analysis, and monitoring tools such as Azure Monitor, AWS CloudWatch, and pg_stat_* views.

4

Identify and resolve performance bottlenecks related to CPU, memory, I/O, locks, and capacity planning.

5

Administer cloud-native database services including scaling, storage optimization, cost optimization, networking, security groups, IAM/RBAC, encryption, audit logs, and access control.

6

Plan and execute database migration projects including on-prem to cloud and cross-cloud migrations using Azure DMS, AWS DMS, and native PostgreSQL replication.

7

Plan and execute PostgreSQL major version upgrades with minimal downtime, including compatibility checks, blue-green or replica-based strategies, and post-upgrade validation.

8

Automate DBA tasks using Shell scripting, Python, or PowerShell and implement Infrastructure as Code where applicable.

9

Work closely with application teams, DevOps engineers, and cloud architects; provide L2/L3 production support, participate in incident RCA, and contribute to runbooks and SOPs.

10

Drive success metrics including database uptime, query performance improvements, migration success with minimal downtime, upgrade success without regression, and cost optimization achieved.