Profile Summary-> Migrate/Upgrade/manage DB in AWS/OCI/Azure.> Conducting Performance Review of Oracle Database for business critical applications> AWR , ASH , ADDM reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth> Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries> Troubleshooting oracle performance using sql monitor, Execution Plan, Oracle hints (SQL patching) and creation of new indexes to improve the performance of SQL statements > Provide tuning recommendations and future memory requirements to Support DBA team to make the changes in Database like table reorg, add enough spaces to databases> Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.Experience in Performance Tuning using AWR, ASH and ADDM.> Experience of creating and managing SQL plan Baseline ,sql patching and SQL profiles.> Experience in Table and index Partitioning working with global and local indexes.> Tracing user session.> Hands on experience on OEM, RAC, Data Guard, Golden Gate and ASM.> Exposure of OMS 12c/13c configuration and managing target through OEM.> Expertise on database backup/recovery strategy (RMAN, Export/Import & Datapump) on Production, Development and testing environment.> Created standby databases, database cloning via RMAN.> Expertise with Data Guard implementation and maintenance for Disaster Recovery on-prem and cloud.> Resync standby database with primary database.> Experience in Database migration (via exp/imp) 11g/12c on Production/Development databases.> Liaising with the Onshore/Offshore DBA team on a regular basis to discuss and resolve the Database related issues