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
Oracle RAC Administration
Data Guard Implementation
Database Security Management
Database Troubleshooting
Backup and recovery
Patch management
Oracle Enterprise Manager
Performance Tuning
Teamwork and Collaboration
Problem-Solving
Linux Operating System
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 -