Oracle Manager

Location:

Alpharetta, GA, 30005

Posted:

May 25, 2011

Contact this candidate

Resume:

[pic] [pic] [pic] [pic]

Anand Murari

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

Lead Apps DBA

571-***-****

Oracle Certified Apps DBA (10g RDBMS, 11g RAC, 11i Apps DBA) with 13+ years

of Apps DBA cum core DBA experience, Installation, Upgrade of EBusiness

suite 12 & Migration, RMAN Backup and Recovery, RAC & Dataguard,

Performance Tuning, SQL tuning, Database Security, Development and

Production support on Operating Systems viz. IBM AIX, Linux, Sun Solaris.

Successfully performed the role as Lead Apps DBA with good presentation and

communication skills to provide support to the customer. Expert in

Administering 7X24 OLTP, Data Warehouse and OLAP databases. Ability to

analyze, plan and execute to perfection.

. Excellent project implementation skills, and ensure on-time delivery

of all content/final deliverables

. Implemented Oracle Applications R12, including functions/features,

configuration, development, security and supporting the AP modules.

. Implementation and Support database services across multiple

environments (Development, Integration, QA, UAT, Production and DR

Support) and adhere to SDLC life cycle,

. Understands business and technology processes, identifying and

implementing improvement initiatives.

. Planning, supporting and coordinating with various teams to ensure the

databases are ready for application releases.

. Upgrade all Databases to 11gr2 RAC with ASM. Install and configure

Cluster ware on Linux, AIX and Solaris. Have performed at least 10

fresh installs and configurations of 11gr2 with ASM and scan listener

technology

. Responsible for design and correct functioning of RMAN backup and

recovery.

. Optimizes database access and allocates database resources for optimum

configuration

. Administer 3 node cluster 11g RAC with ASM &GRID

. Implemented and managed database backup and recovery procedures using

RMAN, and Veritas cluster/storage manager, BMC SQL Backtrack.

. Extensively used Oracle utilities like Golden Gate CDC, Export /

Import, Datapump, Log Minor, dbverify, Hang Analysis, OS Watcher.

. Monitoring and optimizing the Database Performances through oracle 11g

GRID control

. Worked with IBM Tivoli on data Protection, scheduling backup and

setting up alerts.

. Worked as Apps DBA on Oracle 11i Apps, Server 10gR2/Portal.

. Configured Oracle Application Server 10g with Oracle EBusiness Suite

Release 12 upgrade.

. Using AutoConfig profiler to Manage System Configurations in Oracle

EBS Release 12

. Implementation of Enhanced Support for Application Tier Load

Balancing(R12)

. In-depth knowledge of Client/Server (2 tier and 3 tier) Technologies

with hands-on experience.

. Oracle Application DBA support, applying patches, mini-packs, and

maintenance packs, upgrades, multi-tier installations, automate

routine DBA task.

Technical Expertise:

TECHNICAL SKILLS:

Database Administration: Oracle 9i/10g/11g

Tools and Utilities: OEM, RMAN, SQL*Net, Toad, Sql Profiler,

PL/SQL developer

Replication tools : Golden gate (CDC).

Operating Systems: Linux RH as 9/ES, Win 2000/XP/2003, Solaris

8/9,HP-UX,AIX 5.3

File Systems: ASM, OCFS2, veritas

Backup: VERITAS Netbackup.

Programming Languages: PL/SQL

RDBMS: Oracle 9i/10g/11gR2

EBS Utilities: Oracle Application Manager, ADADMIN, Patch

wizard

CERTIFICATIONS: 11gR2 RAC and Grid Infrastructure training at Oracle

University

Oracle certified professional (OCP) Oracle 11g DBA From

Oracle Corporation

Oracle certified 11i Application DBA

Oracle certified professional (OCP) Oracle 9i DBA From

Oracle Corporation

Professional Experience

AT&T Telecom

Sep 2010 - Till date

Sr Apps Consultant

www.att.com

AT&T is a leader in telecommunication services, including cell phones,

wireless, U-verse, digital TV, high speed internet, DSL, home phone.

Responsibilities:

. Provided technical expertise on multiple environments (Development,

Integration, QA, UAT, Production and DR)

. Implementation of Enhanced Support for Application Tier Load

Balancing(R12)

. Monitoring and Maintenance of Oracle Applications 11.5.10. Implemented

and supporting Data guard databases for DR.

. Upgrade all Databases to 11gr2 RAC with ASM. Install and configure

Cluster ware on Linux, AIX and Solaris.

. Support for application code builds and adhere to software development

lifecycle (SDLC)

. Migrate Oracle 10g to 11g on multiple platforms -- AIX 5,3,6.3,

Solaris 10, 9, HP-UX 2.3,3.1, Linux Several Upgrades from 11.5.X AIX,

Solaris, Linux, HP, Windows to R12 -- Performed all analysis,

patching, system setup, migration strategies.

. Understands business and technology processes, identifying and

implementing improvement initiatives, eliminating redundancies and

maximizes re-use of applications.

. Supported on various technologies Oracle 10g/11g, Oracle RAC, Grid

Control, Golden Gate CDC, and Dataguard

. Responsible for design and correct functioning of RMAN backup and

recovery & Veritas netbackup.

. Optimizes database access and allocates database resources for optimum

configuration, database performance and cost.

. Assists management in coordinating of activities and balancing

workload, Allocation of tasks, planning of weekend activities,

Production plans.

. Proactively identifies opportunities for cost-savings and efficiency

improvement.

. Environment Refresh and Database Cloning using RMAN.

. Upgraded from 10.2.0.4 to 11.1.0.7 using outline method.

. Fine tune the queries and setup baselines to improve performance

. Implemented Oracle 11g native compilation feature

. Apply CPU/PSU patches with minimal downtime

. Participate in implementing database strategies and solutions

Environment: Sun Solaris 9/10, RedHat Linux AS 4, Oracle Linux/Unix, MS

Windows XP, Oracle 9i, Oracle 10gR2, Oracle 11g(11.1.0.7), Veritas Cluster,

Veritas Netbackup, PL/SQL, TOAD, SQL navigator, Quest spotlight, Golden

Gate CDC.

Monsanto, MO

Apr 2010 - till date

Oracle Apps Consultant

Monsanto is an agricultural company. We apply innovation and

technology to help farmers around the world produce more while conserving

more. It help farmers grow yield sustainably so they can be successful,

produce healthier foods, better animal feeds and more fiber, while also

reducing agriculture's impact on our environment

Responsibilities:

. Providing Level-3 Support for resolving issues in Oracle 9i, 10g and

11g databases & Apps related issues

. Experience with FDA (Validated) environments preferred. Administrating

the Oracle Applications instances, User administration and patch

management

. As a production Support DBA, troubleshooted and resolved several types

of production issues during the off hours and over the weekends.

. Analyzing and sustaining capacity and performance requirements.

. Analyzing, consolidating and tuning database for optimal efficiency.

. Managing of Storage Area Network(EMC2 CLARiiON)

. Managing databases on IBM-AIX, solaris,HP-UX, and worked with IBM

Tivoli on data Protection, scheduling backup and setting up alerts.

. Configure parallel concurrent processing, tracing and debugging,

defining concurrent managers and concurrent programs, managing

database and applications security

. Implementation of Enhanced Support for Application Tier Load

Balancing(R12)

. Monitoring and Maintenance of Oracle Applications 11.5.10. Implemented

and supporting Data guard databases for DR.

. Installation, configuring environment files & control scripts,

Patching mini packs, family packs, maintenance packs and patchsets,

Shadow Image.

. Performing ShadowImage copies to ensure the highest data availability

. Providing immediate, nondestructive access and sharing of information

for decision support, test and development using ShadowImage

. Setup the environment to upgrade EBS 11.5.10 to EBS R12 and coordinate

with application team.

. Ability to develop and maintain project and production plans

. Documenting database structural changes(SMTD & EPD)

. Analyzing and sustaining capacity and performance requirements.

. Analyzing, consolidating and tuning database for optimal efficiency.

. Handling issues related to Database Upgrade/Migrate and Patching.

. Handling 10G RAC switchover and failover configuration, implantation,

and testing

. Installed Oracle 10G RAC on Linux platform using ASM for a storage

manager

. Providing performance tuning on a 10G RAC database on a Linux

platform

. Installed Oracle 9i RAC in a Unix environment for multiple nodes

. Configured a 10G database in a non RAC environment using Sun clusters

. Implementing Oralce8i Standby Database, Oracle9i Data guard for High

Availability on TEST databases and helping customers in resolving Data

Guard issues.

. Creating, Maintaining and Supporting Physical standby databases.

. Excellent in Oracle Applications technology stacks, architecture,

installation, configuration, maintenance, cloning and patching.

. Monitoring Redo Transport services, Log apply services and Role

transitions.

. Handling issues with Network tuning for Redo Data Transmission, Slow

disk performance on standby databases.

. Proficient in implementing and handling issues with Backup and

Recovery strategies for Oracle databases (Logical Export & Import,

Physical Online and Offline & RMAN) & disaster recovery procedures.

. Setting up the Prod/Development/QA & Test database environment.

. Analyzing STATSPACK, AWR, ADDM and TKPROF for diagnosing the root

cause of the issue.

. Applying CPU (Security) patches on different platforms for different

issues.

. Working with Development in resolving Bugs with Oracle 8i/9i/10g.

. Remotely administrating the production databases through VPN

connection. This includes monitoring the database growth, checking for

the performance bottlenecks and taking backups for disaster recovery.

. Worked with IT managers and application developers to resolving

Critical database issues.

Freddie mac, VA

Aug 2009 - Mar 2010

Technical lead

Freddie Mac is a key player in housing market and its mission is to provide

liquidity, stability and affordability to the housing market.

Responsibilities:

. Supporting customers for resolving Critical Production Issues.

. Administrating the Oracle Applications instances, User administration

and patch management

. Migration and cloning of multi node Oracle Applications Installations

. Configure parallel concurrent processing, tracing and debugging,

defining concurrent managers and concurrent programs, managing

database and applications security

. Upgraded the Oracle 11i to release R12

. Monitoring and Maintenance of Oracle Applications 11.5.10. Implemented

and supporting Data guard databases for DR.

. Installation, configuring environment files & control scripts,

Patching mini packs, family packs, maintenance packs and patchsets,

Shadow Image.

. Performing ShadowImage copies to ensure the highest data availability

. Providing immediate, nondestructive access and sharing of information

for decision support, test and development using ShadowImage

. Setup the environment to upgrade EBS 11.5.10 to EBS R12 and coordinate

with application team.

. Ability to develop and maintain project and production plans

. Documenting database structural changes(SMTD & EPD)

. Analyzing and sustaining capacity and performance requirements.

. Analyzing, consolidating and tuning database for optimal efficiency.

. Handling issues related to Database Upgrade/Migrate and Patching.

. Handling 10G RAC switchover and failover configuration, implantation,

and testing

. Installed Oracle 10G RAC on Linux platform using ASM for a storage

manager

. Providing performance tuning on a 10G RAC database on a Linux

platform

. Installed Oracle 9i RAC in a Unix environment for multiple nodes

. Configured a 10G database in a non RAC environment using Sun clusters

. Implementing Oralce8i Standby Database, Oracle9i Data guard for High

Availability on TEST databases and helping customers in resolving Data

Guard issues.

. Creating, Maintaining and Supporting Physical standby databases.

. Excellent in Oracle Applications technology stacks, architecture,

installation, configuration, maintenance, cloning and patching.

. Monitoring Redo Transport services, Log apply services and Role

transitions.

. Handling issues with Network tuning for Redo Data Transmission, Slow

disk performance on standby databases.

. Proficient in implementing and handling issues with Backup and

Recovery strategies for Oracle databases (Logical Export & Import,

Physical Online and Offline & RMAN) & disaster recovery procedures.

. Setting up the Prod/Development/QA & Test database environment.

. Analyzing STATSPACK, AWR, ADDM and TKPROF for diagnosing the root

cause of the issue.

. Applying CPU (Security) patches on different platforms for different

issues.

. Working with Development in resolving Bugs with Oracle 8i/9i/10g.

. Remotely administrating the production databases through VPN

connection. This includes monitoring the database growth, checking for

the performance bottlenecks and taking backups for disaster recovery.

. Worked with IT managers and application developers to resolving

Critical database issues.

Environment: Sun Solaris 9/10, RedHat Linux AS 4, Oracle Linux/Unix, MS

Windows XP, Oracle 9i, Oracle 10gR2, Oracle 11g(11.1.0.7), EBS 12, Veritas

Cluster, PL/SQL, TOAD.

Organization: Wipro Technologies

Client: GMAC Insurance, St. Louis, MO

Mar 2008-May 2009

Technical lead

GMAC Insurance (www.gmacinsurance.com) Group is one of the largest

properties and casualty insurance companies in the United States and is

part of GMAC Financial services. The company provides a broad range of

insurance and insurance-related Products and services for individual

consumers, as well as automotive dealerships.

Responsibilities:

. As a production Support DBA, troubleshooted and resolved several types

of production issues during the off hours and over the weekends.

. Documenting database structural changes(SMTD & EPD)

. Handling RAC, DATAGUARD, and ASM issues.