Dave Wilke

Senior DB2 Database Administrator at Modern Systems
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Arlington Heights, Illinois, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • Saudi Arabia
    • IT Services and IT Consulting
    • Senior DB2 Database Administrator
      • Nov 2018 - Present

      Consulting as a Senior DB2 Database Administrator

    • United States
    • Airlines and Aviation
    • 700 & Above Employee
    • Senior Manager - Data Services
      • Feb 2017 - Jun 2018

      Proposed, gained approval/funding, and managed the retirement of IDMS at United Airlines by converting it to DB2 on z/OS. This project was successfully completed on-time and on-budget, and it resulted in $600k/year savings, ongoing. Also, managed the upgrade of all of the out-of-support Oracle databases, approximately 100 databases.

    • Director - Airline Ops & Shared Srvcs - Database Engineering
      • Feb 2014 - Feb 2017

      Responsible for Database Engineering/Administration for Airline Operations Shared Services Databases across all platforms/DBMSs, including Oracle, DB2 UDB for z/OS, SQL Server and IDMS.

    • Sr. Manager - Database Services
      • Mar 2013 - Feb 2014

    • United Kingdom
    • Financial Services
    • 700 & Above Employee
    • TEKsystems Database Consultant
      • Nov 2012 - Mar 2013

    • United States
    • Food and Beverage Manufacturing
    • 1 - 100 Employee
    • Associate Director
      • Jan 2004 - Sep 2012

      Responsible for managing the outsourcing environment, by partnering with the appropriate vendors for Infrastructure and Application support, including the management of budget, SLA's and staffing while driving ongoing efficienciesProgram Manager for the Re-Hosting/Elimination of the company's four mainframe boxes, which were comprised of 3,400 MIPS. Directly oversaw the management of 70+ externals as part of the first phase of the implementation.Mainframe costs reduced from $24MM at start of outsourcing to $7MM via re-hosting, retirements, remediation, benchmarking and tuning over a three year period. The platform is in the process of final elimination that will bring it down to zero by the end of 2012. Directly responsible for the negotiation and procurement of licenses ($1MM+ total spend) for mainframe re-hosting and company split, driving cost synergies for both companies.Negotiated the new mainframe contract with our outsourcing partner for infrastructure, driving $4MM of annual savings and positioning us to exit the platform in a cost effective manner.Directed mainframe tuning efforts after initial infrastructure outsourcing to drive $2MM in annual savings.Cadbury North American Integration Lead - was responsible for delivering the overall integration of the Cadbury IT organization into the Kraft infrastructure, while achieving budget objectives and cost synergies.AS400 Value Transformation - delivered $2.4MM total productivity savings by consolidating and eliminating nine AS400 boxes, going from 14 boxes down to 5.Application Support manager for two years in support of outsourcing for B2B Hub, Business Objects, Source-to-Pay (Indirect Procurement), and MRP systems. Managed a staff of 20+ internals and 45+ externals, while continuing to look for opportunities to reduce internals, while driving cost efficiencies with the outsourcer. Total budget responsibility was $2MM internal and $3.5MM external.

    • Business Systems Manager
      • Jan 1999 - Jan 2004

      Managed the DB2 DBA Group - including managing $1MM+ budget, driving standardization, tuning, and support efficiencies, while delivering project work on-time and on-budget.

    • Senior Staff Consultant / Mainframe DB2 DBA
      • Jan 1990 - Jan 1999

      Mainframe DB2 DBA performing development and support for a wide variety of applications, including HR/Payroll, Master Files, Sales, and Operations systems. Developed standards, tools environment setup and implementation, data modeling and overall Master Files E/R / Architecture Diagram. Also, played a key role in system and application tuning efforts, as well as DASD optimization. Through my efforts, Kraft was able for avoid a mainframe upgrade from 2003 on, even while integrating the Nabisco Foods division into the Kraft infrastructure, avoiding a $1MM+ upgrade.

    • United States
    • Banking
    • 1 - 100 Employee
    • Senior Business Consultant
      • Sep 1989 - Aug 1990

      Mainframe DB2 DBA for the Trust Department.

    • Senior Software Consultant
      • 1984 - 1989

Education

  • DePaul University
    Computer Career Program
    1983 - 1983
  • University of Illinois at Chicago
    B.S, Finance; Business Administration
    1976 - 1981

Community

You need to have a working account to view this content. Click here to join now