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.
• 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.
• 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.
• 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.
• 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.