Dylan is available for hire

Dylan Finney

Verified Expert in Engineering

Software Developer

Location

Denver, CO, United States

Toptal Member Since

June 18, 2020

Dylan has over eleven years of experience as a SQL Server data professional. With extensive experience in database engines and enterprise administration as well as OLTP and data warehouse architecture and development, he is able to rapidly come on board and become an effective team member.

Windows SQL Microsoft SQL Server Databases Database Development SQL Server 2005 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server Integration Services (SSIS)SQL Server Reporting Services (SSRS)Agile SQL Server 2016 .NET C#

Portfolio

Gamut Solutions

Microsoft SQL Server

Medalogix

Amazon Web Services (AWS), Azure Active Directory, SharePoint, SSAS...

Market Force Information

SSAS, SQL Server Integration Services (SSIS), Microsoft SQL Server

Experience

Microsoft SQL Server - 10 years SQL - 10 years Evolutionary Database Design - 9 years Windows Server 2012 - 4 years SQL Server 2014 - 2 years

Availability

Part-time

Preferred Environment

Microsoft SQL Server

The most amazing...

...architecture I've designed and built was a custom SQL server sharded architecture, fully automated and self-managing.

Work Experience

Principal Consultant

2007 - PRESENT

Gamut Solutions

Provided consultation on matters related to SQL Server.

Technologies: Microsoft SQL Server

Director of Data Platform

2013 - 2016

Medalogix

Built a custom multi-tenant sharded data warehouse to scale SQL server horizontally using peer-to-peer replication (automated creation/destruction for releases), partitioning (automated partition switching for nightly data loading, automated range maintenance for new client additions), automated sequence range management, and cross-shard awareness.
Migrated AWS EC2 infrastructure for a 50% cost savings.
Handled data platform architecture, development, and administration.
Did general performance tuning and health monitoring of large SQL server environment.

Technologies: Amazon Web Services (AWS), Azure Active Directory, SharePoint, SSAS, SQL Server Integration Services (SSIS), Amazon EC2, Microsoft SQL Server

Manager of Database Engineering

2011 - 2013

Market Force Information

Designed and built an XML database for fast data acquisition. We deployed the solution using SQL Server 2012 and utilized technologies such as partition switching for fast parallel loading and decentralized metadata-driven SSIS packages feeding the data. The system was used to feed an analytics platform built on Solr/JSONiq.
Implemented Quest Foglight and Performance Analysis (PA) for monitoring production database environments from scratch, replacing a mixture of monitoring solutions.
Mentored DBA and development staff through an open dialogue and a series of classes on T-SQL as well as the SQL Server database engine.
Implemented a new 4-node active/active production cluster in the Alpharetta GA data center to support growth in the production environment.

Technologies: SSAS, SQL Server Integration Services (SSIS), Microsoft SQL Server

Lead Database Administrator

2010 - 2011

Global Healthcare Exchange

Led production and development database teams and coordinated efforts within our groups.
Worked to implement a new 6-node active/active production cluster in the Plano TX data center to support growth in the production environment.
Managed production database systems totaling over 6TB in active data.
Developed and presented a series of T-SQL classes for in-house and contracted software development teams.
Created a project plan to migrate development and QA environments onto the VMWare platform as well as move production systems onto a “Big-Iron” platform.

Technologies: SQL Server Reporting Services (SSRS), SSAS, SQL Server Integration Services (SSIS), Microsoft SQL Server

Principal Database Administrator

2009 - 2010

Adams 12 Five Star Schools

Finished migration to a Server 2008/SQL Server 2008 6-node Active/Active cluster for production systems.
Consolidated development and QA environments onto a virtualized infrastructure.
Architected a new data warehouse to consolidate student, HR, transportation, and financial data through SSIS packages.

Technologies: SQL Server Reporting Services (SSRS), SSAS, SQL Server Integration Services (SSIS), Microsoft SQL Server

Experience

Sharded SQL Architecture

Custom SQL Server sharded architecture.

Fast Data Acquisition Datastore

Designed and built an XML database for fast data acquisition. We deployed the solution using SQL Server 2012 and utilized
technologies such as partition switching for fast parallel loading and decentralized metadata-driven SSIS packages feeding the data. The system was used to feed an analytics platform built on Solr/JSONiq.

Skills

Languages

SQL, C#

Paradigms

Evolutionary Database Design, Database Development, Agile, Kanban

Platforms

Windows Server 2012, Windows, Amazon EC2, SharePoint, Amazon Web Services (AWS)

Storage

SQL Server 2016, SQL Server 2014, Microsoft SQL Server, Database Administration (DBA), SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Azure Active Directory, Oracle 10g, Oracle 11g

Other

Software Development, Mixed Reality (MR)

Tools

SSAS, TeamCity

Frameworks

Windows PowerShell, .NET

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring