Vaibhav Patil
Oracle DBA || total 7+Years of experience|!GG|| Dataguard||Datapump||performance tuningl|RAC
- Role
- Senior Oracle Database Administrator at HCLTech
- Location
- Nagpur, MH, IN
- LinkedIn followers
- 500 followers
About Vaibhav Patil
Oracle Database Administration of 6+ years of experienceMonitor/Manage RAC environment database using OEM. Responsible for continuous database monitoring and reorganize the optimum performance of database. Monitored top wait event,sql ids/ top sessions using OE Administering User accounts and granting privileges, managing Profiles as well as Roles (User MGMT). Monitoring tablespaces for space usage and adding required space whenever it reaches threshold (space mgmt.) Creating AWR/ADDM/ASH reports for details investigation on performance. Hands-on experience on performance tuning. SQL tunning using sql tunning advisior,creating sql plan management,sql plan and baseline. Analyzing long running Sql ids and resolving issue with application team. Identifying long running jobs, blocking sessions and killing session process manually. Checking best plan and perform tuning activity. Identify the issue and raise oracle service request to identify the root cause. Database backup using RMAN (differential and cumulative) backup. Database full recovery using RMAN Level 0, Level 1 and archive backup. Work experience on OEM like adding datafile,blackout place and performance issue. Working knowledge of EXPDP and IMPDP Datapump. Handling changes in work environment. Participated in patching and upgrading activity in Production Environment. Knowledge of bash shell scripting. Working knowledge for RAC. Working knowledge of Oracle 12c Dataguard. Create standby database from backup copy of the primary database. Manage operation of physical/logical standby databases archiver stuck,space management. Working knowledge of DGMGRL tool for switchover and switchback using dataguard. Installed and configured of goldengate on 12c database for replication. Involved In database troubleshooting and maintaince activities and solve the issue like abended,lagging and long transaction issues.
Experience
Senior Oracle Database Administrator
Jul 2018 — Present
Education
RTMNU
ElectronicsEngineering
2009 — 2012
G.H Raisoni college of Engineering Nagpur
Master of Technology (M.Tech.)
2012 — 2014
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.