Manager Oracle

Title:Central Office Manager

***************@*****.***

Document

Source below

NAME: Ashutosh Prasad

ADDRESS: **** ******** **

CITY: Santa Clara

STATE/PROVINCE: CA

ZIP/POSTAL CODE: 95054

COUNTRY: USA

EMAIL: ***************@*****.***

PHONE:

CANDIDATE ID: 125142

CITIZENSHIP: US

Citizen

EDUCATION: Master Degree

EXPERIENCE: 5

WILL RELOCATE: Open

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED:

HOMEPAGE:

HOTSKILLS: Oracle Application DBA(5)

ESUME

Ashutosh Prasad

Email:**************@*******.***

Mobile: 408-***-****

More than four and half years of experience in Oracle Applications DBA and Oracle DBA on

SUN SPARC SERVERS, RS/6000, HP 9000 AND COMPAQ SERVER. Worked as Applications-DBA for more

than 31/2 years in Oracle Applications Release 11i(11.5.3)/11.0.30/11.0.28/10.7SC

Prod.16.1 and 1 years as Oracle DBA in Oracle Database 8.1.6/8.0.6/8.0.5/8.0.4/7.3.3/

7.1.1. Have a very good experience in writing shell scripts for extensive system admin

work. Have very good experience in installation, configuration, monitoring of Oracle

Database and Oracle Applications on AIX (RS/6000), HP-UX (HP-9000) and Solaris (SUN SPARC

3500,4000, 4500, 6500 and 10000 series).

Operating Systems

Solaris 2.8/2.6/2.5.1(SUN OS 5.6/5.5.1), UNIX SVR4, HP-UX11, AIX4, MS-DOS v7.0, Linux,

Windows 95/98/NT, Windows-NT 4.0 Server

Oracle Applications

Oracle Applications 11.5.x/11.0.x/10.7/10SC/10.6 and NCA (Financial, Human Resource and

Manufacturing)

Oracle Enterprise Manager for Window NT/95/98, Oracle Server

8i/8.1.6/8.0.6/8.0.5/8.0.4/8.0.3/7.3.4/7.1.4

for Sun Sparc Solaris, 8.0.5/8.0.4/7.1.6 for

AIX (RS6000), Oracle Developer2000, VRML Cartridge 1.1.1. Oracle Web Application Server

3.0.1.0.1, Java Developer's Kit 1.1.5.12.0, SQL*Net version 2.3.2.1.0, Net8 8.0.4.0.0,

Oracle8 Context Cartridge 2.3.6.0.0, Oracle Reports Web Server Release 2.5.7.5.0. Oracle

Reports Web Server Release

2.5.7.5.0, Application Servers WebDB 2.5 (8.1.6-based) and

Apache (1.3.9

) with JServ (1.1), JRE (Java Runtime Environment) 1.1.8, JDK 1.2.2, Oracle

Forms Server6i, Oracle Reports Server6i, Oracle Graphics6i, and WebDB 2.2, 9iAS

1.0.2.1.0,1.0.2.2.0, Oracle Discoverer 3i/4i.

Utilities

Unix Shell Programming Bourne, ksh, csh, sed, awk, perl.

Hardware and Operating system

SUN UltraSparc Server 2.8/2.6/2.5.1, RS/6000, HP-9000 server, PCs (Intel-486,586,P-II,P-

III)

SUNOS-5.5.1, AIX/6000 ver 4.0/3.2.5, HP-UX 10.01, Linux 2.0.34, Unixware-1.1.1 (Unix V),

Windows-NT4.0/95/98/2000

Oracle Applications DBA

American West Airlines, Tempe, AZ April 01-Present

America West is a growing airline Industry for south-west region in the country; I am

working as lead dba for support, all Oracle Application activities and part of functional

activities too.

Done Installation and Cloning of multiple instances of Oracle Applications 11.5.3 on

Sun Server for more than 1000 users to work concurrently.

Done Implementation of Oracle I-Procurement, Self-Service Purchasing, I-Purchasing

Fixed issues for I-Purchasing and I-Procurement Reports

Configured multiple Java Virtual Machine for I-Procurement

Configured, Enhanced the Catalog Bulk Loader and Very much familiar with its functions

Done Setup for Notification Mailer for I-Procurement

Refreshing Schemas in development databases from production databases on demand.

Applying patches and fixing issues on different Tier

Configured multi-tier Application Setup to enhance the performance

Registered and Configured Custom schema for Application module

Fixed the performance issue for Catalog Loading

Tuned Concurrent Manager, Document manager, Apache Server and Database for best

performance and throughput

Configure Business Intelligence Report

Done setup for Discoverer 3i, 4i for BIS Reports

Installed/configured 9ias(1.0.2.2.0,1.0.2.1.0)

Written several Unix scripts for monitoring - database, concurrent manager, jvm,

resource contention, EMC drive errors, requisition/purchase order monitoring, interface

from legacy systems.

Have very good experience under working high stress environment

Posses good inter-communication and problem solving techniques skill to narrow down

problem and fixing it within minimum down time

Oracle Applications DBA

PCTEL Inc, Milpitas, CA.

OCT 00

- Mar 01

PCTEL is pioneering in personal communications (PCs, set tops, cell phones etc.) and

internet service-side access (remote access systems, digital or analog modem pools etc.),

I was working as senior DBA, on Support, all DBA activities, and implementation.

Working on upgrading Oracle Applications 11.0.3 to 11i version

Tuning of Concurrent Manager

Fixing the Conflict Resolution among the module

Data Striping across the NASH server

Worked with Stream-Server for new bar-coding project to fasten the manufacturing unit.

Creation of different responsibilities for high security

Tuned Fixed Assets module for different users

Applying various patches required to multiple instances.

Implemented web-expense report through SSWA

Written several scripts for monitoring Concurrent Manager, database and o/s level

problems

Implementing backup and recovery procedure including logical backup (Export/Import),

physical backup (online/offline) and integrating the backup procedures. Performed recovery

from instance and media failures.

Refreshing Schemas in development databases from production databases on demand.

Worked with Legato Back up software

Oracle Applications DBA

Blue Meteor Inc, Chicago, IL Ag Oracle Applications hosting to several customers. I was

part of the DBA group working on implementation, support and other DBA activities.

Worked on upgrading Oracle Applications 11.0.3 to 11i(11.5.1) version

Done cloning of Oracle Applications 11i for one instance on a server to different

instance on another server. Though Oracle Support does not support cloning 11i, based on

the cloning expertise with 11.0.3, I have successfully completed this work.

Managing Oracle Applications Instance for various clients.

Installed Oracle Field sales (OFS 3.1.2) / Customer Relationship Management (CRM 3.1.2)

Fixed Workflow notification setup, Alert setup

Worked with security feature for Oracle Applications.

Did the setup for AP checks for evergreen format.

Did the Tuning for Concurrent Managers

Created custom responsibilities & custom top.

Installation of multiple instances of Oracle Applications 11.0.3 on Sun Server.

Upgrading the Oracle applications 10.7 to 11.0

Applying various patches required to multiple instances.

Configured Printer Setup for HP4050N and HP8000

Refreshing data from production to test and other instances.

Working closely with developers to address their problem related to applications

installations and upgrades

Closely working with Unix System administrators to resolve the space allocation and

back and recovery related issues.

Offering customer support using remote login and attending the entire emergency calls

from the customers.

Worked on check printing problems of customers on the development side.

Oracle Applications DBA

PCTEL Inc

., Milpitas, CA. OCT 99 - MAR 00

Installation of Oracle RDBMS 8.0.5 and Oracle Applications 11.0.300 on Compaq Server

running Nt 4.0. Created and configured multiple instances for production, test,

development and training environments.

Defining the scope of the database: assessing the space needs of database objects

Installation of Oracle RDBMS Patches to upgrade the oracle Server.

Implementing backup and recovery procedure including logical backup (Export/Import),

physical backup (online/offline) and integrating the backup procedures. Performed recovery

from instance and media failures.

Refreshing Schemas in development databases from production databases on demand.

Written numerous shell scripts to monitor the database administration which includes,

monitoring listener status and automatic restart, Archive log location disk capacity

monitoring, if it reaches 90% a m

Contact this candidate