SUMMARY

• 8 plus Years of extensive experience in design, development and analysis of applications using Databases and Object Oriented methodologies
• An astute Oracle Applications DBA/Oracle DBA experience in Oracle products, both production and development environments spanning several industries.
• Experienced and proficient with Oracle E - Business suite applications (11.5.7, 11.5.8, 11.5.9, 11.5.10.2 and 12.0.4,12.1.2,12.1.3) and Oracle Applications Server (9i/10g/11g) in Sun Solaris, Red Hat Enterprise Linux, AIX and Windows environment.
• Worked on many of the Application modules like Financial, AR, AP, PO, IREC, OE, GL, INV, OM, Manufacturing, HR Payroll, Time & Labor and Workflow etc.
• Expertise in supporting and maintaining Oracle Application Object Library (AOL/FND), Oracle Workflow (WF), Alert (ALR) and System Administration.
• Experience in managing the Concurrent Managers, Internal Concurrent Managers, Standard Concurrent Manager and Conflict Resolution Manager & monitoring their operation.
• Very strong in Auto Patch, Upgrade, Cloning and Oracle Applications Manager.
• Database Backup and Recovery strategy implementation and User administration and Auditing.
• Experience in administering Oracle Apps 11i, databases and upgrade from 11.5.8, 11.5.9 to 11.5.10 and 11.5.10.2 to R12 (12.0.4,12.0.6,12.1.1,12.1.2,12.1.3).
• Expertise in administering Oracle 11i Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch etc.
• Used KINTANA for migration of custom programs, responsibilities and objects across various platforms.
• Troubleshoot problems related to Oracle databases and Oracle Applications 11i, and perform root cause analysis.
• Experienced in Forms Load Balancing, Apache/Jserv upgrades SSL setups.
• Experienced in Multi Reporting Currencies, Multi Language Support and Multi Org setup.
• Experienced in Web technologies, coding the server side and client validation programs.
• Expertise in implementing Shared APPL TOP and PCP.
• Expertise in troubleshooting Workflow and Notification Issues.
• Expertise in Performance tuning Database, Applications and Apache (JVM).
• Successfully installed 11g r2 RAC on Linux as a proof of concept.
• Experience in Business Documentation especially in the Pharmaceutical Industry, Financial Industry, Insurance and Telecommunications Industry.
• Documentation of the work assigned in the environment and stored for the future use.
• 24/7 Database Support and maintenance, TAR Tracking and Remedy Support.
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude and self motivated, dedicated in any work environment

TECHNICAL SKILLS

ERP: Oracle E-Business Suite

R12: 12.1., 12.1.2, 12.1.3

11i: Ver. 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10.2

RDBMS: Oracle 11g/10g/9i/8i/7X, Oracle 10g (RAC, Data Guard & Streams), SQL Server 2000/2005

OPERATING SYSTEMS: Sun Solaris 5.8, 5.9, 5.10, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/2008R2/XP.

LANGUAGES: SQL, Pl-SQL, C, C++, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

& TOOLS: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, TOAD Data Modeler, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

Sr. Oracle Applications DBA

Responsibilities:

• Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Installed and configured Oracle 11g Real Application Clusters (4-node RAC) environment for E-Business Suite.
• Upgraded database and Grid from 11.2.0.2 to 11.2.0.3
• Added/removed nodes to/from a RAC cluster.
• Implemented transparent data encryption (TDE) in Oracle databases to protect customer sensitive data
• Had good experience in troubleshooting ASM disk related issues, RAC VIP and local listener issues.
• Extensively worked on cloning of single and multi-node database and applications.
• Implemented shared APPL TOP and PCP on oracle EBS R12 and VCP
• Experienced in Installation Support and administration of applications like Rapid planning (RP), Demantra and APCC (Advanced planning Command Center), GRCC.
• Extensively Worked on Multi language patching using utilities like adpatch, admrgpch in multinode environment and application of PSU patches.
• Worked on Configuration of external internet based applications like iStore, Isupplier, iReceivables etc., with E-Business Suite R12 in a DMZ environment.
• Troubleshooting issues in oracle applications configured in DMZ and with external load balancer.
• Implemented autoconfig customizations for R12 and worked in Creation of Custom Module Tops
• Worked on ASM and Non-ASM databases/ troubleshoot ASM issues
• Adding and dropping of ASM disks online.
• Provided database support for applications like FMW, AGILE, OBIEE, GRCC, Vertex, IAM/OAM, EPM, ODI
• Involved in Implementation of Database Vault and Audit Vault.
• Had experience in 11g and 12c OEM (Oracle Enterprise Manager) for monitoring applications and databases and to schedule reports.
• Involved in upgrading OEM from 11g to 12c and from 12.1.2 to 12.1.3
• Experience in writing UNIX shell scripts for automating daily, weekly and monthly activities and for monitoring purposes.
• Configured load balancing of oc4j components ( Forms, oacore, Apache) in multinode environment
• Participated in High availability Testing and Disaster recovery drills.
• Taking care of the performance issues both at the database level and applications level.
• Used Rman for backup and recovery of databases and for cloning.
• Worked on SSO integration of ERP applications like EBS and VCP With OAM/OIM
• Implemented Physical Standby and Active dataguard for disaster recovery purpose and for reporting use.
• Extensively worked on Import/export of schemas, tables and complete databases.
• Involved in AACG application upgrade
• Created custom concurrent managers and mailers based on requirement.
• Worked on defining custom concurrent programs and responsibilities and assigning to users
• Performed Form personalization and oaf personalization on developers request.

Confidential, PA

Sr. Oracle Applications DBA

Responsibilities:

• 24x7 Production Oracle Applications Maintenance, Support and Administration.
• Extensively worked on single Node & Multi Node cloning.
• Installed and Configured Discoverer 11.1.1.2 and Oracle OID 11.1.1.2 with E-business R12
• Worked with Team on Hardware migration of Servers between different datacenters.
• Worked on implementation of different phases of Project (DEV, TEST, UAT, and PROD) and providing post Go Live support.
• Performed DB upgrade from 10.2.0.4 to 11.1.0.7
• Extensively worked on rman backup and recovery
• Write and modify UNIX shell scripts to manage Oracle environment.
• Worked on SOA, OBIEE, Hyperion and vertex environments.
• Performed clone of SOA environment from prod to DEV and TEST.
• Involved in upgrade of SOA from 11.1.0.7 to 11.1.1.4
• Had done migration of OBIEE reports, repository from TEST to PROD
• Involved in installation and configuration of HYPERION 11.1.1.3 in development.
• Extensively worked on SSL security configuration.
• Extensive knowledge in Oracle ERP Application modules such as Inventory, Order Management, IStore, Accounts Receivables, Accounts Payables, ipayment, HRMS, Payroll, Paymentech, Purchasing, CRM foundation.
• Worked on oracle XML publisher administrator module and assisted in resolving issues with printing reports in PDF outputs.
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Extensively used adadmin compiling forms, report files, Jar files etc.
• Worked on Workflow mailer configuration and issues
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Worked on creating the custom managers, configured custom OPP and administration of Concurrent Managers.
• Worked on executing pl/sql stored procedures and assisting developers with executing the scripts.
• Experience on PASTA configuration and registration of Printers at OS level

Environment: Oracle 10g/11g, Oracle Applications EBS 11i/R12, Solaris 10, Linux, Windows, RMAN, Data Guard, SOA, OBIEE, Hyperion, Data Pump, Discoverer.

Confidential, CA

Sr. Oracle Applications DBA

Responsibilities:

• Created a Real Application Clusters (2- node RAC) environment for E-Business Suite.
• Development & Test Environnent Support includes cloning, project support, patching and bug-fixing.
• Upgraded Oracle Applications from 11.5.10.2 to Release 12.0.4 on Solaris 10.
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Upgraded Oracle Applications 11i (11.5.5.10) Database Version 8.1.6.4 to 10g (10.2.0.4) on Solaris.
• Applied mini-packs, CPU patches, family packs using ADPATCH, ADCTRL utilities.
• Oracle Application R11i Upgrade (Apps 11.0.3 to 11.5.3/11.5.5/9iAS, Database 8.1.6 to 8.1.7/9i)
• Created test environment through cloning production environment for developers to test on live data using rapidclone and adconfig utilities.
• Administration of Oracle ERP applications 12.1.1 and 12.0.4
• Implemented STAGED APPL TOP to reduce patching downtime.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Experience on various modules such as Financials, MFG, CRM, AR, AP, GL, PO, INV, MMS, OTC, OPS ASCP, FA, MSCA 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.
• Perform SQL tuning and assist developers with coding PL/SQL and code review of customizations.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Supported installation and configuration of Oracle WebDB, Oracle OAS and Oracle 9iAS.
• Configuration of Workflow Notification Mailer, OAM, 10g Grid Control
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack).
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10G database.
• Expertise in migrating forms from 6i to 10g.
• Skills in Oracle E-Business Application single & multi node Shared Installation with Dematerialize Zone DMZ security firewall.
• Installed and configured Single-Sign On with OID and Implemented SSL Security.
• Utilized VERITAS DBAC software to manage raw partitions and clustering on the HP-UX systems.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users.
• Designed and generated forms for data validation and processing in Oracle Forms 10g/11g/6i and also in generating reports in Oracle Reports 10g/11g.
• Applied several Localization patches for country specific functionality.
• Converted the database into Automatic Storage Management (ASM) enabled database.
• Expertise in migrating from Oracle10g to 11g
• Planning and Administration of backup and recovery strategies.
• Upgrades of J-initiator, Forms, and OJSP as part of the Applications Upgrade.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Provided application support to users and created a log of all the problems with solutions for future reference.

Environment: Oracle 9i/10g/11g, Oracle Applications EBS 11i/R12 ASM 10.2.0.4, CRS 10.2.0.4-P21, Solaris, Linux, Windows, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Metal ink, PL/SQL Developer, Data Pump, And VERITAS Net Backup.

Confidential, Atlanta GA

Sr. Oracle Applications 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 Production database from Old servers to new servers.
• Successfully implemented 3-node RAC setup and made the environment stable.
• Good knowledge on 10gAS OID, SSO and complete infrastructure and middle tier components of 10g.
• Configured load balancing on Apache and Forms Servers.
• Applied patchsets, one-off patches, opatch to the Development and production servers.
• Monitoring of databases using 10g OEM grid control.
• Implemented the Oracle E-business suite Application Management Pack on OEM.
• Implemented Shared APPL TOP.
• Troubleshooting the issues raised by oracle ERP from both user community and development.
• Taking care of the performance issues both at the database level and applications level.
• Scheduled the backups using RMAN and disk backups.
• Worked with Oracle Support on resolution of SRs.
• Created and monitored the concurrent managers.
• Allocating system storage and planning future storage requirements.
• Cloning of Database and Applications as per functional requirements.
• Oracle Applications upgrades, patches using various AD utilities.
• Resolving system errors, disk space problems, huge file sizes errors.
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS, and FND STATS packages and ANALYZE command.
• Monitored the Applications and database using OAM.
• Rebuild the indexes and dropped unused indexes.
• Setting up the printers in Application environment.
• Upgraded JDK 1.1 to 1.3.1
• 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.
• Monitoring Oracle Applications users.
• Worked with End Users and Functional Analysts on issue resolution (concurrent manager problems, one off patches etc).
• Tuned the database and applications using EXPLAIN PLAN, Auto Trace, SQL Trace, (advanced version of UTLBSTAT and UTLESTAT).

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

Confidential, MD

Oracle Applications DBA

Responsibilities:

• Maintained Oracle Applications Release 11i (11.5.10.2)
• Successfully completed 3 Test upgrades from 11.5.7 to 11.5.10.2
• Upgraded Oracle Application databases from 8i to 9i (9.2.0.7)
• Upgraded Oracle Application databases from 9i to 10gR2
• Implemented Parallel Concurrent Processing
• Installed, upgraded and maintained Oracle ERP applications version 11.5.9
• Upgraded application from 11.0.3 to 11i using Auto Upgrade.
• Administration of Oracle ERP applications version 11.5.10.2.
• Setup and implementation of Oracle Financial Analyzer.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purpose.
• Setup system profiles in Apps.
• Setup of test 9i RAC Cluster using Linux.
• Implementation of Oracle Applications Server for use with Portal, Custom Forms and Reports and Discoverer 6i.
• Worked with Orchestration Team to simplify the integration Architecture and Transition to ESB.
• Implemented Oracle 9i RAC on Windows.
• Registered customized applications, Apps Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Installed, Configured and Integrated OID with Single Sign On against 9i Database.
• Registered printer in Applications.
• Enabled Auditing feature. Worked on Workflow, Oracle Application manager.
• Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
• Created new application messages and then generated message file for application.
• Experience in performance tuning using TKPROF, EXPLAIN PLAN and STATSPACK and debugging the database.
• Monitoring of database for growth and performance
• Created new concurrent managers, Purged concurrent requests table.
• Wrote custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• Provided application support to users and created a log of all the problems with solutions for future reference. Worked on Punch Out, Bulk Loader.

Environment: Oracle10g(10.1.0.5to10.2.0.4),9i(9.2.0.8), Oracle applications 11 i, SunSolaris8.0/9.0/10.0, AWR, ADDM, Redhat4, RAC, TOAD, OWB, Erwin7.2, ASM, VCS, Citrix, Oracle Enterprise Manager, ETL, RMAN, SQL*Plus, PL/SQL, CRS, SQL*Loader