Postgresql Database Administrator(L3)

Vyntrapro Innovations; Pune District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Vyntrapro Innovations seeks an experienced PostgreSQL DBA to provide advanced support for Azure-hosted EDB PostgreSQL and Postgres community edition. The role covers implementation, high availability, disaster recovery, patching, monitoring, and performance tuning across Linux and Windows servers.

You will review logs, optimize configurations, assist project teams with DB parameter tuning, index recommendations, and query tuning guidelines, and perform pg_restore/PITR restorations as required.

Responsibilities

• Provide advance support for Application DB hosted Azure (EDB PostgreSQL and Postgres community edition)
• EDB Postgres Advanced Server (Implementation, Configuration, HA, Streaming Replication, EFM, REPMGR for Postgres Databases)
• Design, maintain and ensure high availability solutions including replication, clustering etc
• Design, Implement Disaster Recovery strategies
• On-demand support for system failure, DR/HA Drill, festival support
• Review periodic log files for PostgreSQL on proactive basis to find out potential risks and performance issues
• DB Patch management (minor and major upgrade)
• Postgres Performance monitoring and optimization (parameter configuration and recommendation)
• Provide inputs on tuning OS parameters as applicable to the DB server, provide advice on tuning the DB instance parameters, provide recommendation for indexes, provide query tuning guidelines
• Based on the specific requests, help project teams to optimize PostgreSQL configurations
• Restoration of EDB Postgres Database using pg_restore and PITR as per requirement of users and application
• Linux (RHEL & OEL 6,7 and 8) and Windows server 2012,2016 and 2019
• Logical backup using PG_Dump and PG_Dumpall and restoration using PG_Restore
• Database Maintenance (VACUUM, VACUUM FULL, ANALYZE ,AUTOVACCUM, REINDEXING, VACUUMDB), Performance Benchmarking using PGBENCH

Job description

Role & responsibilities

1. Provide advance support for Application DB hosted Azure (EDB PostgreSQL and Postgres community edition
2. 2. EDB Postgres Advanced Server (Implementation, Configuration, HA, Streaming Replication, EFM, & REPMGR for Postgres Databases)
3. 3. Design, maintain and ensure high availability solutions including replication, clustering etc
4. 4. Design, Implement Disaster Recovery strategies.
5. 5. On-demand support for system failure, DR/HA Drill, festival support
6. 6. Review periodic log files for PostgreSQL on proactive basis to find out potential risks and performance issues
7. 7. DB Patch management (minor and major upgrade)
8. 8. Postgres Performance monitoring and optimization (parameter configuration and recommendation)
9. 9. Provide inputs on tuning OS parameters as applicable to the DB server, provide advice on tuning the DB instance parameters, provide recommendation for indexes, provide query tuning guidelines
10. 10. Based on the specific requests, help project teams to optimize PostgreSQL configurations
11. 11. Restoration of EDB Postgres Database using pg_restore and PITR as per requirement of usres and application
12. 12. Linux (RHEL & OEL 6,7 and 8) and Windows server 2012,2016 and 2019
13. 13. Logical backup using PG_Dump and PG_Dumpall and restoration using PG_Restore
14. 14. Database Maintenance (VACUUM, VACUUM FULL, ANALYZE ,AUTOVACCUM, REINDEXING, VACUUMDB), Performance Benchmarking using PGBENCH

Preferred candidate profile