VISHAL PAWAR
Kamothe
Summary
Oracle Database Administrator specializing in Oracle databases and with 8+ years of experience. Supported enterprise database management through installations, migrations, upgrades, and high-availability planning. Strengthened performance and resilience using RAC, Data Guard, and tuning best practices. Managed backup and recovery processes while maintaining clear documentation and stakeholder communication.
Overview
3
3
Languages
1
1
Certification
9
9
years of professional experience
Work History
Oracle Database Administrator
Control M datacentre
Navi Mumbai
06.2026 - Current
- Configured and maintained Oracle High Availability frameworks, enhancing system resilience with Real Application Clusters, Automatic Storage Management, and Data Guard/Active Data Guard.
- Configured metric extensions, threshold limits, and user roles in OEM to support separate L1 and L2 teams.
- Executed database switchovers using OEM to ensure seamless transitions between primary and standby systems., failovers, Data Guard monitoring, and snapshot standby conversions using OEM.
- Implemented Patch Plan and Fleet Maintenance to enhance patch rollout for out-of-band, interim, and Release Update (RU) patches across RAC and standalone targets.
- Automated routine maintenance tasks, including alert log cleanup, listener log cleanup, AUD$ table purging, and tablespace expansion, using OEM jobs and Linux shell scripts.
- Orchestrated database migrations across platforms and supported cloud migrations, ensuring seamless transitions with cross-platform Data Guard, RMAN, and Data Pump.
- Analyzed system bottlenecks and optimized database performance using AWR, ADDM, ASH reports, and SQL Tuning Advisor.
- Identified and resolved slow-running queries, lock contentions, and resource constraints to improve application response times.
- Performed enterprise-wide monitoring, alert configuration, and management utilizing Oracle Enterprise Manager (OEM) Cloud Control.
- Automated routine maintenance operations and health checks, streamlining backup tasks using Shell scripts, Python, or Ansible.
Sr Oracle DBA
3i Infotech
Navi Mumbai
02.2026 - 06.2026
- Performed Oracle database backup and restore operations to ensure data integrity.
- Administered OEM 13c Cloud Control OMS and deployed management agents on Linux/AIX hosts to monitor 100+ production standby and RAC database targets.
- Set metric extensions, threshold limits, and user roles within OEM for separate L1 and L2 support teams.
- Used OEM to handle database switchovers, failovers, Data Guard monitoring, and snapshot standby conversions.
- Helped streamline patching through OEM Patch Plan and Fleet Maintenance for out-of-band, interim, and Release Update (RU) patches across RAC and standalone targets.
- Automated routine database maintenance tasks, including alert log cleanup, listener log cleanup, AUD$ table purging, and tablespace expansion, using OEM jobs and Linux shell scripts.
- Managed Oracle database backup, restore, and recovery operations.
- Administered OEM 13c Cloud Control OMS and deployed management agents on Linux/AIX hosts to monitor 100+ production standby and RAC database targets.
- Configured metric extensions, threshold thresholds, and role-based access within OEM for distinct L1 and L2 support teams.
- Directed OEM use for database switchovers, failovers, Data Guard monitoring, and snapshot standby conversions.
- Optimized patching workflow through OEM Patch Plan and Fleet Maintenance for out-of-band, interim, and Release Update (RU) patch application across RAC and standalone targets.
- Automated routine database maintenance, including alert log purging, listener log cleanup, AUD$ table maintenance, and tablespace expansion, through OEM jobs and Linux shell scripts.
- Supported Oracle database backups, restores, and recovery procedures to maintain database availability.
- Administered OEM 13c Cloud Control OMS and deployed agents on Linux/AIX hosts to monitor 100+ production standby and RAC database targets.
Sr. Oracle DBA & Goldengate Admin
Mindgate Solution
06.2025 - 02.2026
- Installation and management of Goldengate software
- Integration of Goldengate server in OEM Configuration
- Purging activity for large tables and tablespaces to lower high water mark.
- Performed initial load, full load & CDC on tables.
- Configured Goldengate integration with OEM.
- Handled client communications and SLAs.
- Responsible for creation and execution of POA
- A provider of IT solutions including banking technology
- Client (SBI Bank)
Sr. Oracle DBA & Goldengate Admin
Clover Infotech
Mumbai
02.2021 - 06.2025
- Performed database restoration and configure Datagaurd setup in Oracle RAC/NON-RAC
- Configured mail alerts for production databases
- Scheduled cron jobs on AIX and Linux to automate daily activities
- Migrated single instance non-ASM to RAC and vice versa
- Maintained and monitored databases for production clients
- Maintenance policy includes purging of large tables, tablespace, alert log, listener log, AUD$Table
- Performed database & Goldengate Switchover & Switchback activity
- Applied one off /port back interim patches to fix the bugs encountered in NON-RAC /RAC database.
- Performed failover of production RAC database.
- Addition deletion modification on Tables in Goldengate as per client requirement.
- Converted oracle RAC Physical standby into snapshot standby, Active Data Guard and vice- versa in 11g,12c 19C.
- Installation and configuration of Goldengate as per client requirement.
- A company specializing in IT services, including database management
- Mumbai Client (IDFC Bank)
Junior Oracle Dba
Oratechinfosolution Ltd
Mumbai
02.2018 - 02.2021
- Disks Space & Tablespace management
- Completed installation, configuration, and administration of grid infrastructure, Oracle software, and database instance in 11g, 12c, 18c, and 19c standalone database
- Used cluvfy utility to check pre-requisites for cluster configuration and user equivalence prior to RAC installation
- Upgraded GRID infrastructure software and database instance
- Done database creation, upgradation, listener creation, listener modification using DBCA, ASMCA, DBUA, NETCA and NETMGR.
- Table Movement & datafile movement activity
- A company providing Oracle database solutions
- Mumbai client (PAYCRAFT)
Education
Bachelor's Degree - T.Y.BSC.IT
Rajarshri Shahu College
Sion08-2017
H.S.C - Sion, Maharashtra
Aryan Jr. College
Sion, Maharashtra02-2013
S.S.C - Maharashtra
S.K. Pantawalawalkar High School
Maharashtra03-2011
Skills
- Data Guard administration
- Oracle RAC administration
- GoldenGate replication
- Incident management
- Change management
- Backup recovery
- Automation scripting
- Cloud database management
- Problem solving
- Team collaboration
- Disaster recovery planning
- Oracle RAC configuration
- Backup and recovery
- Storage management
- Patch management
- Oracle enterprise manager
- Database cloning
Personal Information
Title: Oracle DBA & Goldengate Administrator
Certification
Oracle PLSQL & DBA Diploma, Diploma in ORACLE PLSQL & DBA
LANGUAGES
Hindi Native, English Proficient, Marathi Native
INTERESTS
Hobbies, Enjoys playing outdoor games, swimming, and building friendships
Languages
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Marathi
Proficient (C2)
C2
Timeline
Oracle Database Administrator
Control M datacentre
06.2026 - Current
Sr Oracle DBA
3i Infotech
02.2026 - 06.2026
Sr. Oracle DBA & Goldengate Admin
Mindgate Solution
06.2025 - 02.2026
Sr. Oracle DBA & Goldengate Admin
Clover Infotech
02.2021 - 06.2025
Junior Oracle Dba
Oratechinfosolution Ltd
02.2018 - 02.2021
Bachelor's Degree - T.Y.BSC.IT
Rajarshri Shahu College
H.S.C - Sion, Maharashtra
Aryan Jr. College
S.S.C - Maharashtra
S.K. Pantawalawalkar High School