Senior Backend Engineer – DPS Core & Data Engine Squad

CCC Intelligent Solutions Inc. is a leading cloud platform for the insurance economy, creating intelligent experiences for various stakeholders in the industry. They are seeking a Senior Backend Engineer who will focus on database modernization, performance optimization, and strategic refactoring of mission-critical systems within the DPS Core & Data Engine Squad.

Responsibilities:

• Analyze, optimize, and decompose complex stored procedures into smaller, testable, well-documented units
• Query tuning, indexing strategy, execution plan analysis, optimizing data access patterns
• Design backward-compatible schema changes with safe rollout/rollback patterns
• Create facades, wrappers, and anti-corruption layers around stored procedures to enable gradual extraction of business logic into services
• 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
• 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)

Requirements:

• 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)
• 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)