Oracle EBS administrator

Aditya Kumanduri * :

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

) : 858-***-****

Professional Summary:

Promising expertise in Database Administration with an experience of 8+

years in supporting, implementing Enterprise solutions.

. Project planning and direction of applications strategy to ensure

alignment with overall technical and project scope, objectives and

deliverables.

. Manage Client co-ordination, project time-lines/mile-stones/SLA adherence

and delivery.

. Tracking Change Management and Incident Response processes.

. Excellent skills in Installation, Administration, Patching, Cloning and

Troubleshooting.

. Excellent Interpersonal and Communication skills.

. Interacting with product vendor support on various issues though service

requests and coordinating with onsite - offshore

DBA's/developers/functional team to resolve them.

. Self-motivated, assertive while possessing the ability to handle and

prioritize multiple tasks.

Employment Details:

Name of the Company From (DD/MM/YYYY) To (DD/MM/YYYY)

Tata Consultancy 20-July-2011 Till date

Services

Genpact India pvt ltd 2-March-2006 18-July-2011

Expertise in Database administration:

. 8+ years of experience as Database Administrator.

. Experience with Oracle databases 10/11g

. Upgrade of Oracle Applications (11.5.10.2 to 12.1.3)

. Experienced in database Upgrade to 11g

. Installation of 11g FMW (11.1.1.6)

. Knowledge of Nosql database concepts.

. Knowledge Cassandra database architecture.

. Installing Cassandra database on Windows/Linux platforms.

. Knowledge on Cassandra database backup and replication.

. Knowledge on monitoring Cassandra cluster and administration.

. Oracle Shared Application Tier Configuration.

. Extensive experience of Cloning Oracle 11i/R12

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

family-packs and maintenance packs,Oracle support dealing with

functional, developers and end users.

. Expertise in using AD utilities of Oracle Applications.

. Managed very large databases in 24/7 Production Environments.

. Oracle Sysadmin activities.

. Knowledge on Oracle Middleware Administration.

. Knowledge on Oracle RAC.

. Troubleshooting Oracle concurrent manager issues and apache issues.

. Export and import of Oracle databases and schemas.

. Setting up Cron Jobs using shell scripts.

. Troubleshooting Database internal errors with Oracle-Support.

. Controlling and monitoring user's access to the database.

Skill Set:

ERP: Oracle Applications 11i (11.5.10 and R 12, Weblogic

Adminstration.

Database: Oracle 11g,10g, Cassandra

Operating Systems: Sun Solaris, Linux Server 3.0/4/5,

Tools &Technologies: Toad, OEM, OAM, Kintana,HPSD

ORGANIZATION: Tata Consultancy Services.

Period July 2011 - till date

Client Qualcomm Inc

I have been working with Tata Consultancy Services designated as an IT

Assistant Consultant.

Qualcomm, based in San Diego, USA leads the world in the development of

CDMA2000 and WCDMA - the two most widely accepted International

Telecommunications Union-approved 3G standards), which helps in creating

state-of-the-art 3G chipsets, system software, development tools and

products. Qualcomm provides technology to support and accelerate the

convergence of wireless data, Internet and voice service. It also provides

comprehensive wireless solutions including two-way data communications

systems, productivity-enhanced applications wireless advisory and managed

network services for various industries like for-hire transportation and

logistics, construction, manufacturing, retail, food and beverage,

healthcare etc..

Roles and Responsibilities:

. I have joined TCS as a IT Analyst wherein I am leading a team of 4

DBA's presently working for the client Qualcomm to support their

existing Oracle ERP environments on 11.5.10.2 & 12.1.3

. Working with release managers, functional team and development team

for planning the cutover to ensure error free delivery and minimum

down time on database.

. Working with the client closely to plan the enhancements and maintain

the timely communication.

. Scheduling client calls and meetings to provide them with solutions on

project implementation.

. Representing in weeks client calls and plan the changes accordingly on

the database and to ensure the availability.

. Installing, Configuring and Upgrading Oracle on Linux Environment.

. Cloning the Oracle Applications using rapid Clone and Kintana.

. Patch Applications for resolving performance and bug issues.

. Managing and Monitoring Concurrent Jobs and Application Users.

. Providing fixes to the issues identified in testing phase.

. Coordinating the end to end System Integration and User acceptance

test for every release.

. Providing Technical Support to Developers.

ORGANIZATION: GENPACT India Pvt Ltd.

Period March 2009 - July 2011

Client GE ENERGY

Worked with Genpact India Pvt Ltd designated as Senior Associate.

Worked for the GE Energy, we Supporting various individual GE Business

which GE offers lifecycle services to support a wide range of power

generation and transmission and distribution equipment and in air quality

solutions and technologies that help reduce emissions, improve plant

performance to customers in energy industry. GE Energy's current product

portfolio includes wind turbines with rated capacities ranging from 1.5 MW-

4.1 MW and support services extending from development assistance to

operation and maintenance.

Roles & Responsibilities:

Being a part of TSG eOps DBA Team at Genpact handling around 25 Production

and around 100 Test & Development etc. GE Instances.

. Maintaining OLTP & ASCP Oracle Applications 11i databases in 24x7

Production environments.

. Upgraded Oracle Applications from 11.5.10.2 to 12.1.3.

. Upgraded database from 10.2.0.4 to 11.2.0.2.

. Extensive Oracle Applications Cloning using Rapid clone

. Extensive cloning experience as this team performs 500+ clones per

year which includes databases of size in terabytes

. Configuration of DMZ using Reverse Proxy.

. Applying latest Oracle Security patches and performing quarterly

password change and Releases.

. Perform Regular Maintenance on the Production Oracle Database

Instances to ensure the dead processes are cleared and to address

memory leaks.

. Scheduled Monitor Maintenance Related Programs & alerts like

Gather Schema Statistics, Purge programs etc.

. Handling P1 and P0 issues 24X7 and make sure to resolve it

within SLA and work on the action plan to ensure the issues are not

repeated again.

. Working with release managers, functional team and development

team for planning the cutover to ensure error free delivery and

minimum down time on database.

. Working with the client closely to plan the enhancements and

upcoming upgrades/projects and ensure to plan the resource in

offshore and maintain the timely communication.

. Representing in weeks client calls and plan the changes accordingly

on the database and to ensure the resource availability in the team.

. Troubleshooting Oracle Applications 11i databases day to day issues.

. Ensuring successful & periodical Backup using Hot, Cold, RMAN

backups.

ORGANIZATION: GENPACT India Pvt Ltd.

Period Aug 2007 - March 2009

Client GE Transportaion

Worked with Genpact India Pvt Ltd designated as Associate Consultant.

GE Transportation is a global technology leader and supplier to the

railroad, marine, drilling, wind and mining industries. GE provides freight

and passenger locomotives, railway signaling and communications systems,

information technology solutions, marine engines, motorized drive systems

for mining trucks and drills, high-quality replacement parts and value

added services.

Roles & Responsibility:

. Providing 24 X 7 troubleshooting and support for over 120+ Oracle

Applications instances which includes Production, Stage, Development &

Test instances with 99.5% uptime as SLA.

. Migration to Shared Application tier files system.

. Reorg of Databases was done using OATM for Oracle Application

instances

. Worked on JDK/JRE upgrade and Developer Patch set Upgrade for Oracle

Application Instances.

. Using the AD utilities for maintaining the application systems

(adpatch, adctrl, adadmin, adrelink) and Configured Workflow.

. Applying Application, NLS and Database Patches.

. Cloning the instances from production to Test, Development instance to

test & simulate few technical challenges, coordinate with testing and

development teams.

. Attending the Tickets raised by the Customers which as Code Moves &

Compiling forms/pll's, DB invalids, creating DB links etc.

. Monitor capacity & system growth and usage for new hardware or

software requirements and communicate these capacity requirements to

Business in the Monthly Performance calls.

. Discussing about the new enhancements and patching outage window on

production boxes with business in ccb calls.

. Customer support over phone, OWC, customer tracking system tool.

. Documenting Database Operations & Creating a CHECKLIST to manage

smooth and stable environment.

. Monitoring and troubleshooting various Oracle Applications 11i

databases remotely located in the US, Europe & Asia-Pacific

ORGANIZATION: GENPACT

Worked with Genpact India Pvt Ltd designated as Associate Consultant.

Period Sep 2006 - July 2007

Client GE Aviation

GE Aviation is a world-leading provider of commercial and military jet

engines and components as well as avionics, electric power, and mechanical

systems for aircraft with an extensive global service network to support

these products. The ORACLE ERP implemented to execute the Financial

Services of the business includes the modules like AP,AR,PA and GL etc..

Roles & Responsibility:

. Applied database patches using Opatch utility.

. Performing code migration and db links creation.

. Monitoring Table space and data files growth.

. Taking schema level backups using Import & Export

. Monitoring alerts and clearing the locks on the database

. Tablespace management by creating table spaces and adding data files

EDUCATIONAL QUALIFICATIONS:

Title as mentioned in Specialization College/University

the Degree Certificate

Bachelor of Technology Information technology Andhra University,

Andhra Pradesh, India

Personal Details:

Sex Male

Nationality Indian

Marital Status Single

Date Of Birth 25 July, 1984

Location San Diego, California

Address 10802, Camino Ruiz, Apt G

California, USA - 92126

Contact this candidate