Postgresql Database Administrator(L3)

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 etcDesign, 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 issuesDB 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 guidelinesBased on the specific requests, help project teams to optimize PostgreSQL configurationsRestoration of EDB Postgres Database using pg_restore and PITR as per requirement of usres and applicationLinux (RHEL & OEL 6,7 and 8) and Windows server 2012,2016 and 2019Logical backup using PG_Dump and PG_Dumpall and restoration using PG_RestoreDatabase Maintenance (VACUUM, VACUUM FULL, ANALYZE ,AUTOVACCUM, REINDEXING, VACUUMDB), Performance Benchmarking using PGBENCH Preferred candidate profile .