mssqlserver.com: Michael Hotek Resume

Michael R. Hotek
Grand Prairie, TX 75050
mhotek@mssqlserver.com

PROFESSIONAL EXPERIENCE

Awards/Certifications

2000 – 2004 SQL Server MVP
Microsoft Certified Trainer
Microsoft Certified IT Specialist SQL Server 2005
Microsoft Certified IT Professional Database Administrator
Microsoft Certified Systems Engineer
MSDN Forums Moderator

1997 - present MHS Enterprises, Inc.

Architecture, replication, clustering, performance tuning, and DR/HA work for more than 90 customers
Authored and taught 3 day and 5 day SQL Server High Availability courses
Participated in SQL Server 2005 deployment for 2 large TAP customer
Participated in the Microsoft customer lab engagement for 2 TAP customers evaluating SQL Server 2005
SQL Server 2005 product launch in Israel
Co-authored SQL Server 2005 upgrade documentation for Microsoft
Participated in the design and authoring of SQL Server 2005 courseware for Microsoft
Delivered hundreds of presentations to tens of thousands of IT professionals world-wide

All phases of database operations

Backup/restore
Monitoring
Security
Capacity planning
Performance analysis and tuning
Infrastructure planning and implementation
ETL and archive routines
All phases of data architecture including requirements gathering, data modeling, physical implementation
All phases of database development
Reporting Services development, implementation, and management
Data warehouse design and development
Cube architecture, development, partitioning, and load routines
Mining model design, training, and analysis

High Availability Architecture

Architectural analysis

Needs analysis
System analysis
Technology review

Clustering

500+ clustered instances implemented across SQL Server 2000 and 2005
Multi-instance clusters, Standard clusters, majority node set clusters, geo-clusters

Log Shipping

500+ log shipping pairs implemented ranging from SQL Server 6.5 through SQL Server 2005
Failover and failback implementations along with development of support center push button failover routines

Database Mirroring

6000+ Database Mirroring pairs in production
First production deployment on SQL Server 2005 Beta version

SAN implementations on various platforms – EMC, HP, 3Par

Disaster recovery

150+ recoveries for 100+ clients

All of these were production systems that were down for hardware/software failures
Recovered as much data as possible
~80% of sites were recovered either fully or with a few hours of data loss
Evaluated backup procedures
Evaluated disaster recovery procedures
Implemented corrections to procedures to ensure recovery

Disaster Recovery planning and analysis for 100+ companies

Replication w/ MS SQL Server 6.5 through 2008 and Sybase System 10 - 11.5

200+ clients
50+ transactional system
100+ merge replication
20+ hybrid (transactional/merge, bi-directional, and peer-to-peer)
20+ Custom coded replication
Analyzed requirements and infrastructure
Recommended topology and any necessary infrastructure changes
Produced design document and implementation plan
Developed scripts for implementation
Provided replication training
Initial implementation of replication
Periodic review of performance and operation of system

Business Intelligence

SSRS deployment and management
Report Model design and development
SSIS routines for general data and environment management, cube ETL and processing, data mining ETL and processing
Numerous SSAS cubes taking advantage all available features such as distributed partitions, language localization, custom MDX, custom aggregations, KPIs, and perspectives
Implementation and evaluation of numerous mining models applied to multiple business problems
Implementation and management of several supporting tools such as Proclarity and Cognos
Performance optimization
Troubleshooting processing issues

2000 - 2001 AdOutlet
Director, Database, Research and Development

Site architect for server, storage, and database infrastructure
Contributed to the site network infrastructure
Designed and began implementation of all core company computing environments
Responsible for purchasing and approval of expenditures within IT
Successfully migrated responsibility for IT purchasing, system and network administration, and facilities management to other personnel
Data architect responsible for all database designs deployed and author of all physical designs
Responsible for all database environments

Disaster recovery planning
Code review
Deployment of code to production and other environments
Security planning and implementation

Application architect

Business analysis
Business process engineering
Requirements gathering
Screen design
Responsible for reviewing all stored procedure code as well as writing the most complex procedures in use by the applications

Participated in planning phases for alliances
Participated in vendor and contractor relations
Pre-sales to potential customers
Responsible for evaluating, testing, and creating implementation plans for all new technology, hardware, software, and processes to be implemented within the IT organization
Participated in strategic business planning
Co-author of patent application number 09/587,566

1998 - 2000 The Maxim Group

Large International Law Firm

Lead DBA for a team of 4 DBAs managing over 50 SQL Servers in multiple countries supporting several hundred users
Implemented a disaster recovery plan
Designed and tested merge replication architecture

Multiple tier implementation with the bottom tier doing transactional to 6.5
Will support approximately 75 servers in 23 countries
Provided solution to minimize the impact of some very slow WAN links
Designed a recovery strategy to isolate failures and provide recovery without impacting WAN links

Provided analysis and recommendations for implementing full text indexing to meet management requirements
Rearchitected backup strategy to meet recovery targets
Improved space management and monitoring to meet expansion needs and streamline the effort required
Analyzed query patterns of 3rd party application and recommended improvements
Began rewrite of all core reporting for 3rd party application to meet performance targets
Provided recovery of more than one failed server
Assisted in planning for the relocation of servers
Assisted in the planning of operational components of a data mart solution
Began planning necessary for the upgrade of all servers from 6.5 to 7.0
Staff training in SQL Server, replication, and disaster recovery

7 clients (5 on a telecommute/travel basis)

Rearchitect and modify existing database schema
Rewrote and optimized all stored procedures and triggers
Tuned hardware and database settings
Analysis of third party application
Recommended improvements to existing application to meet performance and scalability requirements
Executed performance testing as proof of concept for recommendations
Inspected current system and configuration
System troubleshooting and automation
System migration
Automation and analysis of backup strategy
Staff training in SQL and SQL Server

1997 - 1998 Modern Business Technology LLC, Schaumburg IL
Consultant

Member of Education Steering Committee
Instructor for 1998 Associate training class

3 clients

Assisted in some targeted performance tuning that produced a very large increase in performance
Designed row level, user defined security system
Assisted in recovery of failed SQL Servers at two remote customer locations
Revised triggers and stored procedures for proper implementation and improved performance (most exceeding a 90% gain)
Provided analysis and recommendations for existing data model
Provided operational support for 6 servers running MS SQL Server 6.5 and 4.21a
Administered a SQL Server that provided FDA tracking and reporting
Cleaned up backup strategies for databases to produce trusted recovery
Provided system and process documentation
Provided troubleshooting for automated processing
Participated in the redesign of all processing in the environment
Automated periodic processing and provided advanced auditing
Reevaluated indexing strategies and made needed modifications
Recommended database management software
Redesigned mainframe down load strategy to provide a more fault tolerant solution
Eliminated over 60% of existing stored procedures to provide a more robust and stable system
Provided disaster recovery during a hardware failure
Implemented process and resource tracking on all SQL Servers
Provided support to all application development in the areas of code reviews, code enhancements, and implementation of better SQL techniques
Provided SQL Server training to DBA staff, developers, and customers

1994 - 1997 Beloit Corporation, Beloit WI
Application developer, database administrator, database designer, trainer

Member of Information Warehouse design and implementation team
Responsibilities: database design, security, administration, application development, data extraction and transformation, reporting, data analysis, and end user training
Designed six databases for tracking customer and engineering data and implemented equivalent databases in the information warehouse using S-Designor and Sybase
Responsible for maintenance, administration, security, and training for all databases and systems designed.
Participated in the design and implementation of a global, bi-directional replication system
Developed applications in JAM and Powerbuilder for maintaining data
Designed integrated Paradox-Quattro system to manage and schedule personnel, and evaluate existing scheduling capacity
Designed systems, Paradox and Access, to track employee information and pay records on a departmental level
Created end user documentation and conducted training classes for most of our systems

TEACHING

Speaking engagements

SQL Server 2005 70-431 Certification Bootcamp - Fort Worth, TX
Dozens of Top 5 ratings for sessions
Delivered dozens of sessions at User Groups
Jumpstart on Integration Services - Dallas, TX 2007
SQL Server Performance Toolkit - Dallas, TX 2006
SQL Server Disaster Recovery - Dallas, TX 2006
SQL Server 2005 Partitioning - Dallas, TX 2006
SQL Server 2005 Upgrade - Dallas, TX 2006
SQL Server Security - Dallas, TX 2006
SQL Server High Availability Features - Dallas, TX 2006
SQL Server Performance Toolkit - Orlando, FL 2006
SQL Server Performance Toolkit - Redmond, WA 2006
SQL DevCon 2006 London
SQL Server 2005 Launch Tel Aviv
SQL Server 2005 ISV Webcast - Microsoft
SQL Server 2005 Webcast - SQL Server Magazine
SQL Server 2005 High Availability - Microsoft Columbus, OH
SQL Server 2005 Roadshow - Microsoft Great Lakes District
SQL DevCon 2005 London
SQLu Summit Vienna 2005
SQLu Summit Madrid 2005
SQL DevCon 2004 London
Veritas Seminars - multiple cities 2004
SQLu Summit Vienna 2004
TechEd Europe - 2004
TechEd US - 2004
PASS 2004
Unisys Seminars - multiple cities 2003
PASS 2003
SQL Connections 2003
Cornerstone 2002
VSLive! San Francisco 2002
PASS 2002 Seattle
PASS 2002 Denver
VSLive! Orlando 2001
PASS 2001 North America 2001

Delivering day long pre-conference on replication

Prophet21 Chicago 2001

Delivering keynote address

PASS 2000 North America

Awarded Best User Session

BackOffice Administrator's Conference 2000
VSLive! Orlando 2000
eDevCon New Orleans 2000
Compass '99
BackOffice Administrator's Conference '99

Designed a 15 unit course for intro to intermediate Transact SQL
Have taught TSQL and SQL Server Administration to thousands of people

TRAINING COURSES

Author SQL Server 2005 and 2008 Reporting Services – 1 day seminar
Author SQL Server 2008 Certification Bootcamp 70-432 – 4 day seminar
Author SQL Server 2008 Certification Bootcamp 70-433 – 4 day seminar
Author SQL Server 2008 Certification Bootcamp 70-448 – 4 day seminar
Author SQL Server 2008 High Availability – 5 day hands-on course
Author SQL Server High Availability – 5 day hands-on course
Author SQL Server 2005 Certification Bootcamp 70-431 – 4 day seminar
Author SQL Server 2005 Certification Bootcamp 70-441 – 4 day seminar
Author SQL Server 2005 Certification Bootcamp 70-442 – 4 day seminar
Author SQL Server 2005 Certification Bootcamp 70-443 – 4 day seminar
Author SQL Server 2005 Certification Bootcamp 70-444 – 4 day seminar
Author SQL Server 2005 Certification Bootcamp 70-445 – 4 day seminar
Author SQL Server 2005 Certification Bootcamp 70-446 – 4 day seminar
Author SQL Server 2005 Bootcamp – 5 day hands-on course
Author SQL Server 2005 Replication – 4 day hands-on course
Author SQL Server 2005 For Oracle DBAs – 5 day hands-on course
Author SQL Server 2005 Performance Tuning – 3 day hands-on course
Author SQL Server 2005 Database Administration – 4 day hands-on course
Author SQL Server 2005 Database Development – 4 day hands-on course
Author SQL Server 2005 Intro to Transact SQL – 3 day hands-on course
Author SQL Server 2005 Database Mirroring – 2 day hands-on course
Author SQL Server 2005 Security – 3 day hands-on course
Author SQL Server 2005 CLR Programming with C# – 2 day hands-on course
Author SQL Server 2005 Business Intelligence Platform – 5 day hands-on course
Author SQL Server 2005 SQL Server Reporting Services – 3 day hands-on course
Author SQL Server 2005 Integration Services – 3 day hands-on course
Author SQL Server 2005 Analysis Services – 3 day hands-on course
Author SQL Server 2005 with Team System – 2 day hands-on course
Author SQL Server 2005 For Sybase DBAs – 5 day hands-on course
Author SQL Server 2005 For DB2 DBAs – 5 day hands-on course
Author SQL Server 2005 Service Broker – 2 day hands-on course
Author SQL Server 2000 Replication – 3 day hands-on course

PUBLICATIONS/BOOKS

Author

MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 - Implementation and Maintenance (PRO-Certification)
SQL Server 2008 Step By Step
The Rational Guide to SQL Server 2005 Security
Several articles in SQL Server Magazine
Several SQL Server 2005 whitepapers for Microsoft
September 1998 - Powerbuilder Developer's Journal
July 1998 - Powerbuilder Developer's Journal
June 1998 - Powerbuilder Developer's Journal
Seven Questions - May 1998 Powerbuilder Developer's Journal
Datawindow Problems - March 1998 Powerbuilder Developer's Journal
Datawindows - February 1998 Powerbuilder Developer's Journal

SQL Server 2008 Replication - Forthcoming

Co-Author

MCTS Self-Paced Training Kit (Exam 70-433): Microsoft® SQL Server® 2008 Database Development (Certification)
SQL Server 2005 upgrade documentation for Microsoft
Microsoft Certified Database Administrator Self-Paced Training Kit: Microsoft SQL Server 2005 Relational Databases – Exam 70-431
MCITP Self-Paced Training Kit (Exam 70-443): Designing a Microsoft® SQL Server™ 2005 Database Server Infrastructure
MOC courseware 2781
MOC courseware 2789
eLearn material for MOC course 2788
Special Edition Using Microsoft SQL Server 7.0
SQL Server System Administration

Technical Reviewer

The Ultimate Datawindow
Internet and Intranet Applications with Powerbuilder6

Michael R. Hotek

All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.