SUMMARY

• 9 years’ experience as an EBS DBA working with versions 11.5.10, 12.1.3, 12.2.3 - 12.2.6 primarily with Financials, HR, OTM, ASCP, BOM, VCP, Discoverer, Portal, DMZ and LCM on AIX, HP, RHEL, Solaris, and SSO enabled EBS.
• Supported EBS Systems up to 7TB, including up to R12.2.5 on EXADATA and EXALOGIC and Cloud Instances.
• Performed E-Business Suite upgrades to R12.1.3, R12.2.3, R12.2.4 and R12.2.5, including database migration and upgrades, RAC and ASM implementation, and moving to multi-node Shared Application Tier File System.
• Experienced with creating and executing Business Continuity Plans and building High Availability Solutions.
• Involved in all phases of the Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Perform Oracle EBS 11i & R12, configuration, patching, cloning, troubleshooting, tuning and administration.
• Support off shore and in house development teams providing peer code review, testing and timely migrations.
• Setup and maintain an external DMZ with reverse proxy in support of iStore, Sourcing and iProcurement.
• Oracle Certified Professional with 10 years of experience working with versions 8i, 9i, 10g, 11g and 12c.
• Implemented 10g, 11g, 12.1.0.2 RAC on RHEL and Solaris with Hitachi, EqualLogic, and NetApp SAN systems.
• Build and administer 10g, 11g and 12c Data guard instances to both physical and logical standbys.
• Utilized a wide range of products: OEM12C, GRC, AgilePLM, SSO, OID, Golden Gate, SharePlex, OEM 11g, OBIEE, RAT, ADDM, Manhattan WMS, WebCenter, Nagios, Jira, Remedy, Ignite, Solar Winds and Toad.
• Established development coding and documentation standards, ensuring best practices and planning for growth.
• Proficient at writing Unix Shell and SQL scripts and coding indexes, stored procedures, sequences, partitions etc.
• Moved database and file system backups to the Oracle Database Backup Service and Storage Cloud.
• Good experience in SQL, PL/SQL, Bourne Again Shell (bash), Korn shell (ksh), and some Perl Scripting.
• Installed Oracle Fusion Middleware 11g for SOA, Portal, Discoverer, Polaris and Agile PLM, OBIEE, OAM and OID.
• Upgraded SOA, Database from 11.2.0.3 to 12.1 via a Full Transportable Export/Import.
• Established development environments for Agile PLM, SOA WebLogic, and OBIEE.
• Utilized Smart Update utility and OPatch to apply PSU for SOA Suite, Oracle EBS R12.2 and OBIEE systems.
• Proficient with Microsoft SQL Server database management versions 2005 and 2008R2 having provisioned Failover Clusters, Database Mirrors, log shipping on standalone servers and virtual machines.

PROFESSIONAL EXPERIENCE

Confidential

Lead Oracle Applications DBA

Responsibilities:

• Technical Lead for an EBS R12.2.4 System on a two Node RAC, ASM, 8TB database on Exadata and EMC SAN.
• Planned and executed a data center migration and moved from EXADATA X4-2 to X5-2 Quarter Rack.
• Planned and built a two-node Oracle RAC cluster version 12.1.0.2.0 on EXADATA X4-2 and then built an EBS Physical Standby, and performed a RAC to RAC clone to create a pre-production EBS R12.2.4 system.
• Build, refresh, support 24 cloud development instances, and 6 named two node RAC instances.
• The EBS integrates with EIS, Inspyrus Invoice Automation Software, Mentis Data Masking and the HighJump WMS.
• Developed bash shell scripts to refresh EBS instances on Cloud and Exadata systems.
• Lead and mentored a 4-member team, setting and ensuring the achievement of performance goals.
• Created over 100 support task documents to ensure accuracy, reliability and sound repeatable processes.
• Planned and coordinated Disaster Recover testing, performed SOX compliance, and moved to RMAN Net Backup.

Confidential

Senior Oracle and Applications DBA

Responsibilities:

• Short-term project - DBA support of an R12.2.5 upgrade project, and production oracle and sql server databases.
• Lead resource for two production EBS R11.5.10.2 and R12.1.3 System on OEL, with 6 development instances.
• Support Maximo and Hyperion on Oracle Databases, OEM 12c, TSM and 85 production SQL Server databases.
• Performed development and production datacenter migrations from Verizon to Cyrus1.
• Designed a Centralized Crude Transportation and Dispatch Application utilizing Application Express.

Confidential

Senior Oracle and Applications DBA

Responsibilities:

• Maintain Oracle EBS R12.1.3 System with four-node shared APPL TOP, on a two node 11.2.0.4 RAC database with ASM and associated Data Guard Physical Standby on a two node 11g RAC.
• The R12.1.3 system utilizes Parallel Concurrent Processing with an F5 Load Balancer, Financials, OTL, I-expense, Vertex, HRMS, Payroll, Centralized ASCP, Polaris, Discoverer, OAM, OID and DMZ.
• Maintain Fusion Middle Ware 11g in support of the DMZ for the EBS environment for iProcurement, 2000+ users.
• Performed EOY Payroll, ACA Phase II Patching, and Recommended Patch Collection 4 (RPC4)
• Migrated and upgraded four two node RAC 11.2 clusters from RHEL 5.5 to 6.5, and migrated ASM to new storage.
• Administer Oracle Fusion Middleware 11g, with WebLogic server version 10.3.6.0 for Portal and Discoverer.
• Utilized Oracle Advanced Compression 11gR2 to compress tables and index partitions.

Confidential

Senior Oracle and Applications DBA

Responsibilities:

• Performed upgrade of a 4TB, Oracle EBS 11.5.10.2 systems to R12.2.3, with two Web Nodes and two Concurrent Processing Nodes. This system utilized Parallel Concurrent Processing with an F5 Load Balancer.
• This system also included I-Supplier, Financials, OTL, I-expense, Vertex, GRC on AIX 6.1.
• Resolved issues with PDF Printing, WEB ADI, Recurring Invoice Program, Workflow, Revalue Balances, Heap Size, fs clone failing on NFS file System, failed patches, Auto Invoice Program Failing and AR performance.
• Applied patches with ADOP through CRP, UAT and QA environments, analyzing the changes and performance.
• Created a process to archive and preserve Audit Trail Information for 11 Audit Groups to maintain historical data.
• Utilized Oracle GRC Application Access Controls Governor for user provisioning and Segregation of Duties.

Confidential

Senior Oracle and Applications DBA

Responsibilities:

• Principle Oracle Engineer supporting two Oracle EBS 11.5.10.2 systems with ASCP, Discoverer, Agile PLM, SOA suite, Weblogic 11g, OEM 11g and 12c, RAC, ASM, Data Guard, Kardex Remstar and OBIEE.
• Upgraded a SOA database from 11.2.0.3 to version 12.1 via a Full Transportable Export/Import.
• Built four Data Guard Physical Standby’s for 10g and 11g databases, both in file system and ASM to ASM.
• Performed an Oracle EBS technical upgrade from 11i to R12.2.4 and a separate Value Chain Planning instance on SPARC T4 servers, two nodes Oracle RAC 11.2.0.3, ASM, and a Physical Data Guard Standby.
• Applied the Latest AD and TXK Release Update Packs to upgrade to Oracle E-Business Suite Release 12.2.4.
• Established development environments for Agile PLM, SOA Weblogic, EBS and OBIEE.
• Installed Oracle Business Intelligence (OBIEE) 11.1.1.8.1 , ODI 11.1.1.7.1 , SOA Suite and Domain, OEM 12c.
• Moved production database backups to Oracle Storage Cloud Service from VERITAS Net Backup Oracle Release 6.5.
• Installed and configured OEM12c on Linux with Oracle Middleware Management, Diagnostics and Tuning Packs.
• Customization and development of Korn shell scripts, for cloning, automation of data loading and SQL*Loader.

Confidential

Senior Oracle and Applications DBA

Responsibilities:

• Maintained a 4TB Oracle E-Business Suite 12.1.3 system on AIX, utilizing Supply Chain Management, Financials, HRMS modules, additionally supported Manhattan Warehouse Management System on Oracle 11g databases.
• Scripted backups and performed various restore and recovery scenarios using RMAN on test databases.
• Performed Critical Patch Updates to all Oracle Systems, and established monthly maintenance process.
• Created an archiving and purging process for the Landed Cost Manager L4 Staging table, which involved creating materialized views, triggers, alerts, error checking processes and defining two concurrent programs.
• Significantly improved Manhattan WMS performance by tuning 22 queries to utilize better execution plans.
• Installed and configured Oracle Enterprise Manager 12c on a Redhat Linux VM, improving system monitoring.
• Establish a snap copy process on a NetApp 3160 server decreasing cloning time from 24 hours to 4.5 hours.

Confidential

Oracle and SQL Server Database Administrator

Responsibilities:

• Oracle Database Administrator on a 7TB, Oracle 11gR2, six Node RAC OLTP systems, maintaining 99.99% uptime.
• Key member of the Database team that received Compuware's 2011 and 2012 Best of the Web Gold Award in the Retail Product Order Transaction category, which benchmarks measure response time, availability and consistency.
• Received the IT Departments Most Outstanding Performer Award for 2012.
• Built an 11gR2 database and scripted the production refresh process to meet finance reporting requirements.
• Created 2 Logical Standby Databases utilizing Oracle Data Guard 11gR2.
• Configured Golden Gate for replication, ETL, upgrades, and on-demand refreshes of development environments.
• Resolved Data Guard replication lag issues between primary and standby databases.
• Performed table and schema export and imports, DDL Code review, added disk to the ASM disk group etc.
• The sole DBA for 64 instances of SQL Server, supporting applications like HighJump, Fraudnet, Acertify, Sharepoint.
• Upgraded the HighJump Warehouse Shipping System database from SQL Server 2005 with a database mirror to a 2008R2 Active/Passive Failover Cluster, and created the data warehouse for long term Micro Strategies Reporting.

Confidential

Oracle Applications and Database Administrator

Responsibilities:

• Upgraded the E-Business Suite Application Techstack from R12.0.4 to 12.1.3 and the Database from 10g to 11g.
• Migrated the EBS database to HP-Itanium and the APPS tier to four SLES 11 nodes, integrated with Single Sign On.
• Upgraded an Oracle E-Business Suite from 11.5.10.2 to Release 12 RUP4 and cloned to 6 test environments.
• Created a standby database and fail over Oracle Applications Node.
• Supported Shareplex for oracle replication to a data warehouse database, oracle data store and migration.
• Provided 24/7 support for 185 Oracle 8/9i/10g/11g databases, patching, upgrading and tuning instances.
• Maintained 14 SQL Server R2 systems.
• Applied both Critical Patch Updates and Patch Set Updates, configured all production databases with OCM.
• Created a two-node Oracle 10g RAC system on Linux as a proof of concept project.
• Created custom Autoconfig templates, in support of the upgrade to R12.
• Upgraded Fujitsu i-Flow, Java Based workflow engine from 6.1 to 10.1 for BEA WebLogic.
• Migrated 76 Databases from HP-UX PA-RISC to SUSE Linux 10 and Itanium Operating Systems.

Confidential

Oracle Applications and Database Administrator

Responsibilities:

• Performed 11.5.10.2 instance clones on Windows, Solaris, AIX and Redhat Linux and OEL servers.
• Configured a Dell Server Rack consisting of power edge 2850’s, 2650’s, power vault 220’s, with Oracle Linux and RHEL operating systems, 10g databases and release 12 E-Business Suite vision instance.

Confidential

IT Director

Responsibilities:

• IT Director, USS Helena (SSN-725). The sole IT resource on a 150-member Nuclear Submarine. Developed six staff into a network team providing 24/7/365 customer support. Managed 3 LAN systems and Exchange Server.
• Awarded 2 Navy Commendation Medals and 8 Navy Achievement Medals for outstanding performance.
• Served in various leadership roles as the Chief of the Boat, Combat Systems Department Chief and Leading Chief Petty Officer supervising 16 to 165 personnel onboard US Nuclear Submarines.
• At the Special Surveillance Equipment Program Managed overall staff of 35 and budgetary responsibility of $22M with a $12M operational budget and a $10M+ program and project budget.