Kenneth L. Zenger
Database Analyst/Administrator with 25 years’ experience in key support for large-scale, multi-application data sharing mainframe programs and environments.
Navient Solutions/Sallie Mae Fishers, Indiana 1992-2018
Clearance Security: 6C --- Department of Education --- 8 years
oMainframe DB Utilities
Testing upgrades to IBM and BMC Db2 products in DEV, QA and Production using scripts setup to test the functionality of the products online and batch.
Recovery Tool Solutions
ESP & CA7 Scheduling Products
COBOL data extraction
Previous experience with: Online and Batch Data Dictionary
Proficient in debugging and tuning SQL
Experience with REXX and CLIST products
Resolve problem tickets created in Services Desk and monitor the system using Mainview, Apptune and creating report to show Db2 tasks are performing correctly WLM performing correctly and all Databases have been backup in the last 24 hours.
IBM EC 12001
Products RSU 1801
Responsible for the IMS to Db2 conversion. Unloaded IMS database using a COBOL program and load the Db2 Database with BMC loads for over 70 tables.
Created a JUG ( JCL Utilities Generator) Db2 database for creating JCL backup, Reogs, Loads and Unloads.
Responsible for Database changes for over 75 Major Monthly Releases on 500 Databases. The Database changes would be rolled out to selective Development Databases to Develop the code change. Then be moved to selective QA Databases for testing. Then after months of development and testing the Database changes are moved to Production. Once the Database changes are in Production the QA and Development that do not have the change are updated so all Database are like Production.
Created 30 Databases for the Department of Education contract. This included the Utilities, JCL and scheduling of thousands of jobs.
Create standalone unloads from Db2 Production Database using BMC Recovery Manager to be loaded to HADOOP. The process was run over a 30-week period to unload over 40 tables standalone without causing any Production outage and loss of data going to HADOOP.
Worked with z/OS operating system upgrades and validation on IBM and third party products both Batch and online.
Possess strong collaboration skills as well as acting independently to expose and resolve problems.
On call support 24/7
Available for consulting.
VFW Commanders Award 2017
Ruritan Club President/Vice-President 1998 -2012
Community Center Board Founding Board of Directors 1995-Present
References available upon request