SUMMARY:

• Having 16+ years of experience as Oracle Cloud Architect OCI / Oracle Apps DBA (11i, R12 & R12.2) / Oracle DBA (9i, 10g, 11g & 12c) & Oracle Fusion Middleware DBA which includes architect, Installation, upgrade, migration, System maintenance, Cloning, patching, user support, Trouble shooting, database design, Performance tuning, Backup and Recovery. Providing 24x7 support of Production, Development & UAT environments on Various Platforms.
• I have designed, and deployed Oracle EBS R12 on Oracle Cloud (on OCI Gen2) with Database Cloud Service (VM & Exadata CS ). including integration with Identity Cloud Service (IDCS)
• I have worked on highly available deployments including High Availability, Disaster Recovery, Server Sizing, on Oracle Cloud Infrastructure (OCI) using latest EBS Cloud Manager version 19.1.1 including compartment & IAM Policy to secure deployment on Oracle Cloud. My task includes writing high - level designs, low level designs,implementation and operations manuals.
• Highly Experienced with Installation, Up-gradation, Cloning and Recovery of Oracle E-Business suite in RAC (ASM) and Non RAC (ASM). Applications administration from 11.5.10.2, R12.1.x and R12.2.4/5/6/7 and Oracle Database 9.2.0.7, 10.2.0.x, 11.2.0.x & 12.1.0.2, 12.2.0.2
• Expertise in installation, configuration and administration of WebLogic 10.1.3.x and 10.3.6 11g in various environments
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning, Refreshing Databases on Oracle Applications.
• Experienced in Performance tuning of Applications & database using Oracle OEM, ADDM, AWR, Statspack, Grid Control, Tkprof, Trace Analyzer, SQL scripts.
• Expertise in Maintenance, Patching, Cloning, Troubleshooting of Oracle Applications e-Business Suite.
• Migrated Oracle databases to AWS RDS.
• Expertise in Oracle applications e-Business Suite i.e., from 11.5.10.2 to 12.1.3; 12.1.1 to 12.1.3 & 12.1.3 to 12.2.4/5/6/7
• Performed Applications installations, migrations and upgrades of 11i, R12.1.x & R12.2.x (single node and multinode)
• Expertise in shared appltop application systems and configured BigIP to load balance mid-tiers Implemented Parallel Concurrent Processing to load balance CP tier.
• Expertise in integrated Oracle Applications 11i/R12 with OID/OAM SSO .
• Has extensively designed Disaster Recovery (DR) sites for various clients and have successfully conducted DR exercises / drills as part of recovery best practices.
• Experience in High Availability solutions with Oracle 10.2.0.4 /11.2.0.4 RAC, ASM and DATAGUARD.
• Performed Upgrade of Oracle Applications from 11.5.10.2 to R12.1.1
• Extensive knowledge on Oracle tools and utilities (Export, Import, SQL*Loader, PL/SQL, OEM, Data Load, SQL Expert, iSQLplus) in UNIX (Sun Solaris, AIX, HP-UX, Linux) & Windows environment.
• Has hands on experience in PL/SQL, UNIX Shell scripting.
• Worked independently to ensure that the databases and applications are operating efficiently and ensure proper backup and disaster recovery methods are maintained.
• Installed taxing software VERTEX on Weblogic Server 10.3.6.
• Performed Installation of Oracle Webcenter Imaging.
• Knowledgeable to design and Implement the Disaster Recovery Solutions.
• Maintaining SLA promptly, User level security implementation. Experience in implementing three-tier security architecture, Space Management, Memory Tuning and Application Tuning.
• SOX compliance Create and Maintaining the Technical Notes and Documentation.
• Excellent communication, problem-solving and Client Management skills
• Coordinate with Offshore development team, Unix team, all other admin teams
• Ability to work independently and learn new concepts quickly. Open to work new modules and new technologies
• Experience in requirement gathering and working closely with Business Users.

PROFESSIONAL EXPERIENCE:

Confidential, Marlborough, MA

Solution Architect /Sr. Oracle Apps DBA / Oracle DBA

Environment: oracle applications 12.2.6 on Exadata X7-8 servers with Database 12.1.0.2.0 and Oracle Databases 12.1.0.2 & 12.2.0.1.0. And Manhattan applications.

Responsibilities:

• Shell scripts for all the backups, log rotations.
• Performance tuning of Oracle EBS Concurrent programs
• Design for Oracle databases for the Manhattan applications.
• Setup and configuration of DATAGAURD physical standby with flashback enabled
• Performing Patches using ADOP.
• Applied Techstack Patches like 10.1.2, FMW Home (Oracle Common, Webtier), Weblogic and patches on OBIEE and Demantra.
• Integrated Oracle E-business Suite 12.2.6 with OID/OAM.
• RMAN Backups configuration for EBS and Oracle databases.
• Capacity planning for all the Oracle databases.
• OEM 13c installation and configuration.
• Migrated Oracle Databases from IBM to Rackspace.
• Migration of EBS R12.2 to OCI with database tier on Exadata CS for PoC
• EBS integration with On-Premise IDM (OAM/OID). PoC with EBS-IDCS integration with MS-AD using Identity Bridge.

Confidential, San Francisco, California

Sr. Oracle Apps DBA / Oracle DBA

Environment: oracle applications 12.1.3 & 12.2.5/6/7 on Redhat Linux X86-64 servers with Database 12.1.0.2 and Oracle Database 11.2.0.4 & 12.1.0.2, exadata X3-8 and X4-8. AWS RDS

Responsibilities:

• Oracle performance tunning in Oracle databases and oracle applications AWR, ADDM, SQL Tunning Advisor
• Design and development for the Oracle databases and Oracle applications.
• Migration of Oracle databases to X3-8 Servers.
• Oracle applications cloning RAC and non-RAC .
• Capacity planning for Oracle databases.
• Migrated on premise mysql database to AWS RDS with downtime.
• Migrated on premise Oracle databases to AWS RDS for POC.
• Upgraded Oracle applications from R12.1.3 to R12.2.7 for POC.
• Responsible for the creating the new RDBMS databases as per the clients requirement.
• Configuring and monitoring the Oracle Webcenter Imaging.
• Configuring SFTP server from Oracle applications to external vendor servers.

Confidential, Philadelphia, Pennsylvania

Sr. Oracle could Apps DBA / Oracle could DBA

Environment: oracle applications 12.1.3/12.2.5/6/7 on Redhat Linux X86-64 servers with Database 12.1.0.2 and Oracle Database 11.2.0.4 & 12.1.0.2

Responsibilities:

• Oracle performance tunning in Oracle databases and oracle applications
• Design and development for the Oracle databases and Oracle applications.
• Responsible for hosting Oracle applications and Oracle databases on the third-party vendors like Datapipe rackspace and Coresys which is the service as IAAS .
• Experience in lift and shift Migration to cloud.
• Users and roles in cloud.
• DbaaS in EBS cloud.
• Patching using tools like
• Expertise in using the EBS cloud admin tool.
• Worked on R12C environments with pluggable databases.
• Clone and renaming of the Pluggable databses.
• Responsible for Oracle databases / applications / WebLogic patching PSU/CPU on premise and third-party cloud IAAS .
• Troubleshooting for all the application and database related issues.
• Responsible for monitoring the applications using the splunk
• Troubleshooting the user sync related issues in OID/OAM to EBS.
• Cloning of Oracle database and applications.
• Migrated on premise Oracle database to AWS RDS.

Confidential, Keene, NH

Sr. Oracle Apps DBA

Environment: oracle applications 12.1.3/12.2.5/6 on Redhat Linux X86-64 servers with Database 12.1.0.2 and Oracle Database 11.2.0.4 & 12.1.0.2

Responsibilities:

• Supporting the Oracle applications R12.1.3.
• Involved in Oracle applications upgrade from R12.1.3 to R12.2.5.
• Expertise in patching using Opatch, ADOP and weblogic patches.
• Analysed and Applied latest CPU patches.
• Monitoring of long running jobs on the oracle applications with shell scripts.
• Did analysis of the concurrent programs and assigned custom concurrent managers.
• As per the client’s requirement changed the EBS url.
• Monitoring Table spaces, Disks spaces, Concurrent Managers, locks, invalids in database with shell scripts.
• Oracle applications Performance tuning Concurrent programs
• Code migrations using STAT tool
• Troubleshooting of the users sync from OID to EBS.
• Monitoring the databases with OEM.
• Expertise in Active Clone of Oracle Databases
• Expertise in patching using Opatch, ADOP and weblogic patches.
• Did upgrade Oracle database from 11.2.0.4 to 12.2.0.1
• Implemented the Goldengate 12c for replications from across the databases.
• Shell scripts for supporting the oracle databases.
• Worked on Pluggable databases.
• Good knowledge on Exadata and Exalogic Oracle Engineered Systems
• Supporting and monitoring for RAC and Non-RAC Oracle applications.
• Configured Fusion middleware components WebLogic / Jobss / tomcat and deployed applications.
• Good Knowledge of Graph databases/MY-SQL and did installations and configuration --
• Installed and configured MY-SQL for analytics applications.
• Implemented Data-analytics tools Elasticsearch & Linkurious
• Implemented the graph databases and linked to the data analytic tools. Neo4j database and linkurious
• Basic knowledge of Oracle Cloud and AWS EC2.

Confidential, Blue Ash, Ohio

Sr. Oracle Apps DBA

Environment: oracle applications 12.2.5/6 on IBM AIX Power systems with Database 12.1.0.2 and Oracle Database 11.2.0.4 & 12.1.0.2

Responsibilities:

• Implementation of Oracle E-Business Suite - supplier hub 12.2.5 and Oracle Databases 12.1.0.2 with GRID ASM file system.
• Implementation of the SSL in Oracle E-Business Suite on Internal and External Tiers.
• Installation of Oracle Access Manager / Single Sign On.
• Integrated Oracle E-business Suite 12.2.5 with OID/OAM.
• Upgraded Oracle E-business Suite from R12.2.5 to R12.2.6.
• Workflow Notification mailer setup for the Supplier Hub in EBS.
• Resolved workflow related issues for inbound and outbound in EBS
• Implementation of Oracle Databases on AIX power systems.
• Implementation done for the EDQ Oracle Enterprise Data Quality on Weblogic server & Integrated Oracle Watchlist to EDQ.
• Configuring WebLogic Servers in a clustered environment.
• Integrated SOA REST services with Oracle EBS.
• Troubleshooting WebLogic situations and finding solutions where necessary.
• Deploying custom code in to the Oracle E-Business Suite.
• Restored Oracle databases from tapes as per the client requirement.
• Supporting and monitoring for RAC and Non-RAC Oracle applications.
• Expertise in Active Clone of Oracle Databases online clone
• Support to the production, Development and Test instances.
• Analysed and Applied latest CPU patches.
• Oracle applications upgrade from 12.2.0 to 12.2.5 and 12.2.5 to 12.2.6.
• Monitoring Table spaces, Disks spaces, Concurrent Managers, locks, invalids in database with shell scripts.
• Monitoring of long running jobs on the oracle applications with shell scripts.
• Installed OEM and configured alerts for databases.
• Configured RMAN backups in Oracle Databases.
• Monitoring backup jobs, oracle database and applications services. DB Backups are done using Tivoli
• Expertise in patching using Opatch, ADOP and weblogic patches.
• Managing passwords of oracle products and schemas using FNDCPASS.
• Validating the requests against SOX processes.
• Created concurrent managers as per client requirement and for existing concurrent managers changed sleep time and priority.
• Printer issues and setups done in Oracle applications.

Confidential, West Allis, Wisconsin

Sr. Oracle Apps DBA

Environment: oracle applications 12.2.4/5, 12.1.3(RAC) on Linux 6 and 11.5.10.2 on HP-UX 11.31 with Database 11.2.0.4 and Oracle Database 10.2.0.5, 11.2.0.4 & 12c.

Responsibilities:

• Upgraded Oracle applications from 12.1.3 to 12.2.4
• Used ADOP tool for applying patches on 12.2
• Integrated OAM / OID SSO in EBS 12.2 & 12.1.3
• Installed OBIEE and integrate it with OAM.
• Supporting for Oracle Fusion Middleware Components. WebLogic server, OAM, SOA, OBIEE, BPEL .
• Integrated EBS with Discoverer.
• Resolved workflow related issues for inbound and outbound in EBS
• Supporting printer using the loftware.
• Implementation of the weblogic 11g (10.3.6.0)
• Configuring WebLogic Servers in a clustered environment.
• Troubleshooting WebLogic situations and finding solutions where necessary.
• Deploying the applications in weblogic server.
• Basic knowledge on OTM (Oracle Transport Management).
• Implementation done for the Oracle Applications with RAC environment.
• Restored Oracle databases from tapes as per the client requirement.
• Supporting and monitoring for RAC and Non-RAC Oracle applications.
• Expertise in Active Clone of Oracle Databases online clone
• Handling tickets for the support to the production, Development and Test instances through JIRA ticketing tool.
• Analysed and Applied latest CPU patches.
• Code migrations done using Hudson tool.
• Monitoring Table spaces, Disks spaces, port availability, Concurrent Managers, locks, invalids.
• Installed OEM and configured alerts for databases.
• Monitoring backup jobs, oracle database and applications services. DB Backups are done using Tivoli
• Expertise in patching using Opatch and AD patch.
• Managing passwords of oracle products and schemas using FNDCPASS.
• Validating the requests against SOX processes.
• Created concurrent managers as per client requirement and for existing concurrent managers changed sleep time and priority.
• Printer issues and setups done in Oracle applications.

Confidential, Hoboken, New Jersey

Sr. Oracle Apps DBA

Environment: oracle applications 12.2.4/5 12.1.3 (RAC) and 11.5.10.2 on Solaris & Linux with Database 11.2.0.3

Responsibilities:

• Upgraded Oracle applications from 12.1.3 to 12.2.4
• Used ADOP tool for applying patches on 12.2
• Implementation of the weblogic 11g (10.3.6.0)
• Configuring WebLogic Servers in a clustered environment.
• Troubleshooting WebLogic situations and finding solutions where necessary.
• Deploying the applications in weblogic server.
• Installation of the OHS for weblogic servers.
• Implementation done for the Oracle Applications with RAC environment.
• Supporting and monitoring for RAC and Non-RAC Oracle applications.
• Handling tickets for the support to the production, Development and Test instances through service desk tool.
• Analysed and Applied latest CPU patches.
• Installation and troubleshooting of Markview.
• Monitoring Table spaces, Disks spaces, port availability, Concurrent Managers, locks, invalids through foglight and manual scripts.
• Added custom top to Oracle applications R12.
• Monitoring backup jobs, oracle database and applications services.
• Good knowledge in patching using Opatch and AD patch.
• Installation of Oracle Webcenter Imaging with OCS team.
• Implemented Oracle applications iexpense on mobile.
• Experienced in installation of Oracle Fusion Middleware OBIEE, BPEL, SOA, Webcenter Imaging, OAM, Weblogic server .
• Managing passwords of oracle products and schemas using FNDCPASS.
• Validating the requests against SOX processes.
• Created concurrent managers as per client requirement and for existing concurrent managers changed sleep time and priority.
• Printer issues and setups in Oracle applications.
• For File transfers created ssh connection between the servers.
• P2p installations in R12.
• Configured SSL in oracle applications.
• Involved in developing a disaster recovery (DR) plan for Oracle Applications 11i/R12 and successfully executed DR test.
• Responsible for analyze and apply application patches eg (CPU) & database pachtes.
• Performed jar files, forms, flex fields, messages files generation, compiling invalids of apps schema and jsp’s and clearing cache in application server as post patch steps.
• Performed research for patches for specific problems.
• Oracle Applications Cloning done for the Test, Dev, SIT env’s.
• Configured RMAN Scripts for the backups with using catalog database.
• Installation of taxing software VERTEX (o- series), on weblogic Domain.
• Installation of monitoring tool FOGLIGHT for all EBS and Databases
• Registering the new Forms, Reports, PL/SQL scripts as concurrent programs.
• Monitoring tablespace usages using foglight tool and manual scripts.
• Database performance tuning using STATSPACK, TKPROF, SQL Trace, Explain Plan.
• Compiling forms/pll’s, DB invalids, creating DB links
• Upgraded Databases from 11.2.0.2 to 11.2.0.4 for test, development environments.
• UNIX Shell scripting to simplify the day to day activities and monitoring of database and applications.
• Have basic knowledge of Revenue Management and Billing (deployments).
• Upgraded oracle applications database from 10.2.0.4 to 11.2.0.3.3
• Integrated applications with SSO (OAM, OID).
• Implementation of 12.1.3 done on RAC with ASM.