SQL DBA and DATABASE DEVELOPER• Lead SQL Server Admin for DDS - responsible for all issues related to SQL ServerSOLUTION ARCHITECT AND SYSTEM DEVELOPER• Solution Architect and Lead Developer for custom Identity and Access Control system for DDS using the latest technologies Oauth2 and OIDC.• Solution Architect and Server Admin for new, agency-managed, public network spanning multiple network zones and tiers.• Design, develop, test, deploy, and maintain custom software systems, applications, APIs, and libraries. with extensive use of automated unit and integration testing using Blazor and .NET CORE.• Specify network and environment requirements for F5, Firewall, DNS, SMTP, and SSL Certificates.• Configure and troubleshoot client-server communications across multiple network zones and tiers involving various protocols and authentication typesOPERATIONS & BUSINESS SYSTEMS• Install, configure, maintain, monitor, and troubleshoot production web servers and applications• Manage Active Directory service profiles, and security groups• Integrate Quickbooks with other agency data systems to meet reporting and tax requirements• Integrate data from internal and external sources using SSIS and custom script transformations

SOFTWARE ARCHITECT AND DEVELOPER• Designed, coded, tested, documented, deployed, and maintained custom applications using various frameworks including .NET MVC and Entity Framework, VBA, JAVA, ExtJs, Angular, and others.SQL DBA and DATABASE DEVELOPER • Setup, configured, and managed SQL Server instances and databases, including those storing regulated Criminal Justice Information, Criminal Intelligence, and forensic evidence tracking data• Configured data import, export, backup, cleaning, and migration tasks using various tools• Diagnosed and resolved database and query performance issues• Created custom analytical and administrative reports and reporting systems using SQL Server Reporting Services, SQL Report Designer, Jasper Reports, Crystal Reports, MS Office, and others• Migrated MS Access databases to SQL Server• Provided expert support for complex Access databases, macros, reports, etc…PROJECT MANAGEMENT• Worked directly with Users and Administrators, analyzed business needs, and generated detailed requirements documentation in various formats• Facilitated process improvement (LEAN) events to optimize business workflows prior to software design. • Authored and reviewed complex technical specifications and diagrams to ensure conformance with all applicable statutes, regulations, policies, and standards• Managed custom software procurement projects through requirements gathering, RFP writing and scoring, vendor selection and contract negotiation, BEST intake review, and CJIS approval.• Worked with DAS to improve and standardize the RFI/RFP specification and scoring process for DESPPCJIS PROJECT LIAISON• CJIS Project Liaison for multiple in-house and vendor-sourced systems.• Guided in-house and vendor teams through the CJIS review process from initial design to final approval• Provided responsive custom reporting support for CJIS Auditors• Acquired in-depth knowledge of CJIS requirements for data systems and business processes