SUMMARY:

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 11i, 12.0.4,12.0.6 and 12.1.3
• Successfully upgraded the Oracle Applications from 11i Releases to 11.5.10.2. and 12.0.6 and 12.1.3
• 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 (11g,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.
• Configured Physical Standby Database and Data Guard Broker
• Expertise in Switch-over and Fail-Over Stratagies
• Addd additional node to existing Cluser
• 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.0Windows 2000 Server, windows 2003 server, Readhat Linux and Oracle Enterprise Linux(OEL)

Oracle Applications: 12.1.3, 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,10gR2,11gR1,11gR2).

Application Servers: Oracle Application Server 9iAS and 10gAS (portal, SSODiscoverer, 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, FNDLOADMonitoring Tools: 11g and 10g OEM Grid, Quest Spotlight, OAM

Forms Server: Dev2000 (1.6.1) Dev9i/6i (forms and reports).

Application Tools: Workflow Builder, Discover 4i,9i,10g&11g, ADI, ADE, ad utilities.

AD Utilities: adpatch, adadmin, adclone, adcongif, admerge, adctrl, adsplice, adident, adlicmgr, adworker.

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Lead Oracle Application DBA/System Administrator

Responsibilities:

• Production support in going live to Freshly installed Oracle EBS R12.1.3 with 11.1.0.7 database.
• Created and loaded number of user’s for all the departments and sub-department .
• Performed conversion and loaded data like vendors contracts etc,
• Created Custom concurrent mangers as required for performing daily tasks.
• Created custom responsibilities, custom menus, read only functions as part of enabling security in different levels.
• Performance tuning the production before and after go-live in database level, applications level.
• Performed daily DBA activities like Cloning, Patching, backup-restore, space management, monitoring database alerts.
• Installed and configured 11g Grid control and agents for monitoring the Production and development instances
• Applied EBS management pack patching on OEM and EBS to monitor EBS through Enterprise manager.
• Created scripts for cloning and post cloning steps.
• Installed and Configured SSO for Discoverer report to run on report server.
• Troubleshooting end user issues .
• Closely worked with SOA developers during conversions and figuring out any problems with the interface created between the ‘Side system’ and EBS.
• Troubleshooting workflow mailers for PO APPROVALS, REQUISITIONS,AP EXPENSE
• Form personalization to hide certain security attribute’s not available to certain user’s.
• Performed all types System Administrator task like creating and end dating user accounts, responsibilities. updating Profile options in site level, responsibility level and application level.
• Created instance sets and grants to implement certain security futures and assigning them to Users through roles and responsibilities.
• Designed on How/When to run different concurrent requests and scheduled jobs accordingly to reduce load on the system and provide better performance.
• Alert management:- Created and setup alerts to send notification to Users from application wherever necessary.

Environment: - Linux x86-64, os version 5,ERP 12.1.3,TOAD,Data Loader,OEM11g,Discoverer 11g, Oracle web logic server 11g, BI publisher.

Confidential, Redlands, CA

Lead Oracle Application DBA

Responsibilities:

• Client side support in going live to Oracle EBS R12.1.3 with 11.1.0.7 database
• Upgraded the Database from 11.1.0.7 to 11.2.0.2
• Configured Scan Listeners in 11gR2
• Supporting Multi-node architecture.
• Configured parallel concurrent processing (PCP). Adding or deleting Nodes as required.
• Worked on Oracle RAC 10g and 11g
• Integrated R12.1.3 to 11g OID /SSO
• Worked on Integration EBS with SOA/OTM
• Installed stand alone weblogic server for different Applications
• Installed and configured OBIEE for reporting
• Configured Physical Standby database and built Data Guard Broker
• Implemented PCP in EBS R12.1.3
• Created Custom services in RAC for EBS Applciations
• Configured SSL for EBS Applciations
• Used LDAP utilities for migrationg the users to OID
• Installed Discoverer 11g, created EUL and server side setup for accessing Discover through Plus and viewer
• Installed 11g Grid control and agents for monitoring the Production and development instances.
• Applied Management pack patches to monitor EBS through the Enterprise manger
• Configured Compellent backup to take snap shot of the instance for backup and recovery process
• Printers setup and configuration using Cups and then adding to Oracle
• Performed cloning and patching for testing purposes of the production environment.
• Cloning Rac to Rac and Rac to non-Rac.
• Installed Oracle SOA for loading EDI into oracle
• Created CUSTOM concurrent managers.
• Troubleshooting ASCP, workflow notification and MWA mobile devices
• Worked on setting up of Oracle Configurator.
• Performed stress testing /Load testing for Troubleshooting performance issues.
• Automated database cloning.
• Performed system administrator Tasks in Oracle application. Adding users, assigning responsibilities, registering custom forms/reports, managing concurrent managers, Adding printers to EBS.

Environment: - Linux x86-64, os version 5,ERP 12.1.3,TOAD,OEM11g,Discoverer 11g, Oracle web logic server 11g

Confidential, Rochelle Park, NJ

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, 11.1.0.7
• Successfully upgraded Applications from 11.5.10.2 to 12.0.6 to 12.1 .
• 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 (10g )
• 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 and then to 11gEUL (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

Senior Database Administrator

Responsibilities:

• 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.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, GA

Senior Database Administrator

Responsibilities:

• 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 Manager Issues.
• 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

Sr.Consultant- Oracle Apps DBA

Responsibilities:

• 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

Application Database Administrator

Responsibilities:

• 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

Application Database Administrator

Responsibilities:

• 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.