Senior Database Administrator
CurrentSenior Database Administrator on DB2 V12 z/OS 5-way Data-sharing Group and i Series machines.30+ years experience with JCL COBOL DB2 SQL25+ years advising IT dept on SQL/DB2 related matters25+ years QMF For Windows Administrator25+ years experience developing in-house DB2/SQL trainingDeveloped, administrated, and maintained DB2 for z/OS databases in a data-sharing environment ensured integrity and managed security access to all DB2 objects.Identified, resolved, or provided recommendations for programmers with SQL performance tuning and coding of DB2 programs.Developed and presented in-house educational classes and seminars on DB2 and SQL to both the I.T. Trainee Program and various company personnel.Developed materials and methods to on-board and mentor many new DBA's over the years. Developed, coded, and maintained custom software to support DB2 Administration functions including a CICS DB2 Administration System Application, Batch DDL generator tool, Database Activity Reporting Tool, & Database Temporary Authority Tool.Developed, coded and maintained DB2 Utility Generator Tool which has already saved the company hundreds of hours of CPU time and thousands of dollars.Participated in multiple iterations of IBM DB2 Early support program including DB2 V12.Administrated DB2 for AS400/i Series databases.Provided 24 hour on-call database administration support.Coordinated product fixes with software vendors.QMF for Workstation AdministrationAdministered, maintained, and installed QMF for Workstation software for hundreds of company employees.Coordinated with Desktop Software personnel to apply software fixes to the product across the company.Coordinated product fixes and enhancements with the QMF software vendor.