EXPERIENCE SUMMARY:

• Specialized in Oracle Applications R12/11i Database and System Administration wif over seven 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 wif 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.
• 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).
• 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 wif User Management, Performance Tuning, and Concurrent Processing Settings.
• Experience in Security Management and Database Auditing.
• Implemented Sabrix Taxing Software and integrated wif 12.0.4 Applications.
• Implemented DMZ for me-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.
• Database Upgrading from one server to another using Export and Import utility.
• Expertise in installing Discoverer and integrating to ERP Applications.
• 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.
• Performing R&D and analysis to benefit from new releases/features of Oracle Database.
• Basic Administration of UNIX systems (Solaris, LINUX, HP-UNIX TRU64, AIX).
• Troubleshooting Login, Self Service Application, Jinitiator and Network related issues.
• Applications sysadmin tasks like creating and managing users and their responsibilities, Menus, Functions.
• Skilled in handling a heavily customized 11i applications and upgrades.
• Applying RDBMS and Application patches. Sound noledge 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 trouble shooting capabilities.
• Experienced in Space Management, Memory Tuning and Application Tuning.
• Troubleshooting expertise for all tiers (client, middle-tier, database) .
• 11i Multi-Org & Multi Reporting Currency (MO, MRC) Implementations.
• Experience in Installation 11i both in single Node and Dual Node.
• Create and Maintaining the Technical Notes and Documentation.
• Strong Analytical skills and ability to interact wif end-users, managers, and technical personnel.
• Good team player, self-motivated and a quick learner.

TECHNICAL SKILLS:

Operating Systems: Solaris, HP-Unix, Linux, Windows XP/2000/NT, UNIX

OracleApps: Oracle E-Business Suite 11.5.8/11.5.9/11.5.10/ R12.0.4,R12.0.6,R12.1.3

Databases: ORACLE 8i/9i/10g/11gR1,11gR2, Real Application Clusters (RAC 10g/11g), SQL Server 2000/2005

Tools: SQL PLUS, SQL*Loader, Export & Import utility, Data Pump, RMAN, Data Guard 9i/10g,Tkprof, TOAD, Statspack, Discoverer, SQL navigator, Oracle reports, OAM, OEM, Kintana, MS Office, XML Publisher

Languages: SQL, PL/SQL, Perl, shell scripting, C, C++

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany-NJ

Sr. Oracle applications DBA

Responsibilities:

• Upgrade of oracle applications from solaris environment from 11i version to 12.1.1 and then to 12.1.3 to a linux operating system.
• Configuration of PCP for concurrent managers
• Configuration of load balancer for application services.
• Configuration of more4apps into oracle applications to insert data using excel sheet.
• Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH, and ADCTRL.
• Conversion of database from single node to two node RAC database.
• Using utilities like exp, imp, expdp and impdp to import schemas.
• Configuration of SSL.
• Installed and configured 12c cloud control.
• Installed 12c cloud agents and migrated the targets from 10g OEM to 12c.
• Created Custom concurrent mangers as required for performing daily tasks.
• Installation of Oracle SSO, Portal and OID and integrating wif EBS applications
• Upgrading Oracle Gloden gate 11.1.1.0 to 11.2.1.0.1
• Installing OracleGloden GateforEBS ReportingDatabases
• Oracle and SQL server Database Capture usingOracle Gloden Gate 11g
• Configuring Extract Parameters for Gloden GateEXTORA, RMTHOST, RMTTRAIL
• Worked on Configuring Workflow Notification Mailer, OAM.
• Implementation of High Availability solutions wif Oracle 11g/10g RAC, Physical and Logical Standby Databases (Data Guard).Created Agile schema after installing the database and copying the companion.
• WebLogic servers development, testing, applying patch and service packs
• Administer middle tier Oracle SOA, Oracle HTTP server
• Experience on various modules such as Financials, MFG, CRM, AR, AP, GL, PO, HRMS and INV.
• Installation and configuration of dellstat.
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Responding to different types of alerts automation using oracle alerts.
• Troubleshooting / resolving issues wif concurrent managers
• Installation, configuration, creation of end user layer (EUL), maintenance and troubleshooting of Oracle Discoverer 10g.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users.
• Converted single instance e-business database to Oracle 11g RAC

Environment: Red Hat Linux 4/5, SUN Solaris 9,, Oracle 11g (11.2.0.3),11g (11.1.0.7) Oracle Applications EBS 11i/R12,oracle SOA, oracle weblogic Oracle 10g, 11g RAC, TOAD .

Confidential, San Jose

Sr. Oracle applications DBA

Responsibilities:

• Migration of databases from physical host to VM’s.
• Build 4 node RAC databases on ASM and raw file system
• Installation of grid, database from EMAN.
• Maintaining development and test instances of oracle ERP applications, oracle SOA, web logic, and oracle primavera and agile.
• Refresh of databases using delphix.
• Supporting users in day to day activities on all technical issues.
• Experience on various modules such as Financials, ASCP, MFG, CRM, AR, AP, GL, PO, and INV.
• Upgrade of databases from 10.2.0.3 to 11.2.0.3 and As an Oracle Apps DBA, Successfully upgraded database from 10.2.0.5 to 11.2.0.3 and 11.1.0.7 to 11.2.0.3 wif interoperability for 11i and R12 respectively.
• Created test environment through cloning production environment for developers to test on live data using rapidclone and adconfig utilities.
• Configured Clusters on WebLogic using WebLogic Console.
• Installation and upgradation of VT patches.
• Implemented ASM on NFS mount volumes.
• Configured backup settings, created jobs for the backups and maintenance for the database servers in the grid control.
• Implementation, Troubleshooting forms server, report server, Discoverer server, Web Server and Maintenance of Concurrent managers and Parallel concurrent Process (PCP).
• Involved in developing a disaster recovery (DR) plan for Oracle Applications R12.
• Conversion of databases from single node to multimode RAC databases.
• Monitoring long running jobs and troubleshooting them.
• Developed automated scripts to halp 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 schemas.
• Administration of oracle ERP versions 11.5.10, 11.5.10.2 and 12.1.3.
• Perform SQL tuning and assist developers wif coding PL/SQL.
• Configuration of workflow notification mailer and business events.
• Creation of data sources in oracle SOA and web logic instances.
• Utilization of tools like swingbench and raman to generate load on database to test online migration of LUN’S at the backend to test online migration of storage from 7 mode ontapp to cdot(new storage implementation) mode.
• Implemented STAGED APPL TOP to reduce patching downtime.
• Maintenance of sabrix taxing software.
• Expertise in shell scripting and pl/sql programming
• Monitoring of databases using OEM.
• Application of patches as and when required.
• Debug Oracle Reports and Oracle Forms programs.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH, and ADCTRL.
• Creating tablespaces, data objects, setting privileges, indexes, user logins, and passwords.
• Coordinating wif Oracle Corporation for raising the Tar’s and supported activities

Environment: CEL 5.x/6.4,Red Hat Linux 4/5, SUN Solaris 9, Windows XP,7, Oracle 11g (11.2.0.3),11g (11.1.0.7) Oracle Applications EBS 11i/R12,oracle SOA, oracle weblogic, AGILE, Oracle 10g, 11g RAC, TOAD, Developer 6i,10g .

Confidential, Miami, FL

Sr. Oracle Applications DBA

Responsibilities:

• 24x7 Production Oracle Applications Administration.
• Maintaining production, development & test databases and applications.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack).
• Administration of Oracle ERP applications version 11.5.10.2
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Applied patches using ADPATCH, ADCTRL utilities.
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup
• f Oracle10G and 11G database.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack,
• Diagnostics Pack and STATSPACK.
• Created new Concurrent managers, Purged concurrent requests table
• Supporting Production and Development Users in all their technical issues
• Monitor the long running jobs and troubleshooting them for much faster performance
• Installing and configuration of markview
• Expertise in using RMAN for backup and recovery strategies

Environment: Red Hat Linux 4/5, Oracle 11g (11.2.0.3),10g(10.2.0.3),9i(9.2.0.7) Oracle Applications EBS 11i, Oracle 10g, 11g, TOAD, Developer 6i,10g .

Confidential, New York, NY

Oracle Applications DBA

Responsibilities:

• 24x7 Production Oracle Applications Administration.
• Maintaining production, development & test databases and applications.
• Good noledge on Oracle applications 11i Rapid Installation.
• Upgraded Oracle Applications 11. .5.10.2, 11.5.10.2 to 12.0.4 and 12.0.4 to 12.1.3
• Successfully upgraded Oracle Applications 11.5.10.2 to R12 (12.1.3) in multinode configuration.
• Performed installation and configuration of oracle SOA suite 10g/11g for the integration of Application and Database.
• Administration of Oracle ERP applications version R12.1.3
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Implementation, customization and personalization of Oracle iProcurement.
• Applied patches using ADPATCH, ADCTRL utilities.
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup f Oracle10G database.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack,
• Diagnostics Pack and STATSPACK.
• 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 wif coding PL/SQL.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack).
• Installed and configured Single-Sign-On (SSO) and Implemented SSL Security.
• 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 wif users group to ensure timely implementation of an ERP.
• 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, Windows XP,7, Oracle 11g (11.2.0.3),11g (11.1.0.7) Oracle Applications EBS 11i/R12, Oracle 10g, 11g RAC, TOAD, Developer 6i,10g .

Confidential, Adrian, MI

Oracle Applications DBA

Responsibilities:

• Successfully upgraded the Oracle E-Business Suite (EBS) Applications for 12.0.4 to 12.0.6
• Successfully upgraded Applications from 12.0.6 to 12.1 as proof of concept.
• Integrated 12.0.4 Applications wif 10g OID and SSO
• Implemented BPEL for created the adapters between OTM and EBS
• Implemented 2-node DMZ servers for external web servers as part of me-store
• Installed and configured 2 node 10g RAC Databases for EBS Database.
• Implemented Data Guard Broker for managing physical standby databases.
• Expertise in Cloning of Databases from RAC to Non-RAC and Non-RAC to RAC
• Expertise in using RMAN for backup and recovery strategies
• Implemented PCP across 4 Admin Nodes.
• Successfully maintaining and monitoring 2 node RAC Database wif 6 node Applications and 2 node for DMZ configuration
• Implemented Multi node architecture wif a Load Balancer set up.
• Implemented Load balancing between the DMZ servers for me-store.
• Successfully implemented PCP and set up of concurrent queues for faster processing of critical jobs.
• Monitor the long running jobs and troubleshooting them for much faster performance.
• Expertise in tuning of performance of JVM’s and their usage.
• Expertise in tuning of Long Running SQL Queries.
• Expertise in tuning ASCP Collections and planning process.
• Implemented 10g OEM grid control for monitoring the database and installed Applications Management Pack for monitoring applications
• Expertise in Scheduling and configuring the backups through OEM
• Installed and integrated Sabrix Taxing software.
• Expertise in shell scripting and pl/sql programming
• Implemented a HA Solution for 10G Discoverer.
• Supporting Production and Development Users in all their technical issues.

Environment: AIX 5.3, Red Hat Linux 4/5, Windows XP, Oracle 110g (10.2.0.3), Oracle Applications EBS 11i/R12, Oracle 10g, RAC, TOAD, Developer 6i,10g .

Confidential

Oracle Applications DBA

Responsibilities:

• Setup instance for Oracle Apps Upgrade from 11.5.9 to 11.5.10.2.
• Installed Oracle applications release 12.0.3 and upgraded 11.5.10.2 to release 12.0.3
• Periodic refresh and preparation of release environments and databases for Install Testing.
• Maintaining the Oracle Applications System including Oracle databases, Middle tier iAS, Applications tier for testing patches.
• Cloning using Rapid clone, Autoconfig and adclone utility.
• Strong experience in implementing and configuring Single Sign on (SSO) and Oracle Internet Directory (OID) wif Oracle Applications R12.
• Has done the capacity planning before implementing the architecture for R12.
• In depth noledge and experience wif RapidInstall, RapidClone, adpatch, adadmin, adsplice and adctrl utilities for Oracle Applications.
• Extensive experience in system architecture of 11i Applications implementation of various Financials and CRM modules like GL, AP, AR, FA, etc.
• Performed Oracle Application upgrades from Oracle apps11.5.9 to 11.5.10.
• Worked as main point of contact for the old 10.7 to release 11i close invoice transactions conversion. Tuned Auto invoice import program to import 1 million records in less than 6 hours.
• Expertise in Tuning Oracle Applications, Concurrent managers, Apache, Forms Servers, Reports servers.
• Apply Techstack and DB Patches specific to the Oracle Apps environment.
• Worked on Order Import Interface tuning to import the sales orders from legacy SAP system. Tuned the order import interface by implementing custom indexes and optimizer hints.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers and monitoring of the concurrent manager operations.
• Experience on version control tools KINTANA and PVCS.
• Thorough understanding of the Oracle Applications Release Process, architecture of Automated Release Updates ARU .
• Experience on implementing 10g AS wif Split Tier Architecture.
• Troubleshooting of Oracle applications’ patch failures for 11i.
• Creating Code Check-ins and testing them once the developers provide code builds and validate check-ins patches through Automated Release Updates.
• Creation of Application instances and database for the development and production environment.
• Optimized R12 Performance via OC4J Load-Balancing.
• Creation of users and assigning responsibilities. for offshore team
• Registration of Printers, Printer Types, Printer Styles
• Taking periodic backup of Applications & Databases
• Application of Patches as and when need arises
• Coordinating wif Oracle Corporation for raising the Tar’s and supported activities
• Conversion to Multi-Org using ADAADMIN utility

Environment: Oracle 9I,10g Grid Oracle applications, 115.10, Oracle E-business Suite R12, Solaris 10, Sunfire 4800, Linux 2.6.9-67.ELsmp, 1700GB database, 800 peak concurrent sessions, Kintana Version control Tool, NetApp filers backup, Aventx.

Confidential

 Oracle Apps DBA

Responsibilities:

• Responsible for, both manage and support all Production, Development and Test instances of Oracle Applications 11.5.2, 11.0.3.
• Configured and Installed Oracle Application 11i using Rapid Install.
• Upgrading the Base install 11.5.5 to 11.5.6 and maintaining Oracle Applications.
• Monitored the Applications and Database using OEM and OAM.
• Setting up of printers In the Apps.
• Maintenance of concurrent processing requests and concurrent managers.
• Tuned concurrent managers using Oracle Enterprise Manager (OEM).
• Using AD Utilities like ADADMIN, ADIAMGR, ADPATCH, and ADCTRL.
• Created Shell script for daily refreshing an instance from Oracle Apps 11i Production instance.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and passwords.
• Reorganization of the Database using export import.
• Developed Perl scripts wif SQL Server 2000 to provide automated auditing of enterprise environment.
• Installing RHEL and Solaris for Oracle 8i testing and development purpose.
• DB2 stored procedure (SP), user defined function (UDF), and user defined table function experience wif DB2 SQL/PL.
• Database and SQL statement access plan optimization experience wif DB2’s Explain, Visual Explain, and Design Advisor tools.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Design and development of major processing at the back-end through DB-Triggers, Stored Packages and Procedures using SQL and PL/SQL.
• Daily activities include monitoring batch application for performance and space requirements and tuning the system to optimize space and performance.
• Query optimization and tuning using tools like TOAD and SQL Loader.
• Provide technical assistance to developers in all matters concerning performance, application related issues.
• Debugged Oracle Reports and Oracle Forms programs.
• Created new Oracle Reports and Oracle Forms programs based on user specifications.
• Assists in design tasks such as debugging, specifications development and system integration testing.
• Provides technical assistance and user support functions.
• Participated in action planning and implementation.

Environment: Linux 2.4, Oracle database 9i, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader