Over 8 years of expertise handling Oracle databases as an Applications DBA, Applications System Administrator, Database Administrator and Oracle Developer. Main emphasis is on Administration of Oracle Applications and Oracle databases on UNIX (IBM-AIX, HP-UX, Sun Solaris, and Linux). Well versed with the designing, configuring, maintenance, tuning and installation of Oracle databases, Oracle Applications release 11.5.10, 11.5.10.2, 12.0.4, and 12.0.6. Worked extensively with database installation, and administration of Oracle (10g/9i/8i/8.x), Developer 9i/6i/2000 and Oracle utilities. Strengths are in designing strategies for tuning the database, monitoring the system through application and performance tuning. Has good understanding of relational databases and client server computing models and security privileges and also good working knowledge on SQL, PL/SQL. Microsoft networks, TCP/IP and Oracle SQL*Net. Has an excellent academic and technical background along with good Team player capabilities, good communication and interpersonal skills.

AREAS OF EXPERTISE

• Database Design and Administration for Oracle Applications Releases like 11.0.3 , 11i, 12.0.4 and 12.0.6
• Successfully upgraded the Oracle Applications from 11.0.3 and 11i Releases to 11.5.10.2.
• Experience in various releases of Oracle Applications Successfully upgraded the Oracle Applications from 11.5.10.2 to 12.0.6 and 12.0.4 to 12.0.6
• Oracle (10g, 9i, 8i , 8.x) installation and Database creation and Administration
• Expertise in upgrading the RDBMS Databases from Release 9i to 10g
• Database backup and Recovery strategy implementation and User administration and Auditing.
• Experienced in EMC, VERITAS, Comvault (NAS & SAN) Storage Technologies and backup solutions.
• Expertise in RMAN for backup and Recovery
• Excellent skills in SQL, PL/SQL, UNIX scripting, tools.
• Excellent knowledge of Oracle Applications, Monitoring of Oracle Applications
• Experienced in TAR Tracking and Remedy Support..
• Expertise in Cloning of databases from RAC to RAC and from RAC to non RAC Databases
• Experienced in database administration on Unix and windows NT
• Experienced in Forms Load Balancing, Apache/Jserv upgrades SSL setups.
• Experienced in Multi reporting Currencies, Multi Language Support and Multi Org setup.
• Worked active and passive cluster environment.
• Implemented 10g Data Guard set-up for E-Business Suite (EBS) - Databases High Availability
• Expertise in Cloning of databases from Single-node to multi-node and multi-node to multi-node
• Implemented 10g OEM Grid Control and applied Applications Management Pack.
• Experience with 10g AS (OID, SSO, Portal and Discoverer)
• Installed 10g AS and integrated OID and SSO with R12 Applications
• Implemented Portal and migrated the data from DEV - > TEST - > PRD
• Implemented Shared APPL_TOP, Multi Node Architecture, and Load balancing with CISCO Switch.
• Implemented Parallel Concurrent Processing and output post processor setup on a fail over environment.
• Implemented SSL and enabled the forms servlet mode.
• Experienced in Shell Scripting and setting up cron jobs for automating the jobs.
• Well Experienced in creating and maintaining a Custom Schema
• Good knowledge on migrating the custom objects right from Development to Production
• Successfully implemented the DR test in Sun Guard facility and recovered all the Production servers.
• Well experienced in handling the Tera Byte databases.
• Proactive and good analytical and problem solving skills.

TECHNICAL SKILLS

Operating Systems: IBM-AIX (4.33/5.2, 5.3), HP-UX (11.11), Sun Solaris (5.9, 5.10), Win NT 4.0, Windows 2000 Server, windows 2003 server, Readhat Linux and Oracle Enterprise Linux(OEL)
Oracle Applications: 12.1, 12.0.6, 12.0.4, 11.5.10, 11.5.7, 11.5.2
Data Base Servers: Oracle (7.2, 7.3, 8.0.4, 8.0.5, 8.1.7, 9.2.0 and 10gR2).
Application Servers: Oracle Application Server 9iAS and 10gAS (portal, SSO, Discoverer, OID).
Languages: SQL, PL/SQL, C, Shell programming
Business Intelligence: 11iBIS, Discoverer, Portal, OSA, OFA, ADI
Performance: STATSPACK, TKPROF, RDA
Patching Tools: Kintana
Backup and Recovery: RMAN, VERITAS, EMC
Database Utilities: DG-Broker, EXPDP, IMPDP, RMAN
Migration and Development
Tools: CUSTOM.pll, Developer 6i, WFLOAD, FNDLOAD,
Monitoring Tools: 10 OEM Grid, Quest Spotlight, OAM
Forms Server: Dev2000 (1.6.1) Dev9i/6i (forms and reports).
Application Tools: Workflow Builder, Discover 4i,9i & 10g, ADI, ADE, ad utilities.
AD Utilities: adpatch, adadmin, adclone, adcongif, admerge, adctrl, adsplice, adident, adlicmgr, adworker.

PROFESSIONAL EXPERIENCE

Confidential, Rochelle Park, NJ Oct'2007- Till date
Lead Oracle Applications DBA

Responsibilities :-

• Responsible for monitoring and supporting the Production which include a ERP and non-ERP databases.
• Maintained Oracle application Version 12.1, 12.0.6 and 11.5.10.2
• Upgraded database from 9.2.0.5 to 10.2.0.3 and 10.2.0.4
• Successfully upgraded Applications from 12.0.6 to 12.1 as proof of concept.
• Installed Oracle databases on Windows server
• Worked active and passive cluster environment.
• Cloning Databases from Single-node to multi-node and multi-node to multi-node.
• Worked both RAC and non-RAC databases
• Cloned databases from RAC to RAC and from RAC to non RAC Databases
• Configured RMAN for backup and recovery strategies
• Installed oracle Application server 10R3 (10.1.3) and configured Discoverer and SSO
• Installed and upgraded Oracle enterprise Manger Grid Control (10.2.0.4)
• Deployed agents on all servers for monitoring through OEM
• Worked on configuring NETAPP backup for speed recover using snapshot backup.
• Performed forms Upgrade.
• Upgraded the Jiniator to JRE 6 update 21
• Upgraded the Discoverer 4 EUL to 10g EUL (Application EUL)
• Performed cloning from single node to Multi node and from multi node to multi node several times as part of the upgrade iterations.
• Supporting the functional people when opened SR with Oracle.
• Applied series of patches given by Oracle Support to resolve user specific issues, applied various patching techniques to minimize the down time.

Environment: Sun Solaris 5.9, 5.10, ERP 11.5.10.2/12.0.4,12.0.6,12.1, -9iAS, 10gAS, TOAD, ADI, OEM 10g

Confidential, Parsippany, NJ Jan'2007- Sep'2007
Senior Database Administrator

Mainly Responsible for maintaining Oracle Applications ERP Rel 11.5.10 on Sun Solaris
Responsible for database administration and techno functional support of 11.5.10 E-Business Suite. Played a
vital role in Implementing Oracle Applications.

Responsibilities Include but not limited to:

• Maintained Oracle Applications Release 11i (11.5.10)
• Applied CPU Jan 2007 and CPU April 2007 (Critical Patch Upgrades for Oracle systems)
• Successfully completed 3 Test upgrades from 11.5.10 to 11.5.10.2
• Upgradation of Oracle Application databases from 9.2.0.7 to 10.2.0.4
• Database Refreshes from Prod to Dev.
• Troubleshooting Day-to-Day Users Issues in various modules. Technologies and workflow Mailers.
• Manage 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, Data files, undo, Temporary TBS.
• Closely worked with Oracle Consulting Team for a successful implementation of ABG.
• Various level of patching in all of the eBusiness Suite technology stack like adpatch, OPatach etc.
• Cloning of Oracle Applications 11.5.10 Using Autoconfig and Rapid Clone .
• Creation of users, assigning responsibility, creation of customs menus and responsibility.
• Provide database security at different application levels.

Environment: Sun Solaris 2.8, ERP 11.5.10/11.5.10.2, IAS 1.0.2.2 (9iAS), TOAD, etc

Confidential, Atlanta, GAJune'2006 - Jan'2007
Senior Database Administrator

Oracle Applications ERP/CRM Rel 11.5.7 & 11.5.10 Applications Database Administrator

Responsibilities Include but not limited to:

• Maintained Oracle Applications Release 11i (11.5.7)
• Defined upgrade process for 11.5.7 to 11.5.10 with CU2
• Successfully completed 3 Test upgrades from 11.5.7 to 11.5.10.2
• Upgradation of Oracle Application databases from 9i to 10gR2
• Upgradation of Oracle Application databases from 8i to 9i (9.2.0.7)
• 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 ManagerIssues.
• Cloning of Oracle Applications 11.5.7 with Autoconfig and Rapid Clone Technologies .
• Creation of users, assigning responsibility, creation of customs menus 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 (ADADMIN and ADPATCH. Configured additional products through ADSPLICE utility. Used RMAN for incremental and cumulative backup/restore
• Installation & Configuration of 10g Databases( Non ERP)
• Code deployment, installation & configuration.
• Co-ordination with the offshore team for some of the responsibilities sharing
• Tuning of the Long Running processes.
• Provide database security at different application levels.

Environment: Sun Solaris 2.9, ERP 11.5.10/11.5.7, dev9i/dev6i (patch set 16), IAS 1.0.2.2 (9iAS), TOAD, etc.

Confidential, Omaha, NE Mar '05 - May '06
Sr.Consultant- Oracle Apps DBA

• Maintaining Oracle Applications 11.5.9 on HP-UX
• Cloning and Extensive Patching
• Refresh of Databases and Applications
• Providing 24/7 Production support to 11.5.9 Oracle Applications and their databases
• Redo of directory structure
• Managing Instances, Monitoring the database growth
• Migrating Database objects and code migration
• Regular Core DBA Activities and user support
• Provide users and developers support ,Resolving Alerts and Oracle TAR's

Environment: HP-UX 11,Windows NT, 2000,MSDOS, Linux, Oracle9i, 8i, Oracle Applications 11.5.9,Oracle GL, AP, AR, Oracle Configurator, Advanced planning & scheduling, Advanced Queuing

Confidential, Secaucus-NJ Nov '2003 - Feb' 2005
Application Database Administrator

As an Apps DBA was mainly responsible for Maintenance of Oracle Apps 11.5.7 on IBM- AIX 4 and Upgrading Applications to 11.5.10 on AIX 5L.
Responsibilities includes the following

• Installation of Application Instances and configuring them according to the client's requirements
• Configure the following modules
• HRMSfamily, GL, AP, AR, FA, OM, INV, Supplychain & iprocurement,
• Upgrade of Oracle Application from 11.5.7 to 11.5.9 to 11.5.10 using the maintenance patches
• Troubleshoot various HRMS and Oracle Financial module issues and resolve the issues.
• Supported the Implementation of SHERPLEX for Reporting Architecture group, configure the Sherplex setup on Source and the target machine, configure Reporting Managers, Concurrent reports.
• Involved as a team member for Oracle Real Application Clusters (RAC)
• Installed and Configured RING MASTER tool for Patch Management.
• Upgrade of Apache server from 1.3.9 to 1.3.12 and 1.3.12 to 1.3.19.
• Upgrade of Oracle database from 8.1.7 to 9.2.0 versions.
• Following up with Oracle support on software related issues, create TARs and TAR Tracking
• Vertex installation, upgradation, hrglobal administration
• Cloned the Application Instances as per functional and technical requests using the AUTOCONFIG and build the Context.xml file.
• Registering the Custom Applications, installing the Custom Docs into Oracle Application.
• Registered different types of Printers and customized the Style and Drivers to troubleshoot the printing issues for Oracle Application reports.
• System Administration tasks also includes creating and defining the concurrent programs and executables.
• Applying Patches as per Oracle support to troubleshoot various errors
• Resolved various Problems that occurred while re-linking the application executables and generating report files.
• Run ADADMIN to compile APPS schema, regenerate forms, reports, generate Jar files.
• Supporting the databases for different applications like Control M, Application etc
• Written Shell scripts to move the Tables from one instance to another instance using Import/Export.
• On-call support for Oracle ERP Applications and databases.

Environment: IBM AIX 5L/4.3. ERP 11.5.10/11.5.9, dev9i/dev6i (patch set 16), iAS 1.0.2.2 (9iAS), TOAD, UNIX scripting.

Confidential, Ashburn-VA Aug'2003 - Oct' 2003
Application Database Administrator

As an Oracle Database administrator was involved in Installation of Oracle Applications 11i (11.5.4) and maintaining & upgraded the Oracle Application from 11.5.4 to 11.5.5 on Sun-Solaris (5.8) platform.
Cloned the Application Instances using the ADCLONE as per the technical & functional team request.

• Refreshing the database periodically and taking the timely backup.
• Applied the Maintenance Pack Patches.
• Configured the printers and created the custom styles and the drivers.
• Applied the Patches to enable the 9iAS server.
• Maintain Applications database objects, Compile flex field data in AOL tables
• Applied Oracle Applications Release 11.5.5 Online Help patch
• Installed the Developer 6i and other client software.
• Installed Application Desktop Integrator ADI and created the Database Connectivity.
• Automated the Application process startup/stop scripts.
• Automated the Database and complete Application Backup scripts.
• Administration of the UNIX Operation Systems.
• Creating the Users and groups in the O/S. Creating the NFS mounts in the system, setting up Printers on the UNIX machines.

Environment: Sun Solaris 5.8, ERP 11.5.5/11.5.4,1.0.2.2 (9iAS), TOAD, etc.

Confidential. Mar' 2002 to Aug'2003
Database Administrator.

• Installed Oracle 8.0, Forms Server
• Implemented ODBC features
• Created databases & objects, configured Forms server.
• Creating the web documents using Active Server Pages 2.0
• Writing the front-end validation using the Java-Scripts/VB-Scripts.
• Configured SQL*Net for Oracle
• Created additional table spaces, Rollback Segments, Redo log Groups for production support.
• Created tables, views, Synonyms, Db_Links, Snapshots and Indexes.
• Allocated system storage and planned for future storage requirements for the database
• Enrolled users, maintained system security and monitored user access to the database by assigning profiles and roles
• Written scripts to automate database startup & shutdown and to monitor the performance and growth for future estimation
• Designed a backup strategy for backup and recovery of database, maintained archived data on tapes.-
• Maintained databases. Performance tuning of SQL, Memory usage and data storages

Environment: Oracle 8.0, SQL*Plus, Sun Solaris 2.6

During this period I was involved in design through implementation most of which included the use of data base management system. Designed, developed and implemented an entire DBMS for use by application systems. Implemented more effective backup procedures of databases. Spearheaded the separation of databases into production and development environments. Assisted in logical modeling effort of an application containing 150 entities developed plans and standards for backups, monitoring, tuning, client software installation. I was responsible for maintenance and tuning and trouble shooting the database and monitoring the database and the client machines to improve the performance. During this period also improved the performance of the database by implementing the various tuning methods like I/O tuning, Logical tuning, Memory tuning, Query Tuning.
Responsibilities:

• Regularly monitored the table spaces for space allocation.
• Performed backup, and restored the database with back up of specific objects and users of the database using export and import utilities.
• Taking Daily Online Backups, weekly off-line Backups and frequent exports.
• Performed Database Administration functions such as tuning Database, performing hot and cold backups. Networking for Clients
• Used direct and conventional path methods for SQL*LOADER to insert data from flat files to Oracle Database

Environment: Oracle 7.3.4, Linux, Windows NT, SQL, PL/SQL, SQL Developer,

EDUCATION:

MS in Electrical Engineering.
Bachelors in Electrical and Electronics.
Training in oracle ERP Administration.
Training in Oracle 10g/9i Database Administration.