SUMMARY:

• Oracle Apps DBA professional with around 10 years of progressively strong experience in Oracle Technologies under Solaris, Linux, AIX HP - UX and Microsoft Windows.
• Expertise in installing, Maintaining and Administering Oracle Applications 11i/R12 Instances
• Oracle Data Integrator(ODI) Implementation
• Specialized in Oracle Databases (Versions 10g, 9i), Oracle Apps Database Administration (R12, 11.5.10, 11.5.9, 11.5.8, 11.5.7) and Fusion Middleware (10g AS)
• Strong experience in supporting development, unit test, system test, Integration test, test, production databases under almost all flavors of UNIX (Oracle Enterprise Linux, Red Hat, Sun Solaris, IBM AIX) and Windows
• Expertise in Maintenance, Patching, Cloning, Troubleshooting and Performance Tuning of Oracle Applications e-Business Suite
• Creating/Managing Users
• Managing Responsibilities and adding responsibilities to users
• Creating Concurrent requests and managing
• Experience on Multi Org
• Production Experience in administering Oracle Apps 11i, and upgrades from 11.5.8,11.5.9 to 11.5.10,R12
• Implemented shared appltop application systems and configured BigIP to load balance mid-tiers
• Implemented Parallel Concurrent Processing to load balance CP tier
• Integrated Oracle Applications 11i with OID/SSO
• Installation and maintained SOA/BPEL
• ODI Implementation (Full Life Cycle)
• Configured applications on SSL secure mode
• Experienced in Performance Tuning of all Modules, Concurrent Programs and SSWA
• Experienced in Space Management, Memory Tuning and Application Tuning
• Cloned Oracle applications 11i and Databases
• Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, Jinitiator and database)
• Performed NLS implementation
• Applied oracle apps tech stack patches (10.1.2, 10.1.3, iAS, 8.0.6 MT tech stacks + 9.2.0, 10.2.0, 11.1.0.6 DB tier tech stacks), 10g RAC fix patches using opatch
• Applied product specific fix patches, family packs, maintenance packs - all types of patches -adpatching
• Well versed with UNIX shell scripting, PL/SQL and Java Coding
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning, Refreshing Databases on Oracle Applications
• Involved in data model design and database development including PL/SQL stored procedures, functions. Having Strong Oracle Development background besides DBA skills
• Good at intellectual knowledge base creation-documentation during the project implementation phase and maintenance phase
• Worked with KINTANA for patching and code migrations

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite R12, 11.5.10, 11.5.9, 11.5.8, 11.5.7

Databases: Oracle 9i/10g RAC

Operating Systems: Oracle Enterprise Linux 3/4/5, Red hat Linux 2.1/3.0/4.0/5.0 , Sun Solaris 5.6/5.9/10UNIX IBM AIXTools KINTANA,ADDR, ASH, TOAD, OEM, OAM, SQL*Plus, SQL*Net, SQL*Loader, RMAN Middleware Fusion Middleware -10g AS (OC4J clustering, EM, web cache, OID/SSO, Discoverer)

PROFESSIONAL EXPERIENCE:

Confidential

Sr Applications Database Administrator

Responsibilities:

• Supporting oracle applications 11.5.10 CU2 production systems of size 7 Terabytes. 4 Node RAC and on ASM
• BI Database migrations
• BI Database Upgrades
• OBIEE database migrations, building report(prod) instance using TTS
• Performance issues of BI Databases
• Working closely with BI Teams
• Cloud Implementation
• 11g RAC Installation
• R12 Installations
• Data guard Implementation from TEST to PROD
• Data Guard Implementation on ASM File System
• Cloning RAC to RAC, RAC to Non RAC and Non RAC to RAC
• Working on BI Databases, Performance issues
• Siebel Performance Issues
• Patching RAC nodes
• Participating OWC to involve internal Oracle development teams to get the fix patches
• TAR management with Oracle support
• Shell scripting for the database and application monitoring
• Monitoring and configuring OEM
• Handling Concurrent manager PCP issues
• Creating Users, Adding Responsibilities
• Managing Users, working with SOX Team for validations
• Defining Responsibilities,Menu's
• Creating Concurrent requests/sets and managing
• Maintaining Alpha and Beta development test environments to make the patching and implementation phase smoother

Confidential - Torrance CA

Senior Applications Database Administrator

Responsibilities:

• Full ODI END to END life cycle implementation
• Supporting oracle applications 11.5.10 CU2 production systems of size 7.5 Terabytes. 2 Node RAC with 16 node mid-tiers. 8 internal and 8 external
• SOA/BPEL Installation single Node & on RAC
• Cloning RAC to RAC, RAC to Non RAC and Non RAC to RAC
• Patching RAC nodes
• Participating OWC to involve internal Oracle development teams to get the fix patches
• TAR management with Oracle support
• Shell scripting for the database and application monitoring
• Monitoring and configuring OEM
• Handling Concurrent manager PCP issues
• Creating Users, Adding Responsibilities
• Managing Users, working with SOX Team for validations
• Defining Responsibilities,Menu's
• Creating Concurrent requests/sets and managing
• Maintaining Alpha and Beta development test environments to make the patching and implementation phase smoother
• Troubleshooting applications issues at various levels operating system/cluster/database/instance/listener/ concurrent manager/forms tier/webserver/sso/oid/discoverer/BPEL
• Designing backup strategy for SOA/BPEL
• Workflow Queue's rebuilding
• Monitoring and configuring OEM

Confidential

Senior Applications Database Administrator

Responsibilities:

• Supporting oracle applications 11.5.10 CU2 production systems of size 3.5 Terabytes. 4 Node RAC with 16 node mid-tiers. 8 internal and 8 external with SSL supported configuration on Sun Clusters. It includes DR site of same configuration. OID/SSO is clustered to support the authentication process. Integration with BPEL SOA clusters. Discoverer/BI reporting server is implemented along with reporting instance which is standby db refresh of prod
• SOA/BPEL Installation single Node & on RAC
• Installation of R12 and Support
• Implementation, Maintenance of DR site
• Architecting PCP in 4 RAC nodes
• Creating Users, Adding Responsibilities
• Managing Users, working with SOX Team for validations
• Defining Responsibilities,Menu's
• Creating Concurrent requests/sets and managing
• Patching production, development, alpha, beta test environments
• Cloning RAC to RAC, RAC to Non RAC and Non RAC to RAC
• Cloning Oracle Apps HA environment to Beta and alpha environments
• Designing reporting Architecture
• Handling production Crisis calls - Tier 3 support and finding the RCA
• Designing backup strategy
• Workflow Queue's rebuilding
• Monitoring and configuring OEM
• Configurator mid-tier setup and sizing JVM
• Pinning Concurrent managers to a specific RAC node for APS suite
• Installing HA 10.1.4 OID cluster - 10g AS stack
• Configuring DMZ setup for external applications
• Supporting External and Internal facing applications with DMZ setup
• Recommending the feasible solution to Oracle support to get that implemented
• Backing up apps system using RMAN backup
• Patching 2 appltops and handling patching issues
• Creating monitoring alerts in OEM 10g Grid
• Setting new threshold values based on the alert history and business requirements
• Handling Node crashes and finding RCA
• Tuning applications
• Validating the requests against SOX processes
• JVM death detection and resolving
• Handling Concurrent manager PCP issues
• Patching RAC nodes
• Participating OWC to involve internal Oracle development teams to get the fix patches
• TAR management with Oracle support
• Shell scripting for the database and application monitoring
• Capacity planning - space management, ongoing maintenance of prod and dev, alpha, beta envs
• Making configuration changes and running autoconfig in all the external and internal mid-tiers
• Isolating problematic mid-tier to resolve the customer issues
• Resolving datagaurd DR site sync issues
• UNIX Shell scripting to simplify the day to day activities
• Configuring Load Balancing using BigIP
• Maintaining Alpha and Beta development test environments to make the patching and implementation phase smoother
• Troubleshooting applications issues at various levels operating system/cluster/database/instance/listener/ concurrent manager/forms tier/webserver/sso/oid/discoverer/BPEL

Confidential

Oracle Application DBA

Responsibilities:

• Applying patches for enhancement and fixing bugs using Adpatch, Opatch.
• Resolving datagaurd DR site sync isues
• Supported HRMS and applied all HRMS related patches
• Supported Financials and applied all related patches
• Working closely with Functional/Developers and helping them in issues
• Handling Tars
• Production Assessment Tests and maintained to the global standards
• Stress test worked with Test Engineer and evaluated the performance
• Tuned the slow running concurrent requests
• Define New Concurrent Managers
• Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of sysadmin
• Installation of Multi Node with Shared File System and Cloning
• Registering the new Forms, Reports, pl/sql scripts as concurrent programs as part of technical.
• Implemented Mexico legislation
• Working knowledge of Kintana to migrate Concurrent programs, Responsibilities, Menus
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations
• Database Upgrade from 8.1.7 to 9.2.0.6
• Test machine Upgrade to R12
• Rebuilding Database indexes
• Monitoring tablespace usages
• Customizing autoconfig templates according to the environment requirements
• Upgrading JDK versions from 1.4.2 to 1.5 and 1.6
• Compiling forms/pll’s, DB invalids, creating DB links

Confidential

Principal Support Engineer

Responsibilities:

• Installed Applications 11.5.8,11.5.9,11.5.10 for single Node and Multi node
• Upgrading customers databases from 8i to 9i and 10g and Applications upgrades from 11.5.8 to 11.5.9 and 11.5.10.2
• Upgrading from 11.5.10.2 to R12( Oracle E-Business)
• Installation of RAC for Applications and Maintenance
• Performed Oracle Apps 11.5.9 System administrator tasks
• Responsible for Creating Setting Up Users and Assigning Responsibility in various Operating Units
• Setting System and User Profile Values
• Interacted with users and solving their issues
• Configuring Load Balance using BipIP
• 24x7 support on environments
• Worked with Mercury’s ITG Kintana (ITG-IT Governance) Team for the Integration of Oracle Application 11.5.10 with Kintana
• Installed Oracle Applications 11.5.10 in Linux 2.1AS and 3.0 ES Operating systems
• Experience on working emerging technologies like Shared APPL TOP, Parallel Concurrent Processing (PCP)
• Participated in OWC with Oracle Support and solved the issue
• Created tablespace for custom based user data tables and indexes
• Creation of Database Users and Registering in Oracle Apps
• Created of Database links and registered them in Oracle Apps
• Applied various patches using both adpatch and used lot of techniques in minimizing the patching downtimes
• As part of tech team member we handle all technical tasks for entire on demand Customers
• Troubleshooting Apache and Concurrent manager issues and issues after patching and Autoconfigurations
• Created custom based application top CLM TOP, Custom Based application top
• Registered Concurrent programs and applications
• Performed many Database recoveries on Production instances where required
• Worked along with Developers and Users/Database Owners to ensure smooth movement
• Created Control files and Importing data using SQL* Loader to Interface tables
• Managed system configuration using autoconfig
• Tablespace monitoring
• Checking backup status to ensure validity
• Applying Apps and DB Patches
• Cloning Oracle Applications 11.5.10
• As a Team lead of PA(Production Assessment) team of Nine members in team managed 24/7
• Giving to other team members and create knowledge base/documents
• Monitoring the environments from OAM

Confidential

Oracle Database Administrator

Responsibilities:

• Creating and sizing of database objects (tablespaces, tables, and indexes).
• Database Backup and crash/Recovery both local and remote.
• Documented the Backup and Recovery procedures.
• Management of Users, Roles and Privileges
• Database performance tuning, table sizing and administration
• Scripts to monitor online Database objects and SGA.
• Diagnose the bottlenecks and problems causing poor performance
• Database reorganization to minimize fragmentation.
• Rebuilding indexes for faster access and to reduce disk I/O.
• Clone the database for debugging application bugs.
• Data extraction and Loading using Export/Import and SQL*Loader.