We provide IT Staff Augmentation Services!

Db2 System Administrator Resume

SUMMARY:

  • Developed Bind Manager and Path Checker for IBM DB2 Tools.
  • Developed Express Hints to manage setting DB2 Hints through ISPF Panels.
  • DB2 / SAP tuning and availability
  • IDAA implementation in DB2 / SAP environment.
  • Personally responsible for SMP/E maintenance for DB2 Subsystems for V8, V9, V10 and V11
  • Used Confidential to insure the stability and performance of the Development Environment.
  • Wrote and maintained stored procedures, CLIST, and other programs as needed.
  • Developed QMF feature to explore EXPLAIN STATEMENT CACHE ALL data.
  • Developed programs to use the Plan Table data from the Statement Cache.
  • Developed programs to assist in Tuning SQL where the DB2 Optimizer had rewritten the SQL
  • Responsible for DB2 REORGs, Load / Unloads, etc.
  • Developed both Stored Procedures and PL/SQL to identify differences between Dynamic SQL as written and the results of DB2 SQL Rewrite.
  • Upgraded DB2 V10 on our ADCD System
  • Installed DB2 V11 on our ADCD System
  • Upgraded four production DB2 V10 subsystem to DB2 V11

SKILL:

  • Worked as team lead and DBA mentor for DB2 Migrations from both V8 and V9 to V10,
  • Lead DB2 Migrations from V10 to V11 CM and NFM
  • Installed and configured DB2 Z/OS including underlying VSAM datasets, DSNZPARMs, and bufferpools
  • Consultant on DB2 database applications architecture.
  • Version migrations on System z from DB2 V2 to V10
  • Tuning on DB2 and VSAM systems resolving cost impacting performance problems
  • Experienced using tools and utilities from IBM, CA, and BMC
  • Extensive application COBOL, PLI and ALC coding for database access
  • Implement multi - platform solutions
  • Installed and configured DB2 on Windows, AIX, and Linux (including z/Linux)
  • Experience with 32 and 64-bit architectures
  • Performance tune and health check services

TECHNICAL SKILLS:

  • COBOL
  • C, C++
  • ALC
  • PLI
  • REXX

PROFESSIONAL E XPERIENCE:

Confidential

DB2 System Administrator

Responsibilities:

  • Lead both DB2 consultants and DB2 Software Developers.
  • Sold Bind Manager and Path Checker to IBM Tools in December 2012
  • Responsible for SMP/E maintenance for DB2 Subsystems for V8, V9, V10 and V11
  • Did several sites visits for IBM Tools for consulting on tool use and SQL Performance issues
  • Held consulting jobs as needed to assist in cash flow. Three examples are below.

Confidential

DB2 System Administrator

Responsibilities:

  • V11 Migration and Performance
  • Migrated SAP DB2 Subsystems from V10 NFM toV11 New Function Mode.
  • Responsible for SMP/E maintenance for DB2 Subsystems for V8, V9, V10 and V11
  • Developed REXX and SQL procedures to capture both SQL, EXPLAIN data, and Statement Cache data both before and after V11 Migration to assist in finding performance changes.
  • Worked on INSLITP issues with SAP Applications
  • Worked with IBM on performance issues.

Confidential

DB2 System Administrator

Responsibilities:

  • Team Lead and Mentor for DB2 V10 NFM Migration and install of CICS V5R2.
  • Migrated 4 DB2 Subsystems from V10 CM to New Function Mode.
  • Migrated Db2 Subsystem to V11 CM
  • Developed methodology to alter Simple Tablespaces to UTS format. There are approximately 200 Simple Tablespaces per DB2 Subsystem.
  • Planned for DB2 V11 migration for last quarter of 2016.
  • Automated daily production from multiple jobs to a single job using LISTDEF and TEMPLATE structures.
  • Installed and tested CICS V5R2 on two LPARs. Moved CICS V5R2 into production.
  • Trained multiple staff members in basics of DB2 V10.

Confidential

DB2 System Administrator

Responsibilities:

  • Team Lead and Mentor for DB2 V10 Migration
  • Resolved the 6-month project in 3 months.
  • This involved four subsystems that had not had maintenance in three years.
  • Trained two DBAs and several developers

Confidential

DB2 Performance and Data issues

Responsibilities:

  • Technical Consultant to the team migrating from one system design to another.
  • Resolved several issues missed with the original data model that impacted completion.
  • Removed data issues that bottlenecked DB2 performance.
  • Actions resulted in operational cost reductions.

Confidential

DB2 System Administrator

Responsibilities:

  • Development of DB2 System to replace VSAM based Credit Card system
  • Managed both DBA and Data Modelling teams.
  • Resolved Data Modelling issues that heavily impacted DB2 source development.
  • Brought the effort out of the Data Modelling phase and into DB2 source development.
  • Resolved both VSAM Production issues and DB2 Project implementation concerns.
  • Brought the DBA efforts in on schedule and just under budget.

Confidential

Consultant to EVP of International Sales

Responsibilities:

  • Handled European Pre-Sales Support development resolving both morale and sales relationship issues.
  • Assisted Sales in presenting products where a representative from the Home Office was required.
  • Integrated with National Sales efforts in the UK, Germany, France, Italy, Spain, and Denmark.
  • Work with both Spain and Denmark assisted with nearly doubling their annual sales.

Confidential

Technical Sales Consultant

Responsibilities:

  • Participated in development of improvements for Confidential f
  • Specifically, designed graphics for presentation of performance information.

Hire Now