Dylan Finney Email & Phone Number

Denver, Co

Thornton, Co

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)

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.

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.

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

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.

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.

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.