Adept Senior Consultant with a proven track record, enhancing database management systems, including Oracle and PostgreSQL. Specialized in EBS upgrades and integration, demonstrating exceptional problem-solving skills and a commitment to excellence. Expertise in Oracle APPS DBA and a strong ability to lead and innovate, ensuring seamless operations and client satisfaction.
Oracle APPS DBA - R121, R122
Oracle DBA
PostgreSQL
WebLogic, SOA
Infomatrix Enterprise (July 2012 – March 2014):
Managing & Monitoring of application-related products like oacore, oafm apache, etc, then bouncing of Apache, oacore, oafm if needed. Good knowledge on establishes and maintaining backup & recovery policies and procedures. Take care of the Database design and implementation. Perform general technical troubleshooting and give consultation to development teams.
Metropolitan Housing Corp (Sep 2016 – May 2017):
Periodically refreshes Oracle databases and Applications, for various business reasons. Perform DBA activities such as Security Management, Space Management, User and Responsibility setup, Concurrent Managers monitor, and Setup Oracle Alerts. Patching activities are performed using adop with different phases (like prepare, apply, finalize, cleanup, and fs_clone and options
PDI, USA (Nov 2017 – October 2018):
Installation and configuration of Oracle 11g/12c and 19c databases as well as EBS Applications 11.5.10.2/R12.1.3 and R12.2 environments like production, development and testing and always having physical standby configuration using active duplicate cloning.
Worth and Company, USA (June 2019 – Jan 2020):
W&C customer has Oracle E-Business Suite upgrade project from 11.5.10.2 to R12.2.5 and Database version upgrade from 11.2.0.4 to 12.1.0.2. Performing cloning of EBS 11i/R12 instances Multi-Node to Multi-node. Good knowledge of the cloning/patch/upgrade process. Migrating schemas using Export/Import utilities. Apply all technology stack patches, which are compatible with all versions.
Humana, USA (Jan 2020 – August 2020):
Oracle Application Prod, Dev, Test database, and Maintenance. Extensively work on Oracle Applications AD Utilities. Troubleshooting problems with concurrent Managers, Apache, and User related issues. Monitoring and diagnosis database performance through monitoring of alerts. Trace files.
Oman Air, Oman (Nov 2019 – March 2020):
Upgrade of Prod, Dev, and Test databases from 11g to 12c and Table partitioning and used Transportable Tablespace technique to archive database.
PPGPL, Trinidad (Feb 2021 – May 2022):
PPGPL customer has multiple platforms like EBS R12.2.4. Installing and maintaining Oracle database 11g with Applications R12.2.x. EBS applications upgraded non-prod into R12.2.7 version. Vertex software integrated with EBS R12.2.7 Applications. Performed multiple EBS R12.2.7 clone environments like PROD, Prod Support, DEV, TEST, and QA with dualfs option. Managing and monitoring databases like Oracle, PostgreSQL along with E-Business Suite.
RMIT, Australia (May 2022 – November 2022):
Migration of Peoplesoft Oracle database from on-premises to AWS EC2 using transportable tablespaces.
Altice, USA (November 2022 – Till date):
Managing and monitoring of E-Business Suite, Oracle and Postgres databases. Upgrade of EBS from R12.1.3 to R12.2.9 and integration of vertex application to ebs which is used for tax calculations. Providing Database support 24X7 to the client.