John Michael Underwood

ac3mzx@r.postjobfree.com

214-***-****

Dallas, TX

SUMMARY

Self motivated Oracle Applications DBA with seven years experience in E-Business Suite 11i, R12.1 and R12.2 with 10g, 11g and 12c databases on Linux; Versed in management of full application suite installations, upgrades, tuning, patching, cloning, backups/restores both in high level planning and full execution of all technical requirements.

TECHNICAL SKILLS

Subject matter expert for all changes made as DBA with 500 concurrent users in GL, AP, PA, PJI, PO, FA modules with Dev, Test, QA, SIT, UAT, and Production instances with standard, custom, and third-party applications.

Management of full application suite:

oPlanning and execution of all installations, patching, upgrades, backups, cloning, and troubleshooting of R12.2 and 11i environments with and without ASM under 10g, 11g, and 12c single instance databases.

Installation of 11g RAC database with upgrade to 12c alongside EBS Interoperability.

Concurrent Program Creation - Advanced SQL / PL/SQL / shell scripting.

Environment health checks in accordance with Oracle Best Practices.

Extensive working knowledge of OEM 12c including standard and customized operations.

Creation of full backup, restore, and cloning policy through RMAN script, Netapp, bash, SMO, SDU, Commvault, OEM, and cron.

Storage management from OS level to ASM level (iscsi, FC, NFS). Partitioning of disks to creation and provisioning of diskgroups according to performance best practices (Oracle / Netapp / Linux).

OEM 12c, ADDM, trace, ASH, AWR reports, and Database and Systems Administration diagnostics (RDA / ADRCI / Bundle Analyzers / Patch Wizard / ETCC) as well as keeping healthy environments through standard and non-standard purging and maintenance.

Networking / Storage Administration / Linux OS Administration.

Working extensively and maintaining excellent relationships with Oracle Support engineers, vendors, managed services, and all related departments.

Data/report imports and exports using datapump / FTP / PGP encryption / FNDLOAD.

Experienced with Oracle Report Builder / Workflow Builder / BI Publisher for E-Business Suite / FSGs.

Great working knowledge of front end to back end Oracle Financials.

EXPERIENCE

Omni Hotels & Resorts 02/18/13 - Present

Financial Systems DBA

Upgrade ASM and database from 11gR2 to 12.1.0.2 and implement latest PSUs (Apr 2017) across all environments.

oUpgrade Forms 10.1.2.3.0 to 10.1.2.3.2

oSuite wide Java from 6u45 to 8u131 including .pem JAR signing.

oFMW upgrade from 11.1.1.6 to 11.1.1.9, including Weblogic Server 10.3.6 latest patches.

oAD/TXK upgrade 6 to 8.

R12.2.3 Reimplementation

o11.5.10.2 to 12.2.3 on Oracle Linux 6. Support applications throughout project and lead stabilization efforts post reimplementation.

Interfacing

oImports: PL/SQL / Shell scripting to maintain flat file interface procedures to handle batch loading of files up to 800k rows each across GL, PO, AP.

oExports: Create and coordinate export procedures for all requesting departments / outside companies.

Reports

oMigrate Checks and Purchase orders from .rdf to BI Publisher in E-Business Suite.

oBuild new/modify existing reports in PO/FA/PA/PJI/AP/GL modules.

oMigrate Discoverer reports to BI Publisher using (crosstab, pivot tables inside of RTF and Excel templates, including xslt to parse XML based data).

Business

oBuild Concurrent requests based on business needs through shell scripts and PL/SQL.

oDrive / Liason / QA technical (and functional) issues for all modules and third party integrated applications.

oWork very closely with business analyst team to quickly resolve any and all field issues. Drive for root cause analysis.

Independent Contractor – Fortegra Financial 8/2012- 01/2013

Assistant DBA/System Administrator

Project- R12.1.3 11.2.0.3 Upgrade

oUpgrade Oracle database and applications servers from 11.1.0.7 to 11.2.0.3 and

oR12.1.2 to R12.1.3

oMaintained step-by-step documentation and patch record; Installing software and patches.

oUpgrade 11.1.0.7 to 11.2.0.3.5 database and patch with latest PSU (JAN2013)

oAcquire basic SQL knowledge by checking for applied application patch numbers through SQL Developer, and various other attributes (users currently logged in, version numbers, etc.).

oDatabase creation and backups using Oracle DBCA.

Independent Contractor – Novara Solutions 8/2011-4/2012

Assistant Applications Database Administrator

Work directly under a Senior Database Administrator to gain experience in the following areas:

oDBCA and DBUA to install and upgrade databases: 10g and 11g.

oPackage changes and report template uploads requested by developers.

oPatch with Oct 2011 PSU.

oUpgrade R12.1.1 to R12.1.3 and apply latest database CPU (Apr2012).

oUpgrade JDK and JRE to latest version on apps and database nodes.

oConfiguring pfiles of new databases to match Oracle’s best practices.

oInstall User Productivity Kit Pro Version 11.0.0 with an Oracle 11.2.0.2 database - Configure Windows lIS Web Server and E-Business Suite.

Education

B.Sc. in Biology at University of Texas at Arlington 05/2011

Contact this candidate