Summary:

• Oracle Applications DBA with 7 years of experience in software industry and oracle applications administration in production, development and test environments. Good experience in Oracle E - Business patching, upgrading and Load balancing.
• 7 years of Oracle Application and Database Administration experience on variety of Database versions 7,8i, 9i,10g,11g on UNIX, Solaris, HP-UX, AIX, Linux, Windows NT 4.0/2000 with HRMS, HR, Payroll, Financials AP,AR,GL,FA, Order Management, Compensation, modules using Apps 11.5.8, 11.5.9, 11.5.10, Oracle Application Server 9iAS, Developer 2000 6i Forms 6i and Reports 6i, Net8, Sql Plus, PL/SQL, Stored Procedures, DB Triggers etc .
• 7 years' experience in Oracle Database Administration, Oracle Applications, Analysis, Design, Server Optimization Techniques, Production environment and Applications support
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications.
• Experienced and proficient with Oracle E-Business suite application R 12 12.1.3/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.3.
• 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.
• Designed and implemented user security application that assigned Oracle Label Security OLS policy permissions to individual Oracle accounts to provide row level data security.
• Experience in general troubleshooting, fire fighting, and development of scripts, documentation, issue resolution, and TAR support.
• Well versed in implementing System Management and Monitoring procedures.
• Strengths include skills in SQL and PL/SQL.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings.
• Experience in Security Management and Database Auditing.
• 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.
• Experience in Installing, configuring and maintain Oracle RAC, data warehousing and Data guard.
• Database Upgrading from one server to another using Export and Import utility.
• Used INFORMATICA Power Center tool as ETL tool for constantly moving the data from sources into staging area
• Development of the Informatica Mappings, lookups, reusable components, Sessions, Work Flows etc. on ETL side as per the design documents/communication
• Expertise in installing Discoverer and integrating to ERP Applications.
• Expertise in RMAN for recovery and cloning.
• Expert in Configuring Workflow Mail.

TECHNICAL SKILLS

ERP

Oracle E-Business Suite

R12: 12.1.3/12.0.6

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

RDBMS

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

Operating Systems

Sun Solaris 2.6/2.5.1 SUN OS 5.5.1, AIX, HP-UX, Windows 95/98/NT, Windows NT 4.0 Server

Languages

SQL/ PL/SQL, UNIX Shell Programming Bornshell, Csh, Ksh Crontab

Software Tools/ GUI

Oracle Developer2000, Oracle Enterprise Manager OEM, SQL Navigator, SQL Plus and TOAD.

Application Servers

Oracle 10g/9ias R2.

PROFESSIONAL EXPERIENCE

Confidential

Sr.Oracle Apps DBA

Responsibilities:

• 24x7 Production Oracle Applications Administration.
• Maintaining production, development test databases and applications.
• Good knowledge on Oracle applications 11i Rapid Installation.
• Upgraded Oracle Applications 11i 11.5.10 Database Version 8.1.7.4 to 10g 10.2.0.4 on Solaris.
• Involved in creating, editing, scheduling and deleting of sessions and batch of session using Workflow manager in Informatica.
• Designed and implemented OLS label cache to enable use of Hibernate with OLS and to improve performance by eliminating repeated use of Oracle conversion functions.
• Resolved session locking issues using Informatica repository manager
• Upgraded Oracle Applications 11.5.10 to 11.5.10.2, 11.5.10.2 to 12.0.4 and 12.0.4 to 12.1.3 and database 9.2.0.8 to 10g
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle Database which is on RAC.
• Successfully upgraded Oracle Applications 11.5.10.2 to R12 12.0.4 in multinode configuration
• Applied patches using ADPATCH, ADCTRL utilities.
• Performed installation and configuration of oracle SOA suite 10g/11g for the integration of Application and Database.
• Created test environment through cloning production environment for developers to test on live data
• Adapted persistence framework to make WebLogic Server container managed transactions operable with Oracle Label security using JMX MBeans to dynamically mange connection pools
• Administration of Oracle ERP applications version 11.5.10.2
• Good knowledge in Data Modeling tools like Ervin.
• Implemented AUTOCONFIG in the apps environment and used ADCONFIG, ADBLDXML commands
• Implementation, customization and personalization of Oracle iProcurement.
• Experience on various modules such as Financials, ASCP, MFG, CRM, AR, AP, GL, and PO.
• Involved in developing a disaster recovery DR plan.
• Implemented and support of both physical, logical standby databases and Oracle Data Guard.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Applying Oracle Applications patches Maintenance Pack, Interoperability patch, and Family pack .

Environment: Red Hat Linux 4/5, SUN Solaris 9, HP-UX 11i v1 B.11.11, Windows XP, Oracle 8i 8.1.7, 9i 9.2.0 10g 10.2.0, Oracle Applications EBS 11i/R12, Oracle 9i 10g RAC, TOAD, Developer 6i.

Confidential

Sr.Oracle Apps DBA/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.
• Migrated the production database from Old servers to new servers.
• Successfully implemented 3-node RAC setup and made the environment stable.
• Have good knowledge on 10gAS OID, SSO and complete infrastructure and middle tier components of 10g.
• Configured load balancing on Apache and Forms Servers.
• Designed ETL process using Informatica tool to load form sources to targets through data Transformations.
• Applied the patch sets, one off patches, Opatch to the Development and production servers.
• Monitored databases using 10g OEM grid control.
• Implemented the Oracle E-business suite Application Management Pack on OEM.
• Implemented Shared APPL TOP.
• Responsible for troubleshooting the issues raised by oracle ERP from both user community and development.
• Worked on the performance issues both at the database level and applications level.
• Worked with Oracle Support on resolution of SRs
• Created and monitored the concurrent managers
• Provided valuable suggestions for allocating system storage and planning future storage requirements.
• Responsible for Cloning of Database and Applications as per functional requirements.
• Implemented Oracle Applications upgrades, patches using various AD utilities.
• Prepared analysis for resolving system errors, disk space problems, and huge file sizes errors.
• Monitored Oracle Applications users using Oracle E-Business Suite.
• Worked with End Users and Functional Analysts on issue resolution concurrent manager problems, one off patches etc.
• Developing UNIX and SQL scripts for the smooth functioning of database and application related issues.
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS, and FND STATS packages and ANALYZE command.
• Responsible for setting up the printers in Application environment.
• Troubleshooting throughout the project phases and TAR Management.
• Upgraded JDK 1.1 to 1.3.1 as a part of the Oracle Applications Upgrade from11.5.10.2 to R12
• 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.

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

Oracle Apps DBA/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
• Installed, upgraded and maintained Oracle ERP applications version 11.5.9
• Implemented Parallel Concurrent Processing
• 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.
• 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.

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

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, and table spaces, data objects, setting privileges, indexes, user logins and passwords.
• Reorganization of the Database using export import.
• Database upgrade from Oracle Release 7.3.4 to Oracle Release 8.1.7.4.
• 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 Package 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: Linux 2.4, Oracle database 7i 8i, Oracle applications 11i, AD Utilities, OEM, PLSQL, SQL Loader

Confidential

Jr. Oracle Apps/DBA

Responsibilities:

• Installation of Oracle Application 11.5.2.
• Cloning of Application Instance -- Single node to two node Using AD Clone. Applied the patches using ADPATCH.
• Performed Application admin tasks using ADADMIN utility. Applied India Localization patches resolving with Oracle.
• Registered Forms, created Form Functions and Menus. Registered Executables, created Concurrent Programs and Request Groups.
• Created Responsibilities and Application Users System Administration of 11i Setting up of printers in applications.
• Maintenance of concurrent processing requests and concurrent managers. Created and resized the new Data files. Pinning of Packages, Procedures and functions in SGA Run preparatory scripts -- admin server.
• Reset ORACLE schema passwords update configuration-related profiles apply product customizations to environment and files.
• Set rollback segments for normal use validate and compile APPS schema Creation of Schema objects and Space Management. To take backups as per the corporate policy and perform recovery as and when required.
• Developed Data Loading Scripts designed the database structures for the custom module Performed the maintenance of Database and Production support.
• Management. To take backups as per the corporate policy and perform recovery as and when required.
• Developed Data Loading Scripts designed the database structures for the custom module Performed the maintenance of Database and Production support.

Environment: Oracle applications E-Business suite 11.5.2, 11.0.3, Oracle 8i, SunSolaris 2.2, EMC TimeFinder, SRDF, PL/SQL, Forms 4.5, Reports 4.5