Ike Ellis, San Diego SQL Consultant

IKE ELLIS, MVP

Partner at Crafting Bytes
SQL Server Consultant
Data Architect
Conference Speaker
Author




What I do:


  • I'm a partner in Crafting Bytes. We are a San Diego-based software development studio and business inteliigence group. We have deep experience in Microsoft .NET JavaScript (and all the popular frameworks), mobile development, WCF, REST services, software architecture, Azure, AWS, SQL Server, Power BI, SSRS, SSIS, and SSAS.
  • I consult on SQL Server performance tuning, SQL Server architecture, data warehouse design, and business intelligence projects. I extensively write in R, Python, and T-SQL.

Accomplishments


  • 7-time Microsoft Data Platform MVP (2011 - Present)
  • Co-authored a with a few other MVPs on database performance
  • Co-authored a book on Developing Azure Solutions with Michele Bustamante and Zoiner Tejada
  • 18 years as a MCDBA, MCSE, MCSD, and MCT
  • Wrote a cover story for TDWI - 2014
  • Wrote a story for CIO Insider magazine on Database Lifecycle Management
  • Regularly speaks at Code Camps and SQL Saturdays on topics like Data, BigData, Data Visualization, Business Intelligence, SQL Azure, DocumentDB, Azure SQL Database, and SQL Server.
  • Wrote the course material for Power BI and SQL Server HADR (AlwaysOn) for Azure University.
  • Spoke at SQL Pass 2014, 2015, 2017
  • Spoke at RedGate SQL in the City in London and Seattle 2014, 2015
  • Spoke at SQL PASS Business Analytics Conference 2015.
  • Course author and instructor on SQL Server, Business Intelligence, and Big Data for Wintellect

Recent Work

  • Principal outsourced DBA for major software company. Manage the performance and HADR for four different SQL Servers with a combined 300 different databases.
  • Major IoT project for billion dollar San Diego company. Created data model and ETL work for importing 100GB a week into a data warehouse.
  • Created SSRS, SSAS, and Power BI artifacts for data analytics project for a giant US homebuilder.
  • Created over 300 reports for a US retailer covering everything from financials, inventory, purchasing, sales, employee scorecarding, and service effectiveness.
  • Wrote custom telemetry dashboards in Power BI for a device manufactoror showing error rate, efficiency, and stoppage alerts.


I have a strong interest and experience in Application Lifecycle Management (ALM) as it relates to the database. I'm a Friend of RedGate who is a certified trainer and consultant. I actively consult on RedGate Source Control, RedGate Continuous Integration, RedGate Continuous Release, Octopus Deploy, JetBrains TeamCity, tSQLt, Approval Tests, XUnit, RedGate SQL Prompt, RedGate ReadyRoll, JetBrains Resharper, and GoCD.