Prashant Gera Email & Phone Number

Working as Oracle DBA at HCL US Based MNC , Lucknow with 6+ years of expeiance and having progressive experience of Oracle 19c/18c/12c/11g Database Administration on Linux / Solaris / Windows env and supporting a variety of mission critical applications in enterprise and financial environment. Supporting more than 100 Oracle databases and 150 applications.Strong hands-on experience in Oracle 19c,18c,12c database installations, Oracle backup and recovery, RMAN Duplicate, Oracle Physical standby/Active Data guard setup.• Strong hands on 18c and 19c binaries installation on linux platform.• Strong hands on patching on clusterware RAC grid home and rdbms home using auto patch and Opatch utility.• Strong Hands on RAC Clusterware Upgrade from 18c to 19c.• Strong hands on RAC database upgrade from 12c to 18c and 18c to 19c.• To set SSL Connection to Oracle Database using JKS or Oracle Wallets.• Strong hands-on Oracle backup and recovery, RMAN Duplicate, Oracle Physical standby/Active Data guard setup.• Strong hands in ASM - EMC to pure migration.• Strong hands on two node RAC removal and Node addition.• Dropping and creation the RAC Clusterware database.• Database restore from standalone to 2 node RAC using RMAN utility.• Strong hands to start/stop clusterware using crsctl utility during VM Patching window.• Stop and start instances on 2 and 3 node RAC using srvctl utility.• Creating full and single instance blackout in OEM and start and stop the agent using emctl utility.Installed and configured OEM 12c, configured Agents, setup metrics and thresholds for Oracle Databases and hosts/targets.Strong hands on experience in multiple performance tuning tools like ARW, ADDM, ASH, TFA and worked on MPSTAT, VMSTAT, SAR, TOP to resolve performance bottlenecks at OS resources.Expert in setting and configuring RMAN backup and recovery using recovery catalogs and setting up backup policies and archive log and full backup scripts in communicating with the Veritas NetBackup in different environments. Worked as Senior DBA and handling a range of 100+ Oracle databases into 24x7 support model On/Off across globe and responsible for supporting various database issue used by business groups within Customer domain.Configured Targets and used Oracle OEM 12c to do the daily DBA tasks regarding the performance, maintenance.6+ Months of Onsite experience as Senior DBA at Client location , Bristol, UK.

Listed skills include Data Guard, Rman, Shell Scripting, Database Administration, and 8 others.