Dylan Finney
Verified Expert in Engineering
Software Developer
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.
Portfolio
Experience
Availability
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
Gamut Solutions
- Provided consultation on matters related to SQL Server.
Director of Data Platform
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.
Manager of Database Engineering
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.
Lead Database Administrator
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.
Principal Database Administrator
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.
Experience
Sharded SQL Architecture
Fast Data Acquisition Datastore
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
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
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring