Prerak Raghuvanshi

With over * years of consulting and support experience as an Oracle

Application DBA and Oracle Core DBA with Global Customers. Skills in

Installation, Cloning, Patching and Upgrade of Oracle 11i databases on Unix

Operating System. Associated with clients to impart knowledge transfer to

their DBA team with Database and ERP related skills, strategies, procedures

and performance process. Exposed to ORACLE ERP related latest technologies

and varied architecture components. Excellent people skills with

demonstration ability of customer satisfaction. Expertise in working

independently and as a team member in both structured and non-structured

environment.

Significant Strengths:

. Good presentation and communication skills to provide support to the

Customer.

. Ability to work flexibly as a team member.

. Dedication with an inner drive to succeed and accomplish goals.

. Ability to perfectly plan and execute the given job to perfection.

Technical Expertise Details

Operating Systems MS-DOS, MS Windows 95/98,

Linux, Solaris, AIX

RDBMS Oracle 8i,9i,10g,11g

EBS (Oracle E-Business 11 i, R12

Suit)

FMW Web Logic, OAM, OIM, OID

Other Tools RMAN, Tkprof, Stats pack,Toad, SqlDeveloper

Scheduling Tools Cronjob (UNIX), Oracle Enterprise Manager

SUMMARY OF WORK EXPERIENC

Business & Decision GDC Pvt Ltd.(May 2010 - Till Date)

Client: American Institute of CPA's

Role - Oracle Consultant

Team Size: 8

Environment: Database: Oracle 10g OS: Linux, Apps 11i,Shared APPL_TOP,

External Nodes for Ipayment.

Responsibilities:

> Oracle Database 10g (10.2.0.2) 11g (11.2.0.2)

> Refreshing the Reporting instance on Daily basis through automated

scripts.

> Creating, monitoring & managing database, tablespaces, Concurrent

Manager

> Patchset upgrade from 10.2.0.4 to 10.2.0.5 for different DEV instances

> JDK6 / JRE upgrade on Linux

> Applying form patches(8.0.6 Home)

> SSO Implementation with EBS.

> Database refresh (import/export)

> Cloning (Rapidclone/Manual clone,Hot backup clone, Multi-node clone,

shared APPL_TOP)

> Automated the clones through shell scripting

> Taking Database Backup (Hot/Cold Backup)/RMAN Backup

> RAC 11g Installation & Administration.

> Setting up new users /Managing User Responsibilities

> Performance Tuning & identifying bottlenecks.

> OATM Implementation.

> Installation, Setup, Configuration of Oracle 11i e-business suite

> Administering applications of Oracle Apps 11i

> Patching (adpatch, admrgpch, adctrl, adadmin ), Patch Analysis, DB

Patching

> Performing Load Test for performance enhancement with client QA

resource.

> Management of Standby Database.

> Implementing Customizations / Code promotions /Migrations.

> Disaster Recovery planning & Implementation

> Managing Problem Tickets for production database.

Client: BioMarin Pharmaceutical Inc

Role - Oracle Consultant

Team Size: 10

Environment: Database: Oracle 11gR2 OS: LinuxRHEL 5.6, Apps R12.1.3, FMW

implemented.

Responsibilities:

> Experience in Upgrading Apps from 11i to R12

> Installation & Administration of Fusion Components (OIM, OAM, ODS)

> Integration of OAM, EBS with OID.

> SSO Implementation with EBS.

> Database refresh (import/export)

> Cloning (Rapidclone/Manual clone,Hot backup clone, Multi-node clone,

shared APPL_TOP)

> Taking Database Backup (Hot/Cold Backup)

> RMAN Backup/RMAN clone

> Maintaining the Non-ERP Databases for the client.

> Upgrade from 10.2.0.4 to 11.2.0.2

> Executing migrations & customizations after clone.

> Upgraded EBS from 12.0.4 to 12.1.1

> Upgraded EBS from 12.1.1 to 12.1.3

> Concurrent manager tuning, performance tuning of the code

> Database management using Oracle Enterprise Manager (OEM)

> BPEL iAS Software Installation

> OPSM Installation

> Applying HRMS patches( DataInstall & hrglobal.drv)

> Maintaining the physical standby

> Configuring Workflow .

> Installation of Oracle web logic / SOA /OIM.

> Using Administration Console and WLST

> Gathering Monthly Stats.

> Tracing Forms, CM sessions, Enable Diagnostics for Oracle Applications

Components i.e. Apache, OC4J (or Jserv), FRD Trace, FND Diagnostics

and Debugging for SSWA applications.

> Coordination with Oracle Support for addressing Issues.

> Managing application Users, Responsibilities, Request groups,

Concurrent managers and programs, Work shifts, Customized Menus setup

etc.

> Providing Client with implementation DBA support for their R12

Instances.

> Query Tuning, Tuning Waits and monitoring resource usage. Review

Execution Plans, Stats Generation and Recommendations for SQL Tuning.

Client: Ampac Fine Chemicals

Role - Oracle Consultant

Team Size: 8

Environment: Database: Oracle 9i, Apps 11i, OS- Solaris

Responsibilities:

> Managing and Administration of Database as well as Apps Servers.

> Storage/Space management

> Patching

> Cloning (Rapid Clone) the Dev and Test Instances every 2 weeks.

> Routine Troubleshooting

> Performance Tuning of Database, Concurrent Managers

> Managing Backup Strategy using snapshot backups

> CPU Patching, Patchset Applications, Upgrade recommendations

> Perform disk-to-disk, hot or cold, Backup through RMAN

> Establish and maintain backup jobs and schedules

> Perform database refreshes, restores and recoveries

> Manage database archive or transaction logs

> Detect and fix internal database errors

> Implement startup and shutdown procedures

> Manage database initialization parameters

> Manage user accounts, privileges, roles and resources

> Review database health and capacity

> Manage Indexes, Extents

> Manage log files

Client: LDR Spine

Role - Oracle Consultant

Team Size: 5

Environment: Database: Oracle 10g, OS- Windows Server 2003, PROD JDE

Responsibilities:

> Database & Schema refresh on weekly basis through Datapump

> Using OEM for scheduling backups, deleting archives & other

activities

> Install, configure and maintain monitoring scripts

> Monitor and resolve database locks

> Monitor and resolve runaway processes in the database

> Monitor and resolve resource allocation

> Monitor database availability

> Maintain performance tuning parameters

> Monitor and resolve database connectivity issues

> Monitor Alert log on regular basis

Client: American Pacific Institute

Role - Oracle Consultant

Team Size: 6

Environment: Database:9.2.0.8, Apps 11i, OS - IBM Linux

Responsibilities:

> Upgrading database from 9.2.0.8 to 11.2.0.2

> Managing and Administration of Database as well as Apps Servers.

> Storage/Space management

> Patching

> Cloning (Rapid Clone) the Dev and Test Instances every 2 weeks.

> Routine Troubleshooting

> Performance Tuning of Database, Concurrent Managers

> Managing Backup Strategy using snapshot backups

> CPU Patching, Patchset Applications, Upgrade recommendations

> Perform disk-to-disk, hot or cold, Backup through RMAN

> Establish and maintain backup jobs and schedules

> Perform database refreshes, restores and recoveries

> Manage database archive or transaction logs

> Detect and fix internal database errors

> Implement startup and shutdown procedures

> Manage database initialization parameters

> Manage user accounts, privileges, roles and resources

> Review database health and capacity

> Manage Indexes, Extents

> Manage log files

Client: DASSAULT SYSTEMS

Role - Oracle Consultant

Team Size: 6

Environment: Database:9.2.0.2, Apps 11i, OS- Windows 2008

Responsibilities:

> Upgrade to JDK5.

> IE8 Patching

> DEV19 Patchset Installation

> DB/Apps Patching

> Perform disk-to-disk, hot or cold, Backup through RMAN

> Establish and maintain backup jobs and schedules

> Perform database refreshes, restores and recoveries

> Manage database archive or transaction logs

> Detect and fix internal database errors

> Implement startup and shutdown procedures

> Manage database initialization parameters

> Manage user accounts, privileges, roles and resources

> Review database health and capacity

> Part of Reimplementation Project as it moved from Windows to Linux,

9i to 11g, and 11i to R12 (32 bit to 64 bit)

. Other projects includes HTH WorldWide, Leasaffre, Bostwick, AFC which

includes similar role.

Company Name - Heuristics Informatics Pvt Ltd.

Designation - Oracle Application DBA

Clients - National Public Radio, NYPD, Sandals Resorts, World Fuel Services

(Dec-2010 till April-2011)

> Oracle Database 10g (10.2.0.2) 11g (11.2.0.2) / Apps 11i

(11.5.10),R12

> Installation, Setup, Configuration of Oracle 11i e-business suite

> Administering applications of Oracle Apps 11i

> Patching (adpatch, admrgpch, adctrl, adadmin )

> Database refresh

> Cloning (Rapidclone/Manual clone)

> Taking Database Backup (Hot/Cold Backup)

> RMAN Backup

> Setting up new users /Managing User Responsibilities

> Performance Tuning

> Creating, monitoring & managing database, tablespaces, Concurrent

Manager

> Database health check on regular basis

> Alert Log checking on regular basis

> Checking replication through Streams.

> Upgradation 10.2.0.2 to 11.2.0.2

> Executing sysadmin tasks & migrations for WFS

> Preparing Health Check reports for the clients.

> Managing the domestic clients.

> Responsible for all DBA Services

Company Name - AI Webcare Technologies Pvt Ltd

Designation - Oracle Application DBA

Client - Shiva Foods.INC ( Jul-2007 to Dec-2010)

> Managing and Administration of Database as well as Apps Servers.

> Storage/Space management

> Patching

> Cloning (Rapid Clone) the Dev and Test Instances every 2 weeks.

> Routine Troubleshooting

> Performance Tuning of Database, Concurrent Managers

> Managing Backup Strategy using snapshot backups

> CPU Patching, Patchset Applications, Upgrade recommendations

> Perform disk-to-disk, hot or cold, Backup through RMAN

> Establish and maintain backup jobs and schedules

> Perform database refreshes, restores and recoveries

> Manage database archive or transaction logs

> Detect and fix internal database errors

> Implement startup and shutdown procedures

> Manage database initialization parameters

> Manage user accounts, privileges, roles and resources

> Review database health and capacity

> Manage Indexes, Extents

> Manage log files

> Install, configure and maintain monitoring scripts

> Monitor and resolve database locks

> Monitor and resolve runaway processes in the database

> Monitor and resolve resource allocation

> Monitor database availability

> Maintain performance tuning parameters

> Monitor and resolve database connectivity issues

> Monitor Alert log on regular basis

EDUCATION : Bachelors in Computer Science Engineering

Contact this candidate