SUMMARY

• Project DB2 DBA. I am a certified IBM DB2 DBA looking for short term projects or a remote DB2 DBA contract willing to relocate for short periods of time (1 - 3 months)
• Since 1994 my primary duties have been as a Database Administrator for IBM DB2, (DB2 for MVS, DB2 for Z/OS). have been employed by four different Fortune 500 corporations as DB2 DBA (Caterillar, Confidential, Confidential and Confidential Ins).
• Worked with IBM DB2 Version 3 through Version 10 over the course of 19 years.
• Lead DB2 DBA at Confidential Inc. for over 10 years.
• Duties included Lead DBA, Business Continuity, performance and tuning, problem resolution, production support, and design and support of new projects.
• Seventeen years of experience as an application DB2 DBA, 2 years as a DB2 systems programmer
• Mentor for off shore DBA s & programmers

TECHNICAL SKILLS

Platforms: IBM mainframe, PCs

Op Sys: Z/OS, MVS, WINDOWS

DB2 tools: Omegamon for DB2, Fileaid for DB2, BMC suite of database tools and utilities including SQL Explorer and Change Manager, IBM suite of database tools and utilities including Data Studio, EXPLAIN, SPUFI, QMF, DB2 PM batch and on-line Princeton Softech Log Master

Languages: ASSEMBLER, COBOL, SQL, CLIST, REXX, SAS, QMF, SPUFI

Databases: IBM DB2

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Responsibilities:

• Helped transfer a major application from ACI to JP Morgan. The application had several thousand large tablespaces, tables and indexes. Completion of the project required using REXX, SAS and DB2 DBA skills.
• Primary objective was to reduce the time it was taking create the DDL, load and unload jobs as well as reduce the time it was taking to actually unload and load the DB2 data. Accomplished this with solid knowledge of DB2 and the BMC DB2 Tool Suite.
• Modified & created REXX and SAS programs. By introducing BMC compression and the use of BMC unloads, was able to make major improvements to the process they had developed. One of the biggest problems was creating the DDL for all of the databases and underlying objects. They were trying to accomplish this with home grown REXX and SAS programs. Was able to accomplish it with the use BMC tools in 1/10th the time and 100% accuracy.
• Used BMC to create partition unloads and loads so multiple jobs could run at the same time to unload the large tablespaces. The improved process took only 3hours to run to completion (instead of almost 9hours).
• Monitored and tuned the process with Computer Associate’s Insight for DB2.

Confidential, Greenville, SC

Lead DB2 DBA

Responsibilities:

• Performed system and application recovery as well as database performance.
• Supported several applications ~ worked with application analyst on design, testing and tuning. Provided primary support for a life insurance application (ATLAS). Created DDL for new Databases, tablespaces and indexes in the unit test, system test and production system. Monitored the applications with BMC, IBM, CA and Strobe tools for DB2 as needed to accomplish acceptable performance.
• Identified inefficient SQL code and made recommendations for improvement. Modified or created indexes, or rewrote the SQL statement. Made recommendations to change COBOL code to make the process more efficient.
• As a DBA, created RACF (DB2 security) groups and granted the needed DB2 access authorities for individuals, application groups and production jobs.
• Implemented Resource Limit Facility (RLF) to control Dynamic SQL on all mainframe platforms resulting in over a million dollar savings in CPU from dynamic SQL. If the dynamic SQL statement exceeded its threshold it was not allowed to run.
• Created reports using SMF records which allowed me to work with analyst responsible for long running queries, either eliminating or tuning them to acceptable standards.
• Was also involved on the interview staff of DBAs. Performed technical interviews of DBA candidates to determine if they had the level of expertise they claimed to have. Would present hypothetical situations and ask them to explain how they would fix the problem.

Confidential, East Peoria, IL

Technical Specialist

Responsibilities:

• Responsible for Performance, Recovery and Application Development of a large PeopleSoft project. Worked with developers migrating data and structures, creating and managing new DB2 objects.
• Implemented PeopleSoft applications on the mainframe which required creating thousands of new tables, tablespaces and indexes. Used Omegamon for DB2 to monitor and tune the PeopleSoft applications. Used REXX to write an application that would recover data to previous established recovery points making it easy to rerun application tests.
• Granted appropriate DB2 access such as Read, Write, Bind, etc. as requested. Confidential used Computer Associates ACF2 for security (not IBM’s RACF).
• Implemented RLF in the East Peoria division of Confidential savings hundreds of thousands of dollars in CPU time from dynamic SQL.

Confidential, Morton, IL

DB2 DBA Team Lead

Responsibilities:

• Led a central Database Resource Management (DRM) Group of 16 DB2 DBA’s.
• Identified DB2 problems or issues, reported to manager, performed problem solving & resolution.
• Supported the Global online ordering system for Confidential Logistics Services.
• Worked with programmers to create an automated process for running RUNSTATS and REORGS with adjustable thresholds which eliminated the old process of running REORGS on all tablespaces every weekend and reduced the 3rd shift batch window by several hours.
• Responsibilities included but were not limited to:
• All DB2 Database Design & Support
• Database Recovery as needed
• RLF implementation
• Continuous Availability (7 X 24 X N)
• Batch Window reduction
• Business Resumption planning and testing
• Y2K compliance
• SQA (System Quality Assurance) testing

Confidential, Morton, IL

Assistant DB2 Systems Programmer

Responsibilities:

• Worked with the Systems Programmer to install SMPE fixes and updates to the DB2 system. Also helped install the DB2 Tools such as Omegamon, Platinum Tools for DB2 and STROBE.
• Worked with the Systems Programmer to install Data Sharing in Version 4 of DB2. We were one of very few shops to have installed data sharing at that time.
• Most tuning issues were becoming DB2-related, which caused interest in becoming involved with DB2.