Accomplished Oracle DBA with over 9 years of experience, specializing in database management and optimization for major firms like HCL Technologies. Demonstrated expertise in Oracle, PostgreSQL, and SQL Server, coupled with a strong ability to lead and improve database performance. Proven track record in implementing effective solutions and enhancing operational efficiency.
Ø Day-to-day activities on Oracle & SQL Server database for support and management of the prod and non-prod databases.
Ø Build, installation, configuration, upgrading, patching, migration across platforms of Oracle (11g,12c and 19c) Exadata
Ø Experience in administration of production databases, installation, support, upgrading, patching, and migration of multiple database versions, backup and recovery, tuning databases, security patches, bug fixes.
Ø Regular monitoring the Health Check for blocking sessions, high CPU, high I/O, and other metric alerts to keep track of database performance.
Ø Database error monitoring and space management.
Ø Working experience on oracle enterprise manager (OEM)
Ø Maintaining documentation for all kinds of activities for Knowledge management.
Ø Experience on Data Guard and GoldenGate
Ø Day-to-day activities on Oracle & PostgreSQL database like support and management of the prod and non-prod databases.
Ø Experience on 19C database (19.3 version)
Ø Regular monitoring the Health Check for blocking sessions, high CPU, high I/O, and other metric alerts to keep track of database performance.
Ø Database error monitoring and space management.
Ø Applying Oracle Critical Patching (CPU) for the released security patches
Ø Working with IBM BPM Team to fix the current issues.
Ø PostgreSQL database data migrations
Ø Supporting and Administering RAC with ASM (patching, cloning, and troubleshooting of issues).
Ø Regular monitoring the Health Check for blocking sessions, high CPU, high I/O, and other metric alerts to keep track of database performance.
Ø Database error monitoring and space management.
Ø Database Refresh using export & import and rman backups
Ø Applying Oracle Critical Patching (CPU) for the released security patches
Ø Involved in the RCA meetings and implementing solutions to fix the problems permanently.
Ø Alert monitoring on tablespace space issues, blocking and locking sessions, long-running concurrent job.
Ø Experienced in new schemas creation and roles and privileges maintenance as per request from team
Ø Maintaining documentation for all kinds of activities for Knowledge management.
Ø Providing Production support (24*7) and troubleshooting the incidents in Production, Pre-Production and UAT instances.
Ø Supporting and Administering RAC with ASM (patching, cloning, and troubleshooting of issues).
Ø Day-to-day business database support and management of the production databases.
Ø Regular monitoring of OEM12c for blocking sessions, high CPU, high I/O, and other metric alerts to keep track of database performance.
Ø Database error monitoring and space management.
Ø Cloning various Applications R12, R12.2 Including Multi-node Cloning Apps from PROD to TEST, DEV, UAT Instances
Ø Handling issues related to Apache, Forms and Concurrent Managers
Ø Handling issues related to OBIEE and Demantra.
Ø Involved in the RCA meetings and implementing solutions to fix the problems permanently.
Ø Cloning the instances using different methodologies as per client's requirement.
Ø Alert monitoring on tablespace space issues, blocking and locking sessions, long-running concurrent job.
Ø Experienced in new schemas creation and roles and privileges maintenance as per request from team.
Ø Troubleshooting user related issues and coordinating with the users from different time zones.
Ø Checking for database locks and clearing the blocking sessions.
Ø Monitoring mount point alerts and took required actions based on Alert Guide.
Ø Oracle Database : RAC and Non- RAC 10g, 11g, 12c & 19c Exadata
Ø Oracle ERP : R122,1213, 115102
Ø Middleware : WebLogic
Ø Operating systems : Red Hat Enterprise Linux5& 6, Aix hp-ux Solaris
Ø Tools : Putty, PL/SQL Developer, SQL Developer, PGAdmin
Ø Ticketing System : Service Now, Workiro
Ø Other Database : PROGRESQL, SQL Server & MySQL
Oracle Autonomous Database Cloud 2019 Certified Specialist issued by ORACLE. Oracle Cloud Infrastructure Foundations 2020 Certified Associate issued by ORACLE.
Oracle Autonomous Database Cloud 2019 Certified Specialist issued by ORACLE. Oracle Cloud Infrastructure Foundations 2020 Certified Associate issued by ORACLE.