Lead Backend Engineer - DPS Core & Data Engine Squad
Overview:
In this Senior Backend Engineer role, you will advance database modernization, performance optimization, and strategic refactoring of mission-critical systems. You'll join the DPS Core & Data Engine Squad, shaping the system-of-record platform that powers internal and external claims experiences at scale. You'll tackle complex stored procedures, performance tuning, and safe migration patterns while evolving .NET codebases toward clean, domain-aligned modules. This multi-year transformation emphasizes modernization with production stability and measurable impact on claims processing. You'll work with cross-functional teams to deliver scalable, service-oriented architecture. Compensation / Benefits 401K MatchPaid time off Annual Incentive Plan Performance Bonus Comprehensive health insurance Adoption Assistance Tuition Reimbursement","Wellness Programs","Stock Purchase Plan options","Employee Resource Groups
Responsibilities:
- Stored procedure refactoring to smaller, testable units
- Performance engineering: query tuning, indexing, execution plan analysis
- Schema evolution with backward-compatible changes and safe rollouts
- Migration seams: build facades/anti-corruption layers to gradually extract business logic
- Refactor .NET Framework code into maintainable modules with domain-aligned structure
- Implement strangler fig patterns for incremental migration while preserving production stability
- Establish patterns for dependency injection, observability, and error handling in .NETImplement performance baselines, regression detection, and alerting for data-intensive workflows
- Participate in incident response and collaborate with SRE/DevOps on safe deployments (blue/green, feature flags, canary)
- Create diagnostic tooling and runbooks to reduce mean time to resolution
Key requirements:
- 8+ years of professional software development in object-oriented languages (C#/.NET)
- Expert-level SQL Server knowledge (SQL Server 2019)
- Advanced query optimization and index tuning
- Stored procedure, function, and trigger development/refactoring
- Database design and normalization
- Performance tuning at scale with large datasets
- Indexing strategies (clustered, non-clustered, etc.)SQL Agent jobs and automated workflow patterns
- Transaction isolation, locking, and concurrency managementC# and .NET Framework/.NET Core (legacy and modern)
- Experience refactoring established systems while maintaining production stabilitySQL source control (migrations, schema/stored procedures)
- Experience with strangler fig, anti-corruption layer, and facade patterns (preferred)DDD concepts familiarity (bounded contexts, aggregates)
- 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 builders
- PowerShell for database scripting/automation
- Experience with microservices and event-driven patternsORM familiarity (EF Core, Dapper) or native SQL knowledgecollaborationproblem-solvingownershipSQL Server 2019 Stored procedures
- Query optimization