Oracle eBusiness Suite Administration

• Over 6 years' experience on versions 11.5.10 through 12.2.4 primarily with Oracle Financials, Advanced Supply Chain Management, Value Chain Planning, HR and LCM on AIX, HPUX, RHEL, HP, Solaris, OEL and SuSe Linux.
• Planned and performed an upgrade of an E-Business Suite to R12, including the migration to new servers with a different operating systems, and from a Unified APPL TOP to a three node Shared Application Tier File System.
• Experienced with creating and performing Business Continuity Plan testing.
• Over 3 years' experience working with a Single Sign On enabled Oracle E-Business Suite.
• Proactively support development teams, cloning instances, timely code review, testing and production migrations.

Oracle Database Administration

• An Oracle Certified Professional with 8 years' of experience with Database Administration 8i through 12c.
• Utilized a wide range of features: SSO, OID, ASM, WebLogic, OEM12C, AgilePLM, SOA, Golden Gate, SharePlex, Oracle Fusion Middleware 11g, OEM 11g Grid Control, SOA, OBIEE, Oracle Fusion Middleware, RMAN and Flashback.
• Implemented 10g RAC/11g RAC with ASM file system and Migrated Non ASM databases to ASM.
• Build and administer 10g and11g Dataguard instances both physical and logical .
• Adept at working with Development teams, communicating best practices for new DDL, enforcing standards.
• Proficient at writing Unix Shell and SQL scripts and coding indexes, stored procedures, sequences, partitions etc.
• Architect, install, tune, upgrade, migrate and maintain security.

Microsoft SQL Server Administration

• 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.
• 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 and 2008R2 SQL Server Instances.

ORGANIZATIONAL EXPERIENCE

Confidential

Lead Oracle Applications Database Administrator

• Lead DBA and project manager for an upgrade to R12.2.4 with a separate Value Chain Planning Instance.
• Consultant providing production support for an EBS 11i system with ASCP, Agile PLM, SOA suite, Weblogic, OEM 12c, OEM 11g, RAC, ASM, Data Guard, OBIEE and an R12.2.4 implementation with Value Chain Planning.
• Resolved single instance R12.2.4 performance issues by configuring a separate Value Chain Planning R12.2.4 instance and a standalone ASCP Managed Server with Web Logic Server 12.1.3. Configuring the New Material Plan to execute via the WLS, reducing the total planning process from 11 hours to 5.2 hours.
• Built two physical data guard standby instances, one for an EBS 10g DB and another for Agile PLM 11.2.0.3 DB.
• Cloned two 11.5.10.2 instances to SPARC T4 servers and performed a Direct Path Upgrade as a proof of concept.
• Applied the Latest AD and TXK Release Update Packs to upgrade to Oracle E-Business Suite Release 12.2.4.
• Fixed issues with failed and erring backups groomed the associated policies and the exchange with Net Backup.
• Resolved Oracle Performance issues related to Solaris Zone configuration, initialization parameters and storage.
• Fixed failed and backup with warnings issues with RMAN and VERITAS Net Backup for Oracle Release 6.5.
• Upgrade two databases from 10g to 11g and converted them from file system to two node RAC /ASM instances.

AREAS OF EXPERTIS

Lead Oracle Applications Database Administrator

• Maintained an Oracle E-Business Suite 12.1.3 system, on AIX 6.1, utilizing Supply Chain Management, Financials, HRMS modules, additionally supported Manhattan Warehouse Management System on Oracle 11g databases.
• Performed Critical Patch Updates to all Oracle Systems, and established monthly maintenance process.
• Developed documentation for cloning, and restoring EBS and WMS systems from backups.
• Resolved issues with Epicor POS and Manhattan WMS transactions that were creating a negative on hand balance.
• Cloned the production EBS using RMAN Duplicate Database, without target and recovery catalog connection.
• 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.
• Established security audits, access process, corrected deficiencies and modified associated site profile settings.
• Developed standard procedures to include cloning, health checks, patching, month end processing, monthly maintenance, printing, code migration, testing and business continuity planning.

Confidential

• 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.
• Built a Data Mart 11g database on a four node RAC as a repository for the Strong Mail email campaign system.
• Troubleshoot ETL jobs and Golden Gate extract errors providing data to Teradata systems.
• 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.
• Completed the annual switch over testing to stand by systems.
• The sole DBA for 64 instances of SQL Server, supporting applications like HighJump, Fraudnet, Acertify, Sharepoint, Riversand MDMCenter, Strong Mail and NCR Customer Power.
• 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.
• Performed Oracle Internet Directory and WebLogic administration and maintenance.

Confidential

• 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 three 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 without Dataguard through manually shipping and applying redo log files for the EBS system, developed the Business Continuity Plan and coordinated the switchover testing.
• Supported Shareplex for oracle replication of data from production to warehouse databases.
• Provided 24/7 support for 185 Oracle 8/9i/10g/11g databases, patching, upgrading and troubleshooting instances.
• Installed and upgraded Ring Master APM to manage patches between environments, from test through production.
• Developed shell scripts to startup /shutdown, set the environment and clone Oracle EBS R12.
• Developed CRON jobs to perform daily database backups for test databases, and remove old archive logs.
• Applied both Critical Patch Updates and Patch Set Updates, configured all production databases with OCM.
• Migrated 85 Databases from HP-UX to SUSE Linux 10 and Itanium Operating Systems.
• Utilized RMAN to backup and restore databases and to clone production systems for development teams.
• Developed maintenance plans to identify, prioritize fragmented tables and to rebuild associated indexes dramatically improving performance, reclaiming space and decreasing backup and restore times.
• Worked with functional developers and determined bug fixes for Oracle E-Business Suite modules like: Accounts Payable, Payments, Legal Entities, Fixed Assets, Purchasing, IProcurement, IExpense, Subledger accounting, General Ledger, Cash Management, Workflow, XML Gateway, BI Publisher and Oracle Time and Labor.
• Upgraded the Oracle Application Server from Java 5 to Java 6, and Oracle Forms and Reports server to 10.1.2.3.
• Administered Oracle Application Manager, Single Sign On and Oracle Internet Directory with 10g and 11g databases.
• Evaluated, tested and migrated 2136 production code changes.

Confidential

Key Result Areas Significant Highlights

• 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.
• Upgraded a Solaris server from v5.6 to 5.8 and the resident database from 8.1.7.4 to 9.2.0.5, then installed an Oracle 10g database on windows VM and imported the 9.2.0.5 database from the Solaris server.
• Upgraded a client Oracle Application 9i database to 10gR2 and E-Business Suite 11.5.9 to 11.5.10.
• Resolved issues with Web Server, Web Listener, Forms Server, Concurrent Manager/Request, and Report Server.

Confidential

Significant Highlights

• Advanced Network Analysts, 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.
• 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.