Tim Gorman

Consultant

Evergreen Database Technologies, Inc.

Email: Tim@EvDBT.Com

Mobile: +1.303.885.4526

Fax: +1.303.484.3608

 

Summary

·         Widely recognized as expert in tuning and trouble-shooting advanced technology, large-scale, highly-complex, secured systems employing Oracle technology.

·         23 years IT experience including: Oracle database administration, UNIX systems administration, mentor, instructor, technical team leader, applications- and systems-programming on UNIX and VMS, Oracle custom-application development.

·         Highly regarded presenter and instructor, published author, effective and efficient communicator, highly regarded mentor, and technical database consultant.

 

Technology

Software Tools & Languages

Databases

 

Perl, C, SQL, PL/SQL, UNIX shell, PRO*C, SQL*Plus, Oracle Call Interface (OCI), lex/yacc
Oracle RDBMS versions 6 thru 11g, Oracle Parallel Server (v7, 8, 8i), Oracle9iR2 thru 10gR2 RAC, DEC VMS RMS, Informix C-ISAM

 

PROFESSIONAL EXPERIENCE

Executive and Entrepreneurial

Senior IT management

·      Founder and president of Evergreen Database Technologies (Aug 1998 – present), an IT consulting firm specializing in Oracle technology, training, and education.

·      Member of Advisory Board, department of Computer Information Sciences (CIS), Metropolitan State College of Denver (Jan 2005 – present)

·      VP Architecture (Jan 2000 – Dec 2000) at SageLogix, Inc., providers of premium Oracle technology consulting services and managed residency services and database security consulting

·      Senior Oracle Consultant (June 2001 – Dec 2001) in the Emerging Technologies practice of the Technical Leadership Group at Compaq Global Services.

·      Technical advisor to the Board of Directors for TargetRx, Inc (Mar 2000 – Dec 2003), a market research firm that surveys physicians for pharmaceutical clients using web-based services.

·      Technical Manager at Oracle Corporation (July 1996 - Aug 1998), leading a team of a dozen technology consultants for Oracle Consulting Services to perform all core technology services in the Rocky Mountain region and across the US.

 

 

Oracle Application and Database Administration

Database Administration

·         Senior, Principal, Senior Principal consultant, then Technical Manager at Oracle Corporation (Jan 1990 – Aug 1998)

·         Widely recognized as one of the most skilled database administrators in the worldwide Oracle community, with exceptional trouble-shooting, security, and architectural/internals expertise

·         Widely recognized as one of the most effective Oracle performance-tuning experts in the worldwide Oracle community

·         Co-authored Oracle Insights – Tales of the Oak Table (July 2004, ISBN #1-59059-387-1, published by Apress Publishing)

·         Front-line DBA support for 7x24 systems for a number of small and large companies, first stabilizing critical and/or deteriorating situations then working toward permanent self-sufficiency, stability, and maintaining defined/expected service levels.

·         On-site and remote emergency resolution during crisis situations

·         Taught Oracle Education courses and seminars in Database Administration, Backup and Recovery, Performance Tuning, and clustered databases

·         Writes and presents frequent seminars on database administration, performance tuning, Oracle architecture, and backup/recovery for audiences with all levels of technical expertise

·         Numerous seminars and presentations at Oracle Open World, IOUG “Collaborate”, Oracle Users Groups, and customer sites

 

Database Security

·         Research, planning, and implementation of database security standards for large telecommunications company in Englewood CO for Sarbanes-Oxley Act (SOX) compliance.

·         Firm understanding of the process of fitting practical database security requirements to the optimal combination of Oracle security features, planning and implementing their phased implementation, anticipating and testing for incompatibilities, and testing effectiveness using “white hat” techniques.

·         Published articles on database security in Oracle for Oracle users groups (www.rmoug.org, www.ioug.org) newsletters and magazine (i.e. “Unraveling the Sweater” series)

·         “IOUG-A University Masters Classes” in Boston, MA and Las Vegas, NV in August and September 2002

·         4-hr seminar on “iDatabase Security: Fear and Loathing on the Internet” – beginner/intermediate level database security seminar

 

Data Warehousing

·         Developed and delivered training entitled “Scaling to Infinity:  Partitioning Data Warehouses on Oracle” which specifies in detail, from design through implementation, how to optimally implement scalable and available data warehouse databases on Oracle.

·         Co-authored Essential Oracle8i Data Warehousing (September 2000, ISBN #0-471-37678-7) and Oracle8 Data Warehousing (March 1998, ISBN #0-471-19952-4) with primary author Gary Dodge (published by John Wiley & Sons, Inc., of New York)

·         Design architect and implementation lead for consolidated analytic data warehouse for large consumer-credit company

·         Assisted in curriculum development for Oracle Education courses on Data Warehousing

·         Data mart and data warehouse development using Oracle RDBMS 7.1 through 11.1, taking full advantage of new features as they become available and stable.

·         Installation, configuration, and tuning of a decision-support environment on Oracle clustered databases for the largest credit-card processing company in America.

·         Conversion, redesign, and re-hosting of data warehouse from Teradata to Oracle clustered databases for major American telecommunications company.

·         Implementation of custom-built data warehouse "usage tracking" software package in Oracle clustered database environments, as well as Pine Cone (now Ambeo) "Usage Tracker".

 

ERP Applications

·         Expert at tuning the performance of Oracle E-Business Suites from release 9.4 through 12, as well as trouble-shooting any performance problems or technical failures

·         Troubleshooting and performance tuning on PeopleSoft and Siebel systems

 

Clustering Technology

·         Experienced on Linux and Solaris with Oracle10g RAC (Real Application Clusters), including all options for storage and justifications for deployment.

·         Experienced on HP-UX and Windows with Oracle8i Parallel Server and Oracle9i RAC.

·         Taught Oracle Education courses for "Oracle Parallel Server Administration and Implementation" and "Oracle7 Parallel Server on IBM RS6000 SP"

 

Custom Application Design and Development

·         Analysis, detailed design, coding, and testing of custom-built applications for an insurance company using Oracle SQL*Forms 3.0, PRO*C, and PL/SQL. Innovated in many areas to maximize throughput, reliability, and manageability of this mission-critical application. Other duties included production support, trouble-shooting, and mentoring.

·         Designed and implemented customized replication system for the largest Oracle on-line transaction processing system (in 1993) in PRO*C and C, before the introduction of Oracle’s Symmetric Advanced Replication product.

·         Developed and enhanced a quote-pricing system for an insurance company using PRO*C, C, and LEX/YACC (lexicographical and compiler-compiler utilities).

·         A long history of creative, maintainable, and robust application-development solutions using UNIX shell scripting, SQL, PL/SQL, C, and PRO*C.

·         Evergreen Database Technologies website http://www.EvDBT.com is a globally well-regarded repository of white papers, scripts, and tools, available free to all.

 

Knowledge Transfer through Teaching and Curriculum Development

Through Oracle Education

·         Developed curriculum and provided instruction for Oracle University EMEA (Europe/MidEast/Africa) in data warehousing – “Scaling to Infinity:  Partitioning Data Warehouses on Oracle” (2-day lecture)

·         Database Administration & Architecture (two sections, each 5-day lecture and lab)

·         Using SQL, SQL*Plus, and PL/SQL (3-day lecture)

·         Tuning SQL Applications in Oracle (2-day lecture)

·         Backup & Recovery Workshop (3-day lecture and lab)

·         Oracle Parallel Server Administration  (2-day lecture)

·         Oracle Parallel Server on IBM SP (2-day lecture)

·         Performance Management in Oracle (3-day lecture)

·         Seminar: A Very Short Guide to Very Large Databases (1-day seminar)

·         Seminar: Roadmap to Oracle8 Tuning (1-day seminar)

·         Seminar: Oracle8: New Features (1-day seminar)

·         Seminar: Oracle8i: Basic/Advanced Components (1-day seminar)

·         Seminar: Dumps, Crashes, Corruptions (1-day seminar)

·         Seminar: Data Storage Mgmt Internals (1-day seminar)

·         Seminar: Adv Backup & Recovery Issues (1-day seminar)

 

Through Evergreen Database Technologies, Speak-Tech, and TruTek:

·         Scaling to Infinity:  Partitioning Data Warehouses on Oracle (1-, 2-, and 3-day seminar)

·         Oracle Performance Tuning Methodology (2-day seminar)

·         Oracle9i:  New Features for DBAs (3-day seminar)

·         Oracle8i:  New Features for DBAs (3-day seminar)

·         Backup and Recovery using RMAN (3-day seminar and lab)

·         SQL*Net and Net8 Basics (4- to 8-hr seminar)

 

Publications

·         Co-authored the following published books:

·         "Essential Oracle8i Data Warehousing" (ISBN #0-471-37678-7, September 2000) with primary author Gary Dodge. Published by John Wiley & Sons, Inc.

·         "Oracle8 Data Warehousing" (ISBN #0-471-19952-4, March 1998) with primary author Gary Dodge. Published by John Wiley & Sons, Inc.

·         “Oracle Insights – Tales of the Oak Table” (ISBN # 1-59059-387-1, July 2004) with a dozen other co-authors, published by Apress

·         Technical reviewer for the following published books:

·         “Oracle SQL Tuning Pocket Reference” (ISBN #0-596-00268-8, November 2001).  Published by O’Reilly and Associates, Inc.

·         “Oracle RMAN Pocket Reference” (ISBN #0-596-00233-5, November 2001).  Published by O’Reilly and Associates, Inc.

·          “PeopleSoft for the Oracle DBA” (ISBN #1-59059-422-3, January 2005).  Published by Apress

·         “Forecasting Oracle Performance” (ISBN #978-159059-802-3, April 2007).  Published by Apress

 

Presentations

·         Oracle Open World

·         Oracle Open World US in September 2006 in San Francisco, on “Scaling to Infinity:  Partitioning Data Warehouses on Oracle”

·         Oracle Open World US in December 2004 in San Francisco, on “Understanding Indexes”

·         Oracle Open World Australia-Asia in December 1997 in Melbourne, Victoria on “SQL Tuning for DBAs”

·         Hotsos “Symposiums” in Dallas TX

·         2006 – “Performance Diagnostics using STATSPACK”

·         2005 – “Using STATSPACK as a performance data warehouse”

·         Miracle A/S

·         “Absolutely-The-Last Database Forum”, September 2006 in Lalandia, Denmark

·         1-hr presentation “Worst Practices:  How not to build a Data Warehouse in Oracle”

·         1-hr presentation “Reporting from the RMAN Repository”

·         1-hr presentation “Backup and Recovery:  Best Practices for Large Databases”

·         “Data Warehousing Master Class” in January 2005 in Copenhagen, Denmark

·         3-day seminar “Scaling to Infinity:  Partitioning Data Warehouses on Oracle”

·         “Final Database Forum”, November 2004 in Lalandia, Denmark

·         1-hr presentation “Scaling to Infinity:  Partitioning Data Warehouses on Oracle”

·         Independent Oracle Users Group (IOUG) conferences:

·         “Collaborate 2008” conference in April 2008 in Denver, CO

·         7-hr university seminar “Scaling to Infinity:  Partitioning in Oracle Data Warehouses”

·          “Collaborate 2006” conference in April 2006 in Nashville, TN

·         7-hr university seminar “Scaling to Infinity:  Partitioning in Oracle Data Warehouses”

·         Article “Understanding Indexing” selected as “Editor’s Choice 2006” by IOUG’s “SELECT” Magazine

·         “Live 2005” conference in April 2005 in Orlando, FL

·         1-hr technical presentation on “Scaling to Infinity:  Partitioning in Oracle Data Warehouses”

·         “Live 2004” conference in April 2004 in Toronto, Ontario, Canada

·         7-hr university seminar “Advanced Troubleshooting of Oracle on UNIX”

·         1-hr technical presentation on “Understanding Indexing”

·         30-min Quick Tip on “Tuning PL/SQL using DBMS_PROFILER”

·          “Live 2003” conference in April 2003 in Orlando, FL

·         7-hr university seminar “Advanced Troubleshooting of Oracle on UNIX”

·         1-hr technical presentation on “Using Oracle8i and Oracle9i Log Miner”

·         30-min Quick Tip on “Oracle9i Table Compression”

·         “IOUG University Masters Classes” in Boston, MA and Las Vegas, NV

·         4-hr seminar on “Performance Tuning for Beginner/Intermediate DBAs”

·         4-hr seminar on “iDatabase Security: Fear and Loathing on the Internet”

·          “Live 2002” conference in April 2002 in San Diego, CA

·         7-hr university seminar “Advanced Troubleshooting in Oracle”

·         1-hr technical presentation “The Search for Intelligent Life in the CBO”

·         "Live 2001" conference in May 2001 in Orlando, FL

·         7-hr university seminar "Advanced Oracle Data Warehousing:  Getting Past the Hump"

·         1-hr technical presentation "High-Availability and Scalability in Oracle".

·         "Live 1999" conference in April 1999 in Denver, CO

·         1-hr technical presentation "Tuning Your Data Warehouse According to it's Usage"

·         2-hr Oracle Education mini-lesson "Dumps, Crashes, and Corruptions"

·         2-hr Oracle Education mini-lesson "Advanced Backup and Recovery Issues"

·         Rocky Mountain Oracle Users Group (RMOUG) "Training Days" conferences:

·         February 2005, 2006, 2007, 2008 “Scaling to Infinity:  Partitioning Data Warehouses on Oracle”

·         February 2004 “Optimizing Performance with STATSPACK” and “Understanding Indexes”

·         March 2003 “Succeeding with STATSPACK”, “Cats, Dogs, and ORA-01555”, and “Using Oracle8i and Oracle9i Log Miner”

·         February 2002 “Search for Intelligent Life in the Cost-Based Optimizer”, “Managing Oracle Applications R11 Performance Using STATSPACK”, and “Cats, Dogs, and ORA-01555”

·         February 2001 "High-Availability and Scalability in Oracle"

·         February 2000 "Is RMAN Really Worth the Trouble" and "High-Availability and Scalability in Oracle"

·         February 1999 "Tuning Your Data Warehouse According to it's Usage"

·         February 1999, January 1998, and April 1997 "SQL Tuning for DBAs"

·         April 1995 and April 1994 "PRO*C Tips and Techniques"

·         Rocky Mountain Oracle Users Group (RMOUG) quarterly educational workshops:

·         November 2001 “Oracle9i Data Guard”

·         April 1998 "Oracle8 New Features for DBAs"

·         August 1997 "Optimizing the Parallel Query option"

·         November 1996 "Oracle Parallel Server for the IBM RS6000 SP"

·         November 1995 "Oracle Gateways Developers Kits"

·         Utah Oracle Users Group (UTOUG):

·         October 2002 “Managing Performance in Oracle Apps R11 Using STATSPACK” and “Using Oracle8i and Oracle9i Log Miner”

·         April 2002 “Understanding Locking in Oracle”

·         October 2001 “Cats, Dogs, and ORA-01555” and “Oracle9i RAC on Compaq Tru64 Clusters”

·         July 2001 “The Search for Intelligent Life in the Cost-Based Optimizer”

·         February 2001 “Virtual Private Databases”

·         October 2000 “Is RMAN Really Worth The Trouble?”

·         October 1999 “Oracle8i: Less-appreciated New Features Overview”

·         October 1998 “SQL Tuning for DBAs”

·         Pikes Peak Oracle Users Group (PPOUG):

·         January 2001 "SQL*Net Basics"

·         September 2000 "High-Availability and Scalability in Oracle "

·         September 1999 "Oracle8i: Implementing New Features on the Internet"

·         Other presentations, seminars, and keynote speeches at:

·         Keynote speaker for Maine’S Oracle Users Group (MSOUG) annual conference in June 2000 in Sebasco, ME on “Database Administration and Managed Services” and “Virtual Private Databases”

·         Eastern Caribbean Oracle Users Group (ECOUG) in March 2001 in Port of Spain, Trinidad on “Is RMAN Really Worth The Trouble?”

·         Database Users Association of Iowa (DBAUI) meeting in December 2000 in Perry, Iowa on “Data Warehousing Basics”

·         Twin Cities Oracle Users Group (TCOUG) in July 2002 in Eden Prairie, MN on “Managing Oracle Applications Performance using STATSPACK”

·         Ottawa Oracle Users Group (OOUG) in September 2002 in Ottawa, ON on “Is RMAN Really Worth The Trouble?”, “Cats, Dogs, and ORA-01555”, and “The Search for Intelligent Life in the Cost-Based Optimizer”

·         Los Angeles Oracle Users Group (LAOUG) in November 2002 in Norwalk, CA on “Succeeding with RMAN”, “Using Oracle8i and Oracle9i Log Miner”, “Managing Performance with STATSPACK”, and “Cats, Dogs, and ORA-01555”

·         New York Oracle Users Group (NYOUG) in December 2002 in NYC, NY on “Cats, Dogs, and ORA-01555”

 

Memberships and Certifications

·         Oracle ACE - Oracle launched the Oracle ACE program, which formally recognizes Oracle advocates with strong credentials as evangelists and educators in that community.  Oracle ACEs are technically expert and eager to share their experiences, 2007 - present

·         Member of the Oak Table forum, an organization specializing in the application of scientific methods to advanced problems in Oracle database technology, based in Denmark (http://www.oaktable.net), 2002-present

·         Oracle8i Certified Professional DBA, 2000

·         Oracle8 Certified Professional DBA, 1999

·         Oracle7.3 Certified Professional DBA, 1998

·         President of Rocky Mountain Oracle Users Group (RMOUG) from 2003-present, directory of “Training Days 2007”; education director 2002-2003; programs director: 1996–1999, 2000-2002; membership director: 1999-2000; member of board of Rocky Mountain Oracle Users Group from 1995-present

·         Oracle Consulting Services:  Quality Club ("Qool"), 1995 and 1996, Rocky Mountain Region "Consultant of the Month", November 1994 and August 1995

·         Citicorp Information Management Services, Inc., "Significantly Improving the Main Line of Business", 1988

 

Chronology of Employment

·         Evergreen Database Technologies, Inc (Aug 2006 – present)

·         SageLogix, Inc. (Dec 2001 – Aug 2006)

·         Compaq Professional Services (June 2001 – Dec 2001)

·         Evergreen Database Technologies, Inc. (Dec 2000 – June 2001)

·         SageLogix, Inc. (Jan 2000 – Dec 2000)

·         Evergreen Database Technologies, Inc. (Aug 1998 – Dec 1999)

·         Oracle Corporation (Jan 1990 – July 1998)

·         Fidelity Management & Research (July 1989 – Jan 1990)

·         Citicorp Information Management Services, Inc. (Aug 1987 – June 1989)

·         Kontron Instruments, Inc. (May 1985 – Aug 1987)

·         Medicomp Management Services (May 1984 – March 1985)