• Upgraded EBS Database from 11.2.0.4 to 19.11.• Upgraded EBS Application from R12.1.3 to R12.2.11.• Converted single instance EBS Database to rac database using rconfig.• Implemented EBS Application shared APPLTOP and PCP• Expertise in Oracle Apps R12.2 Patching using ADOP.• Experience in cloning from single node to multinode and multinode to multinode rac to non rac and rac to rac using RAPID CLONE.• Performing database/schema refreshes using expdp/impdp and Rman. Automated the process daily schema level refreshes from production database to replica database• Upgraded Oracle Database and Cluster from 12c to 19c on Oracle Linux.• Installed, configured, upgraded and supported Web Logic 12c.• Install configure and maintain Disaster Recovery site using Oracle Data Guard.• Perform DR switchover and failover using Data Guard Broker configuration.• Installation, administration, and performance tuning of All production 12c,19c Database and Cluster.• Clone Production Environment to UAT & Test, required by Functional and Development team.• Administration, maintenance and performance tuning of Oracle Database• Created and Scheduled Shell scripts for the Database For real-time monitoring and Hourly Health Check Reports.• Configured and maintained Oracle Data guard replication for EBS and FMW databases.• Configured and monitored Oracle rman,expdp for backup and recovery.• Created shell scripts to monitor resource utilization of Oracle Database and Servers.• Golden Gate Classic and 21c microservices architecture setup and maintenance.• Golden gate Downstream mining setup and maintenance.

• Installation and configuration of Oracle Database 11g and Real application cluster.• Up-gradation of Oracle Database and Cluster from 11.2.0.2 to 12.1.0.2 on Oracle Linux.• Responsible to upgrade Oracle EBS 12.1.3 to 12.2.11 .• Up-gradation of database EBS database from 11.2.0.4 to 19.11.• Installed , configured, upgraded and support Web Logic 12c.• Installed, configured and maintained Disaster Recovery site using Oracle Data Guard.• Performed DR switchover and failover using Data Guard Broker configuration.• Installation , administration and performance tuning of All production 11g,12c Database and Cluster.• Clone Production Environment to UAT &Test , required by Functional and Development team.• Installation, administration of Oracle EBS R12.1.3 with Cluster database 11.2.0.2• Administration, maintenance and performance tuning of Oracle Database• Created and Scheduled Shell scripts for Database real time monitoring and Hourly Health Check Report.• Configured and maintained Oracle Data guard replication for EBS and FMW database.• Configured and monitored Oracle rman ,expdp for backup and recovery.• Created shell scripts to monitored resource utilization of Oracle Database and Servers.

• Support of Oracle database 11g , RAC, Non-RAC .• Configured RMAN , EXP backups and ensured backup completed successfully.• User management , performance tuning , and day to day daily support for Oracle DB Servers.• Installation and configuration of Oracle Database for any new application.• Troubleshoot any performance issue in Database servers.• Added Oracle RAC cluster node in Existing 2-Node RAC Cluster.• Upgraded Oracle RAC Cluster from 11g to 12C.• Installed Oracle RAC cluster 12c with ASM for UAT Environments.• Completed Disaster Recovery Site Implementation with ASM storage replication.• Database consolidation into new Power 8 IBM Servers.• Installation and configuration of web logic server..• Ensuring database health using scripts , oswatcher and nmon tools.• Created and Scheduled Shell scripts for Database monitoring and Daily Health Check Report.• Installed and Configured Oracle RAC 11g Cluster for production Banking Applications.• Cloning of Oracle Databases FOR UAT , DEV using RMAN Hot backup in RAC & Non RAC .• Configured RMAN hot backup and scheduled with CRONTAB

• Maintaining the production, test, & development database environments associated with the daily operations and support of the Oracle database administration.• Install, maintain, and administrator Oracle Discoverer 10g with Oracle EBS.• Investigating, reviewing, applying, and testing all patches and bug fixes in the database environment, Run patch impact analysis report before production patching.• Patching Oracle application with custom code patch and Oracle Product patch.• Cloning Oracle EBS multi-node to multi & multi-node to a single node.• Monitoring configuring and troubleshooting Oracle data guard environments.• Monitoring Oracle EBS apps and database tier from Grid control.• Supporting all database needs for all development projects (both Oracle Apps and plain Database projects.• Staying up-to-date on the most current release of Oracle, including compatibility issues with operating systems, third-party software, & utilities.• Oracle Database cloning and refresh activity with RMAN duplicate and Application clone using Rapid clone utility in Oracle apps.• Monitors system/application performance and provides suggestions for system performance improvement to ensure optimal system/application performance by using different methods including TKPROF, SQLT trace analyzer, and SQLT using explain and extract methods.• Enabled trace in Oracle application for the affected page, form, and Concurrent Requests having performance issues.• Communicate with Oracle support for any bug or performance-related issues.• Monitor database and application performance and user sessions with run-time queries.• Create SQL tuning sets, SQL tuning baseline, SQL profiles, transport, and load into SPB & SPM in 11g to test SQL Plain for new applications.• Configure Oracle OCM (oracle configuration manager) with all production and test environments to better utilize MOS Get Proactive features for patching, upgrading, installing, and configuring Oracle database and Oracle EBS.

• Installation, configuration, and upgrading of Oracle server software and related products .• Establish and maintain sound backup and recovery policies and procedures to ensure the maximum availability of the database.• Take care of the Database design and implementation• Implement and maintain database security (create and maintain users and roles, assign privileges)• Perform application, database monitoring, and performance tuning using enterprise manager grid control, alert log and trace files, and monitoring tools.• Installation and configuration of Oracle Data Guard for Reporting and Failover servers to offload the production server.• Implement the Enterprise Grid Control 10g on the PRODUCTION Server.• Setup and maintain documentation and standards• Plan growth and changes for database and hardware as well to achieve maximum performance goal (capacity planning)• Interface with Oracle Corporation for technical support.• Troubleshoot and administration of Oracle Application EBS with Ad utilities.• Prepare a standby database Data-guard configuration to ensure maximum availability.• Prepare and implement database backup and recovery plan.• Measuring Oracle E-Business Suite performance and availability with OAM and OEM.• Cluster configuration & load balancing configuration in APPS• Implementation of Real Application Cluster on Oracle database 10g with two nodes on IBM AIX in PRODUCTION environment.• Coordination with the Systems team for the preparation of the OS Platform (AIX 5.3) for the Oracle CC&B implementation;• Work as part of a team and provide 7x24 support when required• Perform general technical troubleshooting and give consultation to development teams.