Dan Kick Email & Phone Number

Served as subject matter expert and process expert in databases and SQL areas. Held DBA privileges in development and QA databases. Served as an experienced developer.• Designed and coded complex stored procedures for Global Data Collection application that moved data from 6 staging tables to 90 end target tables. Procedures handled multiple responses by language, converting dates from multiple formats and locale settings, decimal precision and error handling to identify data not… Show more Served as subject matter expert and process expert in databases and SQL areas. Held DBA privileges in development and QA databases. Served as an experienced developer.• Designed and coded complex stored procedures for Global Data Collection application that moved data from 6 staging tables to 90 end target tables. Procedures handled multiple responses by language, converting dates from multiple formats and locale settings, decimal precision and error handling to identify data not conforming to proper data type. • Served as subject matter expert for DB2 SQL for the developers in my area which helped to complete projects on time and within budget. • Performance tuned long running queries to ensure that jobs did not exceed the batch window. Show less

Implemented and supported DB2 UDB, Informix IDS and Informix XPS databases from development phases to production implementation. Included installing and upgrading the database software, trouble shooting performance issues and providing 24x7 support.• Was lead DBA for an 8TB data warehouse and worked closely with the development team on design and performance issues.• Formulated a backup and recovery strategy for the data warehouse databases which was used to successfully recover the… Show more Implemented and supported DB2 UDB, Informix IDS and Informix XPS databases from development phases to production implementation. Included installing and upgrading the database software, trouble shooting performance issues and providing 24x7 support.• Was lead DBA for an 8TB data warehouse and worked closely with the development team on design and performance issues.• Formulated a backup and recovery strategy for the data warehouse databases which was used to successfully recover the production database.• Created custom programs utilizing shell scripts and Perl to replace DB2 export of a PeopleSoft database which reduced the time from 15 hours to 3 hours.• Wrote scripts to automatically add space to dbspaces when they reached a certain percent full which eliminated outages. Show less

Database Administrator Implemented and supported DB2 for z/OS and Informix IDS from development phases to production implementation. Including trouble shooting performance issues and providing 24x7 support. • Participated in disaster recovery tests.• Resolved performance issues as they occurred. • Assisted System Administrators with installation of software on the mainframe.

Wrote and tested COBOL programs and JCL and provided support when they went to production. • Worked on project to send self-certified floor checks to dealers which eliminated the need for on-site inspections.• Automated process to convert mainframe COBOL programs to run on UNIX server.

Wrote and tested PL1 programs and JCL and provided support when they went to production• Selected to be part of a four person team that had sole responsibility to modify key programs, including the billing program which generated company revenue.

Wrote and tested COBOL programs and JCL.