12+ 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| 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|Patroni) and Monitoring tool like PEM |Prometheus| Grafana.
• Scheduled maintenance activities to vacuum, analyze to improve the query response time.
• Analysis log using Pgbadger tool and query tuning.