Professional Summary:

I am an Oracle Database Architect as well as a long-time Oracle DBA with specific experience supporting the needs of custom software application development teams. I possess over twenty-five years' experience performing logical and physical data modeling, SQL and PL/SQL tuning, and developing and supporting ETL activities using both custom and popular packaged-based ETL applications.

Technical Summary:

• Databases: Oracle RDBMS versions 5.0 through 11i
• Toolsets: SQL Plus, PL/SQL, SQL Loader, TOAD, SQL Developer, UNIX Shell Programming, ERWin, PowerDesigner, ER/Studio, Microsoft Office suite

Employment Experience:

Confidential

Sr. Data Architect

• Senior Data Architect and Application Oracle DBA for the Confidential division. Supported project team of ten developers, five business analysts, and seven testers as the sole Oracle DBA resource.Developed standards and procedures for TFM DBAs and Data Architects.Light systems DBA work user provisioning, security, tablespaces, etc. extensive Application DBA work including SQL scripting for structures, data, and reporting, as well as PL/SQL coding of functions, procedures, and packages Data modeling forward- and reverse-engineering using Visio test data generation for testing groups data migrations and replications from production to test and development environments.

Confidential

Staff Analyst

• Sr. Data Architect and Application Oracle DBA on contract to Confidential.Led team of four contractors across two continents in maintaining and improving an Operational Data Store receiving data from Oracle Financials. Provided needed Oracle expertise to development teams. Co-designed and implemented non-O/S reliant data loading procedures and load tracking application.

Confidential

Application Database Administrator

• Application Oracle DBA on contract to Confidential. 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.

Confidential

Database Administrator

• Oracle DBA and in-house Information Technology resource for a help-desk call center of over 50 persons. SQL Server DBA on project for Confidential Command at Confidential. 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.

Confidential

Oracle Data Architect and Application DBA

• Served as an Oracle DBA and Database Analyst responsible for Application DBA support and the design, development and support of Oracle-based data warehouse systems for Confidential area clients including Confidential.
• Supported daily operation of billing adjustment application Confidential for ten different hospitals. Documented custom before- and after-application database code with very different requirements for each of the ten hospitals in the Confidential network. Support included review and modification to source data ETL processes. Used ErWin to document data models.
• Created new database tables, views, indexes, functions, procedures, and synonyms in support of many user groups within Confidential. 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.
• Provided application development DBA support for Confidential insurance on multiple project teams across multiple Oracle instances. Managed tablespaces and datafiles 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.
• Supported Oracle instances for versions 8i, 9i, and 10g in both development and production modes for Confidential. 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 Confidential. Worked closely with developers to optimize ETL processing with Informatica and performed query reviews and tuning for Cognos and Business Objects users. Power Designer used for data modeling.
• Development Oracle DBA on multi-phased implementation project for the Confidential. 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.

Confidential

Oracle DBA / Data Architect

• Served as an Oracle DBA and Data Architect responsible for traveling to nationally based clients to design and develop Oracle database solutions and to diagnose / resolve Oracle based data warehouse issues.
• Improved reporting performance from data warehouse staging tables, 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 educational 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 Ab Initio.
• Performed PL/SQL code development and implemented Oracle based data warehouses for use in multiple dynamic client environments. Provided Oracle, SQL and UNIX based coding standards and leadership to other consultants and contractors.
• Gathered specifications of multiple sources of data and coalesced findings into manageable part of presentation. Implemented and Oracle based sales performance data warehouse application.
• Developed processes and code working with legacy application programmers to effect data warehouse population, data quality auditing, and automated error checking of daily data loads.
• Extensive use of Confidential as a Data Modeling tool at most IBM engagements.