Senior Postgres Database Engineer (Pune)

Title: Senior Postgres Database Engineer

Location: Pune Exp: 6+ years

Job Description:

Job Responsibilities

1. Database Engineering & Deployment Lead the deployment of current PostgreSQL instances and RDS/Aurora clusters. Install, configure, and upgrade PostgreSQL databases, ensuring alignment with product functionality and capacity requirements. Manage infrastructure as code by comparing live RDS actions against Terraform configurations.

2. Performance Monitoring & Optimization Conduct proactive health checks using AWS CloudWatch and Performance Insights. Analyze PostgreSQL logs and error reports to identify bottlenecks. Investigate complex performance issues and implement advanced tuning solutions (e.g., vacuum optimization, indexing strategies, and query plan analysis).

3. Operational Excellence & Support Execute data migrations using pg_dump/pg_restore or logical replication for minimal downtime. Perform database patching, service pack installations, and edition upgrades. Monitor server health, including CPU, memory utilization, and file system growth. Configure and fine-tune alerts to ensure 24x7 production stability.

4. Collaboration & Documentation Create and maintain detailed technical documentation for Postgres configurations and recovery procedures. Collaborate with a global, diverse team to resolve operational issues like batch failures or network errors. Apply on Kit Job: kitjob.in/job/4m6bzv