Senior SQL Server & .NET API Developer; Azure) Security Clearance

Position: Senior SQL Server & .NET API Developer (Azure) with Security Clearance
Job Family :
Systems Engineering Travel Required :
Up to 10% Clearance Required :
Ability to Obtain Public Trust Senior SQL Server & .NET API Developer (Azure) What You Will Do Guidehouse 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. Responsibilities
* Design, 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 Need
* U.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 preferred

* Bachelor's degree in Computer Science, Information Systems, Engineering, or a related discipline.

* Five (5)+ years of experience developing enterprise applications using Microsoft technologies.

* Expert-level experience with Microsoft SQL Server.

* Extensive experience developing:

* Stored Procedures

* Views

* Functions

* Triggers

* Database Security Models

* Experience implementing Row-Level Security (RLS) and data access controls.

* Experience developing RESTful APIs using .NET and C#.

* Experience deploying and supporting applications in Microsoft Azure.

* Experience implementing Azure Active Directory authentication and Azure App Registrations.

* Strong troubleshooting, debugging, and performance tuning skills.

* Ability to communicate effectively with both technical and non-technical stakeholders. What Would Be Nice To Have
* Experience with Azure Function Apps.

* Experience integrating with Microsoft Power Platform.

* Experience developing Power Apps Canvas Applications.

* Experience supporting federal government systems.

* Familiarity with DOJ or GCC High environments.

* Experience with CI/CD pipelines and Azure Dev Ops.

* Experience supporting production applications through deployment and operational sustainment.

* Understanding of API-based integration patterns and secure service architectures.

* Experience supporting application modernization initiatives.

What We Offer:

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace. Benefits include:
* Medical, Rx, Dental & Vision Insurance

* Personal and Family Sick Time & Company Paid Holidays

* Parental Leave

* 401(k) Retirement Plan

* Group Term Life and Travel Assistance

* Voluntary Life and AD&D Insurance

* Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts

* Transit and Parking Commuter Benefits

* Short-Term & Long-Term Disability

* Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities

* Employee Referral Program

* Corporate Sponsored Events & Community Outreach

* annual membership

*…