11+ Exp PostgreSQL Databases Administrator
• Having experience of Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
• Having experience on installed the multi-cluster postgreSQL database on same server with different port.
• Experience in migrating oracle databases to PostgreSQL and upgrade from 9.x to 10.x,11.x,12.x PostgreSQL version
• Experience in setup Data Replication – Warm standby /Streaming/hot-standby replication.
• Expert in Backup & Recovery including Pg dump, Bart and Barman tool, setting up WAL archiving, Point in time recovery.
• Creation & managing PostgreSQL database, schema, tables, tablespaces and users, roles & groups.
• Having experience on Installation and configuration HA (EFM/Repmgr) and Monitoring tool (PEM).
• Scheduled maintenance activities to vacuum, analyze to improve the query response time.
• Daily log analysis using pgbadger tool and query tuning.
• Installing and monitoring PostgreSQL database using the standard monitoring tools like PEM etc
• Tools Support like PgAdmin, PgPool, PgBouncer [Installed & Configiured]
• EDB - Enterprise database Tools - EDB BART, EDB EFM, EDB PEM