Jeff Maresh

Oracle Database Architect/DBA

31361 Shadow Mountain Drive

Conifer, CO 80433

Phone: (303) 478-4923

Education

1984 M.S. Engineering, The Ohio State University.

1984 B.S. Aviation, The Ohio State University.

1982 B.S. Aeronautical and Astronautical Engineering, The Ohio State University.

Skill Set

·Database architectural design where performance and scalability are critical for web-based, OLTP, data warehouse, and Operational Data Store databases.

·Database performance problem diagnosis and resolution for application scalability and throughput improvements.

·In depth knowledge of database internals, and DBA skills to tackle difficult database software development projects that require high performance and scalability.

·Software design and development experience necessary to build scalable high performance database applications.

·Good communication skills both vertically and horizontally throughout an organization.

·Effective and efficient at training and mentoring technical staff.

Professional Experience

2001-present Oracle DBA, Database Architect – Performed consulting services to various companies as an independent consultant.

2000 Oracle DBA, Database Architect - Joined the staff at Sagelogix, Inc. to provide telecom and DBA expertise in support of in-house projects and consulting efforts.

1995-2000 Database Consulting - Developed and supported databases and database software for Oracle Versions 6, 7, and 8. Most projects involved database and application design, and performance tuning. Technical papers were written for application developers and DBAs to disseminate features, problems, and solutions. Papers were presented at local Oracle User Group meetings. Training courses on various Oracle topics were developed and taught to developers and DBAs.

1982-1997 Software Development Consulting - Developed high-performance real-time aircraft simulator software for a variety of customers including USAF, NASA, FAA and 8 major academic institutions. Tasks included problem analysis, software design, programming in C and C++, statistical analysis in SPSS and SAS. Formed Engineering Solutions, Inc. as a partner in 1989. Responsibilities included management of the business and projects, proposal and report writing, and software and database development.

Recent Consulting Projects

2001-2003 Apache Corporation – Provided Oracle technical leadership role to design and implement the company’s corporate data warehouse facility. Tasks included dimensional and hierarchical logical and physical design of the entire warehouse, application and production DBA support, mentoring, and technical staff training for application developers and DBAs. SQL, PL/SQL, and Perl scripts were developed to perform ETL operations from flat files and other databases, and to build materialized views, summary and drill-across tables. Scripts were written to automate various database administrative tasks including the gathering of optimizer statistics, index rebuilds, tablespace space management, and errant session detection and kill. Designed and implemented schemas to house metadata for physical database information (ETL job status and performance, storage use, maintenance activities) and end-user metadata including table and column descriptive information. Assisted management in the development of SLAs (service level agreements), and hardware and software budgets. Set up development, test and production databases. Performed testing and migration from Oracle 8.1.7 to 9.2.0. Implemented StatsPack for monitoring and tuning database performance. Tuned queries to optimize performance. Taught in-house courses on data warehouse and ODS (operational data store) design, query tuning and database performance, configuration and use of the PX (parallel execution) facility, and Perl. Tested and implemented Oracle 9i features including list partitioning, resumable transactions, index usage monitoring, dynamic SGA configuration, and SQL merge operation. Apache Corp (NYSE:APA) is an independent oil and gas company with annual revenues of over $2.5 billion.

2001 Duke Energy Field Services – Tuned two third-party OLTP databases and applications. The work involved analysis of the database, which resulted in changing various database parameters. Index structures were analyzed to determine when they should be rebuilt. Offensive SQL, including dynamic SQL, was identified and changes were recommended. Reviewed PL/SQL stored procedures for security flaws, and other constructs that would affect performance and scalability. Recommended code changes were developed and documented for developers. Duke Energy Field Services is a subsidiary of Duke Energy (NYSE:DUK), an integrated energy services company with annual revenues of over $36 Billion.

2000-2001 Level 3 Communications – Data Warehouse Group – Developed software to automate data management within a 15 TB Oracle 8i data warehouse facility. Perl scripts were developed to automatically create table and index partitions at periodic intervals, create tablespaces, and add datafiles as space was required. Code was written to automatically analyze, coalesce, reclaim free space, and set tablespaces to READ ONLY status. Developed processes to automatically migrate tablespaces to nearline storage. A centralized logging and notification facility was developed for all automation processes. This was used to log job status, all DDL executed, critical error page outs and email notifications, and was used to assess storage history and future requirements. Developed a storage reporting application that mined the automation log tables to track the storage history and status of tables and tablespaces. This tool was used by management to plan future data warehouse storage requirements. General database tuning was provided which included tuning the Parallel Execution facility and parallel query tuning. Provided data modeling and process design consultation for a number of projects. Trained and mentored DBAs on PERL programming and various database tuning topics. Provided enterprise-wide and data warehouse on-call DBA support. Participated in effort to migrate data warehouse databases to other servers. Tested and employed locally managed tablespaces. Provided maintenance and enhancement support for a Perl-CGI application that manages system, database, and DBA metadata enterpise-wide. Level 3 Communications (NASDAQ:LVLT) is a global communications services provider with annual revenues of over $3 Billion.

2000 SageLogix, Inc. – Developed requirements and data model for a telecom Asset Management System designed for integration into the company’s BSS ASP model. The project involved investigation and limiting of system scope, analysis of data communication and synchronization strategies with other database systems. A fourth normal data model was developed to provide greater flexibility for creating data elements stored for various telecom asset types. In addition, the data model was designed for scalability, and for use with a user interface programmed in Java. SageLogix is a consulting company specializing in Oracle database technology.

1997-2000 Qwest Communications International - Database Architecture Group - Enterprise-wide application troubleshooting, remediation, design, and training for Oracle 7 and 8 databases. Applications included Metasolv TBS, Remedy, Clarify as well as custom applications written in Powerbuilder, Pro C, PL/SQL, and Java. Training courses in PL/SQL, Pro C, and application performance tuning were developed and taught on an ongoing basis. The courses replaced those taught by Oracle Corporation. Internal technical white papers were written to disseminate tuning issues and cost savings opportunities to the IT community. Performed database performance analysis, developed performance monitoring scripts and remediation procedures for 57 production databases, and taught production DBA team how to use them. Database and application performance tuning was planned and conducted enterprise-wide on an ongoing basis. Developed annual database performance tuning Statements of Work. As the lead technical person, several software systems were developed. One of the larger projects included an automated system to periodically identify, archive, and purge inactive accounts and. This effort reduced the size of the main database by over 40% resulting in the deferral of major hardware purchases by two calendar quarters. Many short-term high-visibility projects were undertaken to correct data problems, recover expenses, or reduce costs. One such project recovered $22 million in a year. Assistance was provided to application development teams to improve the reliability and performance of primary batch-processing operations including billing, CARE (PICC), and commissions. The techniques used in the development of high-performance graphics systems were utilized to design and implement high-throughput multithreaded parallel processing database applications. Much of the work involved the facilitation and development of business and system requirements and the development of design and implementation plans. New features including keep and recycle buffer pools, reserved and large pools, hash joins, partition tables, bitmap indexes, index-only tables, star schemas, and other data warehouse features were implemented. The primary Oracle 7 generation corporate data warehouse was redesigned to take advantage of Oracle 8 and 8i features enumerated above. Provided technical leadership and implementation for enteprise-wide migration from RULE to COST based optimizer which resulted in database performance gains ranging from 20% to over a factor of 6. Performed extensive review and testing to qualify Oracle Discoverer 3.0 and 3i as enterprise-wide ad hoc reporting tool. The interests of the Enterprise Database Services Group were represented as a member of the IT Department Chief Architecture Team. Worked with application development teams to review database architectures and to help design effective and efficient n-tier database application architectures. Provided application tuning support for off the shelf products including Remedy, Clarify, Metasolv TBS. Provided database and application tuning support for custom 3-tier Java applications supporting self-service corporate web sites. Qwest Communications (NYSE:Q) is a broadband Internet communications and local telephone service provider with annual revenues of over $16 Billion.

1996-97 Chemical Abstracts Service - Member and Subscriber Services - Participated in an effort to convert a legacy member and subscriber management system from legacy to a two-tier architecture. The on-line and batch application consisted 25 GB of data contained in over 400 tables and 1,100 indexes. Application performance tuning, ad hoc query development and standardization were the primary responsibilities. The publication auditing subsystem was analyzed, performance tuned, and installed into a batch processor. The result was a reduction in run-time of 75% and a reduction in operator interaction of 90% through automation and improvements in process fault tolerance, detection, and resolution. An ad hoc reporting system was developed for the VP Publications to report on subscription information of adjoining organizations. An ad hoc reporting system was developed for the Manager of Member and Subscriber Services to verify data integrity against the complex set of business rules. Errant and unauthorized processing was nearly eliminated through the development and implementation of a set of system analysis tools. Analysis of batch, on-line, and data export/import processing was conducted at the database level to improve system performance. Performance of these processes was improved from 25% to 200%. The system was hosted on Sun Servers running Oracle 7. Software was developed in SQL Plus and PERL and analysis was conducted with Oracle utilities such as explain plan and tkprof. During the course of the project, communication between developers, senior IT management and senior business managers was facilitated. Chemical Abstracts is a subsidiary of the American Chemical Society and is the leading worldwide provider of technical periodicals to the scientific community.

Recent publications and presentations

Database parameters that affect query performance – presented at Ohio Oracle Users Group, April 2000.

How to improve database performance with full-table scans – presented at Rocky Mountain Oracle Users Group, July 2000 and Pikes Peak Oracle Users Group, August 2002

Performance problems caused by nonreuse of SQL statements – Published in Rocky Mountain Oracle Users Group newsletter, Summer 2000, feature article in International Oracle Users Group – Americas Select Magazine, October 2000

Optimizing Parallel Query in Oracle 8i – Presented at Rocky Mountain Oracle Users Group Training Days, February 2001.

SQL*Loader Strategies For Data Warehouse Applications - Presented at Rocky Mountain Oracle Users Group Training Days, February 2002.

In Defense of Full-Table Scans – posted on www.evdbt.com February 2003.

Parallel Execution Facility Configuration And Use – Presented at Rocky Mountain Oracle Users Group Training Days, March 2003.

Affiliations

Member of Rocky Mountain Oracle Users Group (RMOUG).

Member of International Oracle Users Group – Americas (IOUG-A).

Contributing Editor for IOUG-A Select Journal.

References and curriculum vitae are available upon request.