Senior Oracle E - Business Suite Dba Resume
Boston, MA
SUMMARY:
- Senior Oracle E - business Suite DBA
- Secret Security Clearance
- EBS DBA on numerous Oracle E-business Suite (11i/R12) implementations (over 15)
- Primary DBA from implementation of VCP 12.1.3.x, OBIEE/APCC and Demantra 7.3.x
- Implementation, support and cloning of Demantra 7.3.x on Linux
- EBS DBA on numerous 11i to R12 upgrades
- Extensive Oracle E-business production support of HR, Financials and Manufacturing
- Installed and Configured Fusion Middleware, Discoverer, SOA, BPM, OBIEE, OBIA, ODI, APCC, SSO, OIM, Access Manager(OAM), and OID
- Managed DBA teams and mentored junior DBAs in Oracle and Oracle E-business
- Oracle Access Manager and Oracle Identity Manager Integrator
- Excellent communication skills
TECHNICAL SKILLS:
Key Skills: Oracle E-business Suite DBA (15 years), Oracle DBA (17 years), Managed DBA team (2 years), Oracle Access Manager and Identity Manager Implementer, OBIEE/OBIA/ODI Implementer, IT industry experience (33 years).
Databases: Oracle 7.5, 8.x, 9i RAC, 10g RAC, 11gR2.
Database Utilities\Tools: OEM, Grid Control, RMAN, Toad, AD utilities, OATS, FlowBuilder.
Programming: PL/SQL, Perl, Shell (Korne, Bash).
Operating Systems: UNIX (Solaris, HP, AIX), Red Hat Linux, OEL.
Storage Systems: IBM System Storage, EMC, Hitachi, HP SAN
PROFESSIONAL EXPERIENCE:
Confidential
Environment: OBIEE on OEL 6
Responsibilities:
- Upgraded OBIEE 11.1.1.9 to 12c (12.2.1.1.0 ).
- Performed migration of RPD and Catalog using BI Migration Tool.
- Migrated Users from 11g to 12c Weblogic.
- Installed OBIEE 12c Client for rpd administration.
- Integrated SSO from EBS 12.2.5 to OBIEE 12c
Confidential
Environment: EBS 12.2.5 on OEL 6
Responsibilities:
- Upgraded EBS 11.5.10.2 to EBS 12.2.5 and Oracle DB from 11gR1 to 12.1.0.2 RAC.
- Cloning and support of EBS 12.2.5 environments (dev, test, integration, etc.).
- Developed runbooks and IQ documents for client.
- Install OBIEE 11.1.1.9 with APCC in Development and Test environments.
- Implement SSL on Loadbalancer and each Application Server.
Confidential
Environment: EBS 12.2.5 on OEL 6
Responsibilities:
- Upgraded EBS 11.5.10 to EBS 12.2.5 and Oracle DB from 11gR1 to 12.1.0.2
- Upgraded Configurator Developer 11.5.10 to EBS 12.2.5 and Oracle DB from 11gR1 to 12.1.0.2
- Cloning and support of EBS 12.2.5 environments (dev, test, integration, etc.).
- Developed runbook for client’s DBA team.
- Supporting DBA on upgrades of various environments.
- Developed material and trained Client’s DBAs on Weblogic Administration, ADOP, etc.
Confidential
Environment: EBS 12.2.4 on Solaris 10
Responsibilities:
- Upgraded EBS 11.5.10 to EBS 12.2.5 and Oracle DB from 11gR1 to 11.2.0.4.
- Cloning and support of EBS 12.2.5 environments (dev, test, integration, etc.).
- Developed runbook for client’s DBA team.
- Supporting DBA on upgrades of various environments.
- Developed material and trained Client’s DBAs on Weblogic Administration, ADOP, etc.
Confidential
Environment: EBS 12.2.4 on Red Hat Linux 6
Responsibilities:
- Upgraded EBS 11.5.10 to EBS 12.2.4 and Oracle DB from 10g to 11.2.0.4.
- Cloning and support of EBS 12.2.4 environments (dev, test, integration, etc.).
- Installation of OBIEE 11.1.1.7 on Red Hat Linux 6. Configured Single Sign-on integration from EBS to OBIEE.
- Installation of ODI and OBIA 11.1.1.8.1 and upgrade to 11.1.1.9.2.
- Installation and configuration of OID 11g, OAM 11.1.2, WebGate/AccessGate 11g for EBS 12.2.5
- Setup and ran Data Loads for Supply Chain and Order Management.
- Installation and administration of Active DataGuard and creation of EBS standby database used by OBIEE.
Confidential
Environment: EBS HR and iProcurement on Red Hat Linux 5
Responsibilities:
- Installation and configuration of OID 11g, OAM 11.1.2, WebGate/AccessGate 11g for EBS 12.1.3.
- One internal node containing OID, OAM and AccessGate for Internal EBS nodes.
- Installed WebGate/AccessGate for external EBS node.
Confidential
Environment: Oracle Access Manager 10.1.4
Responsibilities:
- Support of Demo, Development and Production OAM 10g environment.
- Creation and modification of Domain Policies to protect internal and externally facing Web Application resources for Single Sign-on.
Confidential
Environment: EBS/VCP 12.1.3.7 on Red Hat Linux 5.5
Responsibilities:
- Installation, patching and cloning of Value Chain environment.
- Installation of Loftware label software 10.0 on Windows server with Oracle connector 3.1 for 10g DB and Loftware 10.1 with Oracle Connector 4.1 for 11g DB environments.
- Installation of Demantra 7.3.1.4 with Analytical Engine running on Linux with WebLogic 10.3.6.
- Installed and configured EBS 12.1.3 Validation environment with a 2 node 10g RAC (ASM/CRS).
Confidential
Environment: OAM 11g and OID 11g on Linux RHEL5
Responsibilities:
- Performed the installation and configuration of OAM 11g and OID 11g on Linux for integration with Oracle E-Business Suite R12.
- Performed the integration of the Java plugin between OID and Active Directory for authentication.
- Performed the installation of the Development, Test and Production environments.
Confidential
Environment: OBIEE/OBIA 11g on Linux RHEL5
Responsibilities:
- Installation and configuration of OBIEE 11.1.1.7, OBIA 11.1.1.8.1, ODI 11.1.1.7, and WebLogic 10.3.6 on Linux RHEL5.
- Installed Oracle GoldenGate 11.2.1.0.1 on Target database server (Linux RHEL5) and Source database server (EBS 11.5.10.2) with Oracle 11gR2.
- Created SDS, generated SDS DDL, generated OGG Params, and created SQL for Initial Load using ODI Studio.
- Implemented ODI J2EE Agent on WebLogic Server running on a Linux RHEL5 Application Server.
- Implemented a Stand Alone ODI Agent on the Target Database Server.
- Developed and delivered complete documentation of the installation and configuration procedures.
- Conducted sessions for the client’s engineers.
Confidential
Environment: EBS 12.1.3 (Financials) on Linux RHEL 5
Responsibilities:
- Staff augmentation for major HealthCare Services Company.
- Patching, Cloning, Vertex 6 updates, deployment of OAF customizations in an EBS R12.1.3 environment.
- Installed Oracle Application Testing Suite and FlowBuilder on Linux 64-bit server.
- Supporting testers and OpenScript developers in OATS environment. Monitoring production and performance tuning.
Confidential
Environment: EBS 12.1.3 (Financials and HRMS) on AIX on Power
Responsibilities:
- Backfill for DBA Team. Production support of Financials and HRMS environments which includes patching (Financials RPC1, HRMS Quarterly, CPU), Vertex Tax updates, Cloning, user support (logins, OIM/OAM, etc.).
- Providing support for the upgrade from OSSO (10g) to OAM (11g).
Confidential
Environment: EBS 12.1.3 and OBIEE 11.1.1.7 on Oracle Linux 5
Responsibilities:
- Installation of OBIEE 11.1.1.7 with EBS 12.1.3.
- Performed the installation of ODI and OBIA components in the OBIEE environments.
- Implemented the “Center for Internet Security (CIS) Benchmark” for database and server hardening in the OBIEE environment.
- Included the installation of the latest Application and database patchsets (CPUJan2014), Java 7, and OS patches.
Confidential, Boston MA
Environment: EBS 12.1.3 on Oracle Linux 5.8 (Exadata) and ZFS Storage
Responsibilities:
- Install OBIEE 11.1.1.6.5 with APCC for reimplementation of EBS 12.1.3 with VCP 12.1.3.8 (Centralized).
- The installation was on the development and Test environments.
- Complete documentation and mentoring of client’s DBAs on installation and configuration of APCC.
Confidential
Environment: EBS 12.1.3 on Oracle Linux 5.
Responsibilities:
- Install and implement OID 11.1.1.7 with Active Directory, OAM 11.1.2 configured for EBS 12.1.3 Dev and Test environment.
- Documentation and knowledge transfer to client’s DBA team.
Confidential, Reston VA
Environment: EBS 11.5.10.2 to 12.1.3 on AIX 6
Responsibilities:
- Perform upgrade of E-Business Suite 11.5.10.2 to 12.1.3 for financial applications.
- Migrate Discoverer 10g to EBS R12 structure.
- Document and mentor client DBA team on upgrade and management of EBS.
Confidential
Environment: Demantra 7.3.1.x on Windows
Responsibilities:
- Architecture support of current Demantra environment.
- Providing upgrade recommendations and support.
- Providing DBA support of additional Business units.
Confidential
Environment: Oracle E-business Suite 11.5.10.2 on Solaris 10
Responsibilities:
- Upgrading database from 9i to 11gR2. Implementing OATM, SSL, and archiving of data.
- Applying latest Critical Patch Update.
- Recommending additional security features.
- Installed OEM Grid Control 12c on Linux.
- Upgrade of Discoverer 10g to Discoverer 11.1.1.7 with WebLogic.
Confidential
Environment: Oracle E-business Suite R12 on Linux.
Responsibilities:
- Installation of EBS R12.1.3 with RAC 11gR2 (11.2.0.3).
- All environments are 2 or 4 nodes clusters (Gold, Dev, Conversion, UAT).
- Performed RAC to RAC clones.
Confidential
Environment: Oracle E-business Suite R12 (VCP) on AIX 7.1
Responsibilities:
- Installation of EBS R12.1.3.8 for VCP project.
- 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.1.
- Configured Advanced Planning Command Center (APCC) with OBIEE.
- Installation of UPK Professional 11.1 using MS SQL Server DB on Windows 2008.
Confidential
Environment: Oracle E-business Suite 11i to R12 upgrade on Linux.
Responsibilities:
- Upgrade 11.5.10.2 to 12.1.3 on Linux.
- Installation of Fusion Middleware OID 11g, Oracle Identity Manager and Access Manager 11g for EBS R12 Single Sign-on.
- Implemented integration/sync with Active Directory.
- Trained client’s DBAs on supporting this environment.
Confidential
Environment: Oracle E-business Suite R12 on Linux.
Responsibilities:
- Troubleshooting issues with Fusion Middleware Access Manager 11g for EBS R12 Single Sign-on (SSO) implementation (OID 11g, Oracle Identity Manager, and Access Manager).
Confidential
Environment: Oracle E-business Suite R12 on Linux.
Responsibilities:
- Setup barcode software BarTender.
- Configure MSC servers and dispatchers for warehouse.
- Troubleshoot production performance.
Confidential
Environment: Oracle E-business Suite R12 on Linux.
Responsibilities:
- Performed fresh installation of R12.1.3, UPK 11, OID and Access Manager 11g, and iSupplier.
- Implemented integration of OID/SSO (OID 11g, Oracle Identity Manager, and Access Manager) with Active Directory.
- Trained client’s DBAs on supporting this environment.
Confidential
Environment: Oracle E-business Suite 11i and R12 on Windows and Linux.
Responsibilities:
- Perform R12 fresh installs, R12 production support and 11i Production support for Confidential .
- Platforms included Windows and Linux.
- Clients have Oracle E-business Suite Financials, HR, and Manufacturing.
- Performed SAN Storage and Linux administration duties. These tasks included installation and implementation of Oracle VM and OCFS.
- Performed SAN management (Navisphere), LUN creation, etc. on EMC Clarion CX4 storage.
- Oracle Business Accelerator for EBS certified (DBA).
- Completed Accelerator (Full HR) installation on Linux for NESL.
Confidential, Charlotte NC
Environment: Oracle E-business Suite 11.5.8 upgrade to 12.1.2 with RAC on Red Hat Linux 5.3 (Tikanga).
Responsibilities:
- Performed Oracle Financials 11.5.8 to 12.1.2 upgrade and platform migration (Solaris to Linux 64bit).
- Migration consisted of export/import of 9i database to 10gR2, then upgrade to 11gR2.
- Performed migration to ASM.
- Install and configures Oracle Fusion Middleware WebLogic Server 11g (10.3.1), Oracle OID 11g (11.1.1), Oracle SSO 10g, and Portal, Forms, Reports, and Discoverer 11g (11.1.1).
- Integrated Oracle SSO with CA SiteMinder for E-Business Suite user authentication. This implementation included the installation of 10gR2, 11gR1, and 11gR2 databases.
Confidential, Hoboken NJ
Environment: Oracle E-business Suite 11.5.10.2 on RHEL 4.
Responsibilities:
- Developed Technical Architecture documents (TA120) for Procure to Pay project, which includes implementation of iProcurement and iSupplier portal.
- Performed the installation and configuration of iSupplier Portal which included Punchout.
Confidential, Chicago IL
Environment: Oracle E-business Suite 12.1.1 on Windows 2008.
Responsibilities:
- Install EBS 12.1.1 and created a Development and Test environment.
- Installed the Vision instance. Included installation of 10gR2 database.
Confidential
Environment: Oracle E-business Suite 11.5.10.2 and 12.1.1 on Linux and Solaris.
Responsibilities:
- Providing Oracle E-business Suite DBA support for Confidential .
- Installation of ASCP (E-business Suite 12.1.1), and 11gR1 database on Linux Red Hat 5.3 (64 bit).
- Installing Demantra 7.2.02 on Windows platform for Innophos and JD Irving.
- Researched and implemented ATG RUP7 on 11.5.10.2 running on Solaris, including CPU patches.
Confidential, Philadelphia PA
Environment: Oracle E-business Suite 12.0.6 with RAC on Solaris.
Responsibilities:
- Providing DBA support during and after 11.5.9 to 12.0.6 upgrade.
- Implemented OEM Application Management Pack to monitor R12 environments.
- Environment consists of a 4 node RAC with ASM. Used HP PPM for code migration.
Confidential, Dallas, TX
Environment: Oracle E-business Suite R12 on Red Hat Enterprise Linux (RHEL) 4.
Responsibilities:
- Senior Oracle Apps R12 DBA (12.0.4) performing impact analysis of upgrade from Oracle Apps R12.0.4 to R12.1.1.
- Performed and coordinated successful upgrade to 10gAS 10.1.3.4, 10gAS 10.1.2.3 for Forms server, Java 6, and 12.1.1 maintenance pack.
- Installed Universal Content Manager (UCM) for Governance, Risk, and Compliance (GRC) Suite.
Confidential, Clinton NJ
Environment: Oracle E-business Suite 11i on Solaris.
Responsibilities:
- Senior Oracle E-business Suite DBA performing the migration of Financials from Ingersoll Rand Road Equipment to Volvo IT in Greensboro NC.
Confidential, IA
Environment: Oracle E-business Suite 11.5.10.2 with RAC on Red Hat Enterprise Linux (RHEL) 4. Oracle 10g RAC 4-node cluster on IBM p-series 64-bit servers.
Responsibilities:
- Modules included Financials, Manufacturing/Distribution (Mobile Supply Chain - MSCA), Inventory and HR.
- Included a very customized iStore which ran on 5 externally facing application servers. All environments use ASM on IBM SAN.
- Senior Oracle Apps 11i DBA (11.5.10.2) supporting all e-business environments (Production, Stress, Test, Development).
- Support included day to day production support, patching, cloning, and tuning.
- Performed as the DBA team’s representative to the User community (Finance, Distribution, Inventory, and HR).
- Worked closely with the department representatives to schedule and prioritize e-business changes that included patching and custom code deployment.
- Performed migration of E-business servers to a new Data Center.
- Performed research and implementation of ATG RUP6 and Critical Update Patches.
Confidential, Clarence, NY
Environment: Oracle E-business Suite 11.5.10.2 running on HP/UX.
Responsibilities:
- Environment: Oracle E-business Suite 11.5.10.2 on Red Hat Enterprise Linux (RHEL) 4 running on HP ProLiant DL580 G3 servers. Oracle 10g was running on the same hardware and OS. Modules included Financials and Manufacturing/Distribution (Mobile Supply Chain), Inventory, CRM, Advanced Supply Chain (ASCP), Demantra 7.1, iSupplier, InterAction Center, Mobile Supply Chain (MSCA), Kewill, and Warehouse Management (WMS). Implementation included multi-language (French, Spanish, and German). All environments were setup on HP SAN storage.
- Lead Senior Oracle Apps 11i DBA performing full implementation of Oracle E-business Suite 11.5.10.2 and 10g database.
- Developed TA120 (Platform and Network Architecture) documents.
- Managed and mentored clients DBA team. I also provided production support during this phased implementation.
- The implementation I performed included Inventory, MSCA, ASCP, Demantra, iSupplier, and Oracle Email Server 5.2.2 (Oracle 9i Database).
- Implemented Critical Patch Updates (CPU).
- Installed and configured DMZ and reverse proxy-server for iSupplier. Installation of Discoverer 10g with installation of 10gAS.
Confidential, Birmingham, AL
Environment: Oracle E-business Suite 11.5.10 on Solaris 8 running on Sun V480 servers. The Oracle 9.2.0.6 database is running on Solaris 8 on a Fugitsu 850 server.
Responsibilities:
- Senior Oracle Apps 11i DBA performing an assessment of the current environment and provide recommendations on patching, database tuning, and JVM tuning.
Confidential
Environment: Oracle E-business Suite 11.5.9 on Red Hat Enterprise Linux 3 running on IBM x Series 445 and 346 high-performance servers.
Responsibilities:
- Senior Oracle Apps 11i DBA performing an initial fresh install of 11.5.9.
- Performed a migration of Oracle E-business Suite from Solaris 8 to Linux RHEL 3. After the migration, I performed an upgrade to Oracle 11.5.10.
Confidential, Wayne, PA
Environment: Oracle E-business Suite 11.5.9 load balanced on Solaris 8 running on 2 Sunfire 280 servers. The Oracle 9i database was running on Solaris 8 on a Sunfire v880 server. The modules running included HR, Financials, Inventory, Sales online, Marketing online, and iProcurement. Oracle Application Server 10g (9.0.4) with Oracle Portal, Web Cache, Oracle Internet Directory (OID) with automatic synch with Active Directory.
Responsibilities:
- Senior Oracle Apps 11i DBA performing production support which included patching and cloning.
- Additionally, I was the Lead Oracle Applications 10g administrator performing production support for the Portal and OID environment.
- Cloned the Production Oracle Portal environment to a new Test environment.
Confidential, Trenton, NJ
Environment: Oracle E-business Suite 11.5.9 on Solaris 9 running on Sun Fire 6800 servers. The Oracle 9i RAC database is running on the same platform using Veritas Advanced Clustering 3.4. Modules included Inventory, Financials, iPayment, and Mobile Supply Chain (MSCA).
Responsibilities:
- Senior Oracle Apps 11i DBA performing the fresh install of 11.5.9 on all environments.
- Installed and configured Oracle 9i RAC using Veritas Advanced Clustering.
- Installed and supported Oracle Application Server 10g for use with Discoverer 10g (9.0.4).
- Performed various production support tasks including patching and cloning.
- Managed and mentored the clients Oracle Apps DBA team.
- Implemented and support MSCA and associated servers.
Confidential, Cherryhill NJ
Environment: Oracle E-business Suite 11.5.8 on Solaris 8 running on Sun Fire 6800 servers. Oracle 9i (9.0.3) running on the same platform. The modules include Financials, Discrete Manufacturing, Inventory, iProcurement, Installed Base, Quoting, and Configurator.
Responsibilities:
- Senior Oracle Apps 11i DBA installing the initial Oracle E-business Suite 11.5.5 environment with Oracle 8.1.7.2.
- Upgraded to Oracle E-business suite 11.5.8 and the database to 8.1.7.4 and then to 9i (9.0.3).
- Managed and mentored the clients Oracle DBA to affectively support the Oracle E-business Suite environments. Administration and upgrade of Discoverer EUL.
Confidential, Boca Raton, FL
Environment: Oracle E-business Suite 11.5.4 running on HP/UX 11.0 N and L class servers. Oracle 8.1.7 64-bit running on HP/UX L class servers. Modules include HR, Manufacturing, CRM, Financials, Inventory, and iStore.
Responsibilities:
- Senior Oracle Apps 11i DBA supporting European conversion of 3 sites to Apps 11i.
- Supported production which included patching and cloning.
Confidential, Allentown, PA
Environment: Oracle E-business Suite 11.5.2 running on HP/UX 11.0 N and L class servers. The Modules included Financials, Inventory, Oracle Shop Floor Manager and Discrete Manufacturing.
Responsibilities:
- Lead Oracle Apps 11i DBA installing Oracle E-business Suite 11.5.2.
- Upgraded to 11.5.3.
- Managed and mentored the clients DBA on supporting Oracle E-business Suite.
- Support and administration of Discoverer 4.
- Oracle DBA (7.5 to 8i) on Sun Solaris for Confidential and employers.
- Implemented and support PeopleSoft Financials and HR, Datawarehouse environments, and internally developed applications. (AT&T, Merck, Confidential, Advanta, Bristol Meyers Squibb, Lucent)