Senior SQL Server & .NET API Developer (Azure)

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

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 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 About Guidehouse 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 RecruitingAccommodation@guidehouse.com .
• 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 guidehouse@myworkday.com .
• 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 recruiting@guidehouse.com .
• 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.