Source description
About the role
Role & 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 6. 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 usres 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 Preferred candidate profile .
More at Vyntrapro Innovations