Title: PostgreSQL L3

Location: pune

Exp: 8+ Years

Job Description:
Key Responsibilities:
- Provide L3 support and administration for EDB Postgres Advanced Server (EPAS), PostgreSQL Community Edition, Amazon Aurora PostgreSQL, and Azure Database for PostgreSQL Versatile Server.
- Manage PostgreSQL databases deployed on Azure VM, AWS EC2, and on-premises environments.
- Manage the complete lifecycle of cloud PostgreSQL platforms, including provisioning, configuration, security hardening, monitoring, backup and recovery, HA/DR, and performance optimization.
- Administer and optimize Azure PostgreSQL Flexible Server environments.
- Configure High Availability, Read Replicas, Point-in-Time Recovery (PITR), Long-Term Retention (LTR), Private Endpoints, and VNET integration.
- Monitor Azure PostgreSQL environments using Azure Monitor, Log Analytics, and Azure Alerts.
- Perform Flexible Server upgrades, storage and compute scaling, and maintenance planning.
- Manage Amazon Aurora PostgreSQL clusters in production environments.
- Configure and maintain Aurora Replicas,



Multi-AZ deployments, Global Database, Cross-Region DR, automated backups, and snapshots.
- Work with Aurora Serverless v2, Provisioned Clusters, Reader Endpoints, and Performance Insights.
- Perform Aurora patching, engine version upgrades, and failover testing.
- Design and implement HA/DR solutions using Aurora Global Database, Azure Flexible Server HA, EDB Failover Manager (EFM), RepMgr, Streaming Replication, and Logical Replication.
- Conduct DR drills and ensure compliance with defined RTO/RPO objectives.
- Perform database performance tuning and query optimization using pg_stat_statements, auto_explain, Performance Insights, Azure Query Store, and EXPLAIN ANALYZE.
- Optimize queries, indexes, partitioning, connection pooling using PgBouncer, and database parameters.
- Perform benchmarking and capacity planning using pgBench and workload simulation tools.
- Manage backup and recovery using pg_dump, pg

📌 PostgreSQL (Pune)
🏢 NR Consulting
📍 Pune