Highlights

SUMMARY:

• Highly skilled Oracle Database Administrator with Good Experience in managing and optimizing Oracle databases, including versions 11g, 12c, and 19c


• Proficient in Oracle 11g, 12c, and 19c with hands-on expertise in database patching, file management, and user and role management.


• Experienced in Oracle Enterprise Manager (OEM) 13c,Oracle ASM concepts, and administration including disk and disk group management.


• Skilled in installation and configuration of standalone and RAC databases across 11g, 12c, and 19c environments.


• Proficient in data pump (EXPDP/IMPDP and EXP/IMP), data guard implementation with physical standby databases, lag monitoring, and resolution.


• Adept in backup and recovery strategies utilizing RMAN and data pump utilities


• Monitoring & troubleshooting database hardware, performance monitoring, security analysis, performing data backup, & data recovery.


• Capable of generating and analyzing AWR, ADDM, and ASH reports for performance tuning.


• Experienced with ServiceNow ticketing tool


• Able to work effectively in a 24x7 environment.


• Strong team player with excellent communication, analytical, and problem-solving skills.


• A dynamic team player with excellent analytical, communication, problem solving and decision making skills

Skills

Primary Skills

ADFDI (ADF Desktop Integration)

EBS

Secondary Skills

Oracle 10g, 12C, 19C

Projects

Project1: - Finance Industry (35 months)

Role: Oracle DBA





Project:- Oracle Database Administrator at Bajaj Finserv with extensive experience in managing both production and non-production databases. Proficient in using Oracle Enterprise Manager (OEM) for comprehensive database monitoring and performance management. Skilled in user management, tablespace management, and session management. Experienced in deploying SQL. level patches to ensure database stability and security.





Responsibilities:






• Responsible for Load and Performance testing of the database servers and application servers


• Performing db patching on database using opatch auto.


• Worked on courtly oracle PSU patches to applying patch in oracle database


• Day to day Troubleshooting like adding space tablespace


• Worked on data pump (EXPDP/IMPDP and EXP/IMP)


• Worked on Data guard and implemented Physical Standby Databases. & lag Monitoring and lag resolution.


• Worked on Backup & Recovery strategies using EXPDP/IMPDP, and RMAN utilities.

Project2: Swiss investment bank - Finance Industry (33 months)

Role: Oracle Database Administrator





Responsibilities:






• Responsible for managing and overseeing 3,000+ Oracle databases, ensuring optimal performance, availability, and security across various environments.


• Used RMAN for backup and recovery jobs.


• Extensive experience in performance tuning for both standalone and Oracle RAC databases.


• Responsible for Load and Performance testing of the database servers and application servers


• Performing db patching on database using opatch auto.


• Worked on courtly oracle PSU patches to applying patch in oracle database


• Worked on Database File Management, User management, Role management.


• Worked on OEM13C.


• Day to day Troubleshooting like adding space tablespace


• AWR report Extraction)


• Worked on data pump (EXPDP/IMPDP and EXP/IMP)


• Worked on Data guard and implemented Physical Standby Databases. & lag Monitoring and lag resolution.


• Worked on Backup & Recovery strategies using EXPDP/IMPDP, and RMAN utilities.


• Extraction of AWR,ADDM,ASH report for Database Performance related issues.


• Worked on OS and PSU patching on linux and Unix operating system.


• Experience in database upgrade processes, including planning, executing, and validating upgrades for Oracle databases.