Dave Smits

Background

About Dave Smits

A talented senior software developer with over 24 years experience building and maintaining both large scale and small applications for the insurance, airlines, and healthcare industries. Primary focus for the last 14 years has been SQL Server development and design with a specific passion and expertise for performance tuning. Proven ability to solve complex programming tasks with solutions that are free of defects, properly designed, easily maintained, and perform at a high level. My email is dave.r.smits@gmail.com Highlights: • Key developer for a BI data warehouse project utilizing a star schema and an incremental refresh approach. • Developed key scheduling modules which support complex scheduling logic that must perform and provide reliable and accurate data. Schedulers include MDS & PPS assessments, medication orders (eMAR), and Point of Care schedules. • Primary developer focused on solving SQL Server performance issues using tweaks to the queries, rewrites of the logic, and index and design changes, many times affecting the run times from minutes or many seconds to second or sub-second response time. • Extensive experience analyzing SQL Server query performance by studying execution plans, examining index statistics, utilizing SQL Profiler output and Dynamic Managed Views (DMVs), and leveraging the vast wealth of knowledge of the SQL server community on the web. • Experienced in SQL server deadlock analysis and resolution. • Review and provide feedback for all database schema and database development. • Mentor other developers on proper SQL server design and best practices. Languages: T-SQL for SQL Server 7, 2005, 2012, JAVA, Progress, MySQL, Sybase Tools: SQL Profiler, GIT, CVS, Intelli-J, SSRS, Crystal Reports, Confio Ignite