Himanshu Jaiswal
Oracle Database Administrator
H.no 218/4, Pul Pahladpur, New Delhi
Summary
Accomplished Sr. Oracle DBA with a proven track record at Coforge Limited, enhancing database performance and security. Expert in Oracle RAC Administration and Data Guard Implementation, coupled with exceptional problem-solving abilities and teamwork. Significantly improved system efficiency and reliability through innovative backup strategies and performance tuning.
Overview
7
7
years of professional experience
Work History
Oracle DBA
Coforge Limited
06.2022 - Current
- Upgradation/ Migration of Production and Development Databases.
- Managed backup jobs, DB Maintenance jobs and customized jobs for alerting & monitoring purpose.
- Performed point in time restoration & recovery using RMAN backup utility.
- Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
- Implemented capacity planning strategies, optimizing resource allocation and preventing system overloads.
- Responsible for the Real Application cluster (RAC) and Data Guard (Standby Database) Implementations.
- Configuration and Upgradation of OEM Server from OEM 12c to 13c.
- Streamlined backup processes, ensuring timely recovery in case of data loss or system failure.
- Improved database performance by optimizing SQL queries and implementing indexing strategies.
- Provided technical support to end-users, troubleshooting database-related issues and offering guidance on best practices.
- Managed user accounts within the Oracle Database environment, granting appropriate permissions while adhering to security protocols.
- Proposed database changes to ease monitoring and administrative effort.
- Worked with customers and other third parties to support DBA functions.
- Performed DR-Drill activities such as Failover and Switchover for Oracle databases.
- High Availability for Oracle DB Servers i.e. Clustering, Always-On, Mirroring, Log Shipping and Replication.
- Disaster recovery strategy as per customer needs.
Oracle DBA
Ebixcash Technologies
01.2022 - 06.2022
- Performing the task-related with ORACLE Databases as per the client requirement.
- Production Support of 12C RAC, DATAGUARD troubleshooting.
- Refresh UAT/Development Databases using hot backup, export/import data pump.
- Cloning from production to non-Production Environment using RMAN.
- Creating and maintaining database schemas objects like Tables, Indexes, Views, Database links, etc.
- Database administration, Design & Development of the logical/physical structure of the databases.
- Monitor and tune performance of Oracle databases, alert logs, traces, free spaces, file systems, SQL Tuning.
- Generate AWR Report, and ADDM Reports.
- Checking Database for any issue related to performance. Checks load average, long-ops, Locking, Blocking, SQL PLAN.
Technical Consultant
Dibit Computing System Pvt. Ltd.
12.2017 - 12.2021
- Good understanding of Oracle Database Architecture.
- Set up and controlled user levels access across databases to protect important data.
- Reduced downtime by proactively monitoring and addressing potential issues with the Oracle Database system.
- Having good knowledge of User management.
- Sysadmin tasks like creating users, assigning responsibilities, registering forms, concurrent programs, creating responsibilities, and managing privileges (grants/revoke).
- Monitoring tablespace size, resizing or adding new data files to the tablespace.
Education
Oracle DBA 12c Training -
Selecom Technologies Pvt. Ltd.
New Delhi 04.2001 -
Bachelor of Commerce -
DBRAU
Agra (Uttar Pradesh) 04.2001 -
Intermediate -
Haryana Board of Education
04.2001 -
High School -
CBSE
04.2001 -
Skills
Database Administration
Languages
English
Hindi
Description
I hereby declare that the above-mentioned information is true to the best of my knowledge.
Timeline
Oracle DBA
Coforge Limited
06.2022 - Current
Oracle DBA
Ebixcash Technologies
01.2022 - 06.2022
Technical Consultant
Dibit Computing System Pvt. Ltd.
12.2017 - 12.2021
Oracle DBA 12c Training -
Selecom Technologies Pvt. Ltd.
04.2001 -
Bachelor of Commerce -
DBRAU
04.2001 -
Intermediate -
Haryana Board of Education
04.2001 -
High School -
CBSE
04.2001 -
Similar Profiles
Kiran ChallaKiran Challa
Big Data Developer at COFORGE LIMITEDBig Data Developer at COFORGE LIMITED
Urvashi DharUrvashi Dhar
TEST ARCHITECT at Coforge LimitedTEST ARCHITECT at Coforge Limited
Soniya DavidSoniya David
HRO Capability Development Senior Manager at Coforge LimitedHRO Capability Development Senior Manager at Coforge Limited
Soniya DavidSoniya David
HRO Capability Development Associate Director at Coforge LimitedHRO Capability Development Associate Director at Coforge Limited
Sam KuperSam Kuper
Data Scientist at Acme Packet Inc.Data Scientist at Acme Packet Inc.