oracle apps dba

Name: Sandeep Nagpal

e-mail: ******@*****.***, *******.**********@*****.***

Home : 770-***-****

Summary:

I have been working as Sr. Apps DBA for last 9 years and worked on different version of Oracle Application from 11.5.x to Release 12 , During this time I have been worked on installation , upgrade, patch application, TAR Support , Database tuning, Concurrent Manager Administration , cloning and Oracle Apps Sysadmin activities. I worked on ERP Upgrades from 11.5.x to 11.5.10.2 and Oracle Database Upgrade from 8i,9i to 10g.

Other responsibilities include Database Tuning, RMAN Backup & Recovery , SQL Statement Tuning, general troubleshooting, scripts development, documentations.

Recently worked on implementing of shared Appltop , setting up the Oracle 10g Grid environment & OATM Tablespace Migrations.

Good Knowledge of performing Installation and upgrade to Release 12.0.4, Having Strong theoretical knowledge of Oracle 10g RAC & ASM.

PROFESSIONAL EXPERIENCE:

ORGANIZATION : GENPACT Process Solutions LLC, US

POSITION : Principal Consultant

PERIOD : 21st August 2006 – 23th Jan 2009

Projects

Period : Oct-2007 – Jan-2009

Project e-Ops DBA Support

Environment Sun-Solaris Oracle Applications 11.5.10.2, Oracle 10g, 170 System 5.5

Client : GE-Infrastructure Atlanta GA, US

Position Sr. Apps DBA

Responsibilities:

1 Supporting Production ERP 11.5.10.2 & Oracle 10g environments

2 Meetings with Customer for New Project Releases

3 Installation & Upgrade to Release 12

4 Oracle Application Cloning using 10g Grid

5 Oracle 10g SSO Integration with Oracle eBusiness Applicationa

6 Implementing Shared Appltop

7 Oracle Application Upgrade to 11.5.10.2 and Release 12

8 Setting up Oracle 10g Grid environment to setup the centralized monitoring & maintaining the ERP Databases

9 Monitoring Server & Database performance using 10g Grid

10 Installation of 11.5.10.2 Vision Instance and Performed Upgrade to Release 12

11 Applying Patches and Administration activities using ad admin utilities e.g. adpatch, adlicmgr, adsplice, adctrl, adadmin

12 Working on Database & Application Performance Issues

13 Oracle DB Upgrade from 8i,9.2.0.X to 10.2.0.X

14 Applying Oracle RDBMS Patches using oPatch

15 Identifying and Applying CPU and Security Patches every quarter release

16 Application Tier Load Balancing

17 Implementing RMAN scripts to take Production Database backup on tapes & disk.

18 Monitoring Performance Alerts and fixing the performance issues.

19 Monitoring the status of Service calls for Prod environment

20 Upgrade the Markview database from 4.7 to 5.5.

21 Setting up the Middle tier (includes SQL Flow monitor, Barcode, Viewer) for 170 System

22 Installing the DTM on Document Server.

23 Markview Application Admin Setups includes volume setup, load balancing preference setup

24 Installation of 10g iAS on the Markview Middle Tier

25 Developed the filter scripts used for purging unwanted data which streamline the Upgrade Process and reduce the Storage Space drastically to benefit the customer.

Period : Sep-2006 – Sep-2007

Project Apps Upgrade from 11.5.8 to 11.5.10.2

Environment HP-UX (11.11), Linux 2.9 Oracle Applications 11.5.10.2, Oracle 9i,

Client : Diebold Canton OH

Responsibilities:

1 Upgraded Apps from 11.5.8 to 11.5.10.2

2 Reduced the Maintenance Pack (3480000) time from 26 hour to 11 Hours after analyzing and fixing long running scripts.

3 Completed the Contract Rules Migration before the upgrade in PROD to reduce the Production Upgrade time. Well appreciated by Diebold Client.

4 Prepared the Prod Cutover Plan to execute the upgrade project smoothly

5 Maintained the Patch List

6 Completed the documentation for Upgrade and transition to DIEBOLD DBA’s

7 JDK Upgrade from 1.3 to 1.5

8 Presented and Demo the Maintenance Wizard Tool for Application Upgrade (Toolkit for Oracle

9 Sysadmin Activities

10 Database Upgrade from 9.2.0.6 to 10g

11 Performance improvement recommendation using rebuilding tables and purging workflow tables.

12 Solving complex issue after cloning and patching while some business functionality broken.

13 Implement Workflow Purging process which is never done since implementation

14 Implemented Autoconfig and Rapid Clone to new upgraded instance.

15 Performance tuning by rebuilding indexes and fnd_stats.

16 Solving issues with concurrent manager, Apache, Form servers by Appling security and maintenance patches for database as well as application.

17 Installed Vision Instance 11.5.10.2 on Dual Node (HP-UX, Linux)

ORGANIZATION : GENPACT India

POSITION : Principal Consultant

PERIOD : April 2001 – Aug 2006

Projects

Period : Apr-2006 – Aug-2006

Project eTrade Implementation

Environment Sun Solaris 2.8, Oracle 9i, 170 Systems 4.7

Client : eTrade US

Responsibilities :

1 170 System Data Migration to Single OU

2 Oracle 9i Performance Tuning

3 Oracle RMAN Backup Implementation

4 SYSADMIN Activities—Concurrent Manager Management, Printer Setup, User Creation

Period : Mar-2003 – Mar-2006

Project Apex-170 System Implementation

Environment Sun Solaris 2.8, Oracle Applications 11.5.9, Oracle 9.2.0,

170 Systems 4.7 (Workflow & Electronic Invoice Image)

Client : GE Energy, Atlanta, USA

Responsibilities

1 170 System Administrator, setting up new OU for 170 System.

2 Oracle 9i Database Managements

3 Apps Sysadmin

4 System Administration includes creation of Menus, Responsibilities, Concurrent Program, Request Set, Request Group, defining printers etc.

5 Performing hot & Cold backup.

6 SQL Tuning

7 Implementation of 170 System (Third Party Tool Imaging System Integrated with Oracle AP)

8 Apache, Oracle 9i (9.2.0.6) & OC4J Installation

9 Database performance optimization and tuning using the statspack utility

10 Organizing and leading con-call with the Onsite Project Team.

11 Unix Administration

12 Implementation of Database Scripts through CRONTAB ( OC4J Process, Tablespace Usage & Growth, Datafiles Growth, SGA Space Utilization, Database Hit Ratio for SGA & Block Buffers, Temp Tablespace Alert, Top 10 Active Queries, Compilation of Invalid Objects, Status of Concurrent Jobs, Listener status, Locks), Database Backup & Concurrent Manager scripts

Period : May 2001 - Dec 2002

Environment Sun Solaris 2.8, Oracle Applications 11.5.4, Oracle 8.1.7

Client : GEC-ITS. Newport City, US

Responsibilities

1 Setting up a new Production instance using Oracle Applications 11.5.4 on a multi-tier Sun Solaris 2.8 environment. Modules installed included Manufacturing (OM, PO, Advance Pricing, iStore) , Finance (GL, AP, AR, FA, PO, Cash management), iExpenses, iProcurement, OE, and workflow

2 Sysadmin Activities : Creation of Customized Menus, Responsibilities, Request Group and User Setup

3 Registering the Customized Forms, Reports, Request Set, Request Group, Concurrent Programs, Values Setups

4 Application Cloning using Autoconfig

5 Monitoring Alerts about Invalid Objects, Database Locks, Expensive SQL, Concurrent Requests , Disk Space, CPU Usage, Long Pending Processes

6 Handling the Change Control procedure

7 Shift Coordination, which include assigning roles and responsibilities to the team members and interacting with Online Support team for handling tars.

8 Writing backup scripts for cold and hot backup

9 Running the CBO, gather schema statistics

10 Configuring clients using Net8, creating new users and table space maintenance

11 Registering the printers and creating the Post script drivers

12 Database Tuning which involves generating the reports using the StatsPack

ORGANIZATION : Path Infotech, New Delhi

POSITION : Member Support Group , Oracle DBA

PERIOD : April 2000 – Mar 2001

Path Infotech Ltd, New Delhi is India’s leading software consultancy and training firm having a clientele like Oracle Corp., Wipro Infotech, Maruti Udyog, Cannon India, etc. in the field of Oracle Support.

Sandeep was involved in attending the Oracle support calls on behalf of Oracle Corporation and Wipro Infotech also placed on client sides as a full time Oracle Support person. Calls were mainly elated to Installation of Oracle Database on various Platforms, Recovery of database, Reorganization, Performance Tuning.

Period : Jan 2001 - Mar 2001

Environment Sun Solaris 2.8, Oracle Applications 11.5.4, Oracle 8.1.7

Client : Amtrex Hitachi, Ahmedabad, India

Period : May 2000 – Nov 2000

Environment : HP Unix , Oracle 8.0.6, Apps 11.0.3

Client : GE Countrywide, Bombay, India

ORGANIZATION : Quantum India Pvt Ltd, New Delhi

POSITION : Oracle DBA

Period : Dec 1998 – Apr 2000

Environment : Window NT & Unix , Oracle 7.3.4, D2K

Client : GE Countrywide, Bombay, India

1 Maintaining and monitoring the database

2 Installation of Oracle 8i

3 Installation of Multi level Marketing Software developed for Brach offices

4 Unix Administration

5 User Trainings

6 Performing daily online database backup

7 Database performance optimization and tuning

8 Developed Customization reports for AP/GL Modules

9 Created Standby Server for redundancy

10 Worked on D2K Forms & Reports

EDUCATION AND TRAINING

• Bachelor of Science (Physics, Computer Science, Mathematics) 1992-1995

• Oracle 9i: Performance Tuning Training From Path InfoTech

• Master in Computer Application (2002-2005)

PERSONAL DETAILS

Date of Birth : 14-Nov-1974

Marital Status : Married

Gender : Male

Nationality : Indian

Languages Known : English, Hindi

Contact this candidate