Senior .NET Software Engineer - MSSQL Database Developer

Red Hawk Technologies is a fractional IT consulting firm supporting a diverse portfolio of clients. We're seeking a talented Senior .NET Software Engineer with strong MSSQL database chops to join our team as a contractor. You'll split your time between building and modernizing .NET web applications and serving as a go-to technical escalation point for complex, high-stakes database issues. You'll collaborate with our fractional team, project managers, and clients directly, translating ambiguous requirements and vague bug reports into clear technical solutions. You should thrive in high-stakes environments where accuracy is paramount, bring a "first-time right" mindset to production changes, and be comfortable moving between application development and deep database troubleshooting depending on what the day calls for. Responsibilities - Application Development - Lead the design, development, and deployment of robust web applications using the .NET framework. - Reverse-engineer existing scripts and modernize legacy .NET applications to current .NET Core/8 standards. - Design and implement logic for complex data movement jobs, including OCR integration and REST API management. - Write clean, scalable, well-documented code in C#, and collaborate with project managers and clients to gather requirements and define specifications. - Database Development & Production Support - Diagnose and resolve complex MSSQL performance issues, deadlocks, blocking, failed jobs, data quality problems, and data inconsistencies under tight SLAs. - Author, test, and execute production data scripts and complex stored procedures with a target zero-rework/zero-error rate. - Design comprehensive, fail-safe rollback scripts and contingency plans prior to deploying any data modification or schema change to production. - Build, modify, maintain, and troubleshoot SQL Server Reporting Services (SSRS) reports, matrix views, subscription schedules, and complex underlying datasets. - Assist in evaluating, converting, and modernizing legacy ETL processes, including PowerShell scripts and MSSQL stored procedures, into the Microsoft Fabric and Azure data ecosystem. - Analyze execution plans, indexes, stored procedures, and report queries to refactor inefficient T-SQL code and prevent recurring operational issues. - Troubleshoot and debug complex issues across applications and data pipelines to keep systems reliable and performant.

Qualifications

Must-Have - Bachelor’s degree in computer science, Information Technology, or a related field. - 7+ years of professional software development experience, including 5+ years with the Microsoft .NET framework (.NET Framework 4.6.2+ and .NET Core/8) and C#. - 5+ years of MS SQL Server database development experience, including complex T-SQL (set-based queries, stored procedures, CTEs, dynamic SQL, transactional logic), execution plan analysis, and production support. - Proficiency in PowerShell for managing and automating data flows. - Proficiency with web technologies such as ASP.NET Core, MVC, and RESTful APIs. - Advanced knowledge of explicit transaction management (BEGIN TRAN, COMMIT, ROLLBACK), error handling (TRY...CATCH), and backout script patterns. - Proficiency with Git/Bitbucket and modern version control workflows, plus ticket tracking platforms (Jira). - Excellent analytical, investigative, and communication skills, with the ability to translate complex technical diagnostics into plain-language updates for non-technical stakeholders. Nice-to-Have - Practical experience with Microsoft Fabric (Data Factory pipelines, Warehouses/Lakehouses) or Azure Data Factory. - Experience migrating legacy SSRS reports or datasets into Power BI / Fabric Paginated Reports. - Python experience for file system traversal and data cross-referencing scripts. - Familiarity with Microsoft Azure (App Services, Functions, Key Vault) and Azure DevOps or other CI/CD pipelines. - Previous experience with healthcare EDI files or billing application integrations. - Knowledge of microservices architecture. - Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) or Azure Data Engineer Associate (DP-203). Location - Remote, but USA-based, Eastern or Central Standard Time Zone. Compensation and Terms - We offer $70 per hour, 1099, long-term contract with the potential for full-time. Company - Red Hawk Technologies is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for everyone. - Unfortunately, we cannot accept EAD, OPT, OR H1B candidates or those that live outside the United States.