Work Type
Full TimeLocation Preference
RemoteHybridLocation: Gurugram, INDelhi, DLChandigarh, CHNoida, UP
Open to relocation: Yes
Open To Work
Verified
This profile is verified using an email address.
Himanshu Garg
Gurugram
Work Preference
Summary
Over 9 years of experience in Maintenance and administration of Databases, Core banking systems. Leading database administration, production support projects for bank in India. Strong background and expertise of Oracle databases.
Overview
1
1
Certification
9
9
years of professional experience
Work History
Senior Analyst
Wipro Ltd.
06.2024 - Current
- Supporting a large Oracle (80 TB+) database Infrastructure for a reputed Institution in the US.
- Resolved database issues and troubleshot performance problems, enhancing overall database performance.
- Performed quarterly database activities, including DR drills, patching, and capacity planning, ensuring system reliability.
- Provided 24x7 on-call support and daily operations support, maintaining database availability and performance.
- Monitoring and managing the DR site with Physical & Active Data Guard.
- Working with a team of Oracle database administration professionals and Responsible for performing and supporting database operations for a large Decor/Lifestyle company.
IT Analyst
Tata Consultancy Services
01.2023 - 05.2024
- Installation and administration of Oracle RAC, Non RAC, Datapump, Rman database restoration and DR drills switchover switchback.
- Administration of Oracle Goldengate with Lag issues, abends and storage issues.
- Set up and monitored databases for application teams using Oracle enterprise manager tool.
- Provided continuous database availability for application teams to enhance operational efficiency.
- Creating standard operating procedures for the database administration team to follow.
- Leading the database administration tasks of all Oracle databases for Royal group Environment.
Oracle Database Admin
Paytm Payments Bank
03.2020 - 01.2023
- Perform database upgrades from 12c to 19c for RAC & STANDALONE DBs.
- Installed 12c Grid infrastructure with two node RAC.
- Installed and configured 12c, 19c software on Linux, Solaris OS and created Database.
- Performed Storage addition activities in Oracle RAC ASM.
- Performance tuning, analysis of production issues and analyzing root causes.
- Administered and troubleshot backup restorations for the application team.
- Securing production database Infrastructure using AVDF monitoring tools. Closing security vulnerabilities. and supporting external and internal database audits.
- Resolution of complex database administration issues by engaging Oracle support, development teams.
- Performed database quarterly activities including DR drills and patching.
- Setup the new monitoring of the database through OEM 13c.
- Established user accounts and roles, assigned access permissions for application usage.
Oracle Database Admin
Access Infotech Pvt. Ltd.
03.2019 - 02.2020
- Providing support for the Punjab Haryana High court website for the upcoming cases and the decision given by the Judges on a daily basis.
Oracle Database Admin
Paytm Payments Bank
06.2018 - 02.2019
- Monitoring the Database through Oracle Spot Light.
- Raised the Service Request (SR) with Oracle Support.
- Creating and managing user profiles and privileges and configuring alerts on OEM.
- Monitoring tablespace size and archive logs, database space usage.
- Monitoring of the Database through Alert Log files and system health reports.
Technical Support Engineer
Mind Solutions Technologies
07.2017 - 06.2018
- Worked as a support engineer with BSNL client and provide the support to all the Franchisee, Sub-Franchisee and Retailers of BSNL’s are working to provide the services of Recharges, TopUp and Flexi to the users of BSNL.
Education
B-Tech - CSE
Rajasthan Technical University
Kota03-2016
Skills
- Oracle 19c,12c,11g
- Oracle RAC & ASM
- Oracle Data Guard
- Oracle Goldengate
- Database Upgrades
- Performance Tuning
- DR Drill Management
- OEM 13c
- DB Patching
- RMAN
- Database Restoration
Domain
- Core banking
- Textile
- Hospitality databases
Key Personal Skills
- Patient listener and Learner
- Seeking new learning & opportunities
Certification
- Oracle Cloud Infrastructure 2025 Certified Foundations Associate
Professional Development
- Oracle Cloud Infrastructure OCI Foundation Associate.
- Foundation to Oracle Database in Oracle Cloud Infrastructure OCI.
- Oracle Database Migration: On-Prem to OCI.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Senior Analyst
Wipro Ltd.
06.2024 - Current
IT Analyst
Tata Consultancy Services
01.2023 - 05.2024
Oracle Database Admin
Paytm Payments Bank
03.2020 - 01.2023
Oracle Database Admin
Access Infotech Pvt. Ltd.
03.2019 - 02.2020
Oracle Database Admin
Paytm Payments Bank
06.2018 - 02.2019
Technical Support Engineer
Mind Solutions Technologies
07.2017 - 06.2018
B-Tech - CSE
Rajasthan Technical University