Vishal Hande
Senior Oracle Database Administrator | AWS Cloud DBA | MySQL DBA at TCS
- Role
- Senior Oracle Database Administrator at Tata Consultancy Services
- Location
- Mumbai, MH, IN
- LinkedIn followers
- 500 followers
About Vishal Hande
With more than 13 years of experience as a Database Administrator (DBA) in Oracle…
Experience
Senior Oracle Database Administrator
Oct 2015 — Present · Mumbai, IN
Successfully managed a portfolio of over 500 production databases, encompassing Standalone, RAC, and RAC one node configurations.• Proficiently installed, configured, and administered Oracle versions 10g, 11g, 12c, and 19c, ensuring seamless database operations.• Implemented high availability measures by configuring Oracle Physical Standby databases (Data Guard) to safeguard against downtime.• Applied quarterly Oracle patches across all database servers to enhance security and performance.• Conducted full database refresh and schema refresh of Production databases to non-production databases using expdp/impdp.• Monitored Standby databases, promptly troubleshooting discrepancies between standby and production databases.• Deployed Oracle Enterprise Manager (EM) 13.3 agents on all servers using the push method for efficient centralized management.• Successfully integrated newly created databases into OEM and resolved issues with targets in unknown or down status.• Managed the upgrade of Oracle GRID and RDBMS from version 11.2.0.4 to 12.2.0.1 using the Out-of-Place method.• Proficiently created new users, assigned roles, privileges, and profiles to ensure secure and controlled access.• Collaborated with Oracle Support to address bugs and errors, including resolving issues such as ORA-600.• Effectively managed space in mount points and ASM disk groups, optimizing storage efficiency.• Monitored scheduled RMAN backups, promptly addressing any issues to ensure data integrity 24/7.• Played a key role in database creation and upgrades in both Standalone and RAC configurations.• Proactively monitored tablespace growth, adding new data files and resizing existing data files as needed.• Conducted regular gathering of statistics and rebuilding of indexes to optimize database performance.• Managed archived data on tape for efficient data storage and retrieval.• Specialized in RMAN Backup-Based Duplication and Active Database Duplication techniques.
Education
University of Mumbai
Master of Computer Applications - MCA
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.