Scroll To View More
Dylan Finney, Software Developer in Denver, CO, United States
Dylan Finney

Software Developer in Denver, CO, United States

Member since April 28, 2016
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.
Dylan is now available for hire

Portfolio

Experience

  • SQL, 10 years
  • Microsoft SQL Server, 10 years
  • Evolutionary Database Design, 9 years
  • Windows Server 2012, 4 years
  • SQL Server 2014, 2 years
Denver, CO, United States

Availability

Full-time

Preferred Environment

SQL Server

The most amazing...

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

Employment

  • Principal Consultant

    2007 - PRESENT
    Gamut Solutions
    • Provided consultation on matters related to SQL Server.
    Technologies: 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: SQL Server, Amazon EC2, SSIS, SSAS, SharePoint, Active Directory
  • 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: SQL Server, SSIS, SSAS, Red Gate
  • 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, SSIS, SSAS, SSRS
  • 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, SSIS, SSAS, SSRS

Experience

  • Sharded SQL Architecture (Development)

    Custom SQL Server sharded architecture.

  • Fast Data Acquisition Datastore (Development)

    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
  • Storage

    SQL Server 2016, SQL Server 2014, Microsoft SQL Server, Database Administration, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, Databases, SQL Server Integration Services (SSIS), Oracle 10g, Oracle 11g
  • Other

    Software Development
  • Tools

    SSAS, SSRS, TeamCity
  • Frameworks

    Windows PowerShell, .NET
I really like this profile
Share it with others