Senior Database Administrator

• Sep 2022 - Present

Database Administrator

• Sep 2021 - Sep 2022

Oracle Database Administrator

• Nov 2016 - Nov 2019

☛ Maintaining and upgrading Oracle E-Business and database for various clients ☛ Monitoring, analyzing, troubleshooting abnormalities in Oracle EBS, applying necessary patches and cloning the system when required ☛ Performing Oracle EBS production upgrade from 12.1 to 12.2.5 within 72 hours ☛ Diagnosing database security and database performances ☛ Resolving operational issues, performing cloning and patch fixing for 12.0.4 and 12.2.5 ☛ Migrating oracle R12.2 Application and 12c Database to Oracle Cloud Infrastructure (Lift and Shift Oracle E-Business Suite to Oracle Cloud Infrastructure Using EBS Cloud Tools) Show less

Consultant-Team Lead(Oracle DBA)

• Aug 2015 - Nov 2016

☛ Involved in R12.2.5 demo and production testing ☛ Maintained 4 instances, including Production ERP, OBS, Group, Security analysis and creation ☛ Performed major and critical activities on PROD application and database ☛ Streamlined the regular process to avoid frequent issues ☛ Monitored and diagnosed database performance by assessing alert files & trace files ☛ Implemented security by user creation, assigning responsibilities and setting up profiles ☛ Monitored concurrent requests and troubleshooting ☛ Cloned non-prod instances from production instances using rapid clone utilities ☛ Supported production debugging and implemented Apex4.2 ☛ Implemented Apex in the test database and supported testing ☛ Upgraded R12.1.3 application to R12.2.5 ☛ Implemented GRC and integrated with the instance ☛ Led the implementation of Apex 4.2 and Apex5.2 ☛ Performed database upgrade from 11GR2 to 12c ☛ Installed and supported RUP patches ☛ Migrated third party vendor server to in-house server ☛ Installed and administered Oracle Linux 5, 6 ☛ Upgraded web logic and GRC to the latest releases available for testing ☛ Backed up & recovered database using RMAN ☛ Cloned instance using rapid clone utilities and RMAN ☛ Implemented and configured R12 mobile applications ☛ Implemented R12 mobile apps patch in the test database and supported testing ☛ Supported the production go live Show less

Associate Consultant(Oracle DBA)

• Oct 2012 - Aug 2014

☛ Maintained 13 instances including Production ERP instance ☛ Performed major & critical activities on Pre-PROD instance, with the same PROD architecture ☛ Maintained and supported complex, high performance apps like R12.1.2 architecture ☛ Maintained Oracle Application File System and database using AD utilities Worked on DMZ architectures, f5 Big/IP, public URL and private URL Administered and supported RAC databases on AIX ☛ Backed up and recovered database using RMAN ☛ Coded migration through FNDLOAD, WFLOAD and used shell script ☛ Conducted Oracle Applications AD Utilities Code Review and tracked the record of issues ☛ Analyzed applications and patches including mini pack and one-off patch ☛ Provided key resource 24/7/365 operations support for Oracle internal servers ☛ Implemented security by creating users, assigning responsibilities and setting up profiles ☛ Traced, compiled and validated the invalid objects ☛ Applied patches using an AD patch utility on application file system ☛ Troubleshot the issue that occurred in the standby database ☛ Monitored and troubleshot concurrent requests ☛ Cloned non-prod instances from production instances using rapid clone utilities ☛ Supported in house project - Petrofac Engineering Services, an oil & gas headquarters in Sharjah including architecture of two node databases that runs on 11.1.0.7 version with ASM, RAC ☛ Generated two DMZ zones for external support through the internet ☛ Worked on applications like Primavera, Siebel, Hyperion, BPEL and GRC Show less