SUMMARY:

• 6 plus years of IT Experience as Oracle DBA and Oracle applications DBA on different platform of UNIX.
• Expert in Oracle Applications DBA and Applications System Administrator.
• Extensively worked wif Oracle Applications from R12.1.1.1,12.1.3 and 11. .5.10.2.
• Expert in upgrading Oracle Applications to R12 from 11i.
• Expert in upgrading Oracle Applications Technology stack (Developer patch sets, JDK, Jinitiator etc).
• Expert in Cloning using Adclone, Rapid clone and Adconfig.
• Expert in Cloning from RAC to Non RAC and Non RAC to RAC databases.
• Creating users in the application level and assign the requested responsibilities to dat users.
• Expertise in Implementing Shared APPL TOP and PCP.
• Expertise in Setting up of the load balancing wif CISCO Switch.
• Successfully Implemented DMZ for i - store customers.
• Implemented DR Solutions for the enterprise level architecture and performing periodical testing.
• Using ADadmin, ADpatch, ADconfig, ADrelink etc utilities to maintain Application stack and database.
• Expert in Configuring Workflow Mailer.
• Expertise in applying security patches.
• Installed various taxing software’s like SABRIX and VERTEX.
• Installation and configuration of Application Desktop Integrator (ADI).
• Configure the Form server Load Balancing.
• Installed 10g Applications Management Pack on the 11g Grid Control for monitoring Applications through OEM.
• Expert in monitoring databases and applications using Oracle Enterprise Manager/Oracle Applications manager (OAM).
• Installing and configuring Oracle application stack on both multi and single node using Rapid clone.
• Expertise in using different database utilities like ORADEBUG, TKPROF, SQLT for performance tuning.
• Experienced in writing UNIX shell scripts and setting up cron jobs for database needs.
• Diagnostic Ability - Ability to go to the core of the problem.
• Willing to learn and adapt to new challenges & capabilities to take initiatives.
• Have the ability to interact wif end-users, managers, and technical personnel.
• Strong Technical background wif excellent problem solving skills.
• Have created multiple instances for the demo, development and test environment to facilitate the developers.
• Testing activities.
• Created Custom schema for the custom module in Oracle Application.

TECHNICAL SKILLS:

Oracle E Business Suite R12: 12.1.1,12.1.3,/12.0.6 11i Ver 11.5.9, 11.5.10.1, 11.5.10.2.

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

Operating Systems: Sun Solaris AIX, HP-UX 11.31,11.11, RHEK and OracleLinux

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

Software Tools/ GUI: Oracle Developer6i/10g, Oracle Enterprise Manager (OEM) grid control, SQL Developer, SQL*Plus and TOAD,AWR,ADDM

Application Servers: Oracle 10g/9ias R2.

PROFESSIONAL EXPERIENCE

Confidential, King of Prussia, PA

Responsibilities:

• Good knowledge on Oracle applications 11i and R12 Rapid Installation.
• Upgraded Oracle Applications 11i (11.5.10.2) Database Version 10g (10.2.0.4) to 11.2.0.3.
• Upgraded Oracle Applications 11.5.10.2 to 12.1.1 and Database to 11g.
• Installation and configuration of 10gAS and performance tuning of Oracle Database which is on RAC.
• Installation and configuration of 11g and 10g RAC Cluster, ASM and Databases
• Applied patches using ADPATCH, ADCTRL utilities.
• Created test environment through cloning production environment for developers to test on live data.
• JRE Patches Upgrade to JRE 1 6-35 to 4.
• Implemented SSO/OID - AD to OID and EBS to OID.
• ATG Patching.
• Maintenance of Concurrent managers and Parallel concurrent Process (PCP).
• Administration of Oracle ERP applications version 11.5.10.2 and 12.1.3.
• Good Knowledge in Data Modeling tools like Erwin.
• Strong Experience in various object migration tools like STAT.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.
• Converted the existing table spaces structure to OATM.
• Creating Custom Concurrent Managers and Assigning Work shifts to it.
• 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.
• Integration: Integrate SOA wif Oracle EBusiness Suite and various technologies, such as: OTM, WMS, Ecommerce, SQL Server, DB2 and Oracle database.
• Experience on BPEL Service Monitoring and respective actions.
• Installing and configured SOA Suite, WebLogic Portal Servers.
• Involved in maintenance of production SOA instance.
• Managed production support and troubleshooting for various SOA applications.
• Perform SQL tuning and assist developers wif 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, Grid control 11g.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack).
• Installed and configured Single-Sign On and Implemented SSL Security.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning 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 tan 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.
• Provided application support to users and created a log of all the problems wif solutions for future .
• Oracle 11g Database Implementation/Upgrade/Support.
• Oracle 10g Application Server Implementation/Upgrade/Support.
• Oracle Data Guard Implementation for HA and remote 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),Oracle 9i (9.2.0) & 10g (10.2.0),and 11g (11.2.0) Oracle Applications EBS 11i/R12, Oracle 9i & 10g RAC, TOAD, Developer 6i.

Confidential, Illinois

Applications DBA

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 11.2.0.1 & Oracle Applications 12.1.1 and supporting the production team.
• Cloning using Rapid clone, Autoconfig and adclone utility.
• Involved in database migrations cloning Oracle Applications (11.5.5, 11.5.2) production system, for testing and development purpose using rapid clone.
• Installed Jconsole and worked on tuning the performance of JVM’s usage.
• In depth knowledge and experience wif oracle application utilities such as Rapid Installer, Rapid Clone, adpatch, adadmin, adsplice andadctrl.
• Pre-patch or Impact analysis for the patches and document preparation wif pre and post patch installation steps.
• Involved in maintenance of production SOA instance.
• Configuring Clusters on WebLogic using the WebLogic Console.
• 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.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers and monitoring of the concurrent managers.
• Worked wif the STAT tool for migration of various objects to Dev, Test, QA, Prod Environments.
• Using AD Administration and other AD Utilities. Experience wif Oracle Applications Desktop Integrator (ADI).
• Tuning the databases for optimal performance.
• Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Experience in Load Runner Scripting wif Oracle EBS.
• 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 tan 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 wif users group to ensure timely implementation of an ERP.
• Provided application support to users and created a log of all the problems wif solutions for future .
• Good Knowledge of Oracle SQL & PL/SQL.
• Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.
• Good experience and knowledge on Discoverer.
• Performed Patch Management.

Environment: LINUX, HP-UNIX, Oracle10g, SQL Developer, OEM (Monitoring tools)

Confidential, Alabama

Applications DBA

Responsibilities:

• The project is basically upgrading of existing 11.5.10.2 to 12.1.1 and Maintenance
• Performed two rounds of testing wif TEST and DEV.
• Installed Developer 6i Patch set 19 for Upgrading forms and reports.
• Upgraded their HTTP server to 10.1.3.4
• Upgraded the JRE version to latest JRE.
• Upgraded their database from 9.2.0.8 to 11.2.0.3.
• Upgraded the Java Development Kit (JDK) from 1.5x to 1.6x.
• Configured the forms and load balancing server.
• Configured the Web server.
• Worked wif the functional consultants to complete upgrade tasks.
• Applied series of patches given by Oracle Support to resolve user specific issues.
• Performed post production support after upgrade until their system was stabilized.
• Handled similar kind of projects for other clients (Alliance coal, Loud Technologies and our internal SR module).
• Performance tuning of database.
• Worked wif oracle TAR’s in post production support issues.
• Worked closely wif the business users to monitor the performance of the system.
• Installed discoverer software on various client spaces.
• Configured TNSNAMES, SQLNET and resolved the connectivity issues wif developers.
• Involved in code migrations.
• Worked wif oracle TAR’s in post production support issues.
• Worked closely wif the business users to monitor the performance of the system.
• Installed discoverer software on various client spaces.
• Involved in code migrations.

Confidential, Louisville, KY

Oracle Applications DBA

Responsibilities:

• Install and maintain Oracle Applications in complex environments such as Single-node and multi-node installations on SOLARIS and LINUX AS
• Upgrade of Applications from 11.5.10.2 to r12.0.4 on test servers on SOLARIS
• Applying latest releases of the patches using utilities ADPATCH and ADCTRL.
• Cloning instances from production to Test, Development instance to test wif Rapid Clone and Autoconfig.
• Develop and maintain UNIX shell scripts to manage the Oracle Database and ERP Application environments. The major product modules include FND, AR, AP, PO, FA, GL and HR and also Oracle PSB (Public Sector Budgeting).
• Involved in Database Backup strategies & recovery scenarios and implemented Backups using RMAN.
• Involved in time-to-time troubleshooting Oracle Databases.
• Monitoring user sessions, maintaining, administrating and troubleshooting database issues for OLTP - Oracle databases on Solaris and Red hat Linux.
• SUN SOLARIS and Red hat Linux Server activities like USER Management, Oracle APPS File System Management, Mounting the hardware devices etc.
• Applying latest releases of the RDBMS patches from Oracle to the Production and test instance to resolve few technical challenges & issues.
• Configured Data Guard Broker between the primary and standby databases.
• Transferring the bulk data from text file into Oracle Database using SQL * Loader and export & Import utility for backup purpose and distributing the tables in multiple environments.
• Monitoring and troubleshooting concurrent manager jobs, manage system profile setups, Troubleshooting printer set-ups and other SYSADMIN responsibilities.
• Installation, configuration, creation of end user layer (EUL), maintenance and troubleshooting of Oracle Discoverer 4i.
• Generated Position Management Reports which involves HR, PSB and GL Modules.
• Configured Business intelligence Oracle Applications 11i, and administering End User Layer.
• Generated Custom workbooks for Public Sector Budgeting using Oracle discoverer.
• Configured Discoverer Custom workbooks on Oracle Self Service Portal.

Environment: Sun Solaris, Linux AS Oracle10g, Oracle Discoverer 10g. Oracle 11.5.10.2

Confidential (IRIS INFO SOL)

Jr. Applications DBA

Responsibilities:

• Responsible for, both manage and support all Production, Development and Test instances of Oracle Applications 11.5.10.2.
• Configured and Installed Oracle Application 11i using Rapid Install.
• Upgrading the Base install 11.5.9 to 11.5.10.2 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, 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.
• Database upgrade from Oracle RDBMS 9.2.0.8 to Oracle RDBMS 11.1.0.7
• Installing RHEL and Solaris for Oracle 8i testing and development purpose.
• 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 and 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.

Environment: RHEL,HP UX 11.21, Oracle database 9i,10g,and 11gR1, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader

Confidential

Role: Oracle Database Administrator

Responsibilities:

• Upgrading the current configuration to the latest release of Oracle Database.
• Setting up and configuring client to server communication using Net software
• Responsible for the upgrade and to handle all the technical issues.
• Lead the DBA team in all the phases of this upgrade process.
• Instance strategy for the upgrade runs in all testing phases.
• Strategy for applying of patches found in the Testing process.
• Experience in Network File Structure (NFS).
• Database Cloning to multiple environments.
• Backups were implemented by syncing and splitting the volumes.
• Support and performance tuning post go-live.
• Coordination of the activities wif Customizations and System Administration team.
• Worked wif Oracle Support to resolve issues.
• Provide Support for all the client-side issues.
• Proactively researched application of Oracle 9i Real Application Clusters (RAC) on Data Guard logical standby configuration for Linux.
• Assist in the planning and creation of numerous schemas to establish a solid development environment, including development, build, and prototype configurations.
• Worked closely wif Data Architect to assist in the implementation and configuration of project prototypes in the pre-installed Oracle 9.2.0.4 RAC environment, while personally authoring numerous PL/SQL stored procedures to integrate .NET framework and security solutions wif database layer.
• Developed scripts for database back up and recovery including hot and cold backup options for both RAC and stand alone instances.
• Performed Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning using Oracle’s regular performance tuning tools like Explain Plan, SQL*Trace, TKPROF, DBMS STATS, Data Dictionary Views etc,.
• Configure Oracle OEM (Oracle Enterprise Manager) to monitor database and report on events as defined by the DBA group.
• Performed daily DBA activities, including database backup and recovery initiatives, testing, and occasional performance monitoring/tuning of the 3-tier environment.
• Experience using Data Guard to maintain the standby databases as transactional consistent copies of the production database. These standby databases were located at remote disaster recovery sites from the production data center. The main concern was dat if the production database becomes unavailable coz of a planned or an unplanned outage, Data Guard can switch any standby database to the production role, thus minimizing the downtime associated wif the outage, and preventing any data loss.
• Created and maintained an internal web site for support team, enabling instant access to DBA, Operations and sever infrastructure engineering teams for enterprise level database support.
• Work wif developers and change management team to ensure smooth software development life cycle progress through testing and production implementation.
• Developed business cases, project charter plan, resource plans and allocation, time management for various projects and products the field of health care, e-clinic, finance, insurance etc using Microsoft Project 2000 and Unified Modeling Language.

Environment: Oracle 10G Release 2 on Sun Solaris (UNIX)