Description

You will manage and optimize PostgreSQL database environments across production, DR, and non-production settings.

Responsibilities

• Install, configure, upgrade, and patch PostgreSQL databases while managing high availability and disaster recovery via streaming and logical replication.
• Perform backups and recovery using Barman and native utilities to ensure uptime in 24x7 environments.
• Monitor and tune SQL queries, indexes, memory, I/O, and vacuum processes to resolve performance bottlenecks.
• Implement database security including RBAC, encryption, auditing, and logging to meet compliance standards.
• Automate database tasks and support CI/CD pipelines through integration with DevOps practices.
• Act as an L3 escalation point for complex incidents, performing root cause analysis and mentoring L1/L2 DBAs.

Required Skills

• 5+ years of experience in database administration.
• Deep expertise with PostgreSQL, including on-premises and AWS RDS (PostgreSQL, Aurora).
• Hands-on experience with AWS DMS and native tools for on-premises to cloud migrations.
• Proficiency with Shell, Python, and Ansible for task automation.
• Experience managing databases on Azure Database for PostgreSQL and GCP Cloud SQL.
• Strong SQL skills for query tuning and execution plan analysis.
• Knowledge of CI/CD pipelines and DevOps integration.
• Ability to manage HA/DR architectures and capacity planning.

Preferred Skills

• Experience with GCP Cloud SQL.

Key Skills

Education

Any Gradute