Db2 Systems Programmer Resume
SUMMARY
PROFESSIONAL EXPERIENCE:
Confidential,Chicago, IL
Position: DB2 Systems Programmer, Vice President 5/2006 to present
Working as Senior DB2 Systems Programmer was responsible for the support of over 90 DB2 for z/OS subsystems across the infrastructure. The key responsibilities include version upgrades across data sharing systems and non data sharing systems, DB2 related tool installation and support, performance monitoring and tuning, and problem determination and diagnosis. In addition, DB2 project lead for application failover using Websphere Replication for DB2 z/OS.
Project lead for the DB2 V9 upgrade beginning 1Q 2008. Key member of DB2 V8 upgrade resulting in personally performing over 15 V8 upgrades to both Compatibility Mode and New Function Mode. Proficient in DB2 installation/upgrade, DB2 performance tuning, SMP/e, Rexx programming, and problem determination.
Working extensively with lines of business to coordinate upgrade schedules and technical knowledge transfer.
Confidential,Rolling Meadows, IL
Position: Software Engineer 12/96 to 5/2006
Worked as a post sales technical specialist for the Data Management Tools organization. I provided
support for installation, customization, and training for IBM’s suite of DB2 tools which include DB2
Performance Monitor/Expert, DB2 Administration Tool, DB2 Log Analysis Tool, Buffer Pool
Analyzer, and many others.
Worked in a DB2 systems programmer capacity within the DB2 organization’s System Test group.
Key responsibilities include DB2 subsystem installation/maintenance, DB2 Tools installation/
maintenance, SMS routine creation, coupling facility recovery testing, and DB2 workload creation.
In addition, I took a lead role in an effort to expand the system test scope by modeling actual customer
workload. This involved working with customers to analyze their environment and selectwhich data
and applications to be incorporated.
Also worked as a field DB2 technical specialist in a pre-sales and post-sales capacity. Primarily
involved in assisting customers implement and exploit DB2 data sharing in a Parallel
Sysplex. Additionally, conducted performance and application reviews for both Data Warehouse
and OLTP applications, acted as technical resource in competitive benchmarks, and acted as lead
technical support for customer critical situations. The companies with which I’ve been engaged
are fortune 500 companies in the retail, financial, transportation, and telephone industries.
Confidential,Lincolnshire, IL
Position: Database Administrator 11/94 to 12/96
Key participant in Sysplex project that brought a Parallel Sysplex environment to the firm in
early 1996, including three test and two production data sharing groups. Primary responsibilities
include: data sharing performance, local recovery, and off-site recovery.
Other duties in the following areas: DB2 object creation and maintenance, support for IBM’s Visual
Information Imaging System, subsystem creation, logical database design, and technical training for
applications developers.
Confidential,Downers Grove, IL
Position: Information Technology Consultant 5/93 to 11/94
For a software development company, performed benchmark of DB2 V2R3 access paths. This series
of metrics were used for cost calculation with their performance estimator product.
For a public service company, participated on data team to develop a customer information system.
This project was under the direction of IBM Consulting. Responsibilities included the development
of data access programs on a workstation using MicroFocus COBOL/2 Workbench, OS/2 CICS, and
XDB.
Confidential,Buffalo Grove, IL
Position: Database Analyst 10/90 to 5/93
Responsibilities included physical and logical database design, installation and maintenance, and
performance and tuning for all database platforms including IDMS/R, Microsoft SQL Server, and
HP Turbo Image.
Confidential,Westchester, IL
Position: Senior Consultant 5/87 to 10/90
Key participant in design and implementation of tax collection system using IDMS-DC and COBOL.
Involvement in the entire life cycle of the development of the application. Responsibilities on other
client engagements were primarily application design and programming using COBOL and IDMS/R.
TECHNICAL EDUCATION:
DB2 Database Design, DB2 Database Administration, DB2 Recovery, DB2 Performance and Tuning, DB2 Systems Programming.
Working knowledge of: SMP/e, QMF, JCL, CICS, IBM DB2 Admin tool, DB2PM, Websphere Replication for DB2 (Q Replication), BMC Change Manager, BMC Utilities, DB2 commands and utilities, TMON for DB2, Omegamon/DB2, RACF, Strobe, Assembler, COBOL, C, REXX, Powerbuilder.
EDUCATION:
Bachelor of Science in Computer Science - graduated Cum Laude