SUMMARY:

• Around 17 years of experience as an Oracle Applications DBA/Core DBA, with major clients like Oracle Corp, Juniper Networks, Confidential Power Systems, Confidential Medical Systems, and National Panasonic.
• Experienced in Oracle Database Management systems, Fusion Middle ware, Siebel, OBIEE, Informatica, DAC, OEM, Oracle EBusiness suite, Engineered systems including Exadata, Exalogic and Exalytics running on various flavors of unix/linux operating systems. Skilled in delivery excellence with rich blend of technical and operational skills and primary focus on customer satisfaction.
• An excellent team player, worked with various Application teams and Infrastructure teams.
• Involved in Implementation, installation, Cloning, Root cause Analysis, Capacity planning, Patching, upgrade, space management issues and User management issues related to Oracle Applications.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris, IBM - AIX, HP-UX, Linux, Oracle Linux, Windows 95 / NT/2000

Hardware: HP 9000, IBM RS/6000, IBM PC's and Compatibles, Exadata Rack X2-2, X2-8, X3-2, Exalogic X3-2, Exalytics

Software/Tools: Siebel, OBIEE, TOAD, ADI, Discoverer 3i / 3.1.44, 4.1,10g, 11g Application Desktop Integrator, OEM, PL/SQL, Dataload

Web Servers/Application Servers: Oracle Application Server, Oracle Mobile / Web Server, Apex, Weblogic

Databases: Oracle 8, 8i, 9i,10g,11g, Real Application Clusters(RAC) 10g, 11g

Oracle Applications: Oracle Applications R12, 11i, 11.x, 10.x

ERP: Oracle Applications R12,11i, 9iAS, 10gAS, Oracle Manufacturing, Financials, Advanced Planning and Scheduling Suite, iPayment, iStore, iProcurement, Workflow, and Inventory

WORK EXPERIENCE:

Confidential

Environment: EBS, FMW, SIEBEL CRM with Oracle 11g

Responsibilities:

• Performance tuning and performance analysis for large oracle data warehouse, database and application tiers.
• Managing customer escalations and ensure SLAs are within control.
• Supported Siebel applications for various customers with call center and loyalty applications.
• Configured Exadata machines
• Extensive monitoring of systems and database using unix shell scripts, scheduling crons such that notification email will be generated on reaching a particular thresold.
• Developed unix shell scripts to send automated AWRs for top sqls consuming user i/o, cpu on a regular basis.
• Various unix shell scripts were written to monitor processes that consume high memory, load avg, cpu on the server to send notifications for appropriate action.
• Database refreshes from ASM to ASM, NAS to ASM, ASM to NAS, RAC to RAC, RAC to Non RAC, Non RAC to RAC
• Upgraded EBS to R12.
• Provide Support on R12 E Business suite, FMW, Siebel, OBIEE.
• Converting EBS and other databases to RAC from Standalone databases.
• Implemented Oracle 10g Data Guard.
• Other responsibilities includes ERP/ Custom Application support, Applying Patches to EBS/DBs, Monitoring daily performance and alerts, On-Call 24/7 and day to day support to end-users.
• Interacted among infrastructure, business owners, application support teams and end partners, in order to keep the databases healthy and ensure the processes and policies are implemented according the guidelines.
• Troubleshoot issues for users, developers and functional experts in Database and Oracle Applications.
• System Administration like create Responsibilities and Users for Oracle Applications and assign to users.
• Worked on OEM in setting up monitoring for internal databases and application services. Which includes setting up alerts by customizing rules based on customer’s requirement .
• Rman backup setup on tape and disk.
• Provide technical and operational reports to management and customer with important metrics in timely fashion.

Confidential, CA

Oracle Applications DBA

Environment: Oracle Apps 11.5.10 and Oracle 8i, 9i,10g

Responsibilities:

• Upgraded Oracle Applications from 11.5.7 to 11.5.10
• Installation of Oracle 8i, 9i, 10g
• Database migration from Oracle 8i to 9i
• Copy/Clone of Oracle application environment using Rapid clone
• Database Refresh
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl etc.
• Applied RDBMS patches using Opatch
• Created a number of database instances for development, testing and production.
• Created and managed the Database objects and schemas
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Creation of unix shell scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
• Application user creation / responsibilities assignment

Confidential, Sunnyvale, CA

Oracle Applications DBA

Environment: Oracle Apps 11.5.9 and Oracle 8i, 9i, 10g

Responsibilities:

• Installation of Oracle 8i, 9i, 10g
• Database migration from Oracle 9i to 10g
• Copy/Clone of Oracle application environment using Rapid clone
• Monitoring Databases
• Database Refresh
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl etc.
• Applied RDBMS patches using Opatch
• Code Promotion and controls.
• Developed Unix Shell scripts to automate database operation andmonitoring.
• Created a number of database instances for development, testing and production.
• Created and managed the Database objects and schemas
• Defining and modifying the application users. Audits on the user logs and periodic reporting for the valid users.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Periodic monitoring on apps passwords and password reset controls.
• Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
• Reviewing the day to day maintenance documents with the team and knowledge sharing on the issues.
• Application user creation / responsibilities assignment

Confidential, Atlanta, GA

Senior Oracle Applications DBA

Environment: Oracle Apps 11.5.3, 11.5.8 and Oracle 8i, 9i

Responsibilities:

• Installation of Oracle 8i, 9i
• Cloning
• Upgraded Oracle Applications from 11.5.3 to 11.5.8
• Upgraded oracle from 8.1.7.3 to 8.1.7.4
• Monitoring Databases
• Upgraded 11i FA.F to 11i FA.M
• Database Refresh
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl etc.
• Code Promotion and controls.
• Successfully implemented APS (Advanced Planning and Scheduling) application for Confidential Power systems.
• Defining and modifying the application users. Audits on the user logs and periodic reporting for the valid users.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Registering and managing the printers.
• Periodic monitoring on apps passwords and password reset controls.
• Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
• Reviewing the day to day maintenance documents with the team and knowledge sharing on the issues.
• Application user creation / responsibilities assignment

Confidential

Oracle Applications DBA

Environment: Oracle Apps 11.5.8 and Oracle 8i

Responsibilities:

• Migrating Seed Data using FNDLOAD
• Installed Oracle 8i, 9i
• Database refresh
• Copy/Clone of Oracle application environment using Rapid clone
• Application AOL object setup (users, menus, responsibilities, forms, reports, request groups, request set etc
• Maintaining Security by implementing menu/function exclusions
• Used Dataload tool for creating/assigning Custom responsibilities
• Trouble-shooting of all oracle application problems
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl etc

Confidential

Environment: Oracle Apps 11.5.7 and Oracle 8i

Responsibilities:

• Installing/Configuring oracle application on various platforms.
• Maintaining and tuning multiple database and file system of Oracle application hosted by Oracle EStudio, USA
• Upgrade Oracle Application to current releases and current product-level with applying maintenance packs and Minipacks.
• Trouble-shooting of all oracle application problems.
• Copy/Clone of oracle application environment.
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl, adaimgr, adrelink, adsplice etc.
• Application AOL object setup (users, menus, responsibilities, forms, reports, request groups, request set etc.) and Purge AOL tables.
• Migration from SUN Solaris to Linux apps 11.0.3 to 11.5.7
• Opened the iTARs to resolve the Application issues.
• Installed the Localization Patches and worked with Oracle Corporation to resolve the localization issues.

Confidential, Milwaukee, WI

Senior Oracle Applications DBA

Environment: Oracle Apps 11.5.3 and Oracle 8i

Responsibilities:

• Extending development support to Confidential Medical Systems using Oracle 8.x
• Upgraded Databases (including Production, Test and Development databases)
• Created a number of database instances for development, testing and production.
• Created and managed the Database objects and schemas
• Working with ADSM and NetBackup server in taking database backups and restores
• Working with EMC Time finder technology to take the hot backups and cold backups.
• Scheduled hot and cold backups using AppWorx scheduler
• Tuned oracle databases
• Moved databases between machines
• Installed database patches and upgraded oracle
• Worked with oracle corporation and opened TARs to resolve a number of bugs
• Documentation of the outages of production databases
• Reorganization of databases, monitoring tablespaces, extents, refreshing Test and development databases with Production data, creation of new instances including applications on Application tier and forms on Forms tier.
• Used the AD utilities to administer the Applications
• Created and monitored the Application Users, Responsibilities, Functions and Menus.
• Resolved the Concurrent Managers issues and monitored them
• Applied the patches and upgraded the Applications
• Installed the Localization Patches and worked with Oracle Corporation to resolve the localization issues