SUMMARY:

• Over 11+ years of extensive experience in Oracle E Business Suite Applications DBA, Core DBA and Oracle Fusion Middle ware.
• Worked extensively on Oracle E - Business Suite 11i, R12.1, R12.2, Application Server, Fusion Middle ware, Oracle 9i, 10g and 11g, 12c as well as Oracle E-Business Suite Upgrade from 11i to R12 and R12.2 and migrations involving both the Database and Apps Tiers across different OS environments.
• Excellent Exposure to both the Apps and Core DBA activities like DB/Application install, 11i to R12 upgrades, patching, cloning, maintaining Oracle Applications and Database administration as well as transitioning the Oracle E-Business applications to cloud environment.
• Experience in Installation, Migration, Database Upgrade, Backup and Recovery, RMAN, EXPORT & IMPORT, ASM, OBIEE, SSO/OAM OID, RAC administration and performance tuning of Oracle Database.
• Maintaining, Monitoring and Administering for Oracle Applications environments of both standalone on RAC architecture
• Installed Oracle Web Logic Server 10g and 11g, configured and administered domain, managed servers and node managers using Administration console.
• Experience in patching using ADOP, AD Patch Utility and OPatch.
• Experience in working with AD Utilities adctrl, adconfig, adadmin, adsplice, adident etc.
• Troubleshooting Oracle Application issues related to Apache, forms, concurrent managers.
• Involved in tasks like performing Pre-patch analysis, Pre-config Analysis, for requested patches.
• Involved in critical patches like Demantra Engine patches in VCP and RPD patches in BPEL environments
• Expert in using Tools such as OEM, OAL, PASS, NAGIOS, EM12C, SCOT, SQL LOADER, ORACLE BUGDB, TOAD.
• Implemented Nagios monitoring tool for critical alerts.
• Expert in managing monthly and quarterly releases in production outages.
• Proactive maintenance like checking health of instance monitoring databases, concurrent programs, form sessions, general performance issues.
• Providing support for SR's with Oracle, Experience with Oracle database 11g, Grid, ASM, Application Cluster(RAC), RMAN, Standby data guard, DB upgrade/patching, Performance tuning and Oracle EM12C.
• Configuring and administering Oracle High Availability /MAA
• Infrastructure, Database, Application Solution Designing for In-house Web Applications for SaaS services
• As a part of global IT infrastructure management team, provided support for enterprise database and applications.
• Extensive experience in supporting Fusion Middleware Environment(Web logic, SOA)
• Experience in creating Users, Responsibilities, Menus, and Form Functions (Sys admin) and knowledge of Application Object Library.
• Implemented High Availability replication and OC4J clustering for Infrastructure tier services
• Hands on experience configuration and maintenance of Oracle Identity Management Infrastructure and Single Sign on (SSO), Integration of SSO/OID with Oracle E-business Suite R12.
• Hands on experience in Incidents/Request and Change Management process.
• Experience in Shell scripts for maintenance tasks of database.
• Experience in configuring the Printer Installation in EBS 11i/R12
• Experience in configuring the Work flow notification Mailer
• Providing application support and back end database support.
• Experience in Security Management, and database auditing.
• Experience in Oracle Business Intelligence (OBIEE) administration and E-commerce domain.
• Cloning 11i and R12 ERP instances from Production to Test, Development instances and co-ordinate with Testing and Development teams.
• Controlling and Monitoring of User Access to the database including granting and revoking of privileges and Roles and Table spaces Quotas
• Created Users, Responsibilities, Menus, Functions, and migrated them to remaining environments through FNDLOAD in Oracle Application environment.
• Proficient in using 11g/12c/13cOEM grid.
• Excellent operational support responsibilities involving troubleshooting, interoperability and root-cause diagnosis, Performance analysis, migrating code and applying changes.
• Knowledge on MS SQL Server, Golden gate, Exa data and Oracle cloud appliances.
• A very good team player and self-motivated and dedicated in any work environment.
• Following applicable processes, procedures, policies, standards,best practices, and SLA's.
• Good Interpersonal and Communication skills, technically component and Enthusiastic team player.
• Strong analytical skills and ability to interact with end-users, managers, and technical personnel.
• Incident Management, Change Management(Planning & Execution), On-Call Escalations, Ticket Quality, Processes adherence, customer feedback, Knowledge sharing & documentation of Root cause analysis.

TECHNICAL SKILLS:

Oracle Applications Versions: E Business Suite 11i and R12.1, R12.2, E-Business and Database Upgrades

Modules: AP, AR, GL, FA etc.

Other Components: Application Object Library, Concurrent Manager and Application Tier Services, Java, HTML

RDBMS: Oracle 11g, 10g, 9i

Operating Systems: REDHAT LINUX advance server 4.0/5.0 Windows NT4/2k/XP, Sun Solaris 5.6

Tools: Oracle Forms, Report, OA Framework, Apache, Oracle Enterprise Manager 10.x/9.x, TOAD, Apache Web Server, MS Office, Microsoft Exchange 5.5/2000, RMAN, SCOT, OEM, OAL, HELP CENTER, PASS, NAGIOS, NUMARA TRACK IT, EM12C, PUTTY, ORACLE BUGDB, WINSCP, REMEDY FORCE, JIRA

PROFESSIONAL EXPERIENCE:

Confidential- MIAMI, FL

Oracle Apps DBA consultant

Responsibilities:

• Installation and configuration of OEM 12C and integrated with EBS and Database.
• Installed, configured and deployed OBIEE, SOA, OID, on WebLogic 12c (Fusion Middleware).
• Worked on configuring SSL in OHS and WebLogic.
• Worked on Web tier configuration and installation on WebLogic
• Cloning Oracle databases using RMAN and duplicate database techniques.
• Tuning SQL queries for improved performance
• Fixing the developer issues and finding the root cause for WebLogic and databases
• Administering and maintenance of Oracle WebLogic 11G instances.
• Worked on Bamboo deployments and database replication
• Monitoring of alerts using Oracle Enterprise Manager and related tools.
• Worked on OAS deployments and move docs.
• Monitoring of alerts using Oracle Enterprise Manager and related tools
• Configuration of OEM for monitoring and support
• Applying latest E-Biz12.2 Online patching using ADOP.
• Cloning Oracle databases using RMAN and duplicate database techniques.
• Administering and maintenance of Oracle WebLogic 11G instances.
• Integrating Oracle EBS with Oracle access manager and Oracle Internet directory.
• Monitoring of alerts using Oracle Enterprise Manager and related tools.
• Experience in provisioning of Database, Applications on AWS, Oracle Cloud, VMWare, VSphere and Open Stack Infrastructure as service (IaaS)
• Performance Tuning and maintenance of Application and Database Tiers of Oracle E-Business Suite like Database, Forms, CM, and Reports etc.
• Maintenance and support of Apache as well as Oracle Concurrent Manager having Parallel Concurrent Processing Configuration
• Creation of Environment Strategy and deployment/installation documents for the Production and Non-Production environments.

Confidential

Sr. Oracle Apps DBA Consultant

Responsibilities:

• E-Business Application Upgrade from 12.1.3 to R12.2.5
• Providing Maintenance and Support for 12.2.5 environments
• Installing and maintaining software on UNIX/LINUX operating system.
• Applying patches on different environments in internal PDIT Business Application Systems Operations under Server Technologies.
• Implemented High Availability replication and OC4J clustering for Infrastructure tier services.
• Daily handling the PASS windows and apply the patches within the scheduled downtime.
• Maintaining of Oracle Identity Management Infrastructure and Single Sign on (SSO), Integration of SSO/OID with Oracle E-business Suite R12
• Experience in provisioning of Database, Applications on AWS, Oracle Cloud, VMWare, VSphere and Open Stack Infrastructure as service (IaaS)
• Oracle SOA Cloud services Infrastructure Services Planning and Deployment.
• Infrastructure, Database, Application Solution Designing for In-house Web Applications for SaaS services
• As a part of global IT infrastructure management team, provided support for enterprise database and applications.
• Review the patch documents and analyze the patch strategies regularly and update the WIKI and CONFLUENCE pages as and when changes made by the management.
• Handling the outages for Environment Refreshes on quarterly basis.
• Extensive use of Oracle Tools as such SCOT, OEM, OAL, HELPCENTER, PASS, KMDOC, EM12C, APEX.
• Monitoring of alerts using Oracle Enterprise Manager 12c and related tools.
• Configuration of OEM 12c for monitoring and support.
• Worked for EM12C EOTD dashboards with different portfolio teams like SCPBI, ERPCRM, BEEHIVE etc., and resolve the issues using KM docs.
• Work with p1 rotation shifts based on the time zones, primary on call for both weekends and weekdays based on the calendar schedule.
• Applying latest E-Biz12.2 Online patching using ADOP.
• Providing patch wizard analysis for DB, Application and product patches.
• Applying quarterly CPU patch updates.
• Handling the Incidents/Requests and Change management process.
• Installed and configured Oracle APEX (Application Express) product on windows 2007 servers for corporate Reporting capabilities for Finance, SCM, ERP, VCP and GSI.
• Provided consultancy in upgrading the Oracle E-Business suite 11i to R12
• Migration and Upgrade of Oracle of E-Business Suite 11i to R12 from RHEL 4 32 bit to Oracle Enterprise Linux 6.5 64 bit in OVM environment using RMAN and recompilation utilities as Data Migration uses these utilities as well as installation of interoperability patches of R12 with oracle 11g Database
• Infrastructure, Database, Application Solution Designing for In-house Web Applications for SaaS services
• As a part of global IT infrastructure management team, provided support for enterprise database and applications.
• Installation, configuration and maintenance of RAC, Parallel Configuration Processing, and Data guard Standby database, Installed and configured Oracle 11G RAC, CRS, using ASM.
• Worked for Shared Appl/top application tier configurations.
• Maintain and Support Oracle E-Business Suite 11i Applications running Oracle RHEL (Red Hat Enterprise Linux) Platform
• Integration of APEX 4x Application with Oracle E-Business Suite 11i as well as R12 after upgrade
• Perform Patching, Cloning, and Installation, troubleshoot issues/errors/incidents etc.
• Analyze/Apply CPU, RUP, HRMS as well as one off patches on Test, Patch, and Production Instances as per Change Requests etc.
• Monitoring of alerts using Oracle Enterprise Manager and related tools
• Configuration of OEM for monitoring and support
• Performance Tuning and maintenance of Application and Database Tiers of Oracle E-Business Suite like Database, Forms, CM, and Reports etc.
• Maintenance and support of Apache as well as Oracle Concurrent Manager having Parallel Concurrent Processing Configuration
• Creation of Environment Strategy and deployment/installation documents for the Production and Non-Production environments.
• Interaction with Vendor like for Oracle Support and Services.

Confidential

Senior Oracle Apps DBA (Consultant)

Responsibilities:

• Providing Production Support (24*7) and troubleshooting user tickets in production, test and development instances.
• Sys admin activities like creating Users and responsibilities and managing concurrent managers and concurrent programs.
• Processing new UAF's for change, separation, New Hire and assign responsibilities.
• Perform Patching, Cloning, and Installation, troubleshoot issues/errors/incidents etc.
• Analyze/Apply CPU or one off patches on Test, Patch, and Production Instances as per Change Requests etc.
• Monitoring of alerts using Oracle Enterprise Manager and related tools
• Changing the Apps Password and managing and application user password by using FNDCPASS.
• Reduce the patch time using features like defaults file, merge patch, and AD patch options.
• Monitoring alerts on NAGIOS'S tool.
• Resolving work orders on Numara Track IT System tool.
• Setting up new users and setting user profiles.
• Creation of Environment Strategy and deployment/ installation documents for the Production environments.

Confidential

Oracle Apps DBA Consultant

Responsibilities:

• Involved in Installation of Oracle E-business Suite R12 and Up-gradation from 11.5.10.2 to R12 on Linux platform
• Relinking the executables, generating forms, jar files, validating apps schema, and compiling invalids by using adadmin
• Worked with various Oracle Application Utilities like AD administration, AD controller, Auto config, AD merge patch, AD Relink, AD splice, Auto Patch, f60gen etc.
• Analyze/Apply CPU or one off patches on Test, Patch, and Production Instances as per Change Requests etc.
• Using AD controller to see the status of workers and restarted failed worker after resolving the problem.
• Assigned specific concurrent requests to concurrent managers and resolving issues.
• Monitoring the Application services and bouncing the Application services as per requirement.
• Debugging the Apache issues by using Apache configuration and log files.
• Reduce the patch time using features like defaults file, merge patch, and AD patch options.
• Troubleshooting several worker issues while patching.
• Applied RDMBS patching using Opatch.
• Changing the Apps Password and managing and application user password by using FNDCPASS.
• Responsible for creating Application and managing user accounts and assigning responsibilities.
• Monitoring the alert logs and trace files.
• Performing routine checks for space utilization and extended table spaces by resizing/adding data files when needed.
• Monitoring of alerts using Oracle Enterprise Manager and related tools
• Maintenance and support of Apache, OPMN as well as Oracle Concurrent Manager

Confidential

Oracle Apps DBA Consultant

Responsibilities:

• Providing Production support (24*7) database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Perform Patching, Cloning, and Installation, troubleshoot issues/errors/incidents etc.
• Apply CPU or one off patches on Test, Patch, Production Instances
• Monitoring Report server, form server, Concurrent Managers, Apace Listener.
• Evaluation of System Management Guide and related documentation for Oracle E-Business Suite Application
• Draft and implement the backup policies of the System
• Coordinate with Oracle Support for raising of SR as well as resolution of issues
• Maintenance and support of Apache, OPMN as well as Oracle Concurrent Manager
• Maintaining DR Setup and flashback recovery strategies.
• RMAN setup and managing backups using RMAN on a daily and weekly basis.
• Migration of Oracle E-Business Suite Applications from single to multi-node environment
• Monitoring the incidents from the dashboard and resolve priority of alerts using KM docs.
• Perform Patching, Cloning, and Installation, troubleshoot issues/errors/incidents etc.
• Collaborate with Oracle support for bugs & issues resolutions and personal research
• Support and ensures the high availability of all 11i and R12 Production and Test Servers
• Support all the technical concerns of a team of 15 functional consultants as well as 50 application users of the Oracle E Business Suite Application
• Support the technical concerns of the functional and technical consultants for the in corporation of new modules like HRMS and Inventory in our environment
• Working with Oracle Support, Analysis and management of Oracle defects using SR's and or Metalink with Confidential and installation of patches.