> Markdown version of [/jobs/ext/2599372-senior-backend-engineer-dps-core-data-engine-squad](https://www.wearedevelopers.com/jobs/ext/2599372-senior-backend-engineer-dps-core-data-engine-squad). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Backend Engineer - DPS Core & Data Engine Squad - **Company:** CCC Intelligent Solutions - **Location:** Chicago, IL, United States - **Experience:** Expert - **Salary:** $106,277.0 - $165,000.0 - **Contract:** Permanent contract - **Skills:** .NET Framework, Business Logic, Application Performance Management, Unit Testing, Microsoft Azure, C Sharp (Programming Language), Databases, Information Engineering, Data Security, Database Design, Dependency Injection, DevOps, Entity Framework, Microsoft SQL Server, SQL Azure, Nunit, Object-Oriented Software Development, Performance Tuning, Windows PowerShell, Query Optimization, Sqlprofiler, Swagger, Service-Oriented Architecture, Service Layer, Software Engineering, SQL Stored Procedures, SQL Databases, SQL Server Agent, Test Data, Management of Software Versions, Openapi, Grafana, Database Optimization, Backend, Xunit, Api Design, Domain Driven Design, Code Restructuring, Software Version Control, Microservices - **Published:** August 3, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=dd1098bf3fc43819 ## About the Role * 8+ years of professional software development experience in object-oriented languages (C#/.NET required) * Expert-level SQL Server knowledge (SQL Server 2019): * Advanced query optimization (execution plans, index tuning, query hints) * Stored procedure, function, and trigger development/refactoring * Database design and normalization * Performance tuning at scale (multi-million row tables, complex joins, aggregations) * Understanding of indexing strategies (clustered, non-clustered, filtered, columnstore) * SQL Agent jobs and automated workflow patterns * Transaction isolation levels, locking, and concurrency management * C# and .NET Framework/.NET Core (legacy and modern) * Experience refactoring established systems while maintaining production stability * SQL source control (migrations, version control for schema/stored procedures) Highly Desired: * Experience with strangler fig, anti-corruption layer, and facade patterns in practice * Hands-on experience migrating logic from stored procedures service layer in production systems * Familiarity with domain-driven design (DDD) concepts (bounded contexts, aggregates, repositories) * Azure SQL Database, Azure DevOps experience * Observability tools (Application Insights, SQL Profiler) * API design and versioning (REST, OpenAPI/Swagger) * Unit testing frameworks (xUnit, NUnit) and test data builder patterns * PowerShell for database scripting/automation * Experience with microservices architecture and event-driven patterns * Familiarity with Entity Framework Core, Dapper, or other ORMs (and knowing when to use native SQL) ## Description We are seeking a Senior Backend Engineer who is passionate about database modernization, performance optimization, and strategic refactoring of mission-critical systems. You will be a key member of the DPS Core & Data Engine Squad, working on the system-of-record platform that powers both internal (DPS) and external (IES) claims management experiences supporting millions of transactions and billions of dollars in claims. This is a modernization engineering role for someone who gets excited about: * Refactoring complex stored procedures and carving out domain logic into maintainable services * Optimizing SQL performance and improving system efficiency * Creating safe migration patterns that enable continuous modernization while maintaining business continuity * Working in .NET codebases and evolving them into clean, testable, domain-aligned modules If you love the challenge of strategic system evolution and want to participate in evolving the technical architecture of a multi-year transformation from monolithic database logic to service-oriented architecture-this role is for you., Database Engineering & Modernization (60%) Stored procedure refactoring: Analyze, optimize, and decompose complex stored procedures into smaller, testable, well-documented units * Performance engineering: Query tuning, indexing strategy, execution plan analysis, optimizing data access patterns * Schema evolution: Design backward-compatible schema changes with safe rollout/rollback patterns * Migration seams: Create facades, wrappers, and anti-corruption layers around stored procedures to enable gradual extraction of business logic into services Legacy .NET Modernization (30%) * Refactor .NET Framework code supporting DPS workflows into maintainable, testable modules * Implement strangler fig patterns to incrementally move logic from database service layer while maintaining production stability * Build domain-aligned modules/services with clear contracts that enable the Domain & Services Squad to extract capabilities * Establish patterns for dependency injection, observability, and error handling in established .NET codebases Operational Excellence (10%) * Implement performance baselines, regression detection, and alerting for data-intensive workflows * Participate in incident response for data/performance-related production issues * Create diagnostic tooling and runbooks to reduce time-to-resolution * Collaborate with SRE/DevOps on deployment safety (blue/green, feature flags, canary releases for schema changes) ## Related Videos - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) - [pytest: Simple, rapid and fun testing with Python](https://www.wearedevelopers.com/videos/213-pytest-simple-rapid-and-fun-testing-with-python) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [Migrating half a million users to a new payment service provider](https://www.wearedevelopers.com/videos/730-migrating-half-a-million-users-to-a-new-payment-service-provider) - [Using code generation for test automation – the fancy way](https://www.wearedevelopers.com/videos/230-using-code-generation-for-test-automation-the-fancy-way) - [DevOps Maturity Check – a way to balance autonomy and alignment](https://www.wearedevelopers.com/videos/58-devops-maturity-check-a-way-to-balance-autonomy-and-alignment) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Backend Developer Salary in Germany [2023]](https://www.wearedevelopers.com/magazine/196-backend-developer-salary-in-germany-2023) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [The 7 Most Popular Backend Frameworks for Developers](https://www.wearedevelopers.com/magazine/403-the-7-most-popular-backend-frameworks-for-developers) - [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline)