Summary

• Have around 13 years of experience as Oracle Applications 11i/R12 DBA Oracle DBA, providing 24x7 support of both Production Development on Various Platforms.
• Experienced in Oracle Apps Administration and Sysadmin tasks
• Installation, Configuration Deployment of Oracle E - Business Suite 11i/R12.
• Experience in Oracle Financials modules GL, AP, AR, PO, CM,
• Implemented Oracle Apps 11.5.10.2 with Oracle RAC.
• Implementation of High Availability solutions with Oracle 11g/10g RAC, Physical and Logical Standby Databases Data Guard .
• Trouble shooting Forms server, Reports server, Apache server, Jserv, Jinitiator and Workflow.
• Expert in 11i Apps Cloning, Implemented new techniques for Apps Refreshes.
• Applied Patching, Upgrades, framework, SSL For 11i Apps.
• Application and Concurrent Manager load-balancing and Failover, Shared APPL TOP configuration.
• Excellent experience in Installation of Oracle 8i, 9i, 10g in UNIX/LINUX and Windows environment.
• Proficient in Database and Applications Administration activities such as Upgrades, Patches, TAR support, Backup and Recovery, Performance tuning, script development.
• Effective troubleshooting of Database and Performance problems.
• Worked with development teams and data administration staff to enhance Database and application performance.
• Experience with Data Modeling.
• Extensive performance tuning of Concurrent programs, Concurrent Mangers and SSWA
• Very strong in Auto Patch, Upgrade, cloning.
• Expertise in using ADPATCH, ADADMIN, ADCTRL, ADRELINK, ADIDENT, ADMERGE, ADCONFIG, ADMRGPCH, ADLICMGR PTS tools.
• Experience on Multi Org
• Production DBA Experience on Oracle releases 11g/10g/9i/8i
• Excellent knowledge in installation and maintenance of Oracle Application Server
• Expertise in configuring various oracle application modules like Discoverer, Workflow
• Management of schemas, objects Partitioning the tables indexes.
• Experience in a variety of different environments like HP-UX, SUN SOLARIS, Linux and Windows.
• Experience in managing very large databases Multiple TB of size .
• Experience in administration of large Oracle database running in SAN environment, setting up databases for bank environment.
• Write Korn shell scripts to monitor and maintain the Oracle Applications database.
• Performed backups and tested crash recoveries using conventional Hot Cold backups and RMAN.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM
• Expertise in installing, maintaining and administering Oracle Applications 11i 11.5.8, 11.5.9, 11.5.10, R12 instances.
• Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite.
• Worked on most of the Application modules like HR Payroll, Financial, AR, AP, PO, IREC, OE, INV, OM, Manufacturing, Workflow and SSWA etc.
• Operating Systems: Sun Solaris, Suse Linux, Windows W2K/NT/98/95
• Databases: Oracle 9i/8.x
• ERP: Oracle Applications 10, 11 11i
• Web Servers: Apache web server 1.3, Oracle Application Server
• Tools/ Packages: Oracle 9i/8i, Putty, Oracle Enterprise Manager, SQL Plus, SQL Loader, Import/Export, TOAD, MS Office Outlook, Cute FTP, Telnet, Kintana

Project Experience:

LeapFrog Enterprises

Role s: Oracle Applications 11i DBA

Environment: Oracle Applications 11.5.10.2, R12, Sun Solaris, Oracle 10g, Datagaurd, PL/SQL, TOAD, Secure Shell Client, PVCS

Description: Supporting all the Production, Test, Development instances along with Quarter Releases of both ERP Non-ERP instances.

Personal Responsibilities / Achievements:

• Provide assistance to project teams for technical issues, diagnosing operational issues and resolve them.
• Troubleshooting and resolving performance issues.
• Create tablespaces, tables, and users for custom built applications.
• Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database.
• Managing all the production, development, test, QA instances of both ERP Non-ERP Datawarehouse databases .
• Cloning, Patch Management includes analyzing, documenting. Applying patches.
• Experience tuning work shifts/ queues and monitoring concurrent managers / workers to watch for runaway jobs and keeping the throughput high.
• Responsible for monitoring the scheduled jobs, cron jobs and space management.
• Work with Oracle Support on SEV 1 TARS
• Provide day-to-day 24/7 Production support for users application databases.
• Alert Handling.
• In the process of upgrading to R12.

Confidential

Role s: Oracle Applications 11i DBA

Environment: Oracle Applications 11.5.X 4/7/8/9/10, R12, Sun Solaris, Linux, HP, Oracle 9i/8i/10g, RAC, Datagaurd, PL/SQL, TOAD, Secure Shell Client, PVCS

Description: Supporting all the Production, Test, Development instances along with Quarter Releases of both ERP Non-ERP instances.

Personal Responsibilities / Achievements:

• Provide assistance to project teams for technical issues, diagnosing operational issues and resolve them.
• Resolving performance issues, SSO related issues and RAC issues.
• Create tablespaces, tables, and users for custom built applications.
• Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database.
• Patch Management includes analyzing, documenting. Applying patches using CoPatch Customized tool of Cisco .
• Managing the more than 1000 production, development, test, QA instances of both ERP Non-ERP.
• Cloning of various instances using Cisco custom developed perl script smart clone .
• Experience tuning work shifts/ queues and monitoring concurrent managers / workers to watch for runaway jobs and keeping the throughput high.
• Responsible for monitoring the scheduled jobs, cron jobs and space management.
• Work with Oracle Support on SEV 1 TARS
• Provide day-to-day 24/7 Production support for users application databases.
• Alert Handling.

Confidential

Role s: Oracle Applications 11i DBA

Environment: Oracle Applications 10.7, 11.0.3 11.5.X 7/8/9/10, Sun Solaris Sun Fire 3800, 4800, 6800, Oracle 10g/9i/8i, PL/SQL, TOAD, Datagaurd, Net Team, PVCS

• Description: Supporting all the Production Instances
• GE Energy
• GE Aviation
• GE Rail
• GE Wind Germany

Personal Responsibilities / Achievements:

• Provide assistance to project teams for technical issues, diagnosing operational issues and resolve them.
• Maintain Oracle schemas.
• Create tablespaces, tables, and users for custom built applications.
• Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database.
• Creating Responsibilities, Menus, Users, and Printers and maintaining User Security.
• Expertise in Installation of Oracle Applications R11i Single Node and Multi-Node
• Patch Management includes analyzing, documenting and applying patches also using OAM.
• Managing the more than 115 13 production, development, test, QA instances for various GE Energy, GE Aviation Wind Germany, US, Europe and ASIA Pacific
• Cloning the production instance with Rapid clone and Adclone utility.
• Experience tuning work shifts/ queues and monitoring concurrent managers / workers to watch for runaway jobs and keeping the throughput high.
• Responsible for monitoring the scheduled jobs
• Migrating all custom programs and reports to production instances. This involves enforcing naming standards, maintaining the custom application top, and setting up concurrent requests.
• Trouble shooting forms and reports with oracle support
• Work with Oracle Support on SEV 1 TARS
• Provide day-to-day 24/7 Production support for users application databases.
• Alert Handling.

Responsibilities:

• Maintained Oracle Applications Release 11i on HP UX and RedHat Linux.
• Upgraded Oracle Applications from 11.5.8 to 11.5.9.
• Upgradation of Oracle databases from 8i to 9i
• Upgraded and applied patches as and when required. Database Refreshes from Prod to Dev. Troubleshooting Day-to-Day Users Issues in various modules.
• Defining Customized Transaction Concurrent Managers their work shifts and specialization rule. Monitor and Troubleshooting Concurrent Manager Issues.
• Collect and analyze performance statistics for resource consumption and performance anomalies. Managing Tablespaces, Datafiles, Rollback segments, Temporary TBS.
• Cloning of Oracle Applications 11.5.8 with Autoconfig.
• Creation of users, assigning responsibilty, creation of customs menu's and responsibility for Oracle Apps 11i. Responsible for automating the scripts for backups, alert checking, database and Appl-top refresh
• Patching and automating the AD utilities.
• Code Migration from PVCS to the various instances, migration of Concurrent Programs, Value sets and Request Sets using FNDLOAD.
• Provide assistance to the client DBAs on technical issues when ever required. Diagnosing operational issues and resolve them.

Confidential

Role s: Consultant Oracle Applications 11i DBA

Environment: Oracle Applications 11.5.10, Oracle 9i, PL/SQL, TOAD, Redhat Linux.

Description: This is a KPMG project. Implementation of 11.5.10 Oracle Applications and upgrade to 11.5.10.2

The Oracle Applications 11.5.10 with Finance and HRMS modules to be implemented on Redhat Linux AS 3.0 Operating System. This needs to be upgraded to 11.5.10.2 Oracle Applications. The second phase of the project includes customizations and setups, which also includes production support of the whole system for a period of time.

Responsibilities:

• Installation of 11.5.10 Oracle Applications.
• Upgrade to 11.5.10.2 Oracle Applications.
• Supporting the functional consultants for the functional setups.
• Creation of additional Responsibilities, Menus, Users, Printers, and Reports.
• Cloning Applications Tops from Production to Development and Test Instances.
• Train the client DBAs on the Production System, technicalities of 11.5.10.2 Oracle Applications.
• Train the client DBAs on backup and recovery procedures, applying patches, monitoring tablespaces and users.
• Prepare the documentation on installation of 11.5.10 Oracle Applications, Cloning of Oracle Applications.
• Worked with Oracle on SEV 1 TARS
• Patch Administration.
• Provide assistance to the client DBAs on technical issues when ever required. Diagnosing operational issues and resolve them.

Confidential

Role s: Consultant Oracle Applications 11i DBA

Environment: Oracle Applications 11.0.3 11.5.10, Oracle 8/8i/9i, PL/SQL, TOAD, WinNT, Win2K, Win2003.

Description: Upgrade from 11.0.3 to 11.5.10 Oracle Applications

The Oracle Applications 11.0.3 with Fixed Assets Module was implemented in 1999 on Windows NT Operating System with 8.0.5 Database. This needs to be upgraded to 11.5.10 Oracle Applications on Windows 2003 Operating System with 9.2 Database. The second phase of the project includes customizations and setups, which also includes production support of the whole system for a period of time.

Responsibilities:

• Upgradtion of Oracle Applications.
• Creation of additional Responsibilities, Menus, Users, Printers, and Reports.
• Cloning Applications Tops from Production to Development and Test Instances.
• Train the BSF DBAs on the Production System, technicalities of 11.5.10 Oracle Applications.
• Train the DBAs on backup and recovery procedures.
• Prepare the documentation on upgradation, new features in 11.5.10 Oracle Applications, Cloning of Oracle Applications.
• Worked with Oracle on SEV 1 TARS
• Patch Administration.
• Provide assistance to the BSF DBAs on technical issues when ever required. Diagnosing operational issues and resolve them.

Confidential

Role s: Oracle Applications 11i DBA / System Administrator

Environment: Oracle Applications 11.5.X 7/8/9, Sun Solaris Sun Fire 3800, 4800, 6800, Oracle 9i/8i, Kintana, Windows2000, PL/SQL, TOAD, Smart Team, PVCS

Description: Supported Five Implementations

• GE Power Controls Phase - 3 Financials, Distribution, OM, and Manufacturing Modules
• GE Supply China Financials, Distribution, OM, and Manufacturing Modules
• GE Mexico Equipo Financials, Distribution, OM, and Manufacturing Modules
• GE Sensing Financials, Distribution, OM, and Manufacturing Modules
• GEPC India Localization Upgrade

Personal Responsibilities / Achievements:

• Cloning the production instance with Rapid clone and Adclone utility.
• Managing the more than 25 4 production, development, test, QA instances for various GE Consumer Industrial and GE Infrastructure in US, Europe and ASIA Pacific
• Patch Management includes analyzing, documenting and applying patches.
• Expertise in Installation of Oracle Applications R11i Single Node and Multi-Node
• Involved in Upgradation of Oracle Applications from 11.5.7 to 11.5.9 as a team member
• Experience tuning work shifts/ queues and monitoring concurrent managers / workers to watch for runaway jobs and keeping the throughput high.
• Creating Responsibilities, Menus, Users, and Printers and maintaining User Security.
• Migrating all custom programs and reports to production instances. This involves enforcing naming standards, maintaining the custom application top, and setting up concurrent requests.
• Responsible for monitoring the scheduled jobs
• Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database.
• Create tablespaces, tables, and users for custom built applications.
• Maintain Oracle schemas.
• Provide assistance to project teams for technical issues, diagnosing operational issues and resolve them.
• Trouble shooting forms and reports with oracle support
• Worked with Oracle Support on SEV 1 TARS
• Provide day-to-day 24/7 Production support for users application databases.
• Patch analysis, patch download and monitoring workflow background engine using Oracle Application Manager.

Confidential

Role s: Oracle Applications DBA

Environment: Oracle Applications Release 10.7SC/11.0.3/11i, Oracle 9iAS, Oracle Databases 7.3.4/8i/9i, SUN-Solaris 5.8, Linux, WinNT/2K, Forms 6i/9i, Reports 9i.

Responsibilities:

• Provide assistance to project teams for technical issues, diagnosing operational issues and resolve them.
• Maintain Oracle schemas.
• Create tablespaces, tables, and users for custom built applications.
• Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database.
• Patch Management includes analyzing, documenting and applying patches.
• Installation of 10.7/11.0.3/11.5.8/11.5.9 Oracle Applications and Oracle 9iAS.
• Upgrade of Oracle Applications and the Databases.
• Creation of additional Responsibilities, Menus, Users, Printers, and Reports.
• Cloning Applications Tops from Production to Development and Test Instances.
• Resolve Concurrent Request issues.
• Maintain Oracle Applications using AD utilities.
• Troubleshoot Jinitiator issues.
• Experience tuning work shifts/ queues and monitoring concurrent managers / workers to watch for runaway jobs and keeping the throughput high.
• Responsible for monitoring the scheduled jobs
• Migrating all custom programs and reports to production instances. This involves enforcing naming standards, maintaining the custom application top, and setting up concurrent requests.
• Trouble shooting forms and reports with oracle support
• Worked with Oracle Support on SEV 1 TARS

Confidential

Role s: Oracle DBA and Applications DBA

As an employee of Fujitsu ICIL, worked as Oracle DBA around 2.5 years and more than 6 months as Oracle Applications DBA. Worked on clients CK Tang, Compaq and Sony Electronics. Involved in implementing Oracle applications 10.7 SC for Sony electronics

Responsibilities:

• Installation, configuration and upgrading of Oracle server software, related products and applying the patches for database.
• Installed and Configured Oracle Applications 10.7 SC to implement Oracle manufacturing and Supply Chain Financial Modules.
• Supported Oracle Applications implementation team.
• Migrated Oracle Databases from 7.x to 8i on various Operating Systems.
• Implemented the database tuning to improve the performance of the database using the Perfstat package. Highly experienced in troubleshooting problem queries that take long.
• Application tuning using Hints, Explain Plan, SQL trace, TKPROF using SQL Navigator Expert Tuning, Index Tuning utility.
• Heavily involved in developing and maintaining partitioned database tables, Tablespace creation, Bitmap Index, Index rebuilding and developed PL/SQL packages to archive the Partitioned tables.
• Monitored and allocated share memory, table space as needed and managed replicated servers. Configured the database in the ARCHIVE LOG mode in order to run the ARCH process for archiving updates and changes to the database.
• Monitored backups, space usage, and user activity on daily basis and Performed daily hot backups and weekly Cold backups using RMAN.
• Altered, modified, Partitioned, dropped, created database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM.
• Developed the script files for monitoring the sizes of table spaces, Rollback segments, Temporary segments and percentage of it sizes changing per day.

Confidential

Team Leader

Worked as a Team Lead in Brigade Corporation. Brigade Corporation provides online customer support for clients like Compaq, MyPoints etc.