SUMMARY:

28 years of experience as certified Oracle Database Administrator (DBA), 21 years of experience as ERP DBA supporting Oracle EBS, PeopleSoft and SAP, 7 years of experience as Oracle DBA Team Manager, 1 year of experience in support role as MS SQL Server DBA

TECHNICAL SUMMARY:

APPLICATIONS: ORACLE Applications (9.4, 10.7, 11.0, E - Business Suite (EBS) 11i, R12.1, R12.2) including CRM (iStore, iSupport, Service), Demantra, Distribution, Financials, HRMS & Benefits, Manufacturing, Mobile Agents, Supply Chain, Value Supply Chain (VCP), and Warehouse Management System; DecisionPoint Warehouse; Peoplesoft Financials and Human Resources; Ernst & Young Navigator; SAP Financials; Vantive HelpDesk

DBMS: ORACLE V6 through 12c, MS SQL Server 2008/2012, Sybase

ORACLE TOOLS: Oracle Enterprise Manager (OEM), Grid Control and Cloud Control, SQL*Net, Import, Export, SQL*Loader, Oracle Enterprise Backup Utility (EBU)/Recovery Manager (RMAN), Oracle Application Server (OAS), Oracle Internet Application Server (iAS/Apache Web Server), Oracle Designer 2000, Oracle Names Server, Oracle Advanced Replication, Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Data Integrator (ODI), Oracle Real Application Clusters (RAC), Oracle Data Guard, Oracle Streams, Oracle Golden Gate, Oracle Exadata, Oracle SQL Developer, Service Oriented Architecture (SOA)

LANGUAGES: SQL, PL/SQL, ADA, BASIC, C, FORTRAN, HTML, JAVA, Linux Shell (Bash), Perl, PowerShell, Python, UNIX Shells (Bourne, C, Korn)

OPERATING SYSTEMS: UNIX (HP-UX, Sun OS, Solaris, IBM AIX, SGI IRIX, DEC ULTRIX, Digital UNIX) Linux (multiple distributions including Red Hat, Oracle Enterprise Linux, and SuSE), VAX/VMS 5.4, MS-DOS, Windows 3.1/95/NT/ 2000/2008/2012

HARDWARE: Oracle Database Appliance (ODA) and Oracle Exadata servers, Dell Enterprise Servers, IBM RS/6000, Hewlett-Packard T500/T520, SUN SPARC Enterprise Servers, Silicon Graphics Origin 200, DEC (assorted)

SOFTWARE: All Platinum Technology products for UNIX/ORACLE environmentsLegato NetWorker, Precise i3, Quest TOAD, Veritas NetBackup

SOFTWARE MGMT: Oracle Applications adpatch and ADOP utilities (have applied several hundred patches and troubleshot same), PVCS, RCS, SCCS, Tortoise SVN Subversion change control tool

EXPERIENCE:

Confidential, Warrendale, PA

Sr. Oracle Applications DBA

Responsibilities:

• Served as remote Sr. Oracle Applications Database Administrator consultant to CLI supporting a large Oracle E-Business Suite (EBS) environment.
• Supported multiple Oracle E-Business Suite (EBS) version 12.1.3 environments running on Oracle RDBMS 11.2.0.3 on Sun servers.
• Major EBS modules included Oracle Financials, as well as extensive customizations.
• Performed full complement of Oracle EBS tasks including cloning, health checks, and performance tuning.
• Supported several development and Production environments, including monitoring and alerting via Oracle Enterprise Manager/Cloud Control 13c.

Confidential

Sr. Oracle Applications Database Administrator consultant

Responsibilities:

• OSOS supporting a very large Oracle database environment running custom applications related to Elections and Business Administration.
• Supported Oracle RDBMS 12c Pluggable databases running in a RAC configuration with Tomcat application servers. Participated in migration to Oracle 18c databases.
• Supported several development and Production environments, including monitoring and alerting via Oracle Enterprise Manager/Cloud Control 13c.

Confidential

Sr. Oracle Applications Database Administrator consultant

Responsibilities:

• supporting several Oracle EBS 12.2.5 environments and well as several Oracle non - EBS environments.
• Supported multiple Oracle Data Guard physical standby databases.
• Performed Oracle EBS 12.2.5 application patching using ADOP utility.
• Served as remote Sr. Oracle Applications Database Administrator consultant to Confidential, supporting several Oracle EBS 12.2.5 environments.
• Performed extensive performance tuning for multiple EBS environments.

Confidential, Scottsdale, AZ

Lead Apps DBA

Responsibilities:

• Migrated several Oracle E-Business Suite (EBS) version 12.1.3 environments running on Oracle RDBMS 11.2.0.4 on Sun servers to a combination of Cisco UCS Blades and Oracle Virtual Machines, all running OEL 7.5. Major EBS modules included Oracle Financials, Oracle Procurement, Oracle Projects, as well as extensive customizations.
• Created Oracle Virtual Machine 3.4.5 environment consisting of Oracle VM Server, Oracle VM Manager, Oracle WebLogic 12c and ADF, MySQL 5.6 database repository, and mounted file systems.
• Created Oracle Data Guard 11g physical standby database using RMAN Duplicate command.
• Supported several development and Production environments, including monitoring and alerting via Oracle Enterprise Manager/Cloud Control 13c.
• Attended internal training on Oracle Cloud Infrastructure (OCI), including both enrollment and provisioning.
• Provided guidance to a small implementation firm on how to perform 7x24 support and transform into a Managed Services Provider.

Confidential, Wayne, PA

Lead Database Administrator

Responsibilities:

• Served as Lead Database Administrator for a large Oracle E-Business Suite (EBS) environment supporting the Confidential York plant.
• Mentored several junior DBA’s and led the initiative to build a support organization from the ground up.
• Supported several Oracle E-Business Suite (EBS) version 12.2.4 environments running on Oracle RDBMS 12c.
• Major EBS modules included Oracle Financials, Oracle Manufacturing, Oracle Value Chain Planning (VCP)/Demantra, as well as extensive customizations.
• Performed extensive patching of the AD/TXK modules from Confidential 6 to Confidential 10, upgrade of Fusion Middleware (FMW) from 11.1.1.6 to 11.1.1.9, WebLogic patching using Smart Update BSU tool, and Java upgrades from version 1.6 to version 1.8 121.
• Participated in Disaster Recovery (DR) planning, configuration, and testing of Oracle Active Data Guard standby and reporting databases.
• Worked with Corporate Risk and Controls team on extensive SOC1 survey and large infrastructure audit at the business process, server, database, and application level. Coordinated compliance monitoring using products from ArcSight and Imperva. Imperva agents were used to push information into ArcSight SEIM to meet SOC1 control requirements.
• Architected and implemented database and application monitoring and alerting system for entire Oracle EBS and VCP/Demantra enterprise. This consisted of Oracle Enterprise Manager OEM/Cloud Control (CC) 13c with significant Metric Extensions to monitor all aspects of the EBS applications environment, including WebLogic Server (WLS), Oracle HTTP Server (OHS), Concurrent Processing, Workflow, Oracle Mobile Web Agents (MWA), and Output Post Processor (OPP). Coordinated monitoring of application servers via Nimsoft monitoring.

Confidential, Flower Mound, TX

Sr. Oracle Applications Database Administrator

Responsibilities:

• Supported several Oracle E - Business Suite (EBS) version 12.1.3 environments running on Oracle 12c RAC.
• Implemented SHA-2 Certificates for Oracle Enterprise Manager/Cloud Control (OEM/CC) 12c agents across entire enterprise (100 plus agents).
• Worked on Oracle Enterprise Manager/Cloud Control (OEM/CC) upgrade from 12c (12.1.0.5) to 13c (13.2).
• Architected AD Authentication solution for Oracle databases using Microsoft Active Directory (AD) and multiple Oracle products including Oracle Virtual Directory (OVD).
• Architected AD Authentication solution for Oracle databases using Kerberos authentication with Microsoft Windows 2008 R2 Active Directory (AD).
• Prepared for future migration to Oracle Exadata by attending Oracle EBS on Exadata training conducted by IOUG.

Confidential, McLean, VA

Professional Database Administrator

Responsibilities:

• Served as remote Sr. Oracle Applications Database Administrator consultant to CSC for a large Oracle E-Business Suite (EBS) environment at a large Defense Contractor manufacturing facility in Newington, Connecticut and several nationwide subsidiaries.
• Managed several Oracle E-Business Suite (EBS) version 12.1.3 environments running on Oracle RDBMS 11.2.0.4. Major EBS modules included Oracle Financials, Manufacturing, Distribution, etc. as well as extensive customizations.
• Cloned Oracle E-Business Suite 12.1.3 environments using Rapid Clone utility.
• Patched E-Business Suite 12.1.3 environments using adpatch utility.
• Performed full complement of Oracle Application DBA duties including performing Rapid Clone, adadmin, adpatch, and admerge.
• Conducted extensive Performance Tuning for entire Oracle EBS environment, including Server kernel tuning, Oracle Database tuning and Oracle EBS Application Server tuning of JVM.
• Performed Oracle Applications System Administrator duties including User & Responsibility administration, and Concurrent process and requests.
• Performed Oracle iAS administrator duties for EBS environments.
• Supported integration of Oracle EBS 12.1.3 with Oracle Access Manager (OAM) 11gR2 and Oracle Identity Manager (OIM). This entailed the following:
• Installation and configuration of Oracle Web Logic 10.3.6, Oracle Internet Directory (OID) 11gR1 (11.1.1.9), Oracle Access Manager (OAM) 11gR2 (11.1.2.3.), Oracle Identity Manager (OIM) 11gR2 (11.1.2.3), and OAM WebGate (11.1.2.3.0 ).
• Supported integration of Oracle EBS 12.1.3 with Oracle Business Intelligence Enterprise Edition (OBIEE) and IDAM.
• Implemented Oracle Recovery Manager (RMAN) backups on EBS environments.
• Supported Oracle DataGuard (DG) environments for Disaster Recovery (DR) and High Availability (HA).
• Researched and championed implementation of Oracle Cloud Control 12c with Oracle EBS plugin.

Confidential, IDFalls, UT

Oracle DBA Consultant

Responsibilities:

• Served as Oracle DBA Consultant on a large Oracle database migration project at a Department of Energy (DOE) national energy lab in Idaho Falls, Idaho.Planned and implemented system migrations of several INL projects including:
• INEEL Non-radiological Waste Management Information System (INWMIS)
• Network Information Center (NIC)
• Training Records And Information Network (TRAIN)
• Visual Survey Data System (VSDS)
• Supported migration of Oracle database environments from physical LINUX servers to VMWare virtual machines.
• Performed database upgrades of Oracle databases from 11.2.0.2 to 12.1.0.2.

Confidential, Idaho Falls, ID

Oracle Applications DBA Consultant

Responsibilities:

• Served as Oracle Applications DBA Consultant on a large Oracle E - Business Suite (EBS) upgrade at a Department of Energy (DOE) national energy lab in Idaho Falls, Idaho. Managed several Oracle E-Business Suite (EBS) version 12.2.4 environments running on Oracle RDBMS 12.1, as well as legacy Production support for Oracle Applications 11.5.10.2 environments. Major EBS modules included Oracle Financials and Project Accounting as well as customizations.Performed upgrade of Oracle Applications 11.5.10.2 to Oracle E-Business Suite 12.2.4
• Cloned Oracle E-Business Suite 12.2.4 environments using Rapid Clone utility.
• Patched E-Business Suite 12.2.4 environments using ADOP utility.
• Performed full complement of Oracle Application DBA duties including performing Rapid Clone, adadmin, adpatch, and admerge.
• Performed Oracle Applications System Administrator duties including User & Responsibility administration, and Concurrent process and requests. Mentored local resources regarding Oracle EBS System Administrator functions.
• Performed Oracle Web Logic administrator duties for EBS environments.
• Prepared for integration of Oracle EBS 12.2.4 with Oracle Access Manager 11gR2. This entailed the following:
• Installation and configuration of Oracle Web Logic 10.3.6, Oracle Internet Directory (OID) 11gR1 (11.1.1.9), Oracle Access Manager (OAM) 11gR2 (11.1.2.3.), and OAM WebGate (11.1.2.3.0 ).
• Implemented Oracle Recovery Manager (RMAN) backups on EBS environments.
• Planned implementation of Oracle Cloud Control 12c with Oracle EBS plugin.
• Supported migration of EBS environments from physical LINUX servers to VMWare virtual machines.

Confidential, Salt Lake City, UT

Oracle Applications DBA Consultant

Responsibilities:

• Served as Oracle Applications DBA Consultant on a large Oracle Applications implementation at a payment processing company in Ogden, UT.
• Managed several Oracle E - Business Suite (EBS) version 12.1.3 implementations running on Oracle RDBMS 11.1.0.7.0 and 12.1.
• Major EBS modules included Oracle Financials and well as customizations.
• Performed full complement of Oracle Application DBA duties including performing Rapid Clone, adadmin, adpatch, and admerge.
• Performed Oracle Applications System Administrator duties including Workflow administration, User & Responsibility administration, and Concurrent process and requests.
• Supported migration of EBS environments to Oracle Data Appliance (ODA).

Confidential, Lehi, UT

Principal Technical Support Engineer

Responsibilities:

• Served as Oracle Support Engineer for Oracle DB Admin Group
• Served all Service Requests (SR’s) related to database engine and database internals.
• Completed Oracle 11g Certified Associate (OCA) certification.

Confidential, San Antonio, TX

Lead Technical Consultant

Responsibilities:

• Served as Oracle DBA/Oracle EBS DBA consultant for Oracle ERP division of Confidential .
• Worked with both Project group and Managed Services group in supporting Oracle EBS implementations ranging from Oracle EBS 11.5.10.2 through Oracle EBS 12.2.
• Trained on Vertex Tax software and its integration with Oracle EBS 12.x.
• Installed Oracle WebLogic 10.3.6 and Oracle Business Intelligence Discoverer 11.1.1.7 and integrated both products via End User Layers (EUL’s) with Oracle EBS 12.1.3 environments.
• Supported multiple Oracle EBS and SOA environments using ASM on RAC via Oracle Grid Control.
• Installed Oracle 11gR2 Oracle Grid Control and RDBMS software. Created RAC One single node environment using Grid Control and ASM.

Confidential, San Antonio, TX

Oracle DBA

Responsibilities:

• Served as Oracle DBA on the U.S. Air Force Integrated Pay and Personnel Systems (AFIPPS), a large HR modernization project for the U.S. Air Force.
• Implemented Oracle virtualization products (Oracle VM VirtualBox 4.3.16 and Oracle VM Server 3.3).
• Implemented Oracle Audit Vault/Database Firewall version 12.1.2 running on Oracle Enterprise Linux (OEL 5.10) servers.
• This involved leveraging Oracle Audit Vault work done previously for the U.S. Army Integrated Pay and Personnel System (Army (IPPS-A)) project.
• Composed Disaster Recovery & High Availability Plan for entire AFIPPS computing environment.
• Provided Oracle database support for Oracle Identity Manager (OIM)/Oracle Access Manager (OAM).
• Served as ERP DBA supporting large PeopleSoft 9.2 implementations of both Human Capital Management (HCM) and Financials modules.
• Performed assorted security training including work towards CompTIA Security+ certification.
• Submitted security clearance application (SF-86) and fingerprints for DoD Secret clearance.

Confidential, Portland, OR

Principal Consultant

Responsibilities:

• Served as Oracle EBS DBA consultant for a mid-sized ERP consulting firm based in the Pacific Northwest, including field support on site for clients.
• Worked on Oracle EBS 12.2.0 installation and upgrade from 12.2.0 to 12.2.3.
• Performed performance tuning for large Oracle OBIEE 11.1.1.7 implementation regarding both Oracle Data Integrator (ODI) loads and Dashboard and Analytics performance. Led effort to right size Data Warehouse database server for the Production BI environment.
• Served as System Architect for a large Data Center migration including hardware migration for EBS and Agile environments from HP-UX to Oracle VM’s running on ODA (Oracle Database Appliance).
• Assisted in business development for clients in both the Pacific Northwest and Mountain West.

Confidential, Dedham, MA

Senior Oracle DBA

Responsibilities:

• Served as Primary Remote DBA for a small consulting firm for dozens of clients remotely.
• Performed Oracle DBA activities (installations, upgrades, patching, performance tuning) on Oracle RDBMS’s ranging from Oracle version 9 to version 11.2.0.2.
• Performed Oracle Applications (EBS) DBA activities (patching, upgrades, cloning, performance tuning) supporting clients ranging from Oracle Applications Release 11.0.3 to Oracle e-Business Suite 12.1.2.
• Supported Oracle environments hosted on servers ranging from Windows NT to Linux distributions to various UNIX installations.
• Provided client support to environments ranging from development, test, quality assurance, and production.
• Performed after hours On Call support to dozens of clients world-wide.
• Notable activities include: performance tuning on RAC, maintaining Oracle Database Appliance (ODA) running multiple RAC instances and standby databases in a DataGuard configuration, RAC maintenance using ASM, performance tuning using AWR, Oracle EBS Workflow Mailer cleanup, Oracle backup and recovery, and training and mentoring junior personnel on both Service Desk and Oracle DBA practice.

Confidential, Salt Lake City, UT

Senior Oracle Applications DBA

Responsibilities:

• Served as Senior Oracle Applications DBA on a very large Oracle Applications implementation at an international E-commerce company in Salt Lake City, Utah. Managed several Oracle E-Business Suite (EBS) version 11.5.10.2 and 12.1.1 environments running on Oracle RDBMS 11.2.0.2.0. Major EBS modules included Oracle Financials, Inventory, and Order Management.
• Performed full complement of Oracle Application DBA duties including performing autoclone, adadmin, autoconfig, adpatch, and admerge.
• Performed Oracle Applications System Administrator duties including Workflow administration, User & Responsibility administration, and Concurrent process and requests.
• Served as ERP team lead on all monitoring tools. Upgraded Precise i3 monitoring software. Implemented Oracle Enterprise Manager Cloud Control 12c.
• As Senior Oracle Applications DBA, initiated best practices and industry standards. Mentored and trained several junior DBA’s. Captured, defined, improved, and documented procedures for cloning, security, standard DBA tasks, and user administration. Led department initiative to retrain legacy hires in advanced skills such as ASM, Exadata, OEM Cloud Control 12c, RAC, and Oracle EBS Release 12.
• Led technical initiative to implement Oracle EBS on Exadata.
• Reverse engineered, re-designed, and implemented multiple standby database configuration using Oracle Data Guard for Oracle EBS standby/failover, Disaster Recovery, and cloning environment
• Attended internal training classes on Oracle Real Application Clusters (RAC).
• Attended SQL Pass conference to enhance and upgrade MS SQL Server DBA skills.