the past 11.6+ years as an PostgreSQL/Oracle database Administrator experienced in information technology. Hereby I provide you with a brief overview of my skill set:
· Having experience of Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
· Data Replication - Streaming replication.
· Expert in Backup & Recovery including bart,barman tools, Pg dump, setting up WAL archiving, Point in time recovery.
· 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.