Krishna Mohan Manyam

abgod7@r.postjobfree.com

+1-201-***-****

Summary:

. Over Eleven years of experience as Oracle Applications DBA.

. Seven years of experience in Pharma/Medical device organization.

. Extensive experience in Oracle E-Business Suite Applications R12, 11i

(12.1.3, 12.0.6, 12.0.4, 11.5.10.2, 11.5.10, 11.5.9,) Installations,

configuration, Cloning, Security, Patching, Upgrades.

. Good in Upgrades of Oracle ERP from 11.5.10.2 to 12.0.4, 12.0.4 to

12.0.6 and 12.0.6 to 12.1.1.

. Well experienced with Oracle 9i / 10g R2 RAC on Sun Solaris, AIX and

Red Hat Linux.

. Experienced in setting up Parallel Concurrent Processing

. Experienced in storage migrations from DMX1K to DMX4K and from DMX4K

to VMAX10K

. DBA lead for successful migration of DR databases from GA to CO

datacenter.

. Good in Setting up Logical Standby and have a hands on Switchover and

Switchback of Database in 10GR2 RAC

. Configured Shared Appl tops

. Automated Oracle cloning process.

. Experienced in Callibration/Orion utilities.

. Evaluated IBM Pureflex/Puredata systems

. Enabling Large pages in AIX

. Baseline patching for Oracle Apps extended support

. Very well versed in Rapid Install, DST patches, Security patches, Tech

stack patches, AdPatch, Adadmin and Adctrl utilities for Oracle

Applications.

. Proficient in Cloning using ad clone utility and adcfgclone using Hot

and Cold Backups.

. Highly experienced in Cloning of Oracle applications from multinode to

singlenode and singlenode to multinode

. Experienced in Configuring RMAN for Backups and cloning using RMAN

Backups

. Skilled in Installation of OBIEE, OBI Applications and Informatica

. Have Installed UPK Software

. Upgraded 12.0.6 to 12.1.1,12.0.4 to 12.0.6,11.5.10 to 12.0.4,11.5.9 to

11.5.10 and 11.5.8 to 11.5.9

. Database Upgrade from 9i to 10g and 10g to 11GR2

. OS Migrations From Linux (11.5.10.2 and 9.2.0.8) to AIX and

configuring Shared Appl Top

. Setting up of Dedicated Node for ASCP Managers

. Leading a Team of 15 DBA's.

. Installation and Configuration of 10GAS,SOA Suite,12C Grid

. Experienced in Setting Demantra Instance and Integrating with R12.

. Worked on Projects with Database size of more than 5 TB

. Enabling Load Balancing in a 12 Web-Tier Architecture

. Good insight into Vertex/Quantum upgrades

Certification and Training:

. Trainings on 10g Application Server Technologies from Oracle

Corporation.

. Intensive and Hands-on Oracle Applications DBA boot camp in

Administering Oracle Applications from Oracle University.

. Oracle Certified Professional (OCP) - 10G

Awards:

. Qool Award in Oracle Corporation for the year 2006-2007.

DBA Technical Skills

Hardware : Sun 450, Sun Ultra, AIX, HP- UX

Operating Systems : Solaris 2.X, AIX, Hp-UX, Linux, Windows NT

Rdbms : 12c/11G/10G/9i/8i/8.X

Applications : ORACLE APPLICATIONS

11.5.8/11.5.9/11.5.10/12.0.6/12.1.3

Backup : RMAN and XBP (Backup tools),BCV,EMC Snap

Tools/Others : Import/Export, OEM, TOAD and Quest

software tools, OEM, and Backup and recovery using

RMAN.

Professional Experience:

Stryker Ortho Mahwah, NJ, U.S.A Dec 2010 -

Present

Sr.Oracle Applications DBA

Description:

Stryker Ortho is medical technology firm which develops and produces

medical implants, surgical and imaging technologies, as well as patient

handling and emergency medical equipments. Stryker Ortho has a huge setup

of Oracle ERP and with Real Application Clusters and have also Implemented

Physical Standby which is periodically tested with switchover and

switchback mechanism.

Software: Oracle Application 11i (11.5.10.2), Oracle (10GR2) RAC, Oracle

Application 12.1.3, 11.1.0.7

Operating System: AIX, Linux

DB Size: 5.0 TB

Responsibilities:

. Leading a team of 15 off-site DBA's

. Well versed in validation requirements of Oracle Instances

. Well versed with Sarbanes/Oxley compliance standards

. Participated in Audit meetings with E&Y.

. Managing 100+ ERP and Non-ERP databases.

. Participated in storage migration from DMX to VMAX platform

. Managed successful migration of DR databases from GA to CO datacenter.

. Managed databases across different geographical locations.

. Automated Oracle ERP cloning process.

. Migrated 50+ Non ERP Databases (9.2.0.8, 10.1.0.5 and 10.2.0.4) from

Sun to AIX.

. Providing support to Demantra Applications, SOA Applications

. Configured II engine for Demantra Application

. Worked extensilvely on ERP Stress testing projects

. Good in performance tuning of Oracle Instances

. Installed GL Wand utility for Financial Reporting

. Highly experienced in Cloning of Oracle application environment using

Rapid clone

. Database Refresh/clone doing complete/incomplete recovery using cold

and hot backups.

. Managing the Concurrent Managers and its operations.

. Troubleshooting Apps components like Forms, Apache and Concurrent

Managers.

. Re-Org of critical ERP tables.

. Experienced in Callibration/Orion utilities.

. Evaluated IBM Pureflex/Puredata systems

. Providing support (24*7) and troubleshooting user (remedy) tickets.

. Technical Standards and documentation:

. Technical documentation including documenting standard operating

Procedures.

Oracle Corporation:

Jan 2004 to Dec 2010

Oracle Corporation world leader in providing enterprise software and

computer hardware products and services.

Provided DBA support to below Oracle clients:

Stryker Ortho Mahwah, NJ, U.S.A Aug 2009 - Nov-

2010

Lead Oracle Applications DBA

Pfizer Pharmaceuticals Bridgewater, NJ, U.S.A Oct 2008 -

July 2009

Lead Oracle Applications DBA

Description: The project was a Global Implementation of R12 with 11G RAC.

Software: Oracle Application R12 (12.1.1), Oracle (11G) RAC

Operating System: Sun Solaris, Linux

DB Size: 500 GB, Users: 500

Responsibilites:

. DBA lead of team of 4 Applications DBAs

. Installation/Configuring Instances required for Implementation cycle.

. Upgrade of Database from 10.2.0.3 --> 10.2.0.4 --> 11.1.0.7

. Upgrade of Application from 12.0.4 --> 12.0.6 --> 12.1.1

. Cross Platform Migrations

. Demantra Installation and Integration with R12 Instances.

. Setting ASCP Managers

. Trouble-shooting of all oracle application problems.

. Copy/Clone of oracle application environment.

. DB/Application Backup.

. PCP Configuration for RAC Environments.

. DB refresh from RAC Environment to Non-RAC environment.

. Used Oracle Application tools for maintaining database and application

like adpatch, adadmin, adctrl, adaimgr, adrelink, adsplice etc.

. Participated during the OS Migration from Linux to Aix

. Cluster Management and verifying cluster process to ensure smooth

operations.

. Monitoring the all-running Instance to ensure everything working.

. Quantum upgrade and licensing the New Products.

. DB Upgrades and Database patches using Opatch tool.

. Interacting with oracle support to resolve application issues.

. Setting up of Oracle Configuration Manager

Welch's Foods, Concord, MA, U.S.A May 2007 -

Oct 2008

Oracle Applications DBA

Description:

Welch's Foods is a Fruit Juice manufacturing company based out of Concord,

Massachusetts. Welch's has Implemented Oracle ERP with 10G RAC. Welch's has

a large Oracle Implementation with Products like Demantra, OBIEE along with

10G Grid with the Management Pack. They also have a Decentralized ASCP

setup.

Operating System: AIX

DB Size: 500 GB, Users: 1000

Responsibilities:

. Upgraded the ERP from 11.5.9 to 11.5.10.2

. Provided Technical Support during the Go-Lives of 11.5.10.2 and OPM

Modules

. Migrated the ERP Instance from Linux to Aix

. Trouble-shooting of all oracle application problems.

. Copy/Clone of oracle application environment.

. DB/Application Backup.

. PCP Configuration for RAC Environments.

. DB refresh from RAC Environment to Non-RAC environment.

. Monitoring the all-running Instance to ensure everything working.

. Quantum upgrade and licensing the New Products.

. DB Upgrades and Database patches using Opatch tool.

. Tablespace Maintenance like adding the increase the size of the data

files.

. Interacting with oracle support to resolve application issues.

CAE, Montreal, Canada Apr 2006 - May

2007

Oracle Applications DBA

Description:

CAE a leading provider of simulation & modeling technologies, and

integrated training services to airlines, aircraft manufacturers, and

defense customers worldwide. CAE is one of the Initial Companies to have

gone live on 10G RAC. They have Implemented Oracle Application 11.5.10.2

with 10G RAC with ASM. They also have BPEL Instances.

Operating System: AIX

DB Size: 500 GB, Users: 1000

Responsibilities:

. Installations of Oracle ERP Applications

. Configuring ASM Instances

. Installing of BPEL Instances

. Trouble-shooting of all oracle application problems.

. Copy/Clone of oracle application environment.

. DB/Application Backup.

. Converting into Multi-Nodes.

. DB refresh and Clones.

Invacare, Ohio, US Mar 2004 -

Apr 2006

Oracle Applications DBA

Description:

Invacare is world's leading manufacturer and distributor of non-acute

medical equipments including wheelchairs, mobility scooters, walkers as

well as respiratory products. Inavacare has Eloborate ERP Configuration

with more than dozen web nodes. They have implemented Oracle Application

11i (11.5.10.2) with 9.2.0.8.

Operating System: AIX

DB Size: 2.5 TB, Users: 1000

Responsibilities:

. Participated during the OS migrations of their Application Servers

from AIX to linux

. Trouble-shooting of all oracle application problems.

. Copy/Clone of oracle application environment.

. DB/Application Backup.

. DB refresh and Clones.

. Used Oracle Application tools for maintaining database and application

like adpatch, adadmin, adctrl, adlicmgr, adrelink, adsplice etc.

Liberty Travels, US Dec 2004 - Apr

2006

Oracle Applications DBA

Description:

Liberty Travels are one of the pioneers in the Travel Industry. They

initially started with 11.5.8 and during the Support they have upgraded the

Oracle Applications to 11.5.9 and database to 9.2.0.6. Liberty Travels uses

RAW file systems.

Software: Oracle Application 11i (11.5.9), Oracle (9.2.0.6)

Operating System: HP UX

DB Size: 700 GB, Users: 500

Responsibilities:

. DB refresh and Clones on RAW File systems

. Copy/Clone of oracle application environment.

. DB/Application Backup.

. Installation of OEM and configuring Alerts based on Thresholds

GAP, US Jan 2004 - Dec

2004

Oracle DBA

Description:

GAP is a major clothing and accessories retailer and is one of the largest

specialty apparel retailers in the world. GAP uses Oracle 9i Database for

their production Instance.

Responsibilities:

. Providing DBA Support to ensure 24x7 DBA support.

. Trouble-shooting of all oracle database problems.

. Refresh of oracle database environment.

. DB Backup.

. Applying major Patches for DB upgrade

. Regular monitoring of production as well as Test application.

. Monitoring Performance, Locks using OEM, TOAD.

Telstra, Australia Mar 2004 -

Dec 2004

Oracle Applications DBA

Description:

Telstra is a leading Australian telecommunications company. Telstra is the

largest provider of local and long distance telephone services, mobile

services, dialup, wireless, DSL and cable internet access in Australia.

Telstra has an Implementation of Oracle Applications 11i (11.5.9) with

Database on 9.2.0.6.

Responsibilities:

. Performance Analysis of client systems using EAP tools.

. Running perfstat data collections.

. By using EAP tools analyze the collected data.

. Finding the suitable recommendations based the data analysis.

. Running RDA scripts to find out system specific details.

. Running APPS_RDA scripts to find out Application related details

Unichem Technologies, India Aug- 2003 - Dec

2003

Oracle DBA

Project: In-house support of Oracle Database

Software: Oracle (9.2.0.1)

Responsibilities:

. Trouble-shooting of all oracle database problems.

. Refresh of oracle database environment.

. DB Backup.

. Regular monitoring of production as well as Test application.

Monitoring Performance, Locks using OEM, TOAD

Education:

. Master of Computer Applications from Madras University.

Contact this candidate