SUMMARY:

• Confidential has twenty - three years of experience within the IT field heavily focused on Oracle and Linux technologies with over thirteen years of IT consulting. This includes project work as a programmer, development DBA, production support DBA, and Linux administrator. Main skill focus has been on Linux and Oracle tools including large amounts of pl/sql programming, database modeling, solution architecture design, heavy emphasis on performance tuning, testing and security. The pre-dominant work has been in larger size companies with large user bases and heavy transactional demand. The first ten years was focused in manufacturing within the automotive industry. The last thirteen years has been primarily focused on financial institutions and the health care industry.

TECHNICAL SKILLS:

Relational Database Technologies (Install, upgrades, production support): Oracle Database Versions 7 through 11g. Oracle RAC, ASM, Grid Infrastructure MySQL Version 5.1 through 5.6

Middleware Technologies(Installation, upgrades, production support): Oracle Business Intelligence Suite Oracle Discoverer 4i, 10, 11g Oracle Forms 6i through 10g Oracle Reports 6i through 10g Oracle Fusion Middleware Oracle WebLogic Server 11g Oracle Application Express Versions 3 through 4

Virtualization Technologies: VMWare VSphere VMWare ESXi version 4 and 5 Oracle VirtualBox

Servers, Operating Systems, (Install, upgrades, production support): IBM RS/6000 AIX (over 6 years experience) HP/UX (over 7 years experience) Sun/Oracle Solaris (over 3 years experience) Linux (RHEL, CentOS, OEL) (over 10 years experience) including LAMP stack implementation and support, SELinux, OS hardening, and security best practices.

OS Shell Scripting: All major shell variants for scripting. (bash, ksh, csh) Sed / awk / Unix/Linux tool scripting

Development Tools and IDEs: Eclipse Oracle SQL*Developer Oracle JDeveloper Oracle Forms and Reports Oracle Discoverer Oracle Application Express (Apex) Versions 3.0 and 4.0

Languages: Oracle PL/SQL SQL Java Javascript PHP Perl

Applications: Oracle Applications 10.7 (SC and NCA) (Financials and Manufacturing) Oracle EBusiness Suite v 11, 11i, R12 (Financials, Payroll/HR, Manufacturing)

Admin Tools: Oracle Enterprise Manager/Grid Control HP PPM (formerly Kintana and Chainlink)

PROFESSIONAL EXPERIENCE:

Data Architect/Oracle DBA

Confidential

Responsibilities:

• Responsible for SQL DDL/DML, and PLSQL coding standards and code reviews.
• Performance tuning of existing code.
• Creation of Data Models based on current architecture.

Confidential

Sr. Cloud Operations Engineer - Oracle DBA

Responsibilities:

• Responsible for Oracle databases within the 2ndwatch managed services clients.

Confidential

Lead Dev Ops DBA

Responsibilities:

• Responsible for 9 Oracle 11g databases supporting approximately 20 Srcum teams in an Agile environments
• Provide support for mutlitple automated builds per day
• Support Liquibase change sets for Oracle
• Responsible for Flashbacks of DEMO/ environment
• Responsible for patching, backups, exports
• Responsible for tuning and troubleshooting

Confidential

Senior DBA (Consulting and internal systems)

Responsibilities:

• Recommendations and upgrades on EBS from 11i to 12.1.3 in split configuration
• Managing upgrades and technical patching on 21 instances
• Installation and deployment of Fusion Middleware in support of Discover upgrade from 10g to 11g.
• Performance tuning and analysis for pre-upgrade and post-upgrade

Confidential

Senior DBA

Responsibilities:

• Production support for Oracle databases and applications
• Recommendations and upgrades on EBS from 11i to 12.2
• Support and upgrade of OS from RHEL 2.1 to OEL 6.5

Confidential

Senior DBA/System admin

Responsibilities:

• Internal systems implementations and support for over 15 Linux severs
• Implementation and support of Nagios internal environment for monitoring internal and customer systems.
• Implementation and support of Splunk indexers, search heads and approximately 30 forwarders for internal systems and customer systems. Includes custom indexers for Oracle application and database log files.
• Splunk Certified Knowledge Manager V.6 since April, 2014
• Responsible for Splunk dashboards and alerts for internal systems.
• Implement custom data sources for Oracle Upgrade log files for Splunk analysis.

Confidential

Associates

Responsibilities:

• Development DBA responsible for re-design and implementation for weekly Payroll/HR audit process. Processing encompassed 4,000,000 payroll elements. Original process took up to 40 hours. Re-design included parallel query optimization with configurable multi-threaded works and bulk pl/sql processing while still leveraging Oracle standard Payroll API calls. Re-design took processing from 40 hours to 2 hours.
• Lead development DBA for reporting database design to provide overall reporting solution for GL/financials, supply chain, and payroll. Design also provided auto-recon for reconcilement of sub-ledgers to general ledger. SLA for reporting database refresh and auto-reconcilement was 1 hour nightly process.
• Lead DBA responsible for performance tuning the self-service applications including index optimization, sql query tuning, pl/sql optimization and JVM tuning and optimization.
• Recommendations and upgrades on Oracle database from 9i to 10g
• Lead Production support DBA managing upgrades and technical patching on 10 instances for 4.5 years.
• Lead Production support DBA managing all year end patching for financials and HR/payroll for 4.5 years.
• Performance tuning and analysis for payroll processes for 4 years.
• Lead DBA responsible for supporting internal and external audit processes and controls
• OS, Database, and eBusiness Suite patching eBusiness Suite Instance Cloning
• Technical Issue Resolution
• Code review for standards compliance

Confidential

Technical AP

Responsibilities:

• Implementation of technical interfaces, reports, customizations for 11i AP implementation
• Production support of AP systems.
• Implementation and support of procurement and shadow GL.
• Lead technical resource for tuning of all supply chain, core GL, and AP functions. This included the performance tuning of database, concurrent processes and workflows.
• Production support of procurement systems.
• Design and implementation of Oracle General Ledger for Wachovia Bank to replace mainframe M&D general ledger. Included design requirement of processing 2 million GL transaction within 1 hour and “mini” financials close and reporting every day before noon. This process utilized externally defined tables with custom pl/sql processing for the initial loads, optimization of standard Oracle Journal Import process, and custom logic for extracting all transactional data and code combination balances into data warehouse. Extraction utilized dynamic sql and de-normalization to load 100,000,000 million balance records into pivot tables to allow custom reporting solution to provide optimized queries for financial analysts and reconcilement personnel.
• Production support of General Ledger systems.
• Database and File System Backups
• Performance Tuning
• Instance Monitoring
• OS, Database, and eBusiness Suite patching eBusiness Suite Instance Cloning
• Technical Issue Resolution
• Code review for standards compliance

Confidential

Systems manager

Responsibilities:

• Implementation lead for technical and functional tasks of Oracle manufacturing and Automotive including US and Mexican operations.