Venkatesh Hangal

• 13 years of experience as an Oracle DBA working in large scale production as well as testing environments
• Responsibilities during this time frame included Installation, Configuration, Upgrades, Backup and recovery, Patches, Migrations, Memory as well as space Management, Performance Tuning, Cloning/ Replication, RMAN, Data Guard, and RAC
• Responsible for the installation, configuration, and migration of Oracle databases to Exadata systems
• Managed backup, recovery, and disaster recovery solutions for Exadata environments using RMAN and Data Guard
• Utilized Oracle Exadata Health Checks, automated scripts, and monitoring tools to proactively detect and resolve issues before they impacted operations.
• Assisted in the design and implementation of high-availability architectures with Oracle RAC and Exadata, ensuring minimal downtime during planned maintenance.
• Conducted root-cause analysis for complex database performance issues and implemented corrective measures to improve overall system health and performance.
• Finally, extensive use of the Oracle Enterprise Manager Grid control
• Managing Oracle Databases on AWS on EC2 and RDS services
• Provision and Support Databases on AWS RDS cloud environment
• Migrating databases to AWS Cloud Environment
• Supported Main DBA functions in AWS EC2 environment and documenting in confluence page
• Highly experienced with UNIX (HP UX, IBM AIX, and Sun Solaris) LINUX
• Wrote many Shell Scripts (Korn Shell), automated many Database maintenance jobs
• Implemented and maintained Oracle Exadata for large OLTP and data warehousing workloads, resulting in improved database throughput and reduced query times.
• Improved the turn-around time for database cloning/test environment provisioning from days to hours
• Improved the RAC and Single Instance provisioning from days to hours using Automation and Enterprise Manager
• Received recognition from various teams and departments for fast and reliable services
• Experienced in Enterprise User Security with DB 12c and Active Directory using OUD
• Highly experienced in creation of Gold Images of Grid Infrastructure and Database Homes for OEM 12c and 13c
• Automation of provisioning Agents, Grid Infrastructure and Database Homes using EMCLI
• Patching 11g, 12c and 18c Grid Infrastructure and Database Homes using latest PSU's and RU patches
• Setting up backups using Oracle Enterprise Manager
• Cloning as well as replication of production environment for testing purposes using Oracle Enterprise Manager tool Test Master
• Upgrade of Grid Infrastructure from 12c to 18c using Rapid Home Provisioning (Fleet Maintenance)
• Automation of Rapid Home Provisioning tasks
• Experienced in database maintenance such as Capacity Monitoring, Performance Tuning (SQL & Memory Tuning I/O, etc.), and Database Security
• Extensive knowledge and experience with Real Application cluster (RAC) and ASM infrastructure Implementation and Support
• Highly experienced in Database Tuning using AWR, ADDM, ASH reports
• Experience in Implementing, configuring, trouble-shooting, switchover, failover of Physical Data guard on 12c
• Worked in team environment in order to complete other business goals, designs and reviews
• Maintained database integrity within team dynamic by troubleshooting, patching, updating, and performance enhancing
• Provided 7X24 Analyst on duty on call support for PNC's Mission Critical Databases
• Planned and installed upgrades of database management system software to enhance database performance.
• Documented and communicated database schemas using accepted notations.
• Passionate about learning and committed to continual improvement.
• Proven ability to develop and implement creative solutions to complex problems.
• Participated in team projects, demonstrating an ability to work collaboratively and effectively.
• Demonstrated leadership skills in managing projects from concept to completion.
• Organized and detail-oriented with a strong work ethic.

Worked as a team Lead, in a global DBA team which supports more than 300 production databases around the globe

• (Managed 6 onsite and 5 off site DBA Team)
• Designed and implemented multiple data warehouses/OLTP (Oracle/SQL Servers) on 10/11G RAC cluster servers on ASM disks
• Recent implementation includes 11G R2 RAC, 12C RAC using GRID INFRASTUCTURE and SACN
• Acted as a Lead in Banks 11G Migration from 10g and 9i databases
• (planning and execution and co-ordination), Migrated Bank's 700GB OLTP mission critical Database in 10Minutes of downtime
• (Using Golden Gate Replication)
• Applied multiple PSU/CPU (SPU) patches across the global databases incardination with the Change Management Process using Rolling Forward Upgrade with zero downtime
• Identified subsequently tuned badly performing SQL queries using Oracle utilities tracing, AWR, ASH and SPA
• Designed, planned, executed and documented new 12C cloud control enterprise monitoring system for the capital market databases
• Implemented Hitachi/EMC Shadow image backup for the on line databases in order to minimize the backup performance related issues on the servers
• Implemented TDE (Transparent Data Encryption) for the credit card numbers to meet the PCI compliance
• Implemented and managing Oracle Golden Gate replication between the OLTP and OLAP databases for live reporting
• Developed and implemented the DBA best practices for the database backup and recovery policies for National City and database maintenance jobs for different databases
• Responsible for supporting multiple stakeholders (Wealth Management (WM), Global Cache Management System (GCMS) applications which are running on Oracle/DB2 Databases including troubleshooting, implementation of physical database changes, security planning, index tuning, monitoring critical events
• Implemented 10G/11G Data Guard (Physical and Logical standby/Active Data Guard) as a Disaster Recovery Solution for the corporate databases
• Responsible for replication of multiple databases using Oracle streams and advanced replication for mobile banking systems
• Performing Oracle Database Backup/restores using RMAN and Net backup, impact analysis, and database migrations and creating documentation for production systems and automated the database maintenance jobs through scripts
• Extensive experience with data warehousing applications as well as transactional database development, install, configuration, administration, management of Oracle Databases
• Also experienced in implementing solutions such as Disaster & Recovery, Cloning, Database and Security, and High Availability
• Provided 7X24 On DBA on Call Support for Banks's mission critical databases
• Provided resources and skill sets to support DBA functions for applications.
• Proposed database changes to ease monitoring and administrative effort.
• Established working relationships across various departments to understand existing and emerging IT requirements.
• Troubleshot database issues to create and resolve trouble tickets.
• Reviewed database design to recommend enhancements or improvements.
• Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
• Developed automated processes to manage database creation in virtualized or cloud environment.
• Modified databases to meet needs and goals determined during planning process.