We are seeking an experienced Senior Associate Database Administrator with deep expertise in PostgreSQL (Open Source & EDB) and hands-on experience across multi-cloud environments (AWS, Azure, GCP). The ideal candidate will have a proven track record of managing mission-critical databases, architecting high-availability solutions, executing performance tuning, and delivering robust backup and recovery strategies. You will be part of Datavails Global PostgreSQL Practice, working with diverse clients, complex architectures, and cutting-edge cloud technologies.

Key Responsibilities :

Database Administration & Architecture :

- Administer, configure, and maintain PostgreSQL databases (Open Source and EDB PostgreSQL) across on-premises and cloud (AWS RDS & Aurora, Microsoft Azure Database for PostgreSQL, GCP).

- Perform database installation using source code, RPM packages, and one-click deployment methods.

- Architect and implement high availability and disaster recovery strategies, including replication (streaming, cascading), failover, and DR servers.

- Configure and manage load balancing using pgpool.

Backup, Recovery & Upgrades :

- Design and execute logical and physical backup strategies using BARMAN, pgbackrest, and native PostgreSQL tools.

- Implement and test Point-in-Time Recovery (PITR) and restore strategies (pg_restore, pg_dump, pg_upgrade).

- Manage version upgrades (major & minor) with zero or minimal downtime.

- Apply database patches and security updates in a controlled, documented manner.

Performance Monitoring & Tuning :

- Monitor database health using pgAdmin, pgbadger, pgbouncer, and custom scripts.

- Optimize database parameters for maximum performance and stability.

- Investigate and resolve performance bottlenecks, query tuning, and resource utilization issues.

- Configure query analytics in Azure Query Store and set up performance dashboards.

Cloud & Cross-Platform Integration :

- Provision and manage AWS Aurora PostgreSQL clusters, configure read replicas, and tune parameter groups.

- Integrate PostgreSQL logs with AWS S3 and Azure Log Analytics for centralized monitoring.

- Configure heterogeneous database connections between Oracle and PostgreSQL.

- Execute and lead Oracle-to-PostgreSQL migrations using migration tools and custom scripts.

Automation & Scripting :

- Develop shell scripts for automated backups, maintenance tasks, and monitoring alerts.

- Automate routine DBA operations to improve efficiency and reliability.

- Implement proactive monitoring and self-healing scripts for database environments.

Troubleshooting & Security :

- Diagnose and resolve database corruption issues and unexpected failures.

- Implement and enforce security best practices, including user access control, tablespace management, and encryption.

- Maintain compliance with organizational and industry security standards.

Required Skills & Tools :

- PostgreSQL Core & EDB PostgreSQL Architecture, replication, backup & recovery.

- Monitoring & Administration Tools pgAdmin, pgbadger, pgbouncer, pg_repack, repmgr.

- Backup & DR Tools BARMAN, pgbackrest.

- Cloud Platforms AWS (RDS, Aurora), Azure (PostgreSQL, Query Store), GCP (PostgreSQL).

- Performance & Tuning Query optimization, parameter tuning, connection pooling.

- Scripting Strong in Linux shell scripting for automation.

- Migration Expertise Oracle-to-PostgreSQL migration strategies and execution.