Senior Postgres Database Engineer Pune

Title: Senior Postgres Database Engineer

Location: Pune

Exp: 6+ years

Job Description:

Job Responsibilities

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.

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).

Operational Excellence & Support

Execute data migrations using pgdump/pgrestore 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.

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/4mph1o