Senior .NET Software Engineer - MSSQL Database Developer

Red Hawk Technologies; United States; Remote; USD 83,000 - 110,000; Full time

Job summary

Red Hawk Technologies is seeking a Senior .NET Software Engineer for a contract role. You will build and modernize .NET web applications and act as a technical escalation point for complex MSSQL issues, collaborating with our fractional team, project managers, and clients.

You should thrive in high-stakes environments, applying a "first-time right" mindset to production changes, and moving between application development and deep database troubleshooting as needed.

Qualifications

• Bachelor’s degree in computer science or related field.
• 7+ years software development, with 5+ years on the .NET Framework/.NET Core and C#.
• 5+ years MS SQL Server development, including T-SQL, stored procedures, and data integrity.
• PowerShell proficiency for data workflows and automation.
• Proficiency with ASP.NET Core, MVC, and RESTful APIs.
• Git/Bitbucket and Jira experience for version control and issue tracking.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Lead design, development, and deployment of robust web apps using .NET.
• Modernize legacy .NET apps to current .NET Core/8 standards.
• Implement data movement logic, OCR, and REST API management.
• Write clean, well-documented C# code and translate requirements for stakeholders.
• Diagnose MSSQL performance issues, deadlocks, and data quality problems.
• Author and test production data scripts and complex stored procedures.
• Develop SSRS reports and data visualizations; support ETL modernization.

Skills

C#/.NET

SQL Server

PowerShell

ASP.NET Core

MVC

REST APIs

Transactions

Error handling

Git/Jira

Analytical thinking

Education

Bachelor’s degree in computer science or related field

Tools

SQL Server

PowerShell

ASP.NET Core

MVC

REST APIs

Git/Bitbucket

Jira

Job description

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.

We offer

• $70 per hour, 1099, long-term contract with the potential for full-time.

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.