SUMMARY:

Over Twenty Two years of strong upgrade, configure, maintenance and support experience in Oracle Applications Rel 12(12.2.7 endeca 12.2.6 EBS 12.0.4,11.5.10cu 2/11.5.9/11.5.7 ), 11.0.3/10.7 SC, 10.7 NCA/10.4 CUI using Oracle 13c,12c,11g, OEM 13c, OBS 4.4, OAM, SQL*PLUS, SQL* Loader, Shell Scripts, SVRMGR, ADPATCH, Data Mart Suite 2.0, Pl SQL, C, Pro*C, LINUX SUSE,LINUX AS 2.1,IBM - AIX 5.3, HP

PROFESSIONAL EXPERIENCE:

Confidential, WI

Oracle EBS architect/Lead Apps DBA

Responsibilities:

• Managing day to day activities of the team, ensuring DBA coverage is there 24/7
• Assigning tasks to the team members and assigning complex projects to the team leads
• Conflict resolution between team members and with other teams
• Starting, stopping managed servers, admin servers as per the monitoring status.
• Planning and ensuring DBA team is always uptodate with the latest technologies, e.g. we had 13c inhouse training sessions where every DBA made presentation to the team on one topic.
• Implemented latest Oracle apps technologies like ACFS with ODA appl top technology,
• Integrated Oracle E Business Suite Fusion Middleware with Oracle Identity management products like Oracle Access Manager Single Sign On and Oracle Internet Directory
• Developed portal pages using Oracle Portal for displaying content from UCM repository.
• Used workflow for approval and rejection of documents in real estate department and also added subscriptions for changes.
• Extensive Oracle E-business production support of VCP HFM Endeca and UPK
• Installed and Configured Fusion Middleware, Discoverer, SOA, BPM, OBIEE, APCC, SSO, OAM, Access Manager, and OID
• Created CMO/CNC and used Disvoverer install on CMO GARS reporting worked intensively clonning oracle apps prod to dev,converted multi node to single node,merged with database server with apps node used XML file to merge the two node to single node
• Applied current level patches and upgraded the oracle database and oracle applications.
• Developed Cluster Simulation environment for I/O Performance and Simulation Testing on HP
• Created users and give the responsibilities and give the grand permission.
• Complied flex field and change the mode maintenance mode thru ADADMIN
• Apps server configuration used autoconfig the change the server setting
• Well versed with R12.2 patching,cloning of R12.2 instance and did many iterations. worked intensively cloning oracle apps prod to dev,converted multi node to single node, merged with database server with apps node used XML file to merge the two node to single node

Environment: Oracle Applications 12.2.6 12.2.7 Endeca,Oracle Business Intelligenge,Discoverer 10g,Oracle 12c, OAM, CVS, Oracle Enterprise Manager (OEM), Call Tracking, Standby database, Linux,OID/OAM, SQL Navigator, PDL, Java, Apache, SSL

Confidential, Houston,TX

Lead Oracle EBS Architect/Financial DBA

Responsibilities:

• Fusion Middle ware and SOA Configuration on Development Server
• Installed and configured weblogic with UCM
• Configured Fusion Middle ware and SOA Configuration on Development Server
• Involved in designing the user interfaces using ADF and portal.
• Implemented PCP parallel concurrent Processing on RAC with Concurrent node affinity
• Implemented Oracle Webcenter Imaging WCI with High availability
• Integrated Oracle E Business Suite Fusion Middleware with Oracle Identity management products like Oracle Access Manager Single Sign On and Oracle Internet Directory
• Installed new oracle 11g to Linux
• Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating Dataguarded Exadata clusters for maximum availability.
• Disaster recovery of Exadata Dataguard Physical Standby. Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing.
• Provided capacity planning for new database server as a new plan was coming online.
• Lead DBA role in 10gR2 to 11gR2 database upgrades on multiple database simultaneously.
• Proficient in Exadata maintenance/support/dataguard/backup/recovery/failover/switchover.
• Upgrade of Oracle apps from 12.1.1 t0 12.1.3.(GL,SCM,WMS))
• Upgraded of Oracle database from 9i to 10.2.0.2 Design and implementation of backup and recovery strategy using tools, such as Veritas Netbackup and RMAN. Database and system monitoring tools. before rel 12i upgrade, converted the Oracle APPS DB to OATM model
• Configured the single node to multinode server with cluster file system(ACFS)
• Apply Apps patches and DST patch and Data Base applied Interpretability patch compile the invalid object through admin
• Complied flex field and change the mode maintenance mode thru ADADMIN
• Apps server configuration used autoconfig the change the server setting worked intensively cloning oracle apps prod to dev,converted multi node to single node, merged with database server with apps node used XML file to merge the two node to single node

Environment: Oracle Applications 12i, Rel 12,11.5.10 cu 2,Oracle Business Intelligenge,Oracle 11g,10 g, OAM, CVS, Oracle Enterprise Manager (OEM), Call Tracking, Standby database, SUN SOLARIS 10, SQL Navigator, PDL, Java, Apache, SSL

Confidential, KS

DEV Lead Oracle Apps DBA

Responsibilities:

• Installation of EBS R12.1.3.8 for VCP project. Also, installation of Demantra 7.3.1.4 on Windows 2008 and AIX 7.1 using Tomcat and Oracle 10gAS. Implement cloning of Demantra environment. Installation and configuration of Fusion Middleware OBIEE 11.1.1.6 with Weblogic 10.3.6 on AIX 7.1Implemented latest Oracle apps technologies like shared application top technology, OID/SSO, RAC etc.
• Performance tested multi-tier Oracle Release 12 application deployments for use in Oracle E- business Suite.
• I Installed new oracle 11g to Linux
• Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating Dataguarded Exadata clusters for maximum availability.
• Disaster recovery of Exadata Dataguard Physical Standby. Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing.
• Provided capacity planning for new database server as a new plan was coming online.
• Installed and Configured Fusion Middleware, Discoverer, SOA, BPM, OBIEE, APCC, SSO, OIM, Access Manager, and OID
• Implemented and configured multi tier Oracle Release 12.
• Upgraded several instances of Oracle Applications version 11.5.10 cu 2.
• Upgraded Oracle apps from 11.5.10.2 to R12.
• Configured the single node to multi-node server with cluster file system (ACFS).
• Applied Apps patches, DST patch and Data Base applied Interpretability patch
• Compiled the invalid object through admin.
• Complied flex field and change the mode maintenance mode thru ADADMIN.
• Configured apps server using autoconfig to change the server setting.

Environment: Oracle Applications Rel12, Oracle 11g Release 2, OAM, CVS, Oracle Enterprise Manager (OEM)

Confidential, TX

Lead Oracle Applications DBA

Responsibilities:

• Involved in implementing Oracle Advanced Benefits modules and System Administration of Oracle Applications
• Performance tested multi-tier oracle Rel 12 application deployments for use in oracle E- business Suite. Implemented and Configured Oracle Self Service Web Applications (SSWA) and Concurrent Manager processing.
• Applied current level patches and upgraded the oracle database and oracle applications.
• Configured and implemented Oracle Applications Manager (OAM) with Rel 12.0.4.
• Configured Self Service Web Applications for CRM and iProcurement
• Implemented and configured multi tier oracle Rel 12.

Environment: Oracle Applications Rel 12.0.4, 11.5.10 cu 2, Oracle 10 g,10 g AS, OAM, CVS, Oracle Enterprise Manager (OEM), Call Tracking, Standby database,HP-SUPER DOME,SSL

Confidential, Ft Worth, TX

Sr. Oracle Manufacring/Financial DBA

Responsibilities:

• Implemented and configured multi tier oracle 11i application implemented SSL setup thru using firewall setup DMZ.
• Performance tested multi tier oracle 11i application deployments for use in oracle E- business Suite on Demand Hosted Service
• Fusion Middle ware and SOA Configuration on Development Server
• Installed and configured weblogic 10.3 with UCM

Environment: Oracle Applications 11.5.10 cu 2, Oracle 10 g,10 g AS, OAM, CVS, Oracle Enterprise Manager (OEM), Call Tracking, Standby database, LINUX SUSE, SQL Navigator, PDL, Java, Apache, SSL

Confidential, Dallas, TX

Sr. Oracle Financial DBA

Responsibilities:

• Installed and Configured Oracle Application Instance 11.5.10 cu 2
• Created scripts for monitoring the Databases.
• Setup cron jobs in UNIX to monitor the Databases .
• Installed and applied patch, upgraded, configured, tuned, and maintained the Oracle 11i E-business suite and 9i databases. Provides support (on-call 24x7) for the production environment, which includes business-critical applications.
• Configured and implemented Oracle RAC(Realtime application cluster architect with oracle APPS 11i)
• Involved in Custom Migration of Project Accounting, Purchasing, GL, AP and INV Modules of Oracle Applications.
• Cloned instances from production.
• Configured and implemented Oracle Applications Manager (OAM) with 11.5.10 cu 2
• Configured Self Service Web Applications for CRM and iProcurement
• Carried out bug fixing, trouble shooting, altering and debugging Java programs in the applications.
• Recompiled the Forms and Pl SQL Libraries.
• Designed and implemented the Hot and Cold backups for the Oracle Instances.
• Installed the Oracle 9iAS portal on the IBM-AIX 5.3Enterprise server

Environment: Oracle Applications 11.5.10 cu 2, Oracle 9iAS, 10g,9.2.0.5, OAM, Forms 6i, Reports 6i, Pl SQL, Sun APPS Modules: GL, AR, AP, FA, WIP, OE, INV, PO, QP, ASO, Oracle Projects

Confidential, NJ

Oracle Manufacturing DBA

Responsibilities:

• Upgraded and configured Oracle Applications 10.7 cui to 11i (11.5.5) on Sun Solaris 5.8 on a Multi Nodes.
• Installed 9i Application Server portal on the Sun Solaris server
• Configured Self Service Web Applications for CRM and iProcurement
• Participated in Performance and code review of oracle cluster manager for ORACLE 9i RAC. Installed, Deployed, and administered Linux AS 2.1 and Oracle 9i(both RAC and NON RAC) With EMC and Network Applience.
• Installed and configured ADI (reporting tool for financials) with Oracle Applications 11.5.4.
• Did cloning of Oracle Applications 11i (11.5.3, 11.5.4) instances from PROD to test environments on SUN Solaris.
• Installed and configured Oracle Discoverer with applications and MRC and Autoconfig.
• Installed and configured Oracle Balanced Scorecard (4.4) with Oracle Applications 11.5.4 Vision instances.
• Did conversion of Oracle Applications to Multi Org.
• Recompiled forms and PLSQL libraries.
• Designed and implemented hot and cold backups for Oracle instances.
• Maintained and trouble shooted scripts for database instances.
• Wrote PL/SQL procedures, triggers and packages.
• Managed concurrent requests and concurrent managers.
• Created and registered custom schemas, custom apps and forms with AOL.
• Installed and configured Oracle Enterprise Manager 2.2.
• Installed mobile applications, demand planning and configured with Apps 11.5.5.

Environment: Oracle Applications 11.5.9/11.5.3, Oracle 8.1.7, 8.1.6, 9iAS, OEM 2.2 OAM, Sun Solaris, AIX, Kintana, Oracle Enterprise Manager (OEM), BLT Remedy, Call Tracking, Standby database, IBM AIX 4.2, SQL Navigator, PDL, Java, Apache, SSL

Confidential, NY

Sr. Oracle/Applications DBA

Responsibilities:

• Installation, Upgrade, patching and managing Oracle Applications 10.7NC & Smart client and 11.0.3
• Tuning Concurrent Managers, Defining Work Shifts, etc.
• Installation, Upgrade and Configuration of Oracle (7.1.6, 7.3.4, 8.0.5, 8i).
• Defragmentation of database using export import.
• Removing row chaining fot better performance.
• Data Modelling, Database Design and Creation
• Deciding the naming conventions of datafile, redo log files, tablespaces, segments.
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting in csh, ksh for automating startup/shutdown of databases.

Environment: Oracle (7.3.4/8.0.x/8i), Oracle APPS 10.7 NCA, Pro*C, C, Unix Shell Scripting, SQL, Scripting, Forms (2.3, 4.5), Unix CRON jobs, Oracle Application Object, Library (AOL), BMC patrol monitoring.

APPS Modules: GL, AR, AP, FA, WIP, OE, INV, PO, QP, ASO, PA, CN, HRMS(Payroll, HR), SC, Sun Solaris 2.6, AIX, Windows NT, Windows NT, Sun Solaris 2.6, AIX/6000 Server

Confidential, FL

Sr. Oracle Applications DBA

Responsibilities:

• Installed and configured 10.7 NCA, 11.0.3 applications.
• Upgraded Oracle Applications 10.7 NCA to 11.0.3
• Installed Oracle Applications 11i using Rapid Install.
• Installed and configured Oracle Server 8.1.6 (8i).
• Did migration of Oracle Applications 9.4.2 to 10.7 and 10.7 to 11.0.3.
• Installed oracle web application server.
• Created and maintained staging and development databases.
• Applied patches to application tier and database tier using ADPATCH.
• Wrote scripts for automation of database monitoring.
• Installed and did setup of HP printer in Oracle Applications.
• Did recovery of data at the table level using until time option.
• Installed and configured Oracle Server 7.3.4 and 8.0.5.
• Defined and maintained concurrent managers and programs.
• Created Snapshot Replication, Snapshot Logs and Updateable Snapshots.
• Configured master sites and replication groups.

Environment: Oracle Applications 11.0.3, Oracle (7.3.4/8.0.x), Pro*C, C, Unix Shell Scripting, Perl, SQL Scripting, Forms ( 4.5, 6i), Unix CRON jobs, Oracle Application Object Library (AOL), Reports 6i, BMC patrol monitoring.

APPS Modules: GL, AR, AP, FA, WIP, OE, INV, PO, QP, ASO, PA,, HRMS (Payroll, HR ), Sun E5000, HP9000, EMC Drives, Sun Solaris 2.8, Veritas, Quick IO

Confidential, SC

Oracle APPSDBA

Responsibilities:

• Upgraded Oracle Applications 10.7 NCA to 11.0.3
• Installed and configured Oracle Server 8.1.6 (8i).
• Did migration of Oracle Applications 9.4.2 to 10.7 and 10.7 to 11.0.3.
• Installed oracle web application server.
• Created and maintained staging and development databases.
• Applied patches to application tier and database tier using ADPATCH.
• Wrote scripts for automation of database monitoring.
• Installed and did setup of HP printer in Oracle Applications.
• Did recovery of data at the table level using until time option.
• Installed and configured Oracle Server 7.3.4 and 8.0.5.
• Defined and maintained concurrent managers and programs.
• Created Snapshot Replication, Snapshot Logs and Updateable Snapshots.
• Configured master sites and replication groups.

Environment: Oracle Applications 11.0.3/10.7 SC/NCA/9.4.2, 11i (General Ledger, Payables, Receivables and workflow), Sun Solaris, HP-UX, Windows NT

Confidential

Oracle APPSDBA

Responsibilities:

• Installed oracle application 10.7 sc server and client, Oracle Application DBA, Oracle Alert, Oracle Common Modules and Oracle Financials using auto install.

Environment: Oracle Financial 10.7 SC (GL, AP, AR, HR, PR, OE)