About the Role :
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 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 & 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.(ref : hirist.tech)
