Download PDF

I'm a SQL developer and manager trained by DBAs to be conscientious of how my code affects underlying systems. I love writing simple, elegant T-SQL, doing performance optimization, designing scalable databases, and learning and improving on new systems. I live to teach and to learn.

Work experience

Aug 2018present

Database Engineering Manager

SurveyMonkey

Responsible for all duties as Sr Database Engineer, plus management of the Data Engineering SQL team. Manages and measures work. Monitors performance objectives including giving feedback via performance appraisals and helping identify career growth opportunities. Interviews and makes hiring decisions for various SQL related roles. Provides technical leadership and maintains hands-on role in database, ETL, and data warehouse design and implementation. Expert in SQL Server environment. Accountable for overall code quality and data availability. Coordinates stakeholders, oversees project dependencies, ensures contingency plans, and understands overall impact.

Feb 2018Jul 2018

Sr Database Engineer

SurveyMonkey

All duties from Database Engineer III, plus experience using AWS Redshift and Apache Airflow.

Aug 2016Jan 2018

Database Engineer III

SurveyMonkey

Authors, reviews, and approves complex requirements and designs. Mastery of t-SQL; fixes complex bugs. Defines and implements optimizations and devises new data structures. Improves on process and best practices. Anticipates risk and provides contingency solutions and timelines.

Feb 2014July 2016

Database Engineer II

SurveyMonkey

Extensive authoring and improvement of t-SQL objects. Query optimization. Index tuning and maintenance. SSIS wrangling. Database design, including fact and dimension tables. Monitoring of system health with DMVs, trace, and xEvents. Excellent at pattern recognition, expedient problem solving, and simplifying highly technical concepts.

Mar 2011Feb 2014

SQL DBA Developer

GoDaddy

Responsible for developing, maintaining, and supporting mission-critical internal applications in a high-volume, high-availability OLTP environment. Perform standard development duties including t-SQL scripting and ad-hoc queries, creating scheduled jobs, SSIS packages, automated ETL processes, stored procedures, functions, and triggers. Design and maintain database systems for internal software applications with consideration to potential long-range business requirements, performance, and scalability. Utilize query execution plans, optimization techniques, and monitoring to take a proactive approach towards issue identification and resolution. Ensure data integrity and cleanliness for reports, dashboards, and applications. Collaborate with application developers, project managers, quality assurance, and business stakeholders during the development lifecycle from requirements gathering, effort estimates, database design, status updates, and mentoring end users.

Oct 2007Mar 2011

Jr SQL Developer

GoDaddy

Develop, test, and deploy custom stored procedures to identify requested customer sets for targeted marketing campaigns. Monitor and optimize key database processes for the generation of email marketing campaigns.

Education

20022006

BA in Philosophy

Northern Arizona University

Skills

T-SQL

I've designed procedures, functions, and scheduled jobs. Am familiar with ranking and aggregate functions, query hints, and join types.

Query Optimization

I've fixed missing indexes, bad joins, unnecessary complexity, implicit conversions, functions in joins, suboptimal query plans, and much more.

Indexing

Adept at creating ideal indexes, combining duplicates, and managing fragmentation.

Database Design

Experienced with designing scalable systems using optimal datatypes and BI systems of Fact and Dimension tables.

SSIS

I currently move just under a billion rows nightly via an SSIS Project.

SYSTEM HEALTH

Proficient with DMVs, SQL trace, and xEvents to gauge database health.