RANGE OF EXPERIENCE

Close to 5 years of experience as an Oracle APPS DBA with good hands on in administering of Oracle Databases, Tools and Oracle ERP Applications.Having a valid EAD to work in USA.

Well Exposed to Oracle Consulting Practices and Procedures in Administration that includes: -

• Installation
• Configuration
• Upgradation
• Remote administration and support of Oracle Databases on major Operating Systems.

Worked on Technologies:

• RAC
• ASM
• Shared APPL_TOP
• Standby Setup for Primary, and perform the switch over and switch backup
• Patching the Different Applications at Two Tiers, Three Tiers
• Installation of new Oracle 11i Application (1159), (11510)
• Excellent Remote Systems Support and Troubleshooting Exposure
• Cloning of the Applications using Rapid Clone(RAC to RAC clones, Single node, multi node clones, Database Refreshes)
• Configure / Setting up PCP (Parallel Concurrent Processing) for multi node, RAC environments
• Load Balancing
• Monitoring, Configuration, etc using OEM in Oracle 10g
• Maintain, Administer Oracle Databases.
• Worked with SQL servers
• Experience in Cloning using Ad clone utility and Adcfgclone, Very well versed in Rapid Install, DataInstaller, AdPatch, Adadmin, Adrelink, Adctrl utilities for Oracle Applications
• Managing database Tablespaces, datafiles, users, tables

* As Part of this job, provide the support 24/7 for the Production database for any related issues along with the handling the alerts like locks, temp usage etc.

* Perform the routine DBA activity like Cloning, patch analysis, patching (Both the DB and APPS patch), database refreshes, Upgrades (Both the DB and APPS side)

* Performing the backups both the cold and hot backups. cold backups through through tar and gzip and rman. hot backups mainly through rman and BCV split backup.

*Also handled Shift Lead Responsibilities wherein we have to manage and monitor the tasks performed by the team, troubleshoot issues and handle escalations.

EDUCATIONAL QUALIFICATIONS

• Bachelor of Engineering.
  B.E (Computer Science)

EMPLOYMENT HISTORY

Associate Consultant (Jul 2004 - Jul 2008).
Confidential
IT Analyst (Jul 2008 - Feb 2009)

Trainings

• Training 11i ERP Suite , 9i databases , 10G databases ,Performance Tuning .
• Trained on Rac and ASM

Project Experiences

Confidential (TX) Jul 2008- Feb 2009

Confidential., a Confidential, is a leading provider of innovative document management systems and services, enabling customers to improve document workflow and increase efficiency.

Project Type: Maintenance / Support
Role: Oracle Apps DBA

Responsibilities:

• Monitoring the database activity and check the errors.
• Resize the Tablesapce if it’s required.
• Checking the locked Objects and unlock.
• Database refresh.
• Providing DBA Support to ensure 24x7 DBA support
• Trouble-shooting of all oracle application problems
• Copy/Clone of oracle application environment
• DB/Application Backup
• RAC to RAC clones
• RAC to Single/ Multi node clones
• Multi nodes to Single, Multi to Two Node clones
• Running RDA scripts to find out system specific details
• Running APPS_RDA scripts to find out Application related details
• Handling of remedy tickets
• Performance related issues
• Issues with concurrent managers and long running jobs .
• Also worked with sql servers

Environment: Oracle Application 11.5.9 on AIX (RAC)

Confidential (Elyria) Mar 2006 - Jun 2008

Confidential is the world\'s leading manufacturer and distributor in the $8.0 billion worldwide market for medical equipment used in the home.

Project Type: Maintenance / Support
Role: Oracle Apps DBA

Responsibilities

• Providing DBA Support to ensure 24x7 DBA support.
• Trouble-shooting of all oracle application problems.
• Copy / Clone of oracle application environment.
• DB / Application Backup
• Starting and stopping of mwa services
• Upgrade of db from 9206 to 9207
• Applying major Patches, security patches
• Troubleshooting of Concurrent Mangers related problems
• Regular monitoring of production as well as Test application
• Troubleshooting performance related issues .
• Implementing shared Appl Top
• Implementing load balancing on multi nodes applications
• Have production database support experience and used Oracle MetaLink for SRs

Environment: Oracle Application 1159 Multi Node, on AIX and linux

Confidential (NJ) Jan 2007 - Jun 2008

Founded byConfidential in 1993 in New Jersey, American Tire & Auto Care has taken pride in providing exceptional service and superior value to its customers for over a decade now.

Project type: Production Systems / Upgrade
Role: Oracle APPS DBA

Responsibilities

• Providing DBA 24x7 DBA support.
• Creating Custom Top for the client Requirements.
• Daily Monitoring all the application Systems.
• Trouble-shooting of all oracle application problems.
• Copy/Clone of oracle application environment.
• Custom Top Creations and DB upgrade(9i to 10G).
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl, adaimgr, adrelink, adsplice etc.
• Interacting with oracle support to resolve application issues.

Environment: Oracle 10G, Oracle Application 11I

Confidential: (AZ) Apr 2005 - Jul 2007

Confidential is one of the most desired and trusted brands for houseware and storage products today, making quality and attractive products consumers need. Confidential produces a wide range of innovative solutions that include food containers, dish drainers, laundry baskets, wastebaskets, storage boxes, drawer carts, cabinets and shelving.

Project type: Production Systems
Role: Oracle APPS DBA.

Responsibilities:

• Maintaining PROD, Test, Dev environments
• Resize the Tablespace if it’s required.
• Checking the locked Objects and unlock.
• Database / Application Backup and restore
• Trouble-shooting of all oracle application problems
• Clone of oracle application environment
• Applying major patches in the system
• Troubleshooting rman related issues.
• PCP Configuration
• DR maintenance
• Alert monitoring

Environment: Oracle Application 11510.2 on AIX

Confidential, (NJ) Dec 2005 - Oct 2006

Confidential was founded in 1951 and is based in Ramsey, New Jersey. The company operates retail vacation stores in New York, New Jersey, Pennsylvania, Delaware, Maryland . Florida, Rhode Island, Connecticut, Massachusetts, New Hampshire, Illinois, and California, as well as in Washington, District of Columbia.

Project Type: Maintenance / Support
Role: Oracle Apps DBA

Responsibilities:

• Providing DBA Support to ensure 24x7 DBA support.
• 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, vertex, quantum etc.
• Monitoring the all-running Instance to ensure everything working.
• Tablesapce Maintenance like adding the increase the size of the data files.
• Interacting with oracle support to resolve application issues.

Environment: HP-Unix (RAC), Oracle 9i, Oracle Application 11I (ERP, Workflow & CRM)

Confidential (NY) Jan 2006 - Dec 2006

Confidential is one of the largest specialty music and video retailers in the United States. Founded in 1972, the Company currently operates over 800 stores in 49 states, the District of Columbia, Puerto Rico and the U.S. Virgin Islands

Project Type: Maintenance / Support
Role: Oracle APPS DBA

Responsibilities:

• Monitoring the database activity and check the errors.
• Database Backup and restore
• Handling of hot and cold backups
• Tracking of unusable indexes and rebuilding of indexes .
• Reorg of tables
• Providing DBA Support to ensure 24x7 DBA support

Environment: 10G database Linux

Confidential (FL) Jul 2005 - Dec -2005

Confidential provides dual diagnosis treatment center for eating disorders and alcohol and drug rehab.

Project Type: Maintenance / Support
Role: Oracle APPS DBA

Responsibilities:

• Providing DBA Support to ensure 24x7 DBA support.
• DB Backup.
• Applying db related Patches
• Backup and restore via rman
• Regular monitoring of production as well as Test application
• Running RDA scripts to find out system specific details.

Environment: Database 10G, IBM AIX

Confidential (Herndon,VA) Jul 2005 - Jul 2006

Confidential is the trusted provider of solutions and services that protect and secure personal identities and assets.

Role: Oracle APPS DBA

Responsibilities:

• Providing DBA Support to ensure 24x7 DBA support.
• Trouble-shooting of all oracle application problems.
• Copy/Clone of oracle application environment.
• DB/Application Backup, cold backups
• Applying major Patches
• Regular monitoring of production as well as Test applications

Environment: Oracle Application 1159 Multi Node, IBM AIX

Confidential (CA) April 2005 - March 2006

Confidential provides a vast array of healthy, high-quality foods, including fruit, vegetable and tomato products, as well as broths

Role: Oracle APPS DBA
Responsibility

• Alert monitoring
• Resize the Tablesapce if it’s required.
• Checking the locked Objects and unlock
• Troubleshooting database related issues
• Detecting the long running jobs and taking the necessary actions

Environment - 10G database.

Confidential (ND) Jul 2004- March 2005

Confidential is an acclaimed leader in developing and providing scientific and innovative healthcare.

Role: Oracle APPS DBA
Responsibility

• Alert monitoring
• Resize the Tablesapce if it’s required.
• Checking the locked Objects and unlock
• Troubleshooting database related issues
• Detecting the long running jobs and taking the necessary actions
• Patching
• Cloning

Environment - 10G database.

Skills Summary and Trainings

Software, Tools & Languages:

• Export/Import, OEM, Terminal Client, VNC, VPN, TOAD.

Database/ ERP:

• Oracle 9i/10g
• Oracle Applications 11i
• Discoverer, Oracle Apps,.

Operating Systems:

• Windows 9x/2000/XP, NT 4x, LINUX, Sun Solaris 8/9, Red Hat Linux, AIX, HP- UX.