Résumé of
JOSEPH W. GALLAHER

Contact: Joe Gallaher
800-739-7724
Email: Joe@SPCI.net
Visit us at: www.SPCI.net

BOOKMARKS:

EMPLOYMENT HISTORY
DETAILED EXPERIENCE
EDUCATION
VENDOR TRAINING
CERTIFICATIONS

EMPLOYMENT HISTORY:

Acme Anvil Apr. 2003-present Senior DB2 Systems Programmer
May 2000-Apr. 2003 DB2 Database Administrator
Nov. 1997-May 2000 Applications Programmer

EXPERIENCE:

Nov. 1997-

Acme Anvil
present
Senior DB2 Systems Programmer (Apr. 2003-present) - Responsible for all aspects of systems programming support for 45+ DB2 subsystems running in a large Data Sharing, Parallel Sysplex environment. Specific accomplishments included:
  • Provided SMP/E installation and customization of DB2 v8 across multiple z/OS 1.7 LPARs. Previously installed DB2 v7.
  • Enabled Data Sharing on six DB2 subsystems and sized of all required coupling facility structures.
  • Setup and maintained CICS-DB2 interface
  • Reviewed DB2 performance statistics and trace data using Omegamon/DB2, DB2PE and BMC Activity Monitor. Also used Omegamon/CICS to identify CICS-related DB2 tuning problems.
  • Improved DB2 throughput by tuning bufferpools, adjusting IRLM lock structures, modifying DSNZPARM parameters, and setting WLM policies to achieve DB2 response objectives. Also assisted DBAs and programmers with SQL and DB2 application tuning.
  • Troubleshot DB2-related systems problems using Omegamon/DB2 and IPCS dump analysis. Researched problems and applied PTFs to correct many of them.
  • Planned, implemented and tested DB2 backup, recovery, and disaster recovery strategies.
  • Installed numerous DB2-related products on multiple LPARs. This included Omegamon/DB2, BMC Activity Monitor, Apptune, Catalog Manager, Extended Buffer Manager, Opertune, Recovery Management Solution, and Unload Plus.
DB2 Database Administrator (May 2000-Apr. 2003) - [insert DBA job description. Include any installs, troubleshooting, performance, etc.]
Applications Programmer (Nov. 1997-May 2000) - [insert Applications Programmer job description]

EDUCATION:

B. S., Computer Science (Magna Cum Laude), University of Maryland, May 1996.

VENDOR TRAINING:

DB2 for z/OS and OS/390 Data Sharing Recovery and Restart (IBM)
DB2 SQL Performance Analyzer for z/OS, V2.2 (IBM)
DB2 for z/OS System Performance and Tuning (IBM)
CICS-DB2 Interface for System Programmers (IBM)

CERTIFICATIONS:

IBM Certified Specialist DB2 UDB v7.1 User
IBM Certified DBA DB2 v8.1 for z/OS
IBM Certified Solution Expert DB2 UDB V7. 1

Systems Programming Consultants, Inc
8606 Hillside Avenue
Los Angeles, CA 90069
800-739-7724

[TOP]