Senior .NET Developer – SQL Server Specialist

Fyin Llc; Denver, Northern (CO, KY); Hybrid; USD 95,000 - 135,000; Full time

Benefits offered by this job

401(k)

401(k) matching

Health insurance

Health savings account

Life insurance

Paid time off

Vision insurance

Ski condo in Winter Park

Job summary

Fyin Llc in Denver, CO is seeking a Senior .NET Developer with deep Microsoft SQL Server expertise to join our engineering team and anchor the data layer.

You will design schemas, tune queries, develop advanced T-SQL, and contribute to full-stack .NET development while upholding security and compliance for financial-grade solutions. This is an in-person role with a strong emphasis on collaboration and mentorship.

Qualifications

• 5+ years of professional experience with Microsoft SQL Server (2016 and later).
• Expert-level T-SQL proficiency: complex stored procedures and advanced windowing functions.
• Strong .NET development background (C#, ASP.NET Core, Web API, EF/EF Core).
• Experience with SQL Server performance tuning and query optimization.
• Familiarity with SecDevOps and data security principles for SQL Server.

Responsibilities

• Architect, develop, and maintain complex MS SQL Server databases (schemas, procedures, views).
• Perform advanced SQL performance tuning and index optimization.
• Write sophisticated T-SQL including window functions, dynamic SQL, and CTEs.
• Design and optimize ETL processes for client integrations.
• Contribute to full-stack .NET development beyond the data layer.
• Implement AI-assisted data techniques: embeddings, vector search, LLM integration.
• Ensure data layer compliance, audit logging, encryption at rest/in transit.
• Mentor junior developers and participate in architecture decisions.

Skills

Microsoft SQL Server

T-SQL

C#

ASP.NET Core

Entity Framework / EF Core

Unit Tests

SecDevOps

Communication skills

Education

Bachelor's degree in Computer Science or related

Tools

Azure SQL Database

Azure DevOps

SSIS

Power BI

SSRS

Job description

Senior .NET Developer - SQL Server Specialist

Senior .NET Developer - SQL Server Specialist

This is an in-person position in Denver, CO. Please only apply if you are in/near Denver and can commute to our office.

Team INM is a Denver-based digital agency with an established track record and genuine startup energy. We build sophisticated, compliance-aware software solutions for clients across a wide variety of industries and markets. We value teamwork, accountability, a roll-up-your-sleeves-and-pitch in spirit, and believe in honoring the individual talents and skills of our team members.

Job Overview

We are seeking an experienced Senior .NET Developer with deep Microsoft SQL Server expertise to join our engineering team. You'll serve as a technical anchor for our data layer - designing schemas, tuning queries, and building advanced T-SQL logic that financial-grade solutions demand. But you're more than a database specialist: you'll actively contribute to full-stack .NET development, support team operations, bring AI-driven approaches into your work, and help hold a high bar for the whole team.

Responsibilities

• Architect, develop, and maintain complex MS SQL Server databases - including schemas, stored procedures, functions, triggers, and views.
• Perform advanced SQL performance tuning: query plan analysis, index optimization, statistics management, and blocking/deadlock resolution.
• Write sophisticated T-SQL including window functions, CTEs, dynamic SQL, cursors, and advanced set-based logic.
• Design and optimize ETL processes and data transformation pipelines for client integrations.
• Contribute meaningfully to full-stack .NET development (C#, ASP.NET Core, Web API, Entity Framework) beyond the data layer.
• Implement AI-assisted data techniques: embeddings, vector search, LLM-augmented query and reporting pipelines (Azure OpenAI, SQL integration).
• Ensure all data layer work meets compliance requirements relevant to financial services clients - including data integrity controls, audit logging, and encryption at rest/in transit.
• Apply SecDevOps principles to database development: parameterized queries, least-privilege access, SQL injection mitigation, and vulnerability hygiene.
• Participate in architecture decisions, code reviews, and mentoring of junior developers.
• Provide operational support across development and production environments - including outside your specialty - when the team needs it.
• To understand requirements and deliver value.

Required Qualifications

• 5+ years of professional experience with Microsoft SQL Server (2016 and later).
• Expert-level T-SQL proficiency: complex stored procedures, advanced windowing functions, CTEs, dynamic SQL, performance-critical queries.
• Deep experience with SQL Server performance tuning: execution plans, index strategies, wait statistics, and query store.
• Strong .NET development background (C#, ASP.NET Core, Web API, Entity Framework / EF Core, Unit Tests).
• Solid understanding of database design principles, normalization, and enterprise data modeling.
• Experience with SQL Server HA/DR concepts: Always On, replication, backup/restore strategies.
• Familiarity with SecDevOps and data security principles applied to SQL Server environments.
• Strong communication skills and a genuine willingness to be helpful beyond your primary specialty.

Preferred Skills:

• Experience implementing AI-augmented data solutions: vector databases, embeddings pipelines, LLM integration with structured data.
• Exposure to compliance frameworks relevant to fintech: SOC 2, PCI-DSS data controls, NIST CSF.
• Experience with Azure SQL Database and Azure Synapse Analytics.
• Familiarity with Azure DevOps pipelines for database change management (e.g., Flyway, DbUp, SSDT).
• Experience with SQL Server Integration Services (SSIS) or Azure Data Factory.
• Microsoft SQL Server certification (70-762, DP-300, or equivalent) is a plus.
• Microsoft SQL Server Reporting Services (SSRS) and Power BI is a plus.

Compensation:

Compensation varies based on demonstrated experience and specialization depth. Top-of-range compensation is available for candidates with exceptional T-SQL depth, AI integration experience, compliance expertise, and a track record of meaningful .NET contributions beyond the data layer.

Team members are eligible for the listed benefits as well as access to a ski condo in Winter Park.

• 401(k)
• 401(k) matching
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Vision insurance

Salary: $95,000 to $135,000; overall compensation may vary.