Punit A. Hore
SENIOR POSTGRESQL/EPAS DATABASE ADMINISTRATOR
Manpada
Summary
Senior PostgreSQL/ EDB EPAS Database Administrator having 13+ years of experience in Service Delivery of Database Infrastructure operations, supporting mission-critical enterprise systems across diverse industries including Banking & finance, telecom, travel and oil & energy. Recognized for effective collaboration with cross-functional teams to implement best practices to achieve business excellence, operational and service quality.
Overview
13
13
years of professional experience
2
2
Certifications
1
1
Language
Work History
SENIOR POSTGRESQL DBA
ENTERPRISE DB SOFTWARE INDIA PVT. LTD
12.2024 - Current
- Worked as a Senior PostgreSQL DBA supporting one of the largest banking institutions in India, managing business critical EDB EPAS(PostgreSQL) database systems in Production and non-productions environments.
- Extensive hands-on experience with EDB EPAS, EFM, and PGD platforms with high availability and maintaining 99.99% uptime, serving technical owner for PostgreSQL EDB platforms, defining HA/DR architecture, upgrade strategy, and operational standards.
- Independently planned and executed complex production upgrades across EPAS, EFM, and PGD environments.
- Installed, configured and upgraded EDB failover manager (4.x, 5.x), including cluster setup, witness configuration, and failover testing.
- Installed and upgraded PGD (5.x) including EPAS(16.x) using rolling upgrade for multi-location cluster to ensure continuous availability.
- Planned and Performed EPAS 16.x installations and minor version upgrades, including pre-upgrade compatibility checks, rollback planning and post-upgrade validation.
- Implemented Barman-based backup and PITR strategies, regularly validating restore procedures to meet enterprise recovery objectives.
- Diagnosed and resolved performance bottlenecks related to CPU, I/O, replication lag, WAL pressure, and autovacuum.
- Collaborated closely with application, infrastructure, and security teams on schema changes, controlled releases, compliance audits, and production readiness reviews.
- Mentored junior DBAs; created upgrade runbooks, HA/DR procedures, operational documentation, and standardized database best practices across teams.
- Owned business-critical database platforms powering large-scale banking applications.
- Acted as primary on-call escalation owner for production incidents and guided junior DBAs during critical issue resolution.
LEAD DATABASE ENGINEER
PRICELINE TECHNOLOGY INDIA LLP
07.2017 - 07.2024
- Lead and managed a globally distributed team of six engineers across India, the US, and Canada supporting PostgreSQL and Oracle databases on-premises and in Google Cloud environments, ensuring seamless database operations across development, QA, and production.
- Oversee the maintenance and operation of 50+ PostgreSQL and 100+ Oracle databases, supporting 24x7 database uptime, and achieving 100% compliance with Service Level Agreements (SLAs).
- Strategically plan and execute quarterly Oracle database maintenance activities including patching, version upgrades, ensuring system security and performance optimization.
- Supported Postgresql -
- Installation and setup of PostgreSQL, EPAS, EDB’s EFM, PGD
- Performing backup, recovery, and upgrades of PostgreSQL databases
- Monitoring databases and diagnosing any issues
- Performing quality control audits to ensure accuracy, completeness, and proper usage of data.
- Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing
- GCP support tasks -
- Creating new postgresql/Mysql instances in Google cloud using Github and terraform
- Perform upgrade of postgresql/Mysql instances using Terraform.
- Managing user and access to databases in GCP.
- Utilize JIRA, Confluence, and Atlassian tools extensively to manage database support tickets, documentation, and project collaboration, streamlining communication and tracking across teams.
- Allocate and coordinate team resources for various database activities, including deployment and maintenance, to optimize workload efficiency.
- Develop and maintain automation scripts using shell scripting for database maintenance, deployment, and support tasks, reducing manual intervention and enhancing operational efficiency.
- Collaborate with application teams to plan and execute database maintenance, providing necessary support to ensure minimal downtime.
SENIOR CONSULTANT
CAPGEMINI INDIA PVT. LTD.
11.2015 - 07.2017
- Setup end to end Goldengate replication on RAC.
- - Install Goldengate 12.2
- - Setup bi-directional integrated replication
- - Setup DDL replication
- - Setup alerts and goldengate streams monitoring and manual alert scripts.
- Upgrade databases from 11.2.4 to 12.1.2.
- Prepare monitoring scripts for production databases.
- Experience on the ORACLE EXADATA system.
- Working as a L3 Team lead and managing a 7 member team.
ORACLE DBA ADVANCE
AMDOCS INDIA Pvt. Ltd.
12.2013 - 07.2015
- Handling over 800+ databases
- Managing logical refresh using DATAPUMP and traditional exp-imp utility.
- Creating and managing synonyms of application schemas.
- Automated database environment using SHELL SCRIPTS to monitor different environments.
- Backup Management
- - Taking Manual/ RMAN Hot and Cold Backups
- - Taking export Backups Through datapump utility.
- - Recovery Management
- Working on Goldengate replication, Monitoring and troubleshooting Lag issues.
ORACLE DBA
IBM INDIA Pvt. Ltd
08.2012 - 11.2013
- Oracle Installation
- - RDBMS Installation on Linux Box
- - Configuring Production/Test databases
- Storage Management
- - Adding & Resizing Datafile , creating tablespaces
- - Using locally managed tablespace (LMT).
- User Management
- - Managing 500+ users and Setting up different roles/privileges, profiles for users.
- - Controlling and monitoring user access to the database.
- Implemented ACTIVE STANDBY feature of Oracle 11gr2 on Test environment.
- Cloned oracle 11g database to the test environment using hot backup, and using ACTIVE STATE CLONE using RMAN.
- Performed Upgrade of database from 10.2.0.4 to 11.2.0.2.0.
- Performed Successful upgrade of ORACLE GOLDENGATE from 10.2.0.4 to 11.2.0.2.0.
Education
BE - Instrumentation
Parshwanath College of Engineering
Thane, MAHARASHTRAH.S.C - undefined
K.J SOMAIYA
MAHARASHTRA STATES.S.C - undefined
S.E.S.H.S
MAHARASHTRA STATECertification
11g OCA Certified
Declaration
I consider myself familiar with Information Technology Aspects. I am also confident of my ability to work in a team as well as an individual. I hereby declare that the information furnished above is true to the best of my knowledge. Date: _________ Place:_________ (Punit A Hore)
Timeline
SENIOR POSTGRESQL DBA
ENTERPRISE DB SOFTWARE INDIA PVT. LTD
12.2024 - Current
LEAD DATABASE ENGINEER
PRICELINE TECHNOLOGY INDIA LLP
07.2017 - 07.2024
SENIOR CONSULTANT
CAPGEMINI INDIA PVT. LTD.
11.2015 - 07.2017
ORACLE DBA ADVANCE
AMDOCS INDIA Pvt. Ltd.
12.2013 - 07.2015
ORACLE DBA
IBM INDIA Pvt. Ltd
08.2012 - 11.2013
BE - Instrumentation
Parshwanath College of Engineering
H.S.C - undefined
K.J SOMAIYA
S.S.C - undefined
S.E.S.H.S