Mangesh Hase

Senior Database Administrator with 12+ years of IT experience and 2 years of PostgreSQL DBA experience. Strong expertise in Oracle 19c/12c/11g, RAC, Data Guard, RMAN, ASM, performance tuning, backup/recovery, database migration, and production support. Hands-on experience in PostgreSQL administration, monitoring, backup/recovery, and troubleshooting, along with experience supporting AWS cloud environments, database migration, high availability, and cloud-based database infrastructure.

Senior Oracle DBA at Wipro Limited (2016-10 – Present)

Codan/Alm Brand Group Project - Insurance Domain, HSBC, Citi Bank

• Managed production and non-production Oracle and PostgreSQL databases, ensuring high availability, performance, security, stability, and reliability for critical business applications.
• Having 4 years of onsite experience as a Senior Oracle DBA, managing production and non-production database environments.
• Performed database administration activities across Oracle 19c/12c/11g and PostgreSQL including installation, configuration, database creation, user and role management, privileges, schemas, tablespaces, database links, ACLs, listeners, and database connectivity.
• Performed Oracle RMAN backup, recovery, rebaseline using RMAN, duplication, cloning, and migration activities, along with PostgreSQL backup and recovery using pg_dump, pg_dumpall, and pg_restore.
• Supported AWS cloud environments for database administration activities, including database monitoring, connectivity, backup/recovery support, troubleshooting, and coordination with cloud/infrastructure teams.
• Managed Oracle Data Guard and Snapshot Standby environments, including log application, database masking, validation, role conversion, and recovery activities.
• Daily Oracle and PostgreSQL database health checks including database/instance availability, listener and connectivity status, alert and database logs, archive logs, sessions, locks, long-running queries, space utilization, and overall database health.
• Managed database storage and capacity, including Oracle tablespace extensions/datafile additions and PostgreSQL database/table growth monitoring, and ensuring sufficient space for application requirements.
• Performed database performance monitoring and troubleshooting, including analysis of Oracle execution plans, AWR/OEM alerts, sessions, locks, wait events, long-running queries and PostgreSQL slow queries, locks, connections, and resource utilization.
• Database maintenance activities including Oracle statistics gathering and PostgreSQL VACUUM, ANALYZE, and REINDEX as required for database performance and stability.
• Oracle database patching and PostgreSQL patching/upgrades including pre-checks, implementation, post-patch validation, troubleshooting, and coordination with infrastructure teams.
• Performed UAT and production deployment activities, including planned node/database shutdowns, session termination, database validation, deployment execution, and post-deployment verification through pre-built CI/CD pipelines.
• Handled production incidents, service requests, tasks, and change activities for Oracle and PostgreSQL databases, ensuring timely resolution within defined SLA requirements.
• Coordinated with application, infrastructure, middleware, DevOps, and other technical teams for database incidents, deployments, migrations, maintenance, patching, and performance-related activities.
• Supported database migration, cloning, refresh, and environment setup activities across development, UAT, and production environments for both Oracle and PostgreSQL platforms.
• HSBC: Managed DBA lead team activities, production incidents, database patching, monitoring, and automation tasks across enterprise database environments.
• Citibank: Managed daily DST/DMA portal activities, database monitoring, OEM alerts, production incidents, C-tasks, deployments, and automation activities.

Oracle DBA at Indus Software Technologies Pvt. Ltd. (2014-07 – 2016-08)

• Conducted monthly client visits to review database health, operational activities, and support requirements.
• Performed MDINDIA SQL data replication activities at the end of every month, including monitoring, execution, and validation of replicated data.
• Supported Oracle database availability through daily monitoring, production support, and proactive maintenance.
• Managed RMAN backup and recovery, hot/cold backups, and restore validation.
• Managed users, roles, privileges, tablespaces, datafiles, and space utilization.
• Monitored database, listener, alert logs, and backup status and resolved operational issues.
• Supported database refresh, cloning, export/import, and environment-related activities.
• Worked across Oracle 19c, 12c, 11g, and 10g environments.
• Coordinated with application and infrastructure teams for incident resolution and planned maintenance.

Master of Computer Application – MMCOE Pune (2008 – 2011)

B.Sc. in Computer Science – Pune University (2005 – 2008)