Peter Moses

abjnw5@r.postjobfree.com Oracle Apps DBA

561-***-****

Delray Beach, FL

Summary:

. Apps DBA administrator with 6 years of extensive experience in

implementation, upgrade, application & database support, scripting,

cloning, patching, apps integrations, maintaining security, automation

and mentoring.

. Expertise in Oracle apps 10.7 to 11.5.10.2, 11.5.9 to 11.5.10.2 and DB

7.3.4 to 9i, 9i to 10G, 10g point upgrades.

. Actively involved in all phases of Implementation & Upgrade from the

Designing (Including the Methodology of documenting the system and

Identifying the bottlenecks and trouble shooting at various elements

of the system), standardizing procedure, automation, instance

preparation, cut over activities Etc.

. Involved in automating DBA activities including patch comparison

across multiple instances, user responsibility addition, Instance

refresh and created tools like SQLT & tkprof generation, patch

reports, concurrent program diagnostics with shell scripting/plsql

used by DBA and Developer teams.

. Worked on process improvements like DB security, custom migrations

etc., increasing quality and reducing manual efforts.

. Provided support for mission critical databases with multimode

applications and RAC configurations.

. Performed application and database clones and recognized by customer

for quality and timely delivery.

. Led DBA projects, release implementations and production support.

. Worked with functional and developer team in troubleshooting issues

and planning releases.

. Organized, efficient, self-motivated, hard working, cooperative, team

oriented and have strong interpersonal skills demonstrated in all the

assignments.

[pic]

Education

Degree/Qualification Institution Name

Bachelor of Engineering Bharathiar University, India

Received "The Best Outgoing Student" award for my achievements during my

four year engineering course.

Employment History

Oracle Apps DBA, Wipro Technologies from Aug 2004 till date.

Engagements and Accomplishments

Client Office Depot, Florida, US.

Project Name Oracle Apps Implementation & Production Support

Role APPS DBA

Period Jan 2007 - Till Date

Environment Oracle Applications R11.5.10.2, DB 10.1.0.2, 10.2.0.4,

Suse Linux

This project is one of the major oracle application(11.5.10) implementation

for Office Depot which includes all major financial, CRM and Order

Management modules (AP, AR, GL, FA, PO, OM, CRM) with a team of 80 +

onsite and 50 + offshore resource.

Responsibilities:

. Administration of Oracle application 11i & DB RAC 10g development,

staging and production environments.

. Building, cloning and maintaining single, multinode and external node

instances.

. Creating processes for DBA support to improve productivity and

tracking.

. Analyzing and applying patches to DB, ASM, CRS and application.

. Performed 10.2.0.4 upgrade on ASM, CRS, DB and OEM.

. Automating DBA activities reducing repetitive manual efforts.

Responsible for automating many processes in the project.

. Patch management across 30 + instances using shell script tool,

Implemented a component which extracts user responsibility details

from xl sheet and attach it to users in Ebiz, Script to compare all

custom files in file system between two instances are few of the

notable scripts written in current project.

. Wrote script for automating production refresh which reduced refresh

time and manual efforts.

. Was awarded with "Value Addition award" for my outstanding

contributions in the current project.

. Setting up SSO login for instances, parallel concurrent processing,

external node configurations.

. Implemented and maintaining concurrent manager load balancing using

request types and custom managers.

. Performing table rebuild and partitions on major Finance tables and

automated table rebuild with threshold, control flag and history

features.

. Optimized the process of gathering schema stats with parallel threads

concept.

. Applying and migrating customizations to instances using Kintana/ITG.

. Integrating third party systems (Taxware,Geocode,Courion) to Ebiz and

administering taxware and Geocode applications.

. Involved in go live and support planning.

. OEM monitoring and creating custom monitoring.

. Currently providing production support for 14 TB Instance and other

development instances.

. Planning and supporting dot releases. Led the support for several UAT

testing cycles.

. Worked with Apex admin and added many features helpful to DBA's like

configuration extracts, DB Security, Shift transfers etc.,

Client Getty Images, Washington State, US.

Project Name HRMS Implementation & Rollout

Role APPS DBA

Period OCT2006- DEC 2006

Environment Oracle Applications R11.5.10.2, DB 10.1.0.2, Unix Sun

Solaris

The project involved implementation of HRMS modules (Oracle Self Service HR

& Oracle Daily Business Intelligence for HR) for Getty Images. This project

included assessment of existing system, creating and configuring instances

to implement HRMS modules.

Responsibilities:

. Assessment of existing instances and Involved in Instance creation &

configuration.

. Analyzing and applying standard Patches to implement SSHR & DBI.

. Applied HRMS family pack patches.

. Support during user acceptance testing.

. Refreshing instances.

. Monitoring and tightening security. Performed forms personalization to

give controlled access on certain secured forms to users.

. Applying customizations to production environment which is part of

implementation.

. Working with functional team fixing user issues.

. Performed user set up for approval management.

. Wrote multimode startup & shutdown script.

. Maintained database security.

Client Subaru, New Jersey, US.

Project Name Oracle Applications Upgrade

Role APPS DBA

Period JUL 2006 - SEP 2006

Environment Oracle Applications R11.5.9, Unix Sun Solaris

This project involved analyzing and upgrading of Subaru's Oracle

Applications from 11.5.9 to 11.5.10.2. Including analyzing of the existing

architecture and technology stack and proposing the method for upgrade.

Responsibilities:

. Assessment of the existing Oracle Applications infrastructure and

documenting the upgrade procedure to be followed.

. Involved in application upgrade from 11.5.9 to 11.5.10.2 and fixing

issues during upgrade.

. Database upgrade from 9.2.0.6 to 10.2.0.2 .

. Involved in analyzing and applying standard Patches.

. Applied Maintenance packs, Family packs and one-of patches.

. Worked with oracle support for critical issues.

Client Sony Electronics, California, US.

Project Name Oracle 11i Applications Production Support

Role APPS DBA

Period MAY 2006 -JUN 2006

Environment Oracle Applications R11.5.10.2 Database 10.1.0.5 and UNIX

Shell Scripts, Unix (HPUX B.11.11)

This project deals with the support of newly upgraded production instance.

This also includes configuration of daily instance refreshes. Monitoring

production instance for performance bottlenecks and support for daily

refreshed instances.

Responsibilities:

. Involved in supporting production instance which was upgraded from

R10.7 to 11.5.10.2 with database upgrade from 7.3.4 to 10.1.0.5.

. Proactive monitoring for any bottlenecks in performance.

. Fixing production issues.

. Automating database & application monitoring by writing scripts.

. Refreshing test instances from production.

. Database problem diagnosis, research, fix, testing and resolution

apply and patches on 11i environments.

. Applying customized patches.

Client Sony Electronics, California, US.

Project Name Oracle applications upgrade from 10.7 to 11i

Role APPS DBA

Period MAY 2005 - APR 2006

Environment Oracle Applications R11.5.10.2 Database 10.1.0.5 and UNIX

Shell Scripts, Unix (HPUX B.11.11)

The project is the initiative taken by the Sony Electronics to upgrade its

oracle applications form an older version of 10.7 to the latest version

11.5.10.2.This project contained lot of technical challenge on DBA

perspective. More than 10 official upgrades and many internal upgrades was

performed to optimize the process.

Responsibilities:

. Involved in creating and configuring instances for the upgrade cycle.

. Upgrading applications from 10.7 to 11.5.10.2, troubleshooting issues

during upgrade and optimizing the process on each upgrade to reduce

the overall downtime.

. Performed 10+ official test upgrades from 10.7 to 11.5.10.2 and

successfully upgraded production.

. Used adaimgr for performing the auto upgrade from 10.7/11.0.3 to 11i.

. Applied Maintenance packs, Family packs and one-of patches.

. Involved in planning cut over activities and implementing the same.

. Upgrading database 7.3.4 to 9i, 9i to 10g, 10.1.0.4 to 10.1.0.5.

. Maintaining centralized document and issue log repository.

. Performing backup and recovery using RMAN

. Extensive use of utilities like RapidInstall, RapidClone, autoconfig,

adpatch, adctrl, adrelink, adadmin, aderelink.sh, LicenseMgr, adident,

adautoconfig for maintenance of Oracle application.

. Creating truncated instances.

. Configuring applications over multimode with load balancer

configuration.

. Workflow and discoverer administration.

. Cloning instances using custom procedures, manual method, rapid clone

and performing single node to multi node cloning.

. Developed scripts to automate functions and processes. Jvm error

alerting, SQLT & Tkprof tool and program for extracting customizations

for developers are few of the notable scripts.

Client Sony Electronics, California, US.

Project Name Oracle applications 10.7 instance Production Support

Role APPS DBA

Period DEC2004 - APR 2005

Environment Oracle Applications R10.7 Database 7.3.4 and UNIX Shell

Scripts, Unix (HPUX B.11.11)

This project dealt with the production database support for SONY

electronics. It helped in acquiring knowledge about the existing

architecture, technology stack, process and procedure in Sony

environment which reduced the assessment time during upgrade project.

Responsibilities:

. Handling and maintaining the routine activities in SONY Electronics

10.7 Instance production support.

. Performing and monitoring daily instance refreshes form production.

. Fixing production issues.

. Monitoring daily/weekly backup and working with system administrator

for issues in backup.

. Applying customized patches.

. Proactive monitoring of the database to identify bottlenecks.

Client Wipro Technologies

Project Name Implementation and Testing of XBRL, XML publisher &

Interface engine

Role Project Engineer

Period AUG 2004 - DEC 2004

Environment Oracle 9i,PL/SQL,Oracle Apps R11.5.10,XBRL,Unix

This project involved in-house implementing eXtensible Business Reporting

Language (XBRL), XML Publisher and Generic Interface engine in oracle

application 11.5.10.

Responsibilities:

. Implemented the XBRL & XML publisher feature and presented white papers

on the same. Papers were published in Wipro K-Times.

. Created Generic interface plug ins with dynamic parameters.

. Fixed issues encountered during implementation.

. Worked with oracle support for fixing bugs in functionality.

. Applied patches and configured mailer.

. Received "THE BEST CAMPUS RECRUIT AWARD" for all the contributions to the

in-house projects.

Areas of Expertise:

1. Oracle Apps & Database upgrades

2. DBA process automation/Tool development

3. Oracle Database Administration 9i/10g

4. Oracle Applications 11i Administration

5. Real Application Clusters Install & Administration

6. Backup and Recovery

7. EBiz security administration

8. Cloning, patching & troubleshooting issues

9. Oracle Apps Implementation

10. Unix shell scripting & PLSQL coding

11. Application Installations

12. Apps Integrations with 3rd party

13. Proficient in tools like OEM, ad utilities.

14. Production support

s are still running with same parameters

Contact this candidate