Sten Miles

SQL Developer

Nevada Legislature•  July 2017 - March 2024•  Carson City, Nevada USA

Orchestrated operation and development efforts, employing Excel and Microsoft Project for efficient management. Provided database administration support for implementation of new DBA position. Aligned data initiatives with strategic goals of LCB, Assembly, Senate, and public. • Deployed standardized reporting from disparate applications into central SSRS instance. • Achieved 50% reduction in ETL workload on SQL server by optimizing events through SQL Server Change Data Capture (CDC) and Service Broker. • Consolidated 20+ years of databases, resulting in 75% reduction in database count. • Created T-SQL code, stored procedures and functions for applications and reporting. • Enhanced website data availability, reducing ETL processing time by 75%. • Simplified version management with upgrades to SQL Server 2019.

Software Engineer

Nevada Legislature•  March 2008 - June 2017•  Carson City, Nevada USA

Addressed customer reporting requirements promptly and accurately through SSRS, Crystal Reports, and Excel. Facilitated fact-based decision-making for executives, managers, and staff by providing timely and accurate data. Administered multiple MS SQL instances and schemas as Database Administrator (DBA). Fine-tuned and maintained ETL processes using SQL code to optimize performance. Supervised team of three C# client developers in developing and supporting six in-house enterprise applications. • Executed real-time ETL processing from multiple data sources using SSIS, SQL Server stored procedures, CDC, and functions. • Improved efficiency of posting meeting agendas by 75% through automation of formatting and linking using VBA and C#. • Developed and maintained business applications utilizing VB, C#, and SQL. • Reduced codebase by 75% and migrated legacy VB.Net language to C#.