PROFESSIONAL SUMMARY:

• Over 7+ years of extensive experience as an Oracle DBA and Applications DBA
• 6+ years of solid experience in Oracle 11i Applications (Oracle EBS) DBA.
• 5+years of experience in Oracle database 9i, 10g, 11g and Oracle Grid control.
• 4+ years of experience in implementation and installation RAC Database with 2 and 4 nodes.
• 4+ years of Proficient Experience with Standby Database, Data Guard, Replication.
• Experience in working with different environments/versions and server administration including LINUX, Windows, SOLARIS, AIX and HP-UX.
• Experience providing 24X7 on-call support to maintain all Databases up and running in Production environment.
• Expert in Discoverer 4i,9i and 10gAS integrations and end-to-end Installs.
• Proven Experience with Release 11, 11i & R12 staged CD and Rapid Install.
• Proven experience with 10g R2 10.2.0.4 with datagaurd Disaster Recovery environment.
• 3+ years experience in developing applications using OBIEE
• Experience with SHARED & STAGED APPL_TOP configuration.
• Expertise in cloning and patching the E-Business environment utilizing tools such as rapid clone, adadmin, adctrl and adpatch.
• Installed, Implemented and Configured Oracle 10g Single Sign on (SSO) with OID Server.
• Installation, configuration and maintenance of Oracle 10g RAC, 9iAS/10gAS and 11i applications.
• 5 + years experience in Oracle e-business Suite implementations and Upgrades from CRP, Development, and UAT to production as an Oracle Application DBA.
• Installed and Configured 10gRAC with PCP for Ebusiness 11.5.10.2
• Experience with Installation, Configuration, Upgrades, Migrations, Administration and Patching of Oracle Databases and Oracle Applications.
• Implementation of High Availability solutions withOracle8i/9i/10g/11g, 10g RAC, Standby Database, Data Guard, Replication.
• Experience in using GoldenGate to support data replication in the Oracle database environment.
• Performing Database Cloning in Oracle 9i, 10g and 11g using RMAN.
• Good knowledge on Oracle streams, data guard physical standby databases, working knowledge on BCV'S, SRDF, and managing of partitions and clustering of tables.
• Experienced in using11g features like Database Replay, Partitioning, LogMiner, Schema Management, Transaction management, Caching and Pooling, Resiliency, Case sensitive passwords, Virtual columns and Security.
• Experience implementing Oracle Single Sign-on (SSO), Oracle Internet Directory(OID), Oracle Identity Management , Oracle Grid Control , Oracle SOA Suite, Oracle Transportation Management(OTM), Oracle Business Intelligence Enterprise Edition (OBIEE) , Oracle Data Integrator, Oracle Collaboration Suite, Real Application Clusters(RAC) or high availability oracle operating environment.
• Installed and Configured Oracle Application Server 10g(10.1.2.x & 10.1.3.x SOA) with Portal and Discoverer as an active applications.
• Involved in doing Data Modeling, data mart, designing data warehousing boundaries and parameters, Data Transformation, PL/SQL.
• Designed/implemented data mart, extensive ETL routines and table-partitioning system for data warehouse
• Experience in Data Warehousing using ETL Tools and Oracle.
• Applied patches to update and security fixes to Oracle E-Business Suite 11.5.5, 11.5.9, 11.5.10.2.
• Experienced in setting up/installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g CRS. Experienced in configuring & managing the ASM.
• Strong Experience in Cloning & Patching Oracle 11i Instance using Rapid and manual Cloning and strong experience in 11i e-business suite installation.
• Performed Oracle EBS 11i migration from HP-UX to LINUX.
• Proficient in an Oracle operation tuning and the Oracle RAC.
• Upgradation/Migration of databases from Oracle9i RAC to 10g RAC.
• Expertise in Upgrading Oracle Applications 11i e-business suite to R12.
• 5+ years of experience in implementation and administration of Service Contracts, Install base, INV, OA Framework, TCA and SCM/CRM modules of Oracle Applications ERP/E-Business Suite (EBS), Enterprise Asset Management (EAM), Customer relations Management (CRM).
• Good experience on configuring and installing Oracle Application Server (9iAS/10gAS), Discoverer, IDiscoverer, Punchout, ADI.
• Extensive experience of creating star schema for OBIEE/Siebel Analytics Projects.
• Configured and set-up Oracle BIEE (Business Intelligence Suite-Enterprise Edition) for reporting.
• Build OBIEE Repository from tables in Oracle- build physical layer, business Models and mapping on the Admin tool - Fast Calculations, Testing and validating Analytics Repository.
• Experienced in Maintaining VLDB databases in 11i with most affective modules being GL, Financials, AP, OM, Advance Pricing, Trade Management, INV, PO, HR, AR, FA, MRP, ONT, MFG, Depot Repair, Install Base and Service Contracts.
• Experience in Customization and Implementation of iStore, I collections, I Payment modules.
• Migrated and upgraded single-tier Application Server to HA 10g OracleAS Cluster(Identity Management) behind F5 LTM with RAC Metadata Repository
• Experience in oracle Web logic suite 11g on performance, Scalability, efficiency and manageability on a single unified application server.
• Strong Experience in Installing, Configuring and Implementing Oracle HRMS that includes Enterprise and Workforce Management, Payroll Process Management, Compensation, Benefits , Payroll and HR information systems.
• Experience in controlling and monitoring user access and privileges to the database and maintaining system security and SOX Compliance Auditing.
• Experienced in setting up/Installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g CRS.
• Experienced in configuring & Managing the ASM.
• Installed standalone BPEL Process Manager with Oracle Application Server.
• 5+ years of strong working experience on Oracle forms and reports 6i & 9i
• Well versed in Rapid Install, adpatch, adadmin, adsplicer, adlicmgr and adctrl utilities for Oracle Applications and involved in Apache Load Balancing.
• Applied patches to 11.5.5, 11.5.9, 11.5.10.2 versions of Oracle E-Business suite.
• Upgraded Oracle 11i Applications Database 9i (9.2.0.6) to 10.2.0.3 on Linux.
• Implementation, Troubleshooting forms server, report server, Discoverer server, Web Server and Maintenance of Concurrent managers and Parallel concurrent Process (PCP).
• Oracle 10g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
• Oracle 10g Application Server Enterprise load balanced setup and configuration using multiple Oracle RAC databases for metadata repositories
• Installing, configuring and maintaining Oracle Grid Control.
• Extensive knowledge in working with the utilities like OEM, TOAD, Export / Import, Stats pack, SQL* Loader, SQL Analyze, TKPROF, Explain Plan and Oracle Supplied DBMS_PACKAGE.
• Configuring backup software like VERITAS Netback up, Legato Networker for oracle using RMAN tool for backup and recovery.
• Scripting and scheduling of oracle database backups using hot backup and RMAN.
• Good Knowledge of Oracle SQL & PL/SQL programming and tuning.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listeners running, disk space availability, checking for errors in alert logs etc.
• BPEL/Workflow performance troubleshooting and tuning.
• Proficient in using the tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Experience and expertise in 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 and providing support to apps users for any Technical or functional issues.
• Expertise in Database Space Management, Memory Tuning and Application tuning.
• Upgradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Successfully deployed DR environments using Oracle Data Guard.
• Implemented back office technology solution systems ERP, BAAN financials GL, AP, AR Multi currency, multi language and CRM Siebel SFA and custom software solutions for Supply Chain Management and e-commerce.
• Good team player, self-motivated and a quick learner.

TECHNICAL SUMMARY:

• ERP environment: Oracle 9i ,Oracle10g R2 ,Oracle 11g R 1 , 11g R2
  Oracle Applications R12, 11.5.10.2, 11.5.9, 11.5.8, 11.5.7, 11.5.5, 11.5.2, 11.5.1. Forms 6.0, 4.5, 10g. Reports 6.0, 4.5, 9i, 10g.
• Third Party tools: EMC TimeFider, SRDF (disk to disk mirroring), Shareplex (Object level replication) 3.2, 4.1, 5.2, 170 systems (Markview), Noetix, Veritas software, OID, Oracle Portal, Erwin and DBArtisan, SQL* Loader.
• Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK
• DB Management: TOAD 7.6/7.5, OEM 9.2/10G (10.1/10.2) Grid control (RAC), RAT.
• Databases: Oracle 10g,11g
• Programming: Unix Shell Scripting PERL, Bourne, Korn, AWK-SED, PHP, JavaScript, SQL, PL/SQL, HTML, DHTMLC, C++, Java, FORTRAN 77/80.
• Operating Systems: HP-UX 10.x/11.x, AIX 4.3.x/5.1/5.2,WINDOWS NT/2000/2003 Server, RED HAT LINUX 9/8/7.2/7.1/6.2, RHEL 2.1/3.x/4.x, Sun Solaris 8/9/10, VMware ESX Server 3.0.x/3.5.0.
• Hardware: SunFire 15K with 72 CPUs 144GB Memory, SunFire 6900 with 40 CPUs 80 GB Memory, E6900, IBM XSERIES_346 with 4 CPU's 12GB Memory .

EDUCATION:

• Bachelor of Engineering

PROFESSIONAL EXPERIENCE:

CLIENT: Confidential Sep' 2008 - PRESENT
LOCATION: CHARLESTON, WV.

Oracle Apps DBA/ Oracle DBA
Department of health and human recourses has health plans and public sector entities partnering with more than 3,500 care facilities national wide. Supported as an Oracle Apps DBA implemented and installed Oracle 11i e-business suite and Upgraded to R12 and thus provided 24*7 Production support.

Responsibilities:

• 24x7 Production Oracle Applications Administration.
• Maintaining production, development& test databases and applications.
• Good knowledge on Oracle applications 11i Rapid Installation.
• Configured, created and Managed Oracle Data Guard in a real Applications Clusters (RAC) Environment.
• Installed Release R12 12.0.4 & 12.1 with ASCP, WIP,BOM,INV and Demantra Integrations
• Installed and Managed 10g Database R2 10.2.0.4
• Installed, Configured and deployed SOA BPEL, ESB on single node and cluster node.
• Installed Discoverer with 10gAS, SSO, OID integrations
• Assist Data Warehouse group with developing routines for dataextractions, transformation, loading into operational data stores.
• Implemented data mart, extensive ETL routines and table-partitioning system for data Warehouse.
• Installed and Configured Oracle Application Server 10g SOA (10.1.3.4).
• Involved in a project implementation of Installation and Configuration of SOA suite Version 10.1.3.3 including Application Server with OC4J, ESB, BPEL, OWSM (Oracle Web services manager) & UDDI Registry.
• Applied patches to 11.5.5, 11.5.9, 11.5.10.2 versions of Oracle E-Business suite.
• Responsible for cloning and patching the E-Business environment utilizing tools such as rapid clone, adadmin, adctrl and adpatch.
• Installed and Administered OAS 10g including SOA BPEL & ESB.
• Upgraded Oracle Database 9i (9.2.0.4) to Oracle Database 10g (10.2.0.3) and 10g to 11g (11.1.0.6).
• Upgraded database from Oracle 9i to Oracle 10g and Implemented RAC with Data Guard on Solaris.
• Setup instance for Oracle Apps Upgrade from 11.5.9 to 11.5.10.2.
• Automates cloning using OAM for release 11.5.10.2.
• Load test has been done on oracle application server using SOA UI
• Installation and configuration of Oracle Application Server 10g (10.1.2.0.2 & 10.1.3.3) with portal as a partner application.
• Applied patches using ADPATCH, ADCTRL utilities.
• Designed, Developed and Tested Data security and Dashboard security in OBIEE.
• Configured Java Workflow Mailer with IMAP & SMTP for inbound and outbound processing
• Extensively worked with Legacy Interface Programs with Customers, Invoice and Order Import
• Configured Disaster Recovery Environment with 10g Data guard
• Responsible for developing a plan to upgrade the existing production environment from 11.5.9 to 11.5.10 to R12.
• Responsible for managing the RICE development team at offshore
• Full scale implementation and maintenance of oracle HRMS Suite.
• Experience with the functionality in HR, Payroll Integration, Talent Management and Self Service modules of the Oracle HRMS Suite
• Tuned 'HR/PayrollDetail Extract' process to achieve performance improvements.
• Worked on several small bug fixes for HR/Payrolland OAB modules
• Experience in writing UNIX shell scripts for automating daily, weekly and monthly activities, experienced in developing exhaustive documentation for all activities performed.
• Registered Forms, created Form Functions and Menus. Registered Executables, created Concurrent Programs and Request Groups
• Integration of Oracle Application Server 10g components like Single Sign-On/Portal/Discoverer/ Oracle Internet Directory (OID) with Oracle Applications 11.5.10.
• Installing, configuring and maintaining oracle Grid control.
• Managed the implementation of iStore using configured items designed and built in Oracles Product Configuration Developer tools along with customizations to iStore.
• Worked on Oracle Real Application Testing combined with a workload capture and replay feature with an SQL performance analyzer (SPA) to test changes against real-life workloads, and then fine-tune the changes before putting them into production.
• Support full life cycle of Oracle e-Business Suite, Financial Accounting Hub (FAH) - installation, configuration, patching, cloning, security, upgrades, etc.
• Involved in a project implementation of Installation and Configuration of SOA suite Version 10.1.3.3 including Application Server with OC4J, ESB, BPEL, OWSM (Oracle Web services manager) & UDDI Registry.
• Technical Support for Oracle Applications, including management of databases, application servers, concurrent managers etc.
• Designed and implementedstandards for UNIX-based ORACLE systems.
• Develop shell and/or, PL/SQL and/or SQL scripts to implement automation of ongoing administration and maintenance tasks.
• Deploy the application custom developed code following the corporate code deployment and data migration processes.
• Set and document standards for use of databases with objectives of data integrity, data security, and efficient operation and audit requirements.
• Integrating Oracle Applications R12/11i with OID/SSO.
• Daily activities include taking backups with RMAN, Hot and Cold Backups.
• Installing, configuring and supporting the upgrade of Oracle 11i.
• Converted the database from 32-bit into 64-bit on Linux Environment.
• Tuning of I/O, which includes Separating of Data files and Redo log files on different locations, and Separating of tables and indexes on different locations. Applications Tuning of Database usingEXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc
• Setup a cronjobs using crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.
• Converted the database into Automatic Storage Management (ASM) enabled database.
• Integrating Oracle Utilities Applications with Spatial GIS database.
• Maintaining middle tier Architecture (9iAS/10gAS).
• Oracle Apps Patch management and Patch migration processes.
• Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
• Oracle Applications Upgrade from Oracle Applications(E-Business Suite) 11i (11.5.10) to R12/12i(12.0.4)

Environment: Unix/Linux, Solaris, Oracle 9i&10g, 11g, Oracle Applications 11i and R12

CLIENT: Confidential Aug'2007 - Aug'2008
LOCATION: PLYMOUTH, MN

Oracle Apps DBA Administrator
As an Oracle Apps DBA, responsible for upgrading and smooth functioning of Oracle 11i applications, successfully upgraded 11i version 11.5.5 to 11.5.10.2 and Database 9i to Oracle 10g.

Responsibilities:

• Responsible for both managing and supporting all Production, Development, Test instances of Oracle Version 9.2.07, 9.2.0.6, 10.2.0.2 and Oracle Applications 11.5.10, 11.5.9, 11.5.5, 11.5.2.
• Experience with Installing and Configuring 11i e-business suite and R12.
• Maintaining (VLDB) OLTP databases in 24x7 Production environments on Multiple Applications Tiers with Load balancing of forms tiers.
• Upgrading and Configuring Oracle Applications 11i e-Business suite to R12.
• Installation of 11i e-business on Linux/Unix box.
• In depth knowledge and experience with oracle application utilities such as RapidInstaller, Rapid Clone, adpatch, adadmin, adspliceandadctrl.
• Migration to new Disk Array using ASM Rebalance to minimize downtime.
• Setup of Second RAC cluster running DataGuard for DR system.
• Installed and Configured Oracle Applications 11i e-business suite using Rapid Install.
• Handled database migrations of Oracle Applications (11.5.10, 11.5.9, 11.5.8, 11.5.5, 11.5.2) production (3-tier), test and development instances.
• Cloning Oracle Applications (11.5.10, 11.5.9, 11.5.8, 11.5.5, 11.5.2, 11.5.10.2) from production system, for testing and development purpose.
• Upgraded Oracle Applications (11.5.8, 11.5.9, 11.5.10) to R12.
• Scripting and scheduling of oracle database backups using hot backup and RMAN
• Supported various client modules such as Financials, Oracle Spreadsheet Server, MFG, CRM, AR,HR, OWB, AP, GL, PO, INV, FA, OM etc.
• Experience in configuring and customization of financial accounting, general ledger ERP package using Oracle Spreadsheet Server.
• Expertise in Importing Account Receivables data into Oracle Receivables
• Good Experience in setting up and configuring 9iAS/10gAS schema objects
• Developed a UNIX shell script to reduce the restoration (data files) to half the actual time.
• Installed Oracle 9i, 10g on AIX, Solaris, Linux and Windows.
• Applied Oracle Applications patches such as Maintenance Pack, Interoperability patch, Family pack, one off patch, Security patches etc on 11.5.2 through 11.5.10 instances.
• Installed Oracle Internet Directory (OID) on AIX/Linux/Windows.
• Installed and configured 9iAS/10gAS HTTP/DB adaptors and for interconnect purposes.
• Installed only middle tier instance on DMZ and configured portal as a partner application.
• Experience with Installation, configuration, upgrade and performance tuning of Oracle RAC.
• Performed day-to-day database and oracle apps tasks like code movements, package and form compilations.
• Experience with maintaining, monitoring and administration of physical database on Windows.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases.
• Proficient in performance tuning using Explain Plan, TKPROF.
• Installed and Configured Oracle Application Server 10g SOA (10.1.3.4).
• Installed, Implemented and Configured Oracle 10g Single Sign on (SSO) with OID Server.
• Installed Oracle Application Server 10g and deployed forms and reports with portal as an application.

Environment: Unix/Linux, Solaris, Oracle 9i&10g, Oracle EBS 11i & R12

CLIENT: Confidential, CARLSBAD, CA July '2005 -July'2007

Oracle Apps DBA
As an Oracle Apps DBA, responsible for installation, implementations, upgrades and smooth functioning of Oracle ERP applications on UNIX system and Oracle databases.

Responsibilities:

• 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.
• Extensive experience in system architecture of 11i Applications implementation of various Financials modules like GL, AP, AR, FA, etc.
• 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.
• Involved in 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.
• 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.
• Using TKPROF, EXPLAIN PLAN and STATSPACK for the Better performance.
• 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 datainto custom tables etc.
• Provided application support to users and created a log of all the problems with solutions for futurereference. Worked on Punch Out, Bulk Loader.

Environment: Unix/Linux, Oracle 9i&10g, Oracle Applications 11i

CLIENT: Confidential May'2003- May '2005
LOCATION: HYDERABAD, INDIA

Oracle Apps DBA Administrator
As an Oracle Apps DBA I was responsible for installation, upgrades, maintenance, security and implementation of Oracle ERP applications and Oracle databases.

Responsibilities:

• Responsible for managing production, development & test databases and applications.
• Maintaining the Oracle Applications Systems including Oracle databases, Middle tier IAS Applications.
• Involved in Upgrading of Oracle Version 8.1.7.4 & Oracle Applications 11.5.2 and supporting the production team.
• Cloning using Rapid clone, Autoconfig and adclone utility.
• Involved in database migrations Cloning Oracle Applications (11.5.2) production system, for testing and development purpose using rapid clone.
• In depth knowledge and experience with RapidInstall, RapidClone, adpatch, adadmin, adsplice andadctrl utilities for Oracle Applications.
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Experience in web development using HTML, JavaScript, and XML.
• Extensive experience in system architecture of 11i Applications implementation of various Financials modules like GL, AP, AR, FA, etc.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers and monitoring of the concurrent managers.
• Using AD Administration and other AD Utilities. Experience with Oracle Applications Desktop Integrator (ADI).
• Tuning the databases for optimal performance.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability
• Enabled Auditing feature for tables such as FND_USER etc.
• Created new application messages and then generated message file for application.
• 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.
• 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.
• Experience in implementing Hot, cold and RMAN backups and performance tuning of SQL statements

Environment: Unix/Linux, Solaris, Oracle database 8i&9i, Oracle Applications 11i