Summary

• About 9 years of experience in Administrating Oracle Production Databases and Oracle Application Administration as well as in Design Development, testing and implementation using Oracle and Unix as a Apps DBA, Oracle DBA, Database Architect, Systems Administrator in Customer Support environment.
• Oracle Certified Professional OCP 11G and OCP Oracle 9i DBA-Track
• ITIL V3 foundation certified
• All of my experience knowledge has been gained across Oracle Application installation, Application upgrade, Apps Cloning, Database Upgrade, monitoring, Trouble shooting, System administration of Oracle Apps, Oracle database Administration, and a wide range of operating systems Sun Solaris, Linux, WindowsNT, windows2000.
• Competency in application of patches, cloning Oracle Applications and database from production/ non-production servers, creating clone application as a user trail/ development for application testing and training, maintaining objects using ad admin utility, maintaining object space and table space in different table space, and troubleshooting the production database.
• Proficient in performing regular DBA activities such as backups, modify databases structures, and managing databases database space management backup and recovery of database and database objects process for data backup and restoration monitoring database for availability and performance optimization.
• Strong experience in Installation, Setup, Implementation, customization product support of Oracle Applications R12.
• Supported as system admin on different platforms like AIX, Sun Solaris, HP-Tru 64,Linux and Windows
• Adept in maintaining and managing control files, online redo log files, tablespaces and data files, tables, indexes, users, and roles.
• Coordinating with Oracle Tech support, Registration and follow-up of TARs.
• A highly motivated, energetic individual, and a team player with excellent analytical and problem solving, communication, and interpersonal skills.
• I have both Technical and Management abilities with zeal of learning and empowering myself with self motivation.

SKILL SETS

• OPERATING SYSTEMS: MS DOS, Windows 98/ XP/ ME, Unix, Linux, Red Hat
• LANG/ TECH: SQL, PL/SQL
• ERP's : Oracle Applications 11.x/ 11i eBS, Financials, HR, OPM, Sys Admin and R12
• DATABASES: Oracle 9i, 10g, 11g
• TOOLS: Oracle 10g OEM Grid, Oracle Applications Manager, Quest TOAD , SQL Loader, Putty, RMAN, SQL Loader, STATSPACK, TKPROF, Data Loader
• Project -Confidential Lexington, Kentucky
• Oracle RDBMS - Oracle 10g 11g
• Environment - Oracle Applications 11.5.10.2
• Oracle Database 10g
• Linux RHEL 5 64 Bit
• Oracle Enterprise Manager 10g R4, 11g R1

Lead Oracle APPS DBA

Responsibilities:

• Working as a dedicated resource for client Tempur Pedic ,handling multiple instances for Production, Development and Test environment.
• Performing application cloning periodically using rapid clone hot backup as well as cold backup .
• Database Refresh
• Maintenance and Troubleshooting of Oracle Applications and Database.
• Patch analysis one-off to family packs
• Applied application patches using adpatch.
• Well versed in adadmin, adpatch, adctrl, admrgpch, AutoConfig utilities.
• Performed concurrent manager troubleshooting.
• Troubleshooting of Oracle Apps DBA technical problems and worked on solutions
• Tar support - raising tar with Oracle Support Services in order to resolve an issue.
• Handled and worked with Offshore Remote DBA team operating from Noida, Pune and Hyderabad offices.

Confidential

• Environment - Oracle Applications 11.5.10.2
• Oracle Database 10g
• Linux RHEL 4 64 Bit
• Sun Solaris Sparc
• Oracle Enterprise Manager 10g R4, 11g R1

Sr. Oracle APPS DBA

Responsibilities:

• Worked on cross platform migration project from Sun Solaris onto Linux FlexFrame servers.
• Oracle Application 11.5.10.2 Solaris, Linux.
• Planning and controlling system downtime for maintenance work
• Supported the PROD enviornment and took the KT for various customized processes.
• Patching of Application and Database environments
• Communication with Oracle Support for TAR and providing solutions to the team members
• Prepare automation scripts to automate environments' monitoring
• Status update on daily basis

Confidential

• Oracle RDBMS - Oracle 9i 10g
• Environment - Oracle Applications R12
• Oracle Database 10g
• Sun Solaris Sparc

Oracle APPS DBA

Responsibilities:

• Worked on the implementation of GL and AP module.
• Also took the KT for McDonalds and worked on their Prod environment
• Monitoring of Oracle Production Environment
• Supported all databases and application for the client 12.1.1.1 Application Environment including SSO and Portal setup
• Interaction with client/users on various issues
• Administration of Databases backups, logs, schemas, tablespaces, Indexes
• Preparing Production Clones for testing and development purposes using Rapid Clone
• SYSADMIN tasks creating users, responsibilities etc.
• Develop proactive processes for effective production support

Confidential

• Oracle RDBMS - Oracle 9i 10g
• Environment - Oracle Applications 11.5.10.2
• Oracle Applications 11.5.9
• Oracle Applications R12
• Oracle Database 10g
• Oracle Database 9i
• Linux, Sun Solaris, AIX

Oracle APPS DBA

Responsibilities:

• Working on Oracle Applications Remote DBA Projects as an IT Consultant.
• Serving as an Oracle Applications DBA for FORTUNE 500 US clients McDonalds, CompuCom, Yamaha, and Kelly Moore . Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, fire fighting, developer/integrator relations, script development, documentation and DBA training.
• Proactive Database Monitoring for 24X7 supports for working on alerts and issues, instantly coming from a monitoring tool, named RMON, developed by Fujitsu Team.
• Currently involved in working with tickets for patching, cloning, migration and tuning of Oracle Database.
• Working on ticket assigned by client DBA.
• Assisting in the administration and day-to-day operations of different Databases to provide user support.
• Working on different tasks on priority basis.
• Bouncing Oracle Database and application services.
• Applying patches DB Application after PPA.
• Creating database links.
• Cloning of Oracle Application instances with rapid clone.
• Checking Daily Backup, Disk Space management and user management.
• Modifying Shell Scripts to cater the client's adhoc requests.
• Applied CPU Patches on the Database Tier Apps tier.

Confidential

Team Developer

Responsibilities:

• Worked as a Team Developer
• Worked as an Internal Auditor for various processes handled by the client
• Worked with the Transaction Accuracy Audits TAA process, which was meant for checking the internal quality of the client
• Worked with this process that performed an internal audit of all the events DC, HW, and triggers carried out by client's employees called participants, which was administered by the client
• Mentored for the newly hired associates in the process SME
• Worked on customer centricity
• Participated in setting up and streamlining the new processes for the client TAA
• Created many process improvements for saving the timing and reducing the cost as the member of Quest Drive team
• Served as a Member of Iris, which was a monthly magazine for our cluster
• Received frequent appreciation mails from TAA US team for quality work.