Note: The job is a remote job and is open to candidates in USA. CCC Intelligent Solutions is hiring a Lead Backend Engineer to modernize its DPS Core & Data Engine system-of-record platform. The role focuses on refactoring database and .NET systems, improving performance, and enabling a gradual transition to service-oriented architecture while maintaining production stability.
Responsibilities
- 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
- 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)
Skills
- 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)
Benefits
- 401K Match
- Paid time off
- Annual Incentive Plan Performance Bonus
- Comprehensive health insurance
- Adoption Assistance
- Tuition Reimbursement
- Wellness Programs
- Stock Purchase Plan options
- Employee Resource Groups
Company Overview
Company H1B Sponsorship