SUMMARY

• Having 10 years of experience in IT industry dat comprises Oracle Applications DBA / FMW Administrator.
• Hands on experience in installation, upgrades and administration of Oracle Database 10g, 11g, 12c and Oracle Applications 11i, R12.
• Hands on experience in administering 11i, R12 (12.0.6, 12.1.3, 12.2.4) environments.
• Hands on experience in Oracle Fusion Middleware (11g, 12c) applications and WebLogic.
• Experience in upgrading Oracle Applications from 12.1.3 to new 12.2 release.
• Experience in 12.2 Installation, cloning and patching using ADOP.
• Experience in Database Platform migration and upgrade from 10g AIX to 11g OEL.
• Experience in Upgrading 11g RAC database to 12c RAC.
• Experience in Platform migration and upgrading the Oracle applications from 12.0.6 to 12.1.3
• Experience in OBIEE, SOA Administration, Installation and configuration.
• Expertise in cloning of Oracle Applications and patching.
• Hands on experience in working with RAC Databases and ASM instances.
• Experience in OEM and RMAN backup and recovery.
• Experience in oracle Database Performance Tuning.
• Experience in F5 Load balancing, configuring SSL certificates and implementing jar signing certificate for EBS.
• Hands on experience in PCP configuration and WebLogic Administration.
• Expertise in administering Oracle Applications with ad utilities like adpatch, adadmin, adconfig, adctrl, adrelink, adsplice etc.
• Experience in upgrading Oracle Applications from 11i to R12
• Basic working noledge on Oracle Identity and Access Management.
• Experience in Configuring and Administering Standby database (DR).
• Good understanding in Oracle Applications filesystem and Database Architecture.
• Have acquired expertise and productive capabilities in managing client Oracle Applications, Databases and reaching quick and satisfactory technical solutions with in the SLA.

TECHNICAL SKILLS

ERP: Oracle Applications 11i (11.5.10.2), R12 (12.0.6, 12.1.3, 12.2.4, 12.2.6)

FMW: OBIEE (11g, 12c), SOA, OAM

Databases: Oracle 9i, 10g, 11g (11.2.0.4), 12c

OS: OEL, Linux, IBM AIX, Solaris, Windows Server 2008/2012

Languages: SQL/PL SQL, Shell

Tools: Putty, Winscp, Toad, Remedy, ServiceNow, HPSM, RingMaster

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Applications/FMW DBA

Environment: Oracle Applications on RHEL/Windows

Responsibilities:

• Administering EBS 1224 and 11g,12c database Environments.
• Administering fusion middleware applications and WebLogic.
• Installed and Configured OBIEE 11g,12c.
• Integrating OBIEE application with OAM.
• Implemented SSL certificates for OBIEE Applications.
• WebLogic Administration, domain and cluster configuration.
• Configuring OHS and integrating with WebLogic.
• Applying patches to WebLogic, OBIEE, Hyperion.
• Database Upgrade from 11g RAC to 12c RAC.
• Installed and configured 12c RAC database.
• Merge and deploying the RPDs.
• Deployment of JAR, WAR, and EAR files through enterprise manager.
• Configuration of LDAP, SSL, Security realms.
• Oracle GoldenGate Veridata 12c Installation are configuration for high - speed data-comparison.
• Administering Hyperion Applications.
• Export and Import of oracle database schemas.
• Leading offsore team on daily activities.

Confidential

Oracle Apps DBA

Environment: Oracle Applications R12 on IBM AIX/ OEL

Responsibilities:

• Upgrading Oracle Applications from 12.1.3 to 12.2.4 release.
• Support & administer of oracle R12.2 applications.
• Cloning of Oracle Apps 12.2.4 from multi-node to multi-node and to single-node.
• Patching of Oracle Apps 12.2.4 using ADOP.
• Platform migration from IBM AIX to OEL and upgraded the Oracle applications from 12.0.6 to 12.1.3
• Database platform migration from 10g IBM AIX to 11g OEL.
• Database Upgrade from 10g to 11g.
• Support and Administration of Production and Non-production Instances.
• Cloning of TEST, DEV and UAT instances from production using rapidclone.
• Analyzing and applying the patches through RingMaster tool and adpatch.
• Parallel Concurrent Processing (PCP) configuration.
• Maintaining Oracle Application File System using AD Utilities and Autoconfig.
• Pro-active monitoring and taking care of critical alerts.
• Configuring applications with F5 load balancer url and SSL certificate.
• Performing Backup and restore through RMAN.
• Troubleshooting application and database performance issues.
• Coordinating with other teams like NOETIX, HYPERION, OBIEE.
• Supporting other teams during weekend outages.
• Configuration and maintenance of standby database.

Confidential

Oracle Apps DBA

Environment: Oracle Applications 11i & R12 on Linux

Responsibilities:

• Administering the databases and providing 24 x 7 applications support to ensure high availability and smooth functioning of business-critical functions.
• Resolving Apache and concurrent manager issues.
• Cloning the Test and Dev instances from production.
• Support and maintenance of R12 Applications with PCP configured.
• Resolving user login & SSO issues.
• Troubleshooting database performance issues.
• Migrating flat files from different sources into Oracle Database using SQL*Loader.
• Effectively working on escalated issues and closing them within the SLA.
• Installation and configuration of 10g Oracle Enterprise Manager.
• Reviewing and analyzing Database performance issues with utilities like AWR, ADDM, ASH, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Configuration of Standby database and ensuring both primary and secondary are in sync.
• Taking care of critical alerts.
• Export and import of tables and schemas.
• Helping the SA team during weekly backup.
• Bouncing the BPEL services and Weblogic managed servers on request.
• Generic support during go live.

Confidential

Oracle Apps DBA

Environment: Oracle Applications 11i on Solaris, R12 on Linux

Responsibilities:

• Upgrading Oracle Applications from 11i to R12.
• Setup and configuration of Standby database for disaster recovery purpose.
• Exporting and importing the schema from production to Dev instance.
• Monitoring the health status of WebLogic managed servers.
• Preparing and maintaining the documents (Process, Run Book etc.) for support team.
• Support and Administration of Production, Dev and Test Instances.
• Taking care of Incident and RFS tickets which are assigned to our group.
• Monitoring the daily scheduled database refresh process and troubleshooting the issues if any.
• Refreshing the oracle applications and database as per monthly schedule.
• Performing patch analysis and applying various application and database patches.
• Troubleshooting SSO and other user login related issues, if required scheduling the WebEx session with the end user and solving the issue.
• Administrating the Oracle applications with ad utilities like adpatch, adadmin, adconfig, adctrl, adrelink, adsplice etc.
• Creating the DB - Links between the databases.
• Responding to the critical alerts.
• Coordinating with other teams like Functional, Development, Integration and UNIX.
• Performing the Code deployment through Kintana tool with in the migration window.
• Administrating of satellite Applications (Agile, Demantra, Markview, Sabrix, Optio, Aceva, eTC, Khalix, Emptoris) which are associated with Oracle E-Biz suite.
• Performing Demantra schema refresh.
• Troubleshooting on concurrent request related issues.
• Seeking SOX approvals and assigning the responsibilities as firefighter access.
• Running specific sql scripts (data fix, purging etc.) and compiling the new invalids.
• Supporting during weekend production releases.
• Provisioning various resource profiles (VPN Access, Remote Access user etc.) for users through Oracle Identity Manager Administrative and User Console.
• Creating Oracle SRs and working with oracle support team.

Confidential

Oracle Apps DBA

Environment: Oracle Applications 11i on Linux

Responsibilities:

• Support and Administration of Development and Test Instances.
• Cloning Oracle Applications from Production to Test using Rapidclone.
• Applying Database and Application Patches.
• Administrating the Oracle Applications using adadmin, adctrl, adpatch and FNDCPASS etc.
• Setting the profile options values and recording the changes.
• Restarting the Apache and concurrent manager services on request.
• Running Gather schema statistics program.
• Managing passwords of apps, Product passwords and custom schema passwords.
• Reduced the timelines of patching using features like defaults file and admrgpch.
• Scheduling cold and hot backups.
• Sysadmin activities like defining users and assigning responsibilities.
• Tablespace maintenance like adding and resizing data files.
• User Management & Security management.