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