having more than 12+ experience on Oracle/postgreSQL DBA on the following skill
migrate db from Oracle to postgreSQL using diff tool like ora2pg, scheme conversation tool or code migrate
• 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
for more details you can ping me chat or please share your email id so that I can share my experience CV with you for your reference.