Senior SQL Server & .NET API Developer (Azure)

Job Family:Systems EngineeringTravel Required:Up to 10%Clearance Required:Ability to Obtain Public TrustSenior SQL Server & .NET API Developer (Azure)What You Will DoGuidehouse is seeking a Senior SQL Server & .NET API Developer to support the enhancement, maintenance, and deployment of a mission-critical federal application hosted in Microsoft Azure.This role is ideal for a developer whose primary expertise is SQL Server application development and database-centric solution architecture. The application relies heavily on SQL Server for business logic, data processing, security enforcement, and reporting. .NET Web APIs serve primarily as a secure integration layer between SQL Server, Azure-hosted services, Microsoft Power Platform solutions, and consuming applications.The successful candidate will have deep experience designing and supporting SQL-based solutions, implementing secure data access patterns, and developing API integrations within Azure-hosted environments. This position will work closely with architects, business analysts, Power Platform developers, and government stakeholders to deliver new functionality and support ongoing modernization efforts.ResponsibilitiesDesign, develop, maintain, and optimize SQL Server database solutions supporting mission-critical business processes.Create and modify complex stored procedures, views, functions, triggers, and other database objects.Implement database security controls including Row-Level Security (RLS), Security Predicates, and secure data access patterns.Analyze and tune SQL Server performance, query execution plans, indexing strategies, and database workloads.Develop and maintain .NET Web APIs that provide secure access to application data and services.Support Azure-hosted application components including Azure App Services and Azure Function Apps.Implement authentication and authorization using Azure Active Directory and Azure App Registrations.Collaborate with solution architects and technical leads on application enhancements, modernization initiatives, and roadmap activities.Participate in code reviews, troubleshooting, defect resolution, testing, deployment, and production support activities.Support system integration efforts with Microsoft Power Platform and other enterprise applications.Develop technical documentation, implementation guidance, operational procedures, and knowledge transfer materials.Participate in Agile ceremonies, sprint planning, backlog refinement, estimation, and continuous improvement activities.What You Will NeedU.S. Citizenship.Must be able to obtain and maintain a Federal or DoD "public trust"; candidates must obtain approved adjudication of their public trust prior to onboarding with Guidehouse. Candidates with an active public trust or suitability are preferredBachelor's degree in Computer Science, Information Systems, Engineering, or a related discipline.Five (5)+ years of experience developing enterprise applications using Microsoft technolog...