DB2 DBA - Mainframe / z/OS
Resume:
CHARLES T. COOKSEY ** E. CHICAGO AVENUE • SUITE **5 • CHICAGO, IL 60611
*********@******.***
DB2 DATABASE ADMINISTRATOR (DBA) – MAINFRAME / z/OS
PROFESSIONAL SUMMARY
Conduct DBA functions to support DB2 application teams in parallel sysplex and multi-LPAR/subsystem/schema configurations:
Health Checks
Migrations/Refreshes
Installations
Disaster Recovery
Backup/Recovery
DDL/DCL/DML
Performance Tuning
Sizing
Physical Design
Logical Design (minimal)
Root Cause Analysis
Troubleshooting
Job Scheduling
Security
Stress Testing
Create entity relationship diagrams and reverse engineering schemas
ITIL Incident/Problem/Knowledge/Change management
Create, schedule and execute standard IBM, CA/Platinum, and BMC utilities including Image Copy, Recovery, Reorg, Runstats, Load, Repair, Modify, Bind/Rebind, Explain, Quiesce, Stospace, and DCLGEN
Provide 24/7 onsite and remote support for production and test systems in both onshore and offshore models
TOOLS
DB2 ADMINISTRATION TOOL
INTERACTIVE SQL
SQLEASE
EXPLAIN
SQL
DDL/DML/DCL
OMEGAMON
STOSPACE
SPUFI
DB2 COMMAND PROCESSOR
SMS
IDCAMS/VSAM
DB REQUEST DBMS
CHERWELL
HPSM
PAGERDUTY
HOST EXPLORER
TSO
ISPF/PDF
JCL
EJES
SDSF
DFDSS
PANVALET
ERWIN
SHAREPOINT
QUICKREF
CICS/IMS ATTACHMENTS
MAINVIEW
FILEAID
FILE MASTER
COMPLETE
ONENOTE
APLUS
ASM2
FLASHER
OUTLOOK
MS OFFICE SUITE
SALESFORCE CRM
SITE BUILDER
EXPERIENCE
DB2 DATABASE ADMINISTRATOR (DBA) - Consultant
3 – 7/2018, NORTHWESTERN MUTUAL, Milwaukee/Franklin, WI Application: Insurance
Duties: Provided application support functions on test/production LPARS/subsystems. Executed DB2 utilities and commands. Diagnosed and resolved SQL codes and error messages. Created and altered DB2 objects. Managed and serviced application database requests through DBMS tool, and performed Change Reviews for Elite 8 Application requirements. Conducted physical database design. Identified and resolved database performance issues. Provided deployment support for application enhancements and modifications for multiple schemas (35+) in test/production LPARS/subsystems. Granted and revoked DB2 access in conjunction with RACF administrators. Conducted daily/weekly Health Checks. Produced and issued daily shift Handovers for offshore team members. Maintained SOPs, application information, and job references as Sharepoint knowledge resources. Participated in 24/7 on-call support via PagerDuty. Managed ITIL Incident/Problem/Knowledge/Change processes.
PROJECT MANAGER
8/2015 – 12/2017, POST-GRADUATE PROJECT, Evanston, IL Application: Product Design/Development
Duties: Led a funded product design/development project following the graduation of the 2015 Northwestern University Masters of Product Design and Development (MPD2) program. The project involved designing/developing the Impact Protection System (IPS), a helmet system that helps to minimize and prevent concussions, CTE, and neck injuries in football, hockey, motocross, and other high-impact sports/recreation activities. Functions included the management and leadership of creative, design, user analyst, technical, industrial, and manufacturing team members. Product design/development processes and methodologies were employed that featured "design thinking" user centric strategies based in user input and user experiences (UX), product life-cycle management, product optimization, and product performance analysis and enhancement. An additional feature of the project included the development and execution of a product design/development training curriculum for adults and youth.
DB2 DBA - Consultant
3/2014 – 6/2015, ARCELOR MITTAL, East Chicago, IN Application: Steel Design and Production
Duties: Provided application support functions on test and production systems for DB2 databases. Performed troubleshooting and root-cause analysis, problem resolution, and failure logging duties. Created, edited, executed, and scheduled JCL. Physically created and executed ALTERS on DB2 objects. Executed DB2 utilities including COPY, REORG, UNLOAD, LOAD, RECOVER, CHECK DATA/INDEX, QUIESCE, REBUILD INDEX, RUNSTATS, EXPLAIN, and STOSPACE. Executed BIND and REBIND for PLANS and PACKAGES. Conducted copybook SQL performance analysis. Locked and moved DCLGEN members. Approved production copybook installations via ADABAS COMPLETE. Performed data refreshes of production data to test environments. Executed data purges. Granted DB2 privileges to application groups on test systems. Executed INSERT, DELETE, UPDATE, and SELECT DML for application groups. Managed, created, and closed HPSM interaction, change, incident, and task tickets. Executed DB2 DDL for DB, TS, TB, and IX object creates and alters. Prepared and issued weekly process reporting relating data loads, production average transaction response times, and scheduled production weekend outages. Monitored DASD usage and performed cleanup tasks. Installed ODBC drivers for application access to production test system. Performed MS Windows patching on SQL Server servers. Created and edited CA (Platinum) Strategies/Analysis. Scheduled production maintenance outages. Participated in 24/7 on-call rotation coverage.
PROJECT MANAGER - Consultant
3/2004 – 2/2014, SPAIS/ALC-WORKING FAMILIES/BALLSPORT, Chicago, IL Applications: Websites/Mass Email Marketing
Duties: Lead teams in the creation, design, planning, distribution, and implementation strategies for websites and mass email marketing.
DB2 DBA - Consultant
9/2001 – 3/2002, TEXAS WORKFORCE COMMISSION, Austin, TX Application: Employment
Duties: Provided physical and logical design for WorkInTexas.com, the state’s Internet employment resource for job seekers and employers. Generated documentation for the business analysis and application staff that included object entity relationship diagrams created through the ERWIN engineering tool. Functions included database COPY and REORG utility generation and support.
DB2 DBA - Consultant
3 – 5/2001, AVENTIS, Chicago, IL / Kansas City, MO Application: Pharmaceuticals
Duties: Performed off-site/remote DB2 support from Chicago. Functions included: batch job support and troubleshooting; weekly rotation of on-call 24-hour support; database COPY utility scheduling/execution; and REORG utility generation and support.
DB2 DBA / IMS DBA - Consultant
8/1999 – 2/2001, AMERITECH/SBC, Skokie, IL Applications: Inventory / Sales / Accounting
DB2 Duties: Performed DB2 support functions for the client's migration and conversion of Ameritech/SBC data on an Anixter system to a new and separate Ameritech/SBC system with only Ameritech data (Anixter sold network organization to Ameritech/SBC). The Ameritech/SBC system was resized based on the amount of Anixter data that was dropped. The application used DB2 databases that interfaced with People Soft. Installed test and production DB2 subsystems. Created all DB2 objects in the new test subsystem and performed data loads to populate the tables with production data. Assisted with application data drops of Anixter data from the Ameritech/SBC tables. Other duties included: application BINDS and GRANTS; DASD utilization and capacity planning; DB2 Connect installation; backup and recovery; disaster recovery; and performance tuning.
IMS Duties: The application used IMS databases that interfaced with People Soft. Provided application support functions on test and production systems for IMS databases. Performed DBD, PSB, ACB generations. Executed IMS utilities including REORG, RECOVERY, and IMAGE COPY. Performed backup/recovery tasks. Conducted performance monitoring. Performed job scheduling. Performed ONLINE CHANGE, DBCTL, CHANGE ACCUMULATION, and DYNAMIC ALLOCATION tasks.
SYBASE / MS SQL SERVER DBA - Consultant
2 – 6/1999, ZURICH AMERICAN INSURANCE, Schaumburg, IL Application: Insurance
Duties: Provided SYBASE and MICROSOFT SQL SERVER DBA support functions for client server data downloads from a mainframe DB2 production application to a SYBASE client server. Data was compiled and formatted into OLAP multi-dimensional hypercubes and also presented in SEAGATE CRYSTAL reports. Database administration, data manipulation, and analysis was performed via DBARTISAN, MS SQL SERVER ENTERPRISE MANAGER, WISQL using TRANSACT SQL, and MS SQL SRVR QUERY ANALYZER. Created and maintained some stored procedures, scripts and batch jobs for the monthly processing. Also, assisted in the conversion of tables, stored procedures and batch jobs from the existing SYBASE 11.0 database server to a MS SQL SERVER 7.0 database server.
DB2 DBA - Consultant
4 – 12/1998, CAREMARK, Deerfield, IL Application: Pharmaceuticals
Duties: Provided lead implementation and support functions for the Materials Management System (MMS) application. The application was converted from a VSAM application, which was not Y2K compliant, to an Y2K compliant DB2 application. American Software, Incorporated (ASI) developed the application. Physically created 420 new DB2 tables and associated objects in each of 3 test subsystems and a new production subsystem. Performed: sizing and DASD analysis; DDL maintenance and physical design functions; ongoing utility processing, scheduling and maintenance; BIND/REBIND processing; EXPLAIN and SQL analysis; backup and recovery tasks; and general support and problem resolution. Generated documentation for the application staff that included object naming standards and object entity relationship diagrams through the ERWIN reverse engineering tool. Also, participated in the client's disaster recovery testing. Following the exercise performed an analysis relating the overall results and recommendations for improvements in the process.
DB2 DBA - Consultant
8/1997 – 1/1998, FIRST CARD BANK, Elgin, IL Application: Banking Credit Cards
Duties: Provided support for a data base stress-testing group during the development and phase implementation of a new credit card holding application. The new application, which retained most of the existing functionality and DB2 objects, was designed to accommodate 40 times the existing application enabling the processing of 40 million credit card accounts. Migrated production DB2 objects to the test environment and resized them through the use of PLATINUM DB2 RC QUERY / UPDATE / MIGRATOR/ BATCH PROCESSOR. Created and executed DDL to create new and/or altered objects. IBM and PLATINUM unloads, loads, reorgs, and index recoveries were used to implement any physical structure changes (add/remove columns, new/altered keys, etc.) during the physical design. These utilities were also used to load tables for the application programming group to test new programs. Also, executed BIND/REBIND for the application programmers as needed due to new/altered programs. Identified tablespace candidates for partitioning and implemented the partitioning (24 and 32 partitions) to accommodate a considerable increase in data. Created DB2 utilities for backup and recovery as needed for new and changed objects. Also, packaged the DDL, utilities, libraries, and tools for the data base stress-testing group to use at an off-site test location.
DB2 DBA / IMS DBA - Consultant
9/1996 – 6/1997, AMERITECH, Chicago, IL Application: Telecommunications
Duties: Provided DB2 and IMS DBA support for the application clients, the development staff, and data center operations personnel for several network administration applications. As the support DBA, prepared and implemented database software for release installation using DBD, PSB, ACB and IMS SYSTEM generations, DYNAMIC ALLOCATION, DDL, and BIND/REBIND. Also, setup IBM and BMC database utilities for new and modified IMS and DB2 databases and associated objects. Supported disaster recovery implementation and processing.
DB2 DBA - Consultant
6 – 9/1996, FIRST TENNESSEE BANK, Memphis, TN Application: Banking
Duties: Performed DB2 DBA performance analysis functions and made recommendations for the support DBA group and application programming group using the CANDLE EXPLAIN FOR DB2 and OMEGAMON FOR DB2 tools. Identified peak utilization spikes during online processing. Identified and monitored response time thresholds and exceptions. Monitored resource utilization. Performed EXPLAIN analysis and reporting. Coordinated dataset and DASD management and monitoring.
DB2 DBA / IMS DBA - Consultant
3/1995 – 3/1996, BELL SOUTH, Atlanta, GA Application: Telecommunications
Duties: Provided DB2 and IMS DBA support for seven production sites and four test sites. Functions included ongoing database maintenance, sizing and performance analysis, software implementation, and application support providing release DDL/DML. Coordinated disaster recovery efforts. Participated in a reengineering project that included 40 applications. Created DB2 and IMS objects and setup special migration JCL to move production data to the new test system specifically established for the reengineering effort.
IMS DBA - Consultant
10/1994 – 2/1995, CINCINNATI BELL IS, Cincinnati, OH Application: Wireless Communication
Duties: Provided IMS DBA support for the application programmers. Provided physical design, maintenance, new software implementation, and performance support services. The application provided ongoing development implementation and maintenance for a client that provided national wireless communication services. Designed and created new/modified IMS databases in the test/production systems as requested by programmers. The process included DBD, PSB, ACB, and IMS SYSTEM generations. Development was supported on 3 test systems and implemented in 2 production systems. Virtual test systems were established to reduce physical resource requirements.
DB2 DBA / IMS DBA - Consultant
11/1993 – 10/1994, TOYOTA, Georgetown, KY Application: Auto Inventory Management
Duties: Provided DB2 and IMS DBA application support for the programming staff. Implemented physical design and development for new DB2 tables and associated objects and IMS databases. Determined sizing and space requirements, and placement of objects/databases within the test and production environments. Provided ongoing maintenance, performance monitoring, utility scheduling, and the creation/modification of maintenance utility jobs.
DB2 DBA / IMS DBA - Manager
12/1978 – 12/1990, SOUTHWESTERN BELL CORPORATION, St. Louis, MO Application: Telecommunications
Duties: Provided DB2 and IMS DBA support functions for 3 applications. The applications resided in 2 production environments and 3 test environments. The total number of databases/tables managed in all environments exceeded 1500. Supervised 4 subordinates in each of 3 different groups within a division organization. These groups provided direct production/test support services for client, operations, and development staffs. The services included: problem resolution and software fixes; database/table preparation for release implementation; backup and recovery; sizing and DASD placement; performance tuning; disaster recovery; capacity planning; minimal design modifications; application software fixes; DBD, PSB, ACB, and IMS SYSTEM generations; and job scheduling.
TRAINING
MANAGEMENT & INFORMATION TECHNOLOGY SOLUTIONS, Schaumburg, IL
Oracle Database Administration and OCP Testing
Three Tier Client Server Architecture
Project Management and PMP Certification Testing
Service Oriented Architecture
Business Analysis
IBM Rational XDE
Rational Unified Process (RUP)
EDUCATION
NORTHWESTERN UNIVERSITY, Evanston, IL 2015
Master of Science - Product Design and Development Management
LANGSTON UNIVERSITY, Langston, OK 1978
Bachelor of Science - Business Administration/Accounting
Contact this candidate