SUMMARY:

• 9 years’ experience as an EBS DBA working with versions 11.5.10, 12.1.3, 12.2.3 - 12.2.5 primarily with Oracle Financials, HR, OTM, ASCP, Discoverer, Portal, LCM on AIX, HP, RHEL, Solaris, SuSe Linux, 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 and 11g RAC with ASM on RHEL, Solaris and Hitachi, EqualLogic, and NetApp SAN systems.
• Build and administer 10g,11g and 12c Dataguard 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.
• Proactively tune, monitor, plan system maintenance, improve security, and manage RMAN backups and policies.
• Moved database and file system backups to the Oracle Database Backup Service and Storage Cloud.
• 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 2008 R2 having provisioned Failover Clusters, Database Mirrors, log shipping on standalone servers and virtual machines.
• Adept at SQL Server Database Tuning, identifying bad indexes, transaction log and tempdb sizing, performing DDL code review, managing security and ensuring SOX compliance for 2005, 2008R2 and 2012 SQL Server Instances.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle and Applications DBA

Responsibilities:

• Technical Lead for an EBS R12.2.4 System on a 2 Node RAC, ASM, 7TB database on Exadata with ZFS Storage.
• Support 18 cloud development instances and 6 named 2 node RAC 12c instances.
• The EBS integrates with EIS, Inspyrus Invoice Automation Software, Mentis Data Masking and Highjump WMS.
• Project Lead for EBS Migration from Oracle Exadata Database Machine X4-2 to X5-2.
• Building and documenting processes for projects and standard DBA tasks to ensure reliability.

Confidential

Senior Oracle and Applications DBA

Responsibilities:

• Primary DBA support of an R12.2.5 upgrade project, document all process and train the DBA Staff.
• 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 applications on Oracle Databases, OEM 12c, and 85 production SQL Server databases.
• Performed development and production datacenter migrations from Verizon to Cyrus1.
• Documented and performed annual SOX compliance password changes.
• Designed a Centralized Crude Transportation and Dispatch Application utilizing Application Express.
• Documented and performed the application of AD-TXK RUP 7 and the 12.2.5 patch to a cloud and named RAC EBS.

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

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

Confidential, Calabasas, CA

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.
• Provided SQL Server DBA support as needed for the EPICOR POS system.

Confidential, Cottonwood Heights, UT

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, Woodland Hills, CA

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 2005 / 2008 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, Santa Ana, CA

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, San Diego, CA

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 su pervising 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.