Prashanth Kumar Email & Phone Number

HI I Have a 9+ years of experience in Oracle DBA , working in Data Intensity .Below are my key skills. Space Remediation on servers and following up with the onsite regarding the space checks and adding of space and working GAR reports and performing the database health checks reports.  Expertise in Logical backup (Export& Import, EXPDP & IMPDP) and Physical backup (Hot & Cold). Experience in creating Database links (Public, Private) and Materialized views. Experience in Oracle Data guard for high availability, Standby builds and DG issues. Performed disaster recovery and point in time recovery. Good experience in deleting nodes and adding nodes in cluster environment. Good experience in Managing Cluster ware components using SRVCTL and CRSCTL utilities. Backup of RAC components like OCR and Voting disks. Having good experience on Applying quarterly released CPU/PSU patches on standalone, RAC and standby setups. Good Experience in many Database refreshes/Cloning using Export& Import, Data pump and RMAN. Proficiency with Backup and Recovery’s including User managed backups, Logical Backups and RMAN backup. Good Experience Migration of databases from Linux to Windows, Windows to Linux. Experience on Performance tuning like query tuning using Explain plan, AWR reports and SQL tracing. Working on performance issues & SQL Plan Management, setting old good hash value to SQL_ID’s. Good experience in OEM 13c ,12c and 11g. Installed and configured OEM Cloud Control 13c on 40+ database. Good experience in Oracle Database Upgradations from 11g to 12c. Wrote Several shell scripts to automate the RMAN, expdp/impdp scripts, Database monitoring in Windows and Linux environments. Automated the Database Cloning Process both RMAN Active Duplication, Backup based duplication. Refreshing Production, development and test databases using Export & Import/Data pump /Clone /RMAN/ Hot backup, snap backup and RMAN active duplicate Involved in Scheduling backups, alerts mechanism for the production/dev/test on Linux and Windows environments. Having experience in migrating schema from ON premises to AWS. Having experience in installation of oracle Golden Gate 11g and 12c on Linux. Working on weekly maintenance activities like Re-orgs, Rebuild Indexes and Gather Stats and patch Database clones and change request implementation etc. Having good experience on troubleshooting issue while implementing Data guard setup, sync issues and DR exercises etc. Created standby databases and worked on SYNC issues using DBVISIT.

• 

  Jntuh College Of Engineering Hyderabad

  Electrical And Electronics Engineering