Mike Hotek

BI Architect at Six Flags - I am not looking no recruiter contacts please.

Location
Dallas/Fort Worth Area
Industry
Computer Software

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you and Mike Hotek know in common
  • Get introduced to Mike Hotek
  • Contact Mike Hotek directly

View Mike's full profile

Mike Hotek's Overview

Current
  • BI Architect at Six Flags
  • President and CEO at Champion Valley Software, Inc.
Past
  • Vice President at MHS Enterprises, Inc
  • Vice-President at FilAm Software Technology, Inc
  • Vice President at Western Humidor Corporation
  • Vice President at Bargain Humidors
  • Vice President at AcrylicAcetate.com
  • Director Database and Infrastructure at AdOutlet
  • Consultant at MBT
  • Programmer at Beloit Corporation
Education
Connections

500+ connections

Websites

Mike Hotek's Summary

SQL Server professional with industry leading experience in business intelligence, SSIS, SSRS, SSAS, OLAP, replication, disaster recovery, high availability, performance tuning, database design, database development and database systems architecture. I've published 9 SQL Server books and counting along with speaking at hundreds of events and delivering hundreds of training classes. Instead of the paid training I used to do, I now deliver that training for free in the Dallas - Fort Worth area from time to time.

Specialties

Microsoft SQL Server, business intelligence, SSIS, SSRS, SSAS, OLAP, database design, application development, project management, data modeling, disaster recovery, high availability, replication, security, hardware architecture, development processes, team building, and staff development

Mike Hotek's Experience

BI Architect

Six Flags

Public Company; 10,001+ employees; SIX; Entertainment industry

July 2014Present (3 months) Grand Prairie, TX

President and CEO

Champion Valley Software, Inc.

1997Present (17 years)

I build systems encompassing every thing that affects storing, managing, analyzing, and turning data into intelligence on a SQL Server platform. From development processes, team building, hardware architecture, new systems development, existing system maintenance, database management, performance tuning, and business intelligence platforms on the largest and most complicated environments.

Senior BI Architect

CBRE

Public Company; 10,001+ employees; CBG; Real Estate industry

January 2013July 2014 (1 year 7 months) Dallas/Fort Worth Area

Senior Data Warehouse Administrator

RealPage, Inc.

Public Company; 1001-5000 employees; Computer Software industry

June 2012November 2012 (6 months) Carrollton, TX

Architect of the RealPage Business Intelligence platform.

Privately Held; 1-10 employees; Computer Software industry

2009October 2010 (1 year)

We develop very affordable database management and development tools targeted primarily at the SQL Server platform.

Vice President

MHS Enterprises, Inc

January 2007October 2010 (3 years 10 months)

Our company performs high end consulting on the SQL Server and .NET platforms along. We also speak at many industry events and teach numerous, custom designed SQL Server courses around the world.

Information Technology and Services industry

2007October 2010 (3 years)

We do custom software development and QA automation on an outsourced basis to our highly trained and experienced staff in the Philippines.

Vice President

Western Humidor Corporation

January 2003October 2010 (7 years 10 months)

Vice President

Bargain Humidors

January 2000October 2010 (10 years 10 months)

Vice President

AcrylicAcetate.com

20072010 (3 years)

We sell turning kits and supplies to wood turners around the world.

Director Database and Infrastructure

AdOutlet

19992002 (3 years)

Consultant

MBT

May 1998June 1999 (1 year 2 months)

Programmer

Beloit Corporation

19971998 (1 year)

Mike Hotek's Publications

  • SQL: Server 2012 Data Design and Retrieval

    • Champion Valley Press
    • March 29, 2013
    Authors: Mike Hotek

    The latest book from the best-selling SQL Server author Mike Hotek. SQL Server 2012 Data Design and Retrieval is your reference for building databases and querying data. This book takes you on a tour from the basics through the advanced details delivering a reference which you can employ in solving the real-world problems faced every day by database professionals. Each topic is reinforced with detailed exercises taken from real customer implementations.

    We take you on a tour starting with creating tables, through loading/retrieving data, and into the internal storage structures to explain why SQL Server behaves the way it does. We take off from that point to continue through processor architectures to explain why every design choice you make really matters to the performance of your applications. Along the way, you learn how to go beyond storing and retrieving simple data to employ transactions, hierarchies, full-text search, XML, spatial data, indexes, partitioning, and window functions in the design of your applications. This book is also a great starting point for the 70-461 Querying Microsoft SQL Server 2012 certification exam.

  • Microsoft® SQL Server® 2008 Step by Step

    • Microsoft Press
    • November 12, 2008
    Authors: Mike Hotek
  • MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 Implementation and Maintenance

    • Microsoft Press
    • February 18, 2009
    Authors: Mike Hotek
  • Microsoft SQL Server 2008 Database Development (MCTS Self-Paced Training Kit, Exam 70-433)

    • Microsoft Press
    • May 20, 2009
    Authors: Mike Hotek, Tobias Thernström, Ann Weber
  • MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005

    • Microsoft Press
    • December 6, 2006
    Authors: Mike Hotek, JC Mackin
  • MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance

    • Microsoft Press
    • June 28, 2006
    Authors: Mike Hotek
  • The Rational Guide to SQL Server 2005 Security

    • Ratiuonal Press
    • 2008
    Authors: Mike Hotek
  • Special Edition Using SQL Server 7.0

    • Que
    • 1999
  • SQL Server System Administration

    • New Riders
    Authors: Mike Hotek

Mike Hotek's Skills & Expertise

  1. Database Design
  2. Microsoft SQL Server
  3. ITIL
  4. Data Modeling
  5. High Availability
  6. Disaster Recovery
  7. T-SQL
  8. Performance Tuning
  9. SSRS
  10. SSIS
  11. Databases
  12. Replication
  13. SQL
  14. Windows Server
  15. Software Development
  16. C#
  17. Business Intelligence
  18. Integration
  19. .NET
  20. Analysis Services
  21. Database Administration
  22. ETL
  23. OLAP
  24. Architecture
  25. SharePoint
  26. SOA
  27. Oracle
  28. SDLC
  29. Data Mining
  30. Data Warehousing
  31. Data Governance
  32. Data Quality
  33. Data Architecture
  34. Data Warehouse Architecture
  35. Data Stewardship
  36. Data Integration
  37. ER/Studio
  38. TFS
  39. Agile Methodologies
  40. Agile & Waterfall Methodologies
  41. Source Code Control
  42. Unit Testing
  43. Business Analytics
  44. Predictive Analytics
  45. Prescriptive Analytics
  46. KPI Dashboards
  47. BI Strategy
  48. Enterprise Information Architecture
  49. Database Admin
  50. VB.NET

View All (50) Skills View Fewer Skills

Mike Hotek's Education

United States Naval Academy

Physics, Nuclear Engineering, Military History

19891991

Mike Hotek's Additional Information

Websites:
Interests:

Database technology, wines and spirits, travel, woodworking

Groups and Associations:
Honors and Awards:

Author of multiple best selling computer books, contributing author for several professional publications over the past 10 years, numerous speaking and training awards

Contact Mike for:

  • consulting offers
  • new ventures
  • job inquiries
  • expertise requests
  • business deals
  • reference requests
  • getting back in touch

View Mike Hotek’s full profile to...

  • See who you and Mike Hotek know in common
  • Get introduced to Mike Hotek
  • Contact Mike Hotek directly

View Mike's full profile

Viewers of this profile also viewed...