Ryan Hanlin

Nashville, TN 615-***-**** adjq4n@r.postjobfree.com

SQL Server Developer / Administrator

~7 years of IT experience, including 2+ years as a database administrator. Excels at collaborating in a cross- functional environment with fluid priorities. Experienced at working on data initiatives at all stages from gathering requirements to development and testing to implementing and supporting. Outstanding communication skills, leadership ability, and customer service aptitude. Data Management Creating Reports Data Synchronization SQL Server Mirroring Backup & Recovery Query Writing Debugging / Profiling SQL Server Integration Services SQL Server 2008, 2012, 2014, 2016 Professional Experience

SQL Server Developer – National Distribution & Contracting – Nashville, TN Sep 2019 – Present

Developed data services by creating, modifying, and maintaining ETL processes in SSIS and SQL Server stored procedures, functions, and views.

Built and supported data pipelines using Azure Data Factory, Logic Apps, and SQL Server.

Created reports in Visual Studio and deployed the reports to SQL Server Reporting Services. Database Administrator – PESG – Nashville, TN Jan 2017 – Aug 2019

Administered SQL Server 2012, 2014, and 2016, syncing legacy databases with the current environment and automating the process for importing vendors’ data using SSIS packages created and deployed from Visual Studio.

Optimized queries by analyzing execution plans and auditing their cost of execution.

Triaged critical care issues in SQL Server by utilizing dynamic management views to monitor and diagnose health and performance issues.

Tier II Software Support Analyst – Common Cents Systems – Nashville, TN Dec 2015 – Oct 2016

Fielded and resolved customers’ support tickets within the laboratory information management system, integrating with site instrumentation and applications.

Captured the process to resolve issues in Knowledge Base articles.

Gathered customer report requirements and created customer reports base on those criteria. Software Support Analyst – GeoConex Corporation – Knoxville, TN Sep 2013 – Dec 2015

Coordinated the implementation, upgrade, and support of client/server-based applications across 100+ instances of SQL Server 2008 and 2012.

Installed, upgraded, and administered instances of SQL Server 2008 and 2012, and maintained Database Mirroring and Automatic Failover across clustered servers.

Defined quality standards for upgrading software and managing database schema changes.

Created ad hoc reports with stored procedures and views in SQL Server 2008 and 2012 Education

Associate of Applied Science, Computer Programming – Meridian Community College – Meridian, MS Technical Proficiencies

SQL, SQL Server, SSRS, SSIS, MySQL, Access, InterSystems Cache, ArcGIS, Crystal Reporting, Data parsing with: HL7, ANI/ALI