Oracle Apps DBA with performance tuning

VINAY BHATIA

Phone: 208-***-**** • E-mail: *************@*****.***

EXPERIENCE SUMMARY:

 8 years of strong Oracle Database Administration experience

 6 years of strong Oracle Applications 11i implementation and maintenance experience

 Strong SQL/PLSQL development skills

 Experience in Project Management

 Excellent skills in Oracle Applications Performance Tuning ( Forms, Concurrent Requests, Self Service Pages and Oracle Database )

 Experience in Oracle Application upgrades from 11.5.x to 11.5.10.2

 Experience in Oracle database upgrades from 8i/9i to 10g

 Experience in complete cycle of implementing 11i with RAC, Shared Appltop, Parallel Concurrent Processing (PCP)

 Experience in setting up Load-Balancing, Failover and DMZ Configurations.

 Experience in latest technology integrations with 11i like 10g AS, Discoverer 10g and SSO

 Excellent skills in database ( Oracle 8i /9i /10g ) administration and upgrade

 Excellent skills in backup and recovery methodologies, cloning and performance tuning of databases.

 Experience on High Availability Architectures like RAC and Data Guard.

 Well versed in Rapid Install, adpatch, adadmin, adsplice, adlicmgr and adctrl utilities for Oracle Applications.

 Well versed with Oracle Applications DBA and Sysadmin activities like Patching, Maintenance, Licensing, Administering concurrent managers, Registration of custom forms and reports.

 Well experienced in using Oracle Server Utilities like SVRMGR, Export, Import, and SQL Loader

 Well versed with R12 Installation and new techstack.

 Oracle Certified Professional.

 Oracle Applications R12 Accelerator certified

 Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service

EDUCATION:

 Master in Computer Applications, India

 Bachelor in Science, India

EMPLOYMENT HISTORY :

FUJITSU CONSULTING JUN’ 2007 – TILL DATE

Working with Strategic Support Services group of Fujitsu consulting, which provides oracle consulting and support to multiple customers remotely. The team works on onsite offshore model. I am handling four customers with the role of Primary DBA and managing various implementation and support projects.

01 Client : Kelly Moore Paints

Role : Sr Apps DBA/ Project Lead

Duration : JUN’ 2007 – Till Date

Kelly-Moore is the largest employee-owned paint company in the United States, with 200 retail stores, 3 major manufacturing facilities, and approximately 2,000 employees.

Responsibilities :

• Providing application support for Production and development environments of Kelly Moore Financials ( 11.5.10/10.2.0.3 with AR, GL, AP).

• Installed and Integrated Discoverer 10g with Oracle Applications.

• Maintenance of Oracle Applications using Ad Utilities (adadmin, adpatch, adrelink etc ).

• Cloning of production to development and test environments.

• Created custom managers and work shifts for month-end long running jobs.

• Monitoring long running requests and user sessions.

• Responsible for database backups.

• Registering Custom Reports/Forms in Oracle APPS.

• Performance Tuning of complete application and database.

• Tuned Custom Month End Programs

02 Client : MTD Products

Role : Sr Apps DBA/ Project Lead

Duration : JUN’ 2007 – Till Date

MTD is a leading, global manufacturer of outdoor power equipment, which produces equipment for both the residential and commercial market.

Responsibilities :

• Providing application support for Production and development environments

( 11.5.10/9.2.0.7 with iprocurement, isupplier, sourcing, Inventory).

• Implemented DMZ for isupplier and sourcing modules.

• Setup workflow for production and development instances.

• Responsible for database backups.

• Maintenance of Oracle Applications using Ad Utilities (adadmin, adpatch, adrelink etc ).

• Cloning of production to development and test environments.

03 Client : GES

Role : Sr Apps DBA/ Project Lead

Duration : JUN’ 2007 – Till Date

GES Exposition Services produces the world’s most visible and influential exhibitions and events. GES provides exhibition and event services in every major market across North America and the United Kingdom.

Responsibilities :

• Provided hardware and software requirement for RAC implementation

• Upgraded database from 32 bit to 64 bit.

• Migrated DEV environment from single node to 2 node 10g RAC with PCP.

04 Client : XETA Technologies

Role : Sr Apps DBA/ Project Lead

Duration : JUN’ 2007 – Till Date

Xeta Technologies is a mid size company provide voice and data networking services, having a user base of around 500. Worked as the primary DBA on implementation tasks and support for Oracle Applications 11i

Responsibilities :

• Prepared and executed the plan for Upgrading and moving the existing 11.5.8 applications and 8i database to 11.5.10.2 and 10gR2 and from AIX to Linux successfully.

• Worked as a primary person in implementing the DMZ for the upgraded applications for iSupplier and iStore Modules.

• Configured Workflow Mailer.

• Responsible for database backups and restores.

• Providing application support for Production and development environments

• Cloning of production to development and test environments.

HCL AMERICA INC NOV’ 2006 – JUN’ 2007

01 Client : Essilor USA

Role : Sr Apps DBA

Duration : NOV’ 2006 – JUM’ 2007

Essilor is world's largest manufacturer of lenses with 550 research centers and 215 laboratories. Worked with DBA group to support Oracle Application 11i (INV,PO,AR,OE,iSTORE ) and Oracle data warehouse.

Responsibilities :

Oracle Applications

• Application and Database Performance monitoring/Tuning using statspack reports, tkprof and 10053 trace.

• Maintenance of Oracle Applications using Ad Utilities (adconfig, adadmin, adpatch, adrelink etc ).

• Production cloning to Development and Test instances using Rapid Clone/Manual Clone.

• Day to day troubleshooting of all the environments which includes fixing all the issues and supporting various components of Oracle Applications

• Creating Managers, work shifts and requests for them.

• Monitoring long running requests and user sessions.

• Registering Custom Reports/Forms in Oracle APPS.

Oracle Data Warehouse

• Performance tuning of long running reports/batch jobs which involves using trace/tkprof, pq/pdml

• Creation/modification of partition strategies for performance improvements

• Proactive monitoring of database.

ORACLE CORPORATION APR’ 2003 – OCT’ 2006

01 Team : Application Performance Group

Role : Sr Apps DBA/Performance

Duration : OCT’ 2005 – OCT’ 2006

Application Performance Group is responsible for triaging and solving customer performance issues, benchmarking Oracle Applications on various platforms, performance tuning of upgrade scripts, design reviews of applications products, recommendation of init.ora parameters, uptake of new database features in Oracle Apps and performance training for development community.

Responsibilities :

• Triaging and Resolving customer performance issues which includes generating and analyzing trace files, tkprof reports, explain plans, plsql profiler reports etc for forms, concurrent requests and self service pages.

• Analyzing CBO trace for optimizer issues.

• Analyzing Statspack reports and resolving the rdbms performance issues of customers.

• Performance tuning of batch programs/upgrade scripts using pq/pdml.

• Maintenance of performance debug tools like FND_TRACE, FND_STATS.

• Maintenance of Oracle Application (11i and R12) instances used for benchmarking and regression testing.

• Conduct Performance Trainings for developers.

02 Project : Application Technology Group

Role : Sr. Apps DBA

Duration : APR’ 2003 – SEP’ 2005

ATG is responsible for developing the core components of Oracle E-Business Suite like CP, AOL, FWK and WORKFLOW etc. Our Team was maintaining more than 50 different environments (Oracle Applications Instances) which are having all versions of Oracle Applications starting from 11.0.3 to 11.5.10 in all flavors of Unix (Linux, Solaris), having all flavors of database (8.1.7 /9.2.0.5/ 10gR2).

Responsibilities :

Installation and Configuration of Apps Instance

• Installing Oracle Applications single node and multi nodes for all the versions of Oracle Applications (11.5.6, 11.5.7, 11.5.8, 11.5.9 and 11.5.10 ) in different platforms

• Installation of Oracle Applications 11.5.10 with RAC on Linux

• Maintenance of Oracle Applications using Ad Utilities (adconfig, adadmin, adpatch, adrelink etc ).

• Upgrade of Individual Oracle Applications product and product families by applying Mini-Packs and Family Packs. Adding additional languages in Oracle Applications and adding additional products in Oracle Applications.

• Upgrading Applications from 11.5.7/11.5.9 to 11.5.10

• Upgrading Databases from 8i / 9i to 9.2.0.6

• Cloning from Hot and Cold Backups using Rapid Clone.

• Configuring multiple middle-tiers for Load Balance.

• Configuring Shared ApplTop

• Converting non-autoconfig enabled installations to Autoconfig Enabled.

• Migration of Oracle Applications tablespaces to new model (OATM)

• Cross Platform Migration of Environments from AIX, Solaris to Linux Boxes.

• Application and Database Performance Tuning.

• Day to day troubleshooting of all the environments which includes fixing all the issues coming in them and supporting the various components of Oracle Applications viz Forms, Apache, Concurrent Manager, reports server etc .

• Taking care of Backups of the Instance and doing recoveries whenever there is required.

• 9iAS/10gAS Installation and Administration.

• Extensive Unix Shell Scripting to automate maintenance and configuration of tech stack components, Cron jobs to automate the backups, monitoring crons, Alerts.

System Administration Activities

• Creating Oracle Applications System users.

• Creating, attaching & modifying menus, requests group, responsibilities to users.

• Creating and configuring alerts

• Creating, attaching & modifying request sets

• Creating Managers, work shifts and requests for them

• Monitoring requests, setting request priority and monitoring users on Apps System

• Reports registration

CMC LTD DEC’ 2000 – FEB’ 2003

01 Client : GE Capital Real Estate, US

Role : Database Administrator/ Backend Programmer

Duration : JAN’ 2002 – FEB’ 2003

GE Real Estate is a leading provider of capital and services to the commercial real estate industry throughout world. ATLAS helps in collecting, analyzing and reporting information related to assets like loans and property. This application forms the backbone of Asset Management Services, which are spread worldwide. It is a three-tier application developed in VB, ASP and Oracle 8i.

Responsibilities :

• Database creation and configuration.

• Manage security of Databases with Roles and Privileges

• Writing of several shell scripts and sql loader scripts to migrate data across databases.

• Import/Export of data from migration database to production database.

• Development of several functions/procedures in PL/SQL.

• Making backup strategies using cold backups as well as export dumps.

• Involved in various complete and incomplete database recoveries.

• Refining of procedures and database queries for optimal performance.

• Performance Tuning and Troubleshooting.

02 Client : National Insurance Co. Ltd

Role : Database Administrator

Duration : DEC’ 2000 – DEC’ 2002

This is a comprehensive package dealing with the business aspects of non life insurance companies. It is broadly divided into seven subsystems namely – Underwriting, Accounts, Claims, System Administration, Query, and MIS. They all in turn deal with the finer aspects of the Insurance business. It is a two-tier application developed in D2k and Oracle 8i. Worked as a Sole Oracle DBA to support 25 client offices located under Delhi region of National Insurance Company Ltd

Responsibilities :

• Installation / Configuration of Oracle Software on server and clients.

• Installation / Configuration of Application Software on server and clients.

• Database creation and configuration.

• Manage security of Databases with Roles and Privileges.

• Configuration of SQL*Net Client on clients.

• Making of batch files for taking backups.

• Involved in various complete and incomplete database recoveries.

• Refining of procedures and database queries for optimal performance.

PERSONAL DETAILS

Visa : H1B

Citizen : INDIA

Contact this candidate