Technical: Handling the critical US based customers from finance domain with 1000+ databases on Linux, AIX, Windows, AWS RDS/EC2 Problem solving and root cause analysis (RCA) and defining the process improvement plan. Leading the customer on-boarding, requirement gathering, and the customer environment run through. Oracle GRID and Database upgrade to 19c (19c/12c/11g/10g) Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and using various oracle tools, hints, outlines, explain plan. Performing DR drill activities such as switch-over/switch-back and activating standby. Serving as an escalation point of contact for internal technical team and for the external stakeholders Preparing the strategy, plan of action (POA), and task checklist for critical projects.Operational: Leading the team of 40+ technology experts and the database enthusiasts. People Management and Operation Management. Preparing the strategy and plan of action for critical projects. Problem solving and root cause analysis (RCA). Periodic performance reviews to ensure that team is working towards the defined goals. Conducting appraisals and budgeting. Hiring, supervising, and mentoring the database administrator teams.

Oracle 11g,12c - RAC installation, Administration & Maintenance. Oracle Enterprise Manager 10g/11g installation/Configuration and Monitoring. Oracle RAC implementation - 19c/12c/11g.Database upgrades and Cross platform migration with minimum downtime (11g/12c/19c).Implementation of Transparent Data Encryption (TDE) Cloning and Refreshing of Database using RMAN and EXPDP/IMPDP utility.Applying CPU & PSU patches on Standalone and RAC environments.Configuration of Data-guard & resolved issue related to standby database.AWS RDS – Database upgrades, PSU patch apply, Database restore/recover, schema/object level refreshDatabase Restore/Recovery using RMAN, physical and logical backups.Configuration of physical Dataguard/Standby/replication, and handling DR Failover and switchover and switchbackTables partitioning in Production databases to improve performance, used exchange partition and online table redefinitionAutomation for backup monitoring/space monitoring/alerts/flashback databases/clearing archivelogs. Review the long running batch job and notifications using UNIX shell scripting.Handling shifts and managing resources and work delegation.

Provided support to global production support team as Lead Oracle DBA.Installed, configured, upgraded, migrated and patched Oracle databases in a heterogeneous environment. Extensively worked on the VERITAS clustered database, RMAN, OEM, DataGuard, database tuning and troubleshooting.Provided production and Development database support, and design review in a complex environment.Planned, Implemented and test disaster recovery system, using RMAN and custom written shell scripts. Handled Dataguard/HA switchover and BCP drills.Performed DR drills, tuned drill process and successfully ran the applications on DR site.Configured and maintained Oracle DataGuard configuration.Database monitoring and tuning queries using OEM, AWR, STATSPACK and custom scripts.Work involved is setting up UAT, TEST and SIT databases for Dev and ETL team. Database design, creation, data migration.Backup, stats gather, index rebuild, DB refresh, schema refresh job scheduling using AUTOSYS.VCS failover Configuration for PROD databases and testing.Bug tracking and fixing.Participated in BCP testing using SRDF cutover.

Oracle software installation/Configuration on Linux, Unix, Sun Solaris & WindowsConfiguration of physical Dataguard/Standby.Verifying the daily backups & taking manual/RMAN backups, if any failure is reported. Refreshing/cloning the development/test databases from production backup.Creating test & development instances from production per client requirements.Migrating RAC & other databases to higher versions of Oracle & to different hardware platformsCreating new databases and their structure from scratch as per client’s requirements.Creating and managing Logical & Physical Standby databases.Implemented snapshot standby databases and active data guard to reduce the load on the primary database.Schema refresh tasks using traditional exp/imp and DataPumpMigration & upgradation - Oracle Databases (8x- 9x-10x-11x) Applying oracle patchset and CPU patches. Oracle installation on Linux 3, 4 AS, Solaris, HP UX Platforms, AIX and Windows.SQL Tuning with Explain plan, Hints and ADDM.