Experience in managing and maintaining mission-critical 24 by 7 production databases along with installation and configuration of the database, implementing high-availability solutions, setup monitoring tools, setup database security, optimizing resources, etc

Hands-on experience on Shell scripting

Must have: Experience on EDB products and Certifications

Key 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 usres and application
Linux (RHEL OEL 6,7 and 8) and Windows server 2012,2016 and 2019
Logical backup using PGDump and PGDumpall and restoration using PG_Restore
Database Maintenance (VACUUM, VACUUM FULL, ANALYZE ,AUTOVACCUM, REINDEXING, VACUUMDB), Performance Benchmarking using PGBENCH

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Postgresqlprofessional Pune
🏢 VyntraPro Innovations
📍 Pune