SUMMARY:

• An accomplished information systems professional with over 25 years of experience in the configuration, implementation, management and support of data base administrative systems.
• This includes over eighteen years of experience serving as an Oracle Database Administrator and more than five years serving as a Technical Project Leader.
• More than 15 years working with the Oracle e - Business Suite including installations and upgrades.
• Additional experience includes the development/support of Enterprise Data Warehouse systems that exceeded 50 terabytes in size.
• Performance tuning, Oracle PL/SQL development, CLOUD, interface programming and UNIX scripting are also areas of experience.

ORACLE TECHNOLOGY:

DATABASE ADMINISTRATION, DATA MODELING, DATABASE PROGRAMMING: ORACLE E-BUSINESS SUITE, VERSIONS 12, 11 DATA WAREHOUSE DESIGN, PL/SQL, DATAGUARD, RMAN, ASM,TOAD, INFORMATICA, GRID (OEM), IMPDP, EXPDP, ERWIN, GUARDIUM, SCHEMA DESIGN. UNIX SCURE SHELL SCRIPTING, ACFS, RAC, WEBLOGIC, SSO, VI, PL/SQL, SQL, PYTHON, RAPID INSTALL, GOLDEN GATE, AUTOSYS, EXADATA, ADCTRL, ADPATCH, LOGMINER, CLOUD, ADOP, ETL, APEX PYTHON, PHYSICAL STANDBY, REMEDY, RAC, APACHE HADOOP, PERL, SECURITY

DATABASE TECHNOLOGY: ORACLE 12C, 11G, 10 (15 years +, Last used 2018 ), SQL Server 11.0

OPERATING SYSTEMS: AIX, SOLARIS, LINUX, WINDOWS 2008, WINDOWS 2012

WORK EXPERIENCE:

Senior Oracle Database Consultant

Confidential

Responsibilities:

• Upgrade Oracle Databases from 11G to 12C, EXPDP, IMPDP
• Linux / Windows 2012 hardware, RAC ASM TOAD GRID DATAGUARD PYTHON
• Patching, database tuning and application tuning.

Senior Database Admin

Confidential

Responsibilities:

• Managed LARS database applications (11 50T databases).
• Upgrade from 11G to 12C, Refreshes, tuning, patches, schema creation and changes, development liaison.
• Deploy application code to middleware and provide tuning advice
• ERWIN, TOAD, GRID(OEM) RMAN ASM ACFS SSO RAC IMPDP/EXPDP WEBLOGIC DATAGUARD, TOAD SSO AUTOSYS REMEDY GUARDIUM APEX

Senior Database Developer

Confidential

Responsibilities:

• Liaison with development on PL/SQL tuning and troubleshooting.
• Development of triggers, packages and views.
• TOAD, GRID, PL/SQL, PYTHON

Senior Database Administrator

Confidential

Responsibilities:

• Support Confidential CORP and CARD database applications.
• Installation, upgrade, patching, cloning, tuning and support of Oracle e-Business Suite versions 11.5.10
• Red Hat and Solaris Servers. Custom Schema Design.
• Database and application migration from Red Hat to Solaris
• Problem resolution and code tuning issues.

Oracle DBA

Confidential, Charlotte, NC

Responsibilities:

• Design, creation and loading of multi-terabyte partitioned data storage for the Confidential Enterprise Data Warehouse medical system.
• Global/local partitioned indexes,
• Database upgrades from Oracle 10g to Oracle 11gR2 on RAC storage.
• PL/SQL query writing and tuning techniques for large scale partitioned data.
• Golden Gate was utilized to load data

Oracle DBA Lead

Confidential, Chicago, IL

Responsibilities:

• Migration of 65 Oracle Databases and the custom MEPS application to one consolidated MEPS database
• Design and implementation of database storage and schema modifications
• Installation and configuration of WebLogic, J2EE for Custom Apps /SOA
• Modify PL/SQL procedures and triggers to support merged data
• Database upgrades from Oracle 9i to Oracle 11gR2, platform migration from AIX to Red Hat EXPDP IMPDP ASM RAC

Senior Oracle DBA

Confidential, Charlotte, NC

Responsibilities:

• Installation, upgrade, patching, tuning and support of 9 Oracle Asset Suite instances,
• Schema design and implementation for assets DataMart (5 terabytes)
• Database Upgrade from 11gR1 to 11gR2 on RAC Storage EXPDP IMPDP

Senior Oracle Applications Database Administrator

Confidential, Arlington, VA

Responsibilities:

• Database upgrades from 10G to 11gR1 and 11gR1 to 11gR2
• Development Support liaison for the Application DBA team
• Installation and configuration of WebLogic, ANT, J2EE and SOA
• Lead Technical Support for interface importation of legacy systems from multiple sites, coordinating with end users and management.
• Gathered user requirements for custom development, supported development efforts.
• Additional Products installed and Supported:
• SOA, OBIEE, OID, OEM, WMS TOAD, ERWIN, IMPDP, EXPDP, PL/SQL

Senior Oracle Applications Database Administrator

Confidential, Dayton, OH

Responsibilities:

• Installation, upgrade, patching, tuning and support of 26 Oracle Application Systems in RAC environments on Sun Solaris Servers.
• Application versions include 12.0.6 and 12.1
• Development Support liaison for the Application DBA team.
• Custom schema design and creation
• Additional Products installed and Supported:
• WebLogic, SOA, WMS, OBIEE, OTM, ODI, OID, PLM
• Collaboration Suite, J2EE and DEMANTRA
• Supported the importation of legacy systems from multiple sites
• Developed PL/SQL interfaces for the load of WMS and item data

System Architect / Technical Project Leader

Confidential, Winchester, VA

Responsibilities:

• Managed team of 6 development Database Administrators, 5 Java developers, 2 BOBJ report writers and 4 requirements writers
• Managed the development of the following projects:
• National Coordination Team Tracking Application
• Task Order Administration and Quality Control Systems
• Inspection Management Review
• Relocation Assistance Application
• Database upgrade of all applications from 9i to 10G
• Implemented project management / agile application development methodology
• Designed schema and database storage for Confidential applications.

Oracle DBA

Confidential, Danvers, MA

Responsibilities:

• Upgrade Applications database from 9i to 10G
• Installation of Oracle diagnostics and WEB ADI, CPU patches

Oracle DBA

Confidential, Harrisonburg, VA

Responsibilities:

• Oracle Applications 11.5.10i reimplementation / upgrade project
• Installation of multiple instances of 11i on LINUX
• Upgrade Applications 11.0.3 to 11.5.10 and applications database from 9i to 10G
• Capacity Planning, Developed interfaces for the load of legacy data.
• Cloning, patching, monitoring and tuning multiple instances

Oracle DBA support

Confidential, NY

Responsibilities:

• Database and application patching, cloning
• Installation and configuration of EBS adapter and OAI schema creation
• Performance tuning of Database, middle tier and custom application code
• Application problem resolution and research
• Oracle 11.5.10 Oracle On Demand
• Database and application patching and cloning
• Application problem resolution and research