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