SUMMARY

• Specialized in Oracle Applications R12/11i Database and System Administration with over 7 years’ experience in Oracle under UNIX environment.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications.
• Experienced and proficient with Oracle E - Business suite application (R 12 12.1.1/12.0. x, 11.5.7, 11.5.8, 11.5.9 and 11.5.10) and Oracle Applications Server (9i/10g) in Sun Solaris, Red Hat Linux, AIX and Windows environment.
• Configuring Oracle RAC utilizing Veritas Cluster Service, GoldenGate.
• Performed Application installation and upgrades.
• Expert in upgrading Oracle Applications to 11.5.10.2 to 12.0.4 and 12.0.4 to 12.1.1.
• Performed database installation and upgrades. Experience in setting up HTTP Load Balancing.
• Expert in upgrading Oracle Applications Technology stack (Developer patch sets, JDK, J initiator etc).
• Proficient in Oracle Fusion Middleware including Oracle SOA suite (10g, 11g), web services, Oracle BPEL Process Manager, Oracle Enterprise Service Bus (ESB) and Oracle J-Developer (10g, 11g).
• Expertise with BPEL process Orchestration for integrating ERP applications, Databases, legacy applications, Flat Files and Portals.
• Configured multiple Weblogic Domains which includes NodeManagers and Managed Servers in multifarious environments. Good knowledge on Oracle Fusion middleware software.
• Working knowledge on Implementing WebLogic/AquaLogic Technology based composite applications.
• Expert in Cloning using ADCLONE, Rapid clone and ADCONFIG.
• Expertise in implementing Shared APPL TOP and PCP.
• Expertise in troubleshooting Workflow and Notification Issues.
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance issues.
• Proficient in Oracle tools and utilities (Net8, Svrmgr, WebDB, OAS 4.0.8, Data Browser, Developer Suite, Export, Import, SQL*Loader, PL/SQL, OEM, IA, SQL Navigator, DB Artisan, ER Studio, Glance, SQL Expert) in UNIX (Sun Solaris, AIX, HP-UX) & Windows environment.
• Experience in installation and configuration of Oracle SOA suite 10g/11g.
• Strengths include skills in Shell Programming, SQL and PL/SQL.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings.
• Experience in Security Management and Database Auditing.
• Implemented Sabrix Taxing Software and integrated with 12.0.4 Applications.
• Implemented DMZ for i-store users.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Expertise in RMAN for recovery and cloning.
• Expert in Configuring Workflow Mailer.
• Expertise in applying security patches.
• Improving Query Performance by rewriting the problematic queries.
• Basic Administration of UNIX systems (Solaris, LINUX, HP-UNIX TRU64, AIX).
• Troubleshooting Login, Self Service Application, J-initiator and Network related issues.
• Applications sysadmin tasks like creating and managing users and their responsibilities, Menus, Functions.
• Experience in Cloning of Database and Applications.
• Good understanding of Relational Databases and Client Server computing models.
• Skilled in handling a heavily customized 11i applications and upgrades.
• Applying RDBMS and Application patches. Sound knowledge in AD Utilities.
• Enabling Multi Org, MRC, NLS settings.
• Experienced in writing UNIX shell scripts and setting up cron jobs for database needs.
• Monitor system performance, identify bottlenecks and ensure problem resolution.
• Implemented 10g Grid Control and applied Applications Management Pack for monitoring Applications.
• Expertise in Cloning of databases from RAC to RAC and RAC to non-RAC.
• Excellent remote systems support and troubleshooting capabilities.
• Maintaining SLA promptly. User level security implementation.
• Experience in implementing three-tier security architecture.
• Implemented Sabrix Taxing Software and integrated with 12.1.1 Applications.
• Experienced in Space Management, Memory Tuning and Application Tuning.
• Troubleshooting expertise for all tiers (client, middle-tier, and database).
• 11i Multi-Org & Multi Reporting Currency (MO, MRC) Implementations.
• Experience in Installation R12, 11i both in single Node and Dual Node.
• Create and Maintaining the Technical Notes and Documentation.
• Managing primary database structure and objects.
• Maintaining Hot Backups, Cold Backup.
• Diagnostic Ability - Ability to go to the core of the problem.
• Willing to learn and adapt to new challenges & capabilities to take initiatives.
• Strong Analytical skills and ability to interact with end-users, managers, and technical personnel.
• Good team player, self-motivated and a quick learner.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite R 12 12.1.1/12.0. 611i Ver 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10.2.

RDBMS: Oracle Server 8i/9i/10g/11g for Sun Solaris, Linux, AIX,HP-UX

Operating Systems: Sun Solaris 2.6/2.5.1(SUN OS 5.5.1), AIX, HP-UX, Windows 95/98/NT, Windows NT 4.0 Server

Languages: SQL/ PL/SQL, UNIX Shell Programming (Bornshell, Csh, Ksh) Crontab

Software Tools/ GUI: Oracle Developer2000, Oracle Enterprise Manager (OEM), Goldengate, SQL Navigator, SQL*Plus and TOAD.

Application Servers: Oracle 10g/9ias R2.

PROFESSIONAL EXPERIENCE

Confidential, St Louis, MO

Oracle Applications DBA/ Technical Architect

Responsibilities:

• Cloning and Building new Oracle application databases using Rman backup.
• Converting single node 11.2.0.2 databases to RAC 3 node.
• Installing Grid Infrastructure along with ASM.
• Created Data guard Physical standby database using Rman.
• Implemented Oracle 12c Grid control.
• Deployed OEM agents on database and application servers and enabled active monitoring.
• Installed and configured Weblogic (Version 10.3.5) servers for various applications such as OID and OAM.
• Installed and Configured Single Sign-on (SSO) on Oracle Applications (R12.1.3).
• Setting up a Crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.
• Configured Secure Socket Layer (SSL) at Load balancer level on Oracle Applications (R12.1.3).
• Applying patches including Patch set updates (PSU) and Bug fixes as suggested by Oracle support to improve database performance.
• Implemented SSL on Oracle Access manager (OAM)
• Installation and Upgradation of Oracle Accessgates.
• Installed and configured Oracle HTTP servers for Oracle Webgates
• Performing various data migration strategies using RMAN and DATAPUMP (Imp/Exp) to determine the least time consuming strategies.
• Patching of Oracle applications using ADPATCH utility.
• DBA activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, table spaces, indexing, data maintenance, user management, and maintenance.
• Responsible in platform migration of Oracle Applications R12.
• Worked on Java Mailer configuration and Workflow Administration.
• Solved SQL and PLSQL performance issues like wait events by proactive monitoring of long running jobs using scripts and tools like Explain plan, TKPROF & Stats pack.
• Configured PCP for concurrent managers in R12.
• Configured DIP profile synchronization between AD - OID for user provisioning.
• Configured Workflow for Oracle Applications (R12.1.3)
• Configured Printers from Remote locations for Oracle Applications (R12.1.3)
• Installed and Configured Demantra.
• Integrated Demantra with ASCP environments.
• Installation and setup of OBIEE, DAC, and Informatica and integration with Oracle databases and Teradata environments.
• STunnel configuration for MSCA.
• Configured shared APPL TOP for Oracle Applications.
• Configured iSupplier node setup in DMZ.

Confidential, Mountain View, CA

Oracle Applications DBA /OIM Administrator

Responsibilities:

• 24/7 product support for business critical databases and applications.
• User management and role-responsibility mapping in E-business suite and roles provisioning thru OIM.
• Continuously monitoring automated sync jobs between OID and OIM and between AD and OIM.
• Deployed composites on SOA suite 11g using EM as well as ANT scripts.
• Created JDBC connections and JNDI’s for Oracle Application and DB Adapters in weblogic console for interaction with Database.
• Configured Clusters on WebLogic using WebLogic Console.
• Implemented Shared APPL TOP.
• Implemented the Oracle E-business suite Application Management Pack on OEM.
• Worked on Application system Administration. Activities like user setup, defining responsibilities, values sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs.
• Deploying various WAR, JAR and EAR applications in Production and non-Production Environments.
• Configured and set up Secure Sockets Layers (SSL) for data encryption and client authentication and Experience with F5 Load Balancer.
• Extensively used WLST (WebLogic Scripting Tool) and UNIX Shell Scripts to monitor and manage WebLogic server instances and domains.
• Troubleshooting by using Thread Dump, Heap Dump and Garbage collection analysis for Web Logic Server issues. Provided 24X7 production support with on call on rotation basis.
• Single sign-on end-to-end sync monitoring including OAM, Accessgates and webgates.
• Manual intervention of running AD to OID sync and Bulkload process for OID to OIM sync.
• Installed, Configured and monitored Goldengate replication of Business critical tables. Created Cronjobs for continuous monitoring of the lag and current status of extract/replicat processes of Goldengate.
• Upgraded Oracle Accessgates to version 1.2.2.1 using E-business Accessgate one-off patching.
• Deletion, creation of datasources using ant command line interface.
• Troubleshooting critical month-end GL close issues including issues with the Output post processor (OPP) concurrent manager.
• Oracle OID/SSL/Single Sign-on Implementation and Support.
• Monitoring and troubleshooting concurrent manager jobs, manage system profile setups, troubleshooting printer set-ups and other SYSADMIN responsibilities.
• Installed and configured Single Sign-On and Implemented SSL Security.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Implemented STAGED APPL TOP to reduce patching downtime.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Monitoring and troubleshooting concurrent manager jobs, manage system profile setups, Troubleshooting printer set-ups and other SYSADMIN responsibilities.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Performed maintenance tasks like Purging Concurrent manager log files, Gather schema statistics, Purging Workflow Obsolete Runtime Data.
• Developed automated scripts to help users bounce the apache services on oracle ERP and managed server bounce on oracle SOA and web logic instances.
• Using utilities like exp, imp, expdp and impdp to import/export schemas.
• Debug Oracle Reports and Oracle Forms programs.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Creating tablespaces, data objects, setting privileges, indexes, user logins, and passwords.
• Coordinating with Oracle Corporation for raising the Tar’s and supported activities.

Confidential, Schaumburg, IL

Sr. Oracle Applications DBA

Responsibilities:

• 24x7 Production Oracle Applications Administration.
• Applied PSU patching on 2 node RAC production environment. Patched version 11.2.0.3.0 to 11.2.0.3.5.
• Maintaining production, development & test databases and applications.
• Cloning Application databases from Production to Non-production as per project requirement timelines.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack).
• Administration of Oracle ERP applications version 12.1.1.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.

Confidential, Santa Clara, CA

Sr. Oracle Applications DBA

Responsibilities:

• 24x7 Production Oracle Applications Maintenance, Support and Administration.
• Created test environment through cloning production environment for developers to test on live data using rapidclone and adconfig utilities.
• Installed and Configured Discoverer 11.1.1.2 and Oracle OID 11.1.1.2 with E-business R12.
• Administration of Oracle ERP applications 12.1.1 and 11.5.10.2.
• Configured Clusters on WebLogic using WebLogic Console.
• Building both web as well as J2EE applications using ant scripts and source from MKS.
• Performed WebLogic installation, clustering, domain configuration, load balancing and performance tuning.
• Helped in work with File Adapter, Database Adapter, AQ Adapter, JMS Adapter and Oracle Applications Adapter for establishing connection with services in BPEL.
• Helped in building BPEL processes that subscribe to various EBS events around sales order processing functionality and participate in database and JMS transactions. Used the various activities available in BPEL to perform transformations and write business logic.
• Switch activity to create logical flow in BPEL processes for Order Reprocessing
• OSB (Oracle Service Bus) is used to create wrapper for the services developed in Jdeveloper.
• Switch activity to create logical flow in BPEL processes for Order Reprocessing.
• Upgraded production RAC database from 10.2.0.5 to 11.2.0.3 with interoperability on oracle apps version 11i (11.5.10.2).
• Upgraded production RAC database from 11.1.0.7 to 11.2.0.3 with interoperability on oracle apps version R12 (12.1.1).
• Upgraded 10G and 11G ASM to GRID INFRASTRUCTURE.
• Implemented ASM on NFS mount volumes.
• Migrated data files from file system to asm version 11.1.0.6.
• MIGRATED AND UPGRADED core(non-erp) production database from 10.2.0.2 on solaris to 11.2.0.3 on RHEL using expdp/impdp utility.
• Implemented PSU 4 on 11.2.0.3 on both oracle and grid homes.
• Implemented STAGED APPL TOP to reduce patching downtime.
• Automated database cloning using rapidclone to create the daily refresh environment through scripting.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Implementation, customization and personalization of Oracle iProcurement.
• Experience on various modules such as Financials, MFG, CRM, AR, AP, GL, PO, INV, MMS, OTC, OPS, OPM, Advanced benefits, iProcurement,ASCP, FA, MSCA, SCM (SUPPLY CHAIN) and OM.
• Implementation, Troubleshooting forms server, report server, Discoverer server, Web Server and Maintenance of Concurrent managers and Parallel concurrent Process (PCP).
• Monitored performance and availability of Oracle Applications through Grid Control & OAM.
• Involved in developing a disaster recovery (DR) plan for Oracle Applications R12.

Confidential, King of Prussia, PA

Sr. Oracle Applications DBA

Responsibilities:

• 24x7 Production Oracle Applications Administration.
• Maintaining production, development & test databases and applications.
• Good knowledge on Oracle applications 11i Rapid Installation.
• Upgraded Oracle Applications 11i (11.5.10) Database Version 8.1.7.4 to 10g (10.2.0.4) on Solaris.
• Upgraded Oracle Applications 11.5.10 to 11.5.10.2, 11.5.10.2 to 12.0.4 and 12.0.4 to 12.1.1 and database 10g to 11g
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle Database which is on RAC.
• Configured Goldengate for replication of production databases to reporting databases.
• Successfully upgraded Oracle Applications 11.5.10.2 to R12 (12.0.4) in multinode configuration.
• Applied patches using ADPATCH, ADCTRL utilities.
• Performed installation and configuration of oracle SOA suite 10g/11g for the integration of Application and Database.
• Created test environment through cloning production environment for developers to test on live data.
• Administration of Oracle ERP applications version R12
• Good Knowledge in Data Modeling tools like Erwin.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Implementation, customization and personalization of Oracle iProcurement.
• Experience on various modules such as Financials, ASCP, MFG, CRM, AR, AP, GL, PO, and INV.
• Involved in developing a disaster recovery (DR) plan.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, and Family pack).
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10G database.
• Installed and configured Single-Sign-On (SSO) and Implemented SSL Security.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigned to users.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Created new application messages and then generated message file for application.
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Worked closely with users group to ensure timely implementation of an ERP.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Oracle 10g Database Implementation/Upgrade/Support.
• Oracle 10g Application Server Implementation/Upgrade/Support.
• Oracle DataGuard Implementation for High Availability and remote Disaster Recovery (DR) site.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.

Environment: Red Hat Linux 4/5, SUN Solaris 9, HP-UX 11i v1 (B.11.11), AIX 5L, Windows XP, Oracle 8i (8.1.7), 9i (9.2.0) & 10g (10.2.0), Oracle Applications EBS 11i/R12, Oracle 9i & 10g RAC, Goldengate, TOAD, Developer 6i.

Confidential, Ann Arbor, MI

Senior Oracle Apps DBA

Responsibilities:

• Upgraded 9i database to 10g (10.2.0.3) database.
• Upgraded Oracle Applications from 11.5.10.2 to R12.
• Post go-live support of Oracle Applications R12.
• Maintenance of 10g databases and other non-ERP Databases.
• Implemented parallel concurrent processing in R12.
• Cloning DEV and UAT instances from Production for testing.
• Configured custom Output Post Processor.
• Migration of the Production database from Old servers to new servers.
• Successfully implemented 3-node RAC setup and made the environment stable.
• Have good knowledge on 10gAS OID, SSO and complete infrastructure and middle Tier components of 10g.
• Configured load balancing on Apache and Forms Servers.
• Applied the patchsets, one off patches, Opatch to the Development and production servers.
• Monitored databases using 10g OEM grid control.
• Implemented the Oracle E-business suite Application Management Pack on OEM.
• Implemented Shared APPL TOP.
• Responsible for troubleshooting the issues raised by oracle ERP from both user community and development.
• Worked on the performance issues both at the database level and applications level.
• Scheduled the backups using RMAN and disk backups.
• Created and monitored the concurrent managers.
• Provided valuable suggestions for allocating system storage and planning future storage requirements.
• Responsible for Cloning of Database and Applications as per functional requirements.
• Implemented Oracle Applications upgrades, patches using various AD utilities.
• Worked with End Users and Functional Analysts on issue resolution (concurrent manager problems, one off patches etc.)
• Developing UNIX and SQL scripts for the smooth functioning of database and applications related issues.
• Responsible for performance tuning of the database and applications using EXPLAIN PLAN, Auto Trace, SQL Trace, TKPROF, STATSPACK (advanced version of UTLBSTAT and UTLESTAT).
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS, and FND STATS packages and ANALYZE command.
• Responsible for setting up the printers in Application environment.
• Upgraded JDK 1.1 to 1.3.1 as a part of the Oracle Applications Upgrade from11.5.10.2 to R12.
• Troubleshooting throughout the project phases and TAR Management.
• Effective use of Oracle Web cache with multiple applications.
• Capacity Planning/Management (space/machine load/network).
• Moved the objects from one instance to other using FNDLOAD.
• Performed Application admin tasks using ADADMIN utility.
• Prepare and implement system management and maintenance procedures.
• Analyzing the requirements and creating the database as per the requirements and the connectivity of clients to the server.

Environment: Oracle Applications 11i(11.5.10.2), R12.0.4, Oracle 9i/10g, HP UNIX TRU-64, Precise, OEM, SQL* plus, SQL Loader, Toad, Oracle Discoverer, JDK 1.1/1.3.1