PROFESSIONAL SUMMARY:

• Oracle database Administrator with more than 8 years of professional experience in Oracle database, Oracle E - Business Suite (EBS), application DBA supporting 24x7 production instances.
• Extensive experience in managing Oracle Applications 11i and R12 system Installations, configuration, Cloning, Security, Patching, Upgrades, Maintenance using AD and other utilities.
• Expertise in upgrade of E-Business Suite databases (Upgrades of database from 9i to 10g, 10g to 11g and 11g to 12c), Oracle EBS applications Upgrade from 11.5.10.2 to 12.1.3 and experience in R12 release upgrades (12.0.2 to 12.0.6,12.1.1,12.1.2,12.1.3).
• Patch analysis and application in various test, development and Production instances using ADOP, ADPATCH, OPATCH, Patch Wizard utilities for Oracle E-Business Suite releases
• Experience in R12.2 installations and maintenance of 12.2.4,12.2.5 and patching using adop
• Good Experience on R12.2 Cloning, Multinode to single node, Single node to Multi node on dev and test environments.
• Expertise in Oracle EBS System Administration to manage concurrent managers, registering forms & reports, custom application registration & printer setup.
• Expertise in administering Oracle 11i/R12 Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch etc.
• Maintaining Apps House Keeping Jobs: Gather schema stats, purge concurrent programs, purge workflow tables.
• Configuration of Workflow Mailer, PCP, Discoverer and Maintaining security using FNDCPASS.
• Installation, Upgradation, Configuration and Troubleshooting GoldenGate 12c software
• Specialization in administering RAC Databases, OEM, Grid Control and working in high availability environment.
• Database Administration on Exadata Oracle Linux, Backup & Recovery, Performance Tuning, Tuning/Monitoring using OEM, RMAN, and data guard.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, Data Guard, ASM and OEM.
• Expertise in SQL query tuning and database tuning using ADDM, AWR and Explain Plan
• Expert in management of 10G & 11G RAC on ASM with in Linux/Unix platforms
• Experience on latest Oracle E-Business Suite version R12.2.4 and in advanced topics like Exadata, RAC, Data guard, PCP, DMZ setup, shell scripting and Fusion Middleware products.
• Support activities of Fusion Middleware products SSO/OAM Oracle Access Manager, Oracle Identity Management (OIM), Oracle Internet Directory (OID), WebLogic, WebGate and AccessGate.
• UPGRADING the Standalone, RAC, Standby Database from 10g to 11g,11g to 12c
• Implementing Backup strategies: Hot / incremental backups using RMAN.
• Good Knowledge on Web Logic Administration.
• Knowledge on Database migrations from oracle ODA servers to EXADATA.
• Knowledge in SSO(OID) integration with EBS 12.2.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.7, RedHat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/ME/NT/2000/XP.

RDBMS: Oracle 12c,11gR2/11gR1, Oracle 10g, Oracle 9i, Oracle 11g (RAC), Oracle 10g (RAC), Exadata.

ERP Applications: Oracle E-Business Suite 11i, R12,12.2 - Sys Admin.

Tools: RMAN, Export, Import, expdp, impdp, Tkprof, Discoverer, Oracle Applications Manager (OAM), OEM (Enterprise Manager.), Toad.

PROFESSIONAL EXPERIENCE:

Confidential, Fort Lauderdale, FL

Oracle Apps DBA

• Production Support and maintenance of E-Business Suite 11i and R12.
• Worked on upgrading oracle applications from release 11.5.10.2 to R12.
• Extensively worked on R12.2 installations and maintenance of 12.2.4,12.2.5 and patching using adop.
• Experience in upgrading base R12 applications to 12.1.1, 12.1.2,12.1.3 releases.
• Expertise in administering Oracle Applications with ad utilities like adpatch, adadmin, adconfig, adctrl, adrelink, adsplice etc.
• CPU / PSU Patching, Autoconfig Stabilization, Apache Stabilization.
• Used OEM Cloud 12c for Monitoring the EBS 11i, R12.1.3 and R12.2.5 application and database server instances.
• Worked on Configuration of external Internet based applications like isupplier with E-Business Suite R12 in a DMZ environment.
• Clone of EBS 11i/R12 Instances Multi-Node to Multi Node, Multi node to Single Node
• Worked on the Cloning of Run File System, patching using ADOP and Troubleshooting issues on R12.2.5
• Experience in troubleshooting all layers of EBS (CM, JVM, OPMN, Workflow, PCP and middle tier Load balancer).
• Hands-on experience in Performance Tuning and Troubleshooting the database and concurrent jobs.
• Hands on experience in PCP configuration and WebLogic Administration.
• Strong Trouble Shooting skill for R12.2 issues like fs clone, prepare online patching and application issues
• Familiar with Workflow configurations, Troubleshooting concurrent managers, Apache and Discoverer issues.
• Strong experience in various versions of Oracle Exadata Database Machine Architecture
• Experience in Oracle Exadata Administration and diagnostic utilities such as cellcli, dcli, ilom, exachk, sundiag, MegaCLI.
• Strong experience in monitoring Oracle Exadata Storage cells, Database and InfiniBand components.
• Strong experience driving end - end Patching (QFSDP) Oracle Exadata Database Machine on various versions of Exadata
• Hands on experience on using of Oracle GoldenGate Macros, Conflict Detection Resolution (CDR), filtering and transformation parameters, exception handlers and Security
• Oracle Database upgrade to 12c version and supporting experience on 12c databases.
• Configuring and monitoring the databases through OEM 12C
• Database upgrade from 11.2.0.1 and 11.2.0.3 to 11.2.0.4 version for Non-production and Production databases.
• Data guard setup, RMAN Level backups. Worked on RAC & ASM
• Upgrading of 12c databases for Standalone, RAC, Standby
• Converting Single Node to Multi Node RAC Environments for 12.2
• Schema Migration using Export/Import Utilities
• Installation, configuration and managing Fusion Middleware components Oracle SOA, HTTP server and web logic.

Environment: Oracle Applications 11i/R12,12.2, Oracle Database 9i,10g,11g,12c, HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, GoldenGate, Exadata X2-2, X3-2, X4-2,RAC, ASM, OAM, OEM, WebLogic.

Confidential, Maryland Heights, MO

Oracle Apps DBA

Responsibilities:

• Provide 24x7 production support of Oracle EBS 12.1.3 and 11GR2 multi node RAC.
• Performed multiple iterations of Oracle EBS upgrade from 11.5.10.2 to R12.2.3.
• Experience on technologies like Shared APPL TOP, Parallel Concurrent Processing(PCP), Standby Databases and Oracle Real Application Clusters(RAC)
• Applying patches with ADOP in R12.2.5
• Cloning, Upgrade, Installation, Patching, Troubleshooting and Administration of various components of E-Business Suite 11i & R12.
• Cloned Oracle Applications instances from production environments and created the Development and Test instances using Rapid Clone method.
• Expert in Upgradation of Databases from 10g to 11g,11g to 12c.
• Application of CPU Patches, Application Patches and Database PSU patches
• Application of ATG RUP7, HRMS Family Pack, DST & Extended baseline patches
• Validating & Recreating grants & synonyms on Apps schema, Performed jar file/forms generation.
• Managing concurrent managers - ensure system is running smooth, monitoring throughput, watch for long running jobs.
• Troubleshooting Apache, Forms, Concurrent Manger, Workflow issues in Oracle Applications PCP Implementation and troubleshooting the Concurrent Manager Issues.
• Defining Custom Managers to run specific type of requests and enhance the performance
• Upgradation of Discoverer from 10g to 11g (32 and 64 Bit).
• Implementation of NLS Languages and DMZ, MT Addition and Node Decommission.
• Installing and administrating oracle WebLogic & FMW
• Configured GoldenGate Downstream Mining and Integrated components for Active-Passive and Active-Active replication
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability.
• Administered 10g/11g/12c Real Application Clusters (RAC) system on Linux x86-64 bit systems on ASM storage environments.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
• Experience with Role transition (Switchover/Failover) in Data guard
• Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Worked on Auditing, Security & Flash Recovery Area with Oracle databases.
• Performance analysis using AWR/ASH/ADDM reports and wait event analysis
• Database Upgrades for Non-EBSO technologies (PeopleSoft, OBIEE, Hyperion, Siebel)

Environment: Oracle Applications 11i/R12, Oracle Database 9i,10g,11g,12c, HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, RAC, ASM, GoldenGate, OAM, OEM, WebLogic.

Confidential, Dallas, TX

Oracle Apps DBA

• Upgraded Oracle Applications from 11.5.10.2 to 12.1.1 and applied 12.1.3 patchset
• Upgraded the Oracle Apps Database from 11.1.0.7 to 11.2.0.3
• Configured DR Solutions from R12 ERP Applications.
• Experienced in Oracle Apps Administration and Sysadmin tasks
• Installation, Configuration & Deployment of Oracle E- Business Suite 11i/R12
• Implemented Oracle Apps 11.5.10.2 & R12 with Oracle RAC.
• Implementation of High Availability solutions with Oracle 11g/10g RAC, Physical and Logical Standby Databases.
• Expert in 11i and R12 Cloning Production to Development & Test Instances
• Application of CPU Patches, Application Patches and Database patches.
• AUTOCONFIG customization in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Created new Concurrent managers, purged concurrent requests table and Implemented PCP.
• Experience in troubleshooting issues related to database and E-Business (Concurrent Managers, Forms, Apache, XML Publisher, workflow and Notification mailer).
• Monitoring the Oracle Applications through OAM and Troubleshooting the issues
• Experience with AD utilities and SYSADMIN activities of Oracle Applications environments
• Configured workflow mailer and resolved the notification issues.
• Expertise working on oracle 11gR2 RAC,12c environment.
• Implemented ASM on RAC and standalone databases, managed disk groups using ASM.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Data pump Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Responsible for tuning application including rewriting of SQL, partitioning of tables, analyzing jobs and scheduling them properly, etc.
• Performance Monitoring and tuning using STATSPACK, TKPROF, EXPLAIN PLAN, AWR, and ADDM.
• Monitoring and troubleshoot database issues with OEM grid control

Environment: Oracle Applications 11i/R12, Oracle Database 9i,10g,11g,12c HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, RMAN, RAC, ASM, OAM, OEM.

Confidential, NY

Oracle Apps DBA

• Administrating of Production, Test and development of Oracle Applications 11i & R12.
• Extensively worked on Oracle Applications 11i, R12.1 and Oracle 11gr2, RAC/Non-RAC/10g Database Administration.
• Applied patches using ADPATCH, ADCTRL, ADADMIN utilities.
• Application of CPU Patches, Application Patches and Database patches.
• Cloning of 12.1.3, 12.0.6, and 11.5.10 application file system from multi-node to multi-node and to single-node.
• Monitoring concurrent jobs, Concurrent Programs/Managers Status for Oracle E-Business Suite
• Support and Maintenance of 11i/R12 E-business suite application with PCP (Parallel Concurrent Processing) configured.
• Troubleshooting Apache, Forms, Concurrent Manger, Workflow issues in Oracle Applications.
• Experience in Configuring, troubleshooting Oracle Workflow Managers.
• Installation and creation of 11g RAC, 10g RAC databases for Testing, Development and Production
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Planning Backup/Restorations Strategy, Planning and Scheduling Backup and taking backup of database using RMAN.
• Tuning of Oracle database, tuning memory, I/O, Resource contention, Database Operation and performance diagnostic tools like TKPROF, SQL Trace utility, Oracle expert and SQL Analyze
• Oracle Data Guard Implementation for High Availability and remote Disaster Recovery (DR) site
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Daily monitoring the database alert log files & trace files for any error messages, periodic checking table spaces, Undo TS & index status

Environment: Oracle Applications 11i/R12, Red Hat Enterprise Linux, Oracle Database 10g,11g, RAC, ASM, RMAN, OAM.

Confidential

Oracle Apps DBA

• Responsible for managing 10g/11g production, development & test databases and 11i applications.
• Handled administration of 24*7 Production Test & Development Databases.
• Worked with various Oracle Applications Utilities like AD Administration, AD Controller, Autoconfig, AD Merge Patch, AD Relink, AD Splice, Auto Patch, Rapid Install etc.
• Patching the Application System using ad patch (minipacks, one-offs).
• Cloning using Rapid clone, Auto config and adclone utility.
• Involved in database migrations cloning Oracle Applications 11.5.10.2 production system, for testing and development purpose using rapid clone.
• Performed maintenance tasks like Purging Concurrent manager log files, Gather schema statistics, Purging Workflow Obsolete Runtime Data.
• Sysadmin activities like Concurrent Manager Management, Printer Setup, User Creation
• Monitoring Concurrent Manager & its operations like starting, stopping the concurrent managers & Troubleshooting problems, resolved the view log/out files issues of concurrent requests.
• Configured Workflow Notification Mailer for inbound and outbound processing
• Worked on HA of the databases including RAC, ASM and Data Guard.
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Experienced in RAC Administration (11gR2) with ASM storage and backup and recovery using RMAN.
• Configured and Upgraded to Oracle 11gR2 from 10g and from 11.2.0.2 to 11.2.0.3
• Taking Database Backup Hot/Cold Backup with RMAN
• Application of Quarterly release of Oracle Critical Patch Updates to Oracle Application databases.
• Implemented disaster recovery by using Data Guard for Single instance, RAC environment and troubleshooted issues in DATAGUARD environment.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Performance analysis using AWR/ASH/ADDM reports and wait event analysis.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports

Environment: Oracle Applications 11.5.10.2, OEM, Red Hat Enterprise Linux, Oracle Database 10g, 11g, RAC, TOAD, Oracle Enterprise Manager, ASM, RMAN, AWR,ASH,ADDM.