PROFESSIONAL SUMMARY:

• Oracle Database Architect and Oracle DBA with specific experience supporting the needs of custom software application development teams.
• Experienced in performing logical and physical data - modeling, SQL & PL/SQL tuning, and in developing / supporting ETL activities (using both custom and popular packaged-based ETL applications).

TECHNICAL SKILLS:

• Oracle RDBMS versions 5.0 through 12c
• Toolsets
• SQL* Plus
• PL / SQL
• SQL* Loader
• TOAD
• SQL* Developer
• UNIX Shell Programming
• ERWin
• PowerDesigner
• ER/Studio

PROFESSIONAL EXPERIENCE:

Senior Technologist

Confidential

Responsibilities:

• Defined SQL coding standards and Best Practices for group not having same.
• Customized existing process for account migration to specific needs of another set of account migrations.
• UNIX, SQL, and PL/SQL coding required. Oracle RDBMS versions 11g and 12c.

Database Analyst, Lead

Confidential

Responsibilities:

• Designed and implemented new database objects (tables, views, synonyms, database links, packages, functions, stored procedures) in response to both formal and informal requirements.
• Designed and implemented new processes for data replication between database instances for Siebel and DPS applications.
• Used Agile Methodology for application development.
• Maintained and upgraded data model for DPS application database objects using ERWin.
• Supported in-house testing group with back-end data analysis. Oracle RDBMS versions 11g and 12c.

Data Analyst

Confidential

Responsibilities:

• Provided data analysis of contents of Operational Data Store (ODS) and Brokerage Data Warehouse (BDW) to multiple projects.
• Created Functional Data Requirements documents from Business Requirements documents and database contents; created data extract file layouts; analyzed and improved SQL for reports generator tool. Oracle RDBMS version 11g.

Sr. Data Architect

Confidential

Responsibilities:

• Supported project team of 10 developers, 5 business analysts, and 7 testers as the sole Oracle DBA resource.
• Developed all standards and procedures for TFM DBAs and Data Architects.
• Performed “light” systems DBA work (user provisioning, security, tablespaces, etc).
• Led extensive Application DBA work including SQL scripting for structures, data, and reporting, as well as PL/SQL coding of functions, procedures, and packages.
• Performed development work using Agile Methodology.
• Provided data modeling (forward- and reverse-engineering using Visio), test data generation for testing groups, and data migrations / replications from production to test and development environments. Oracle RDBMS version 11g.

Staff Analyst

Confidential

Responsibilities:

• Led team of four contractors across 2 continents in maintaining and improving an Operational Data Store receiving data from Oracle Financials.
• Co-designed and implemented non-O/S reliant data loading procedures and load tracking application. Oracle RDBMS version 11g.

Application Database Administrator

Confidential

Responsibilities:

• Documented and managed development schemas using ERWin and ER/Studio.
• Reviewed existing application code and improved database performance by 52%.
• Performed badly-needed database cleanup by removing obsolete objects and developing data currency maintenance scripts in PL/SQL and Unix.
• Provided needed Oracle expertise to development teams. Oracle RDBMS version 11g.

Database Administrator

Confidential

Responsibilities:

• SQL Server DBA on project for SDDC Command at Scott AFB.
• Installed SQL Server on Windows 2003 server, applied required service packs and security patches, restored backups taken from Production databases onto new Development server.
• Developed queries from non-technical specifications. Oracle RDBMS version 10g.

Oracle Data Architect and Application DBA

Confidential

Responsibilities:

• Supported daily operation of billing adjustment application (HCC) for 10 different hospitals. Documented custom before- and after-application database code with very different requirements for each of the 10 hospitals in the BJC network. Support included review and modification to source data ETL processes. Used ErWin to document data models. Oracle RDBMS version 10g.
• Created new database tables, views, indexes, functions, procedures, and synonyms in support of many user groups within Smurfit-Stone. Analyzed existing queries and procedures for processing improvements. Managed daily reporting needs as a part of the data warehouse team. Support included review and modification to source data ETL processes. Oracle RDBMS version 10g.
• Provided application development DBA support for Monsanto, Nestle-Purina and GMAC insurance on multiple project teams across multiple Oracle instances. Managed tablespaces and data files; performed database security administration: applied changes to schemas for multiple development teams; promoted changes through the change management process and synchronized data between Oracle instances. Oracle RDBMS version 10g.
• Supported Oracle instances for versions 8i, 9i, and 10g in both development and production modes Performed knowledge transfer and mentoring of junior DBAs. Performed PL/SQL development, code reviews and reviewed the Architecture data warehouse development schema and provided recommendations for improvements.
• Developed process to refresh development and test data from production data sources for a parameterized retailer and range of dates for Nestle-Purina. Worked closely with developers to optimize ETL processing with Informatica. Used Power Designer for data modeling. Oracle RDBMS version 9i.
• Development Oracle DBA on multi-phased implementation project for the U.S. Government. Performed re-development and maintenance of ERWin data model diagrams and maintained source-to-target data mapping documentation. Developed ETL solutions, including SQL*Loader scripts, stored procedures, functions, packages, triggers, indexes, views, materialized views and batch scripts for unattended data loading. Also maintained DDL, DML and DCL code stored in Microsoft Visual SourceSafe. Oracle RDBMS version 9i.

Oracle DBA / Data Architect

Confidential

Responsibilities:

• Improved reporting performance from data warehouse staging tables (reducing from 20 hours to 10 hours). Migrated legacy application data from SQL Server, Oracle, and VSAM sources to single, conformed target set of tables.
• Developed a query "governor" using CRON utility in UNIX to terminate long-running queries. Performed Query and Optimization Plan Analysis and provided SQL and Oracle table change recommendations.
• Redesigned ETL processing for data warehouse, conforming five disparate sources to a single, conformed target. Led team of three DBAs in migrating 25 Tb of Oracle data on DEC Alpha systems to Oracle on IBM AIX 5L systems.
• Coordinated actions between IBM teams and client database teams. Allocated tasks for successful implementation. Effected knowledge transfer to IBM team and client team members. Converted an al based data warehouse data model from DB2 to Oracle. Implemented converted data models.
• Performed data transformation and loading (ETL) using the Sagent Design Studio and tuned report queries. Mentored other DBAs in Korn Shell Programming. Mentored Business Analysts and Data Modelers in use of Oracle RDBMS.
• Developed new ETL processing using Korn Shell Programming, SQL*Plus and PL/SQL coding. Worked closely with developers at multiple client sites with ETL processing, using Informatica, DataStage and