Dylan Finney

Dylan Finney Email and Phone Number

Principal Architect, Partner @ Switch Architecture
denver, colorado, united states
Dylan Finney's Location
Denver, Colorado, United States, United States
Dylan Finney's Contact Details

Dylan Finney personal email

Dylan Finney phone numbers

About Dylan Finney

I have extensive experience across the Microsoft SQL Server product stack with a primary focus on the database engine. I have had the privilege to lead teams in designing and implementing clustered, virtual and VLDB environments on the administrative side as well as architect various products and solutions for internal projects. My primary areas of expertise include:• Enterprise Architecture• Data Center Migrations• SQL Development• SQL Performance Tuning• SQL Server Administration• Systems Design• AutomationSome of the highlight systems and architectures I have implemented include a nationwide bidirectionally replicated OLTP system, a geo-spanned cluster across two sites both actively serving requests and a 6 node active/active “big iron” cluster. I also built a custom SQL server sharded architecture using peer-to-peer replication allowing a company to scale out instead of up. Working in these varying environments has exposed me to a number of design philosophies and coding practices.SQL Server engine internals is the facet of the product that I am most passionate about. I apply my expertise and knowledge to ensure the scalability and availability of the systems I design and help to implement.Beginning in early 1998 I started working with technology as a career. Across my years in IT I have had the privilege to work in capacities from tech support to IT manager. Having worked in so many positions I have a journeyman level of knowledge in areas including programming, infrastructure design, systems administration and QA. For over a decade I've focused my career on the SQL Server technology stack and have attained a level of skill that allows me to be a technical leader within an organization for the technology stack.

Dylan Finney's Current Company Details
Switch Architecture

Switch Architecture

View
Principal Architect, Partner
denver, colorado, united states
Website:
switcharch.com
Employees:
2
Dylan Finney Work Experience Details
  • Switch Architecture
    Principal Architect, Partner
    Switch Architecture Apr 2017 - Present
    Denver, Co
  • Gamut Solutions
    Owner/Principal Consultant
    Gamut Solutions Dec 2007 - Apr 2017
    Thornton, Co
  • Medalogix
    Director Of Data Platform
    Medalogix Apr 2013 - Apr 2016
    Greater Denver Area
    • Worked inside company to establish a new Data Platform team responsible for both SQL development and Administration• Built a custom multi-tenant sharded datawarehouse 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.• Solely responsible for data platform architecture, development and administration. As the in-house database authority I not only built new data structures but also maintained existing functionality and improved performance continually across the board.• Migrated entire organization to AWS EC2 instances for a monthly cost savings of 50%.• Maintained and expanded TeamCity automation of everything from SQL code deployments to environment shutdown to save money in EC2.• Implemented self service BI platform using PowerView, SharePoint and SSAS (tabular and multidimensional)
  • Market Force Information
    Mgr Database Engineering
    Market Force Information Oct 2011 - Feb 2013
    Louisville, Co
    • Worked inside company to establish a new SQL Development team and managed both the DBA and SQL Development groups.• Implemented a new 4 node active/active production cluster in the Alpharetta GA data center to support growth in the production environment.• 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 meta data driven SSIS packages feeding the data. The system was used to feed an analytics platform built on Solr/JSONiq.• Was in-house authority and resource for database design, tuning and development. Working closely with application developers across multiple products.• Implemented Quest Foglight and Performance Analysis (PA) for monitoring production database environments from scratch replacing a mixture of monitoring solutions.• Mentor DBA and Development staff through an open dialogue and a series of classes on T-SQL as well as the SQL Server Database Engine.
  • Ghx
    Lead Sql Dba
    Ghx Jun 2011 - Oct 2011
    Louisville, Co
    • Lead production and development database teams and coordinated efforts within our groups• Worked to implement new 6 node active/active production cluster in the Plano TX data center to support growth in the production environment.• Developed and executed project plan to implement clusters in lower environments to better align release and maintenance methodologies as well as eliminate silos of knowledge in the teams.
  • Ghx
    Sr. Database Administrator
    Ghx Aug 2010 - Oct 2011
    Louisville, Co
    • Manage 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 team.• Created project plan to migrate development and Q/A environments onto VMWare platform as well as move production systems onto a “Big-Iron” platform.• Mentor Jr. DBA staff and help them improve their skill set
  • Adams 12 Five Star Schools
    Principal Database Administrator
    Adams 12 Five Star Schools Feb 2009 - Aug 2010
    Thornton, Co
    • Create and implemented proper backup and recovery procedures• Worked closely with various vendors and departments on implementing new software.• Finished migration to Server 2008/SQL Server 2008 6 node Active/Active cluster for production systems.• Consolidated development and Q/A environments onto a virtualized infrastructure.• Architected new a data warehouse to consolidate Student, HR, Transportation and Financial Data through SSIS packages.
  • Megastar Financial
    It Manager
    Megastar Financial Aug 2008 - Feb 2009
    Cherry Creek, Co
    • Migrated company infrastructure to a virtual environment using VMWare ESX server.• Reported directly to CEO regarding IT department project staffing, direction and budget issues.• Designed and implemented development, testing and deployment strategies minimizing application user downtime.• Evaluated and recommended new technologies for organization use.
  • Megastar Financial
    Developer\Dba
    Megastar Financial Dec 2007 - Feb 2009
    Cherry Creek, Co
    • Create and implemented proper backup and recovery procedures• Designed SQL Server 2005 database from the ground up for in house mortgage back office support system.• Supervised in house report writing team for legacy database system (SQL 2000)• Designed and implemented a data warehousing solution with an integrated Reporting Services front end allowing Accounting to create Ad-Hoc reports needed to satisfy day to day tasks. Loads to and from the warehouse were done using SSIS.
  • American Skiing Company
    Developer
    American Skiing Company Dec 2005 - Dec 2007
  • Healthcoast
    Nerd
    Healthcoast 2000 - 2003

Dylan Finney Skills

T Sql Microsoft Sql Server Databases Sql Database Design Ssis Database Administration Data Warehousing Performance Tuning Sql Tuning Software Development Stored Procedures Business Intelligence Ssrs Agile Methodologies Etl Cluster Enterprise Architecture Data Architecture Database Admin High Availability Oltp Replication Dts C# Data Warehouse Architecture Sql Server Management Studio .net Disaster Recovery Asp.net Data Modeling Database Security Xml Brewing Data Migration Windows Server Data Center Relational Databases System Administration Web Services Architecture Vmware Olap

Dylan Finney Education Details

  • Wellsboro Area High School
    Wellsboro Area High School

Frequently Asked Questions about Dylan Finney

What company does Dylan Finney work for?

Dylan Finney works for Switch Architecture

What is Dylan Finney's role at the current company?

Dylan Finney's current role is Principal Architect, Partner.

What is Dylan Finney's email address?

Dylan Finney's email address is dy****@****mut.com

What is Dylan Finney's direct phone number?

Dylan Finney's direct phone number is +130333*****

What schools did Dylan Finney attend?

Dylan Finney attended Wellsboro Area High School.

What are some of Dylan Finney's interests?

Dylan Finney has interest in Zombies, Biking, Computer Gaming, Metal, Brewing Beer, Movies, Hip Hop.

What skills is Dylan Finney known for?

Dylan Finney has skills like T Sql, Microsoft Sql Server, Databases, Sql, Database Design, Ssis, Database Administration, Data Warehousing, Performance Tuning, Sql Tuning, Software Development, Stored Procedures.

Not the Dylan Finney you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.