Senior SQL Server & .NET API Developer (Azure)

Guidehouse; McLean (VA); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Medical Insurance

Rx Insurance

Dental & Vision insurance

Parental Leave

401(k) Retirement Plan

Employee Assistance Program

Job summary

Guidehouse is seeking a Senior SQL Server & .NET API Developer to enhance, maintain and deploy a mission-critical federal application hosted in Microsoft Azure. The role focuses on SQL Server-based development, secure data access, and API integrations within Azure-hosted environments.

You will work with architects, analysts and government stakeholders to deliver new functionality and support modernization efforts while ensuring robust security and performance across the platform.

Qualifications

• Proven experience with Microsoft SQL Server and database-centric architectures.
• Strong skills in designing and implementing .NET Web APIs in C#.
• Experience deploying and supporting applications in Microsoft Azure.

Responsibilities

• Design, develop and optimize SQL Server database solutions for mission-critical processes.
• Create/modify stored procedures, views, functions, triggers and other DB objects.
• Implement database security controls including Row-Level Security and secure data access patterns.
• Analyze performance, tuning and indexing strategies for SQL Server workloads.
• Develop and maintain secure .NET Web APIs for data access and services.
• Collaborate with architects and stakeholders on modernization efforts and roadmaps.

Skills

SQL Server

C#/.NET

Azure

RESTful APIs

API Integration

Education

Bachelor's degree in Computer Science / Information Systems / Engineering

Tools

Azure App Services

Azure Functions

Job description

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 DevOps.
• 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

• 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
• Care.com annual membership
• Employee Assistance Program
• Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
• Position may be eligible for a discretionary variable incentive bonus

Guidehouse is an Equal Opportunity Employer–Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation. Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at [e-mail]. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation. All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or [e-mail]. Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process. If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse’s Ethics Hotline. If you want to check the validity of correspondence you have received, please contact [e-mail]. Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant’s dealings with unauthorized third parties. Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.

Guidehouse is a global AI-led professional services firm delivering advisory, technology, and managed services to the commercial and government sectors. With an integrated business technology approach, Guidehouse drives efficiency and resilience in the healthcare, financial services, energy, infrastructure, and national security markets.

Built to help clients across industries outwit complexity, the firm brings together approximately 18,000 professionals to achieve lasting impact and shape a meaningful future. guidehouse.com