Lead Backend Engineer (SQL Server/.NET)

Location: Hybrid in Chicago (Green St), IL, United States

Salary: $119,030.52–$165,000.00 per year; bonus and/or commission eligible

Company

hirify.global provides a cloud platform for the insurance economy, supporting insurers, repairers, automakers, part suppliers, and claims and repair workflows with AI-enabled technology.

What you will do

• Analyze, optimize, decompose, and document complex SQL Server stored procedures, including query tuning, indexing, execution-plan analysis, and data-access optimization.
• Design backward-compatible schema changes, safe rollout and rollback patterns, facades, wrappers, and anti-corruption layers for gradual business-logic extraction.
• Refactor legacy .NET Framework code into maintainable, testable, domain-aligned modules and services with clear contracts.
• Establish dependency injection, observability, error-handling, performance baselines, regression detection, alerting, diagnostic tooling, and runbooks.
• Participate in data and performance incident response and collaborate with SRE/DevOps on blue/green deployments, feature flags, and canary releases for schema changes.

Requirements

• 8+ years of professional software development experience in object-oriented languages, with C#/.NET required.
• Expert-level SQL Server 2019 knowledge, including advanced query optimization, execution plans, index tuning, query hints, stored procedures, functions, triggers, database design, and normalization.
• Experience with performance tuning at scale across multi-million-row tables, complex joins, aggregations, clustered, non-clustered, filtered, and columnstore indexes.
• Knowledge of SQL Agent jobs, automated workflow patterns, transaction isolation levels, locking, concurrency management, and SQL source control for migrations and schema or stored-procedure versioning.
• Experience with C# and .NET Framework/.NET Core and with refactoring established systems while maintaining production stability.

Nice to have

• Practical experience with strangler fig, anti-corruption layer, and facade patterns, including migrating production logic from stored procedures to a service layer.
• Familiarity with domain-driven design concepts such as bounded contexts, aggregates, and repositories.
• Experience with Azure SQL Database and Azure DevOps.
• Experience with Application Insights, SQL Profiler, REST and OpenAPI/Swagger API design and versioning.
• Experience with xUnit, NUnit, test data builder patterns, and PowerShell database scripting or automation.
• Experience with microservices, event-driven patterns, Entity Framework Core, Dapper, or other ORMs, including choosing native SQL when appropriate.

Culture & Benefits

• Values include integrity, customer focus, innovation, inclusion and diversity, tenacity, and connection.
• Benefits include a 401(k) match, paid time off, annual incentive plan performance bonus, comprehensive health insurance, adoption assistance, tuition reimbursement, wellness programs, and stock purchase plan options.
• Employee Resource Groups and an inclusive environment where diverse perspectives and employee contributions are valued.

Hiring process

• A video interview is required and interviews are transcribed and retained for review by CCC and its recruiters.
• Generative AI or automated assistance is not permitted during interviews unless explicitly allowed for a specific exercise.