Senior Backend Engineer - DPS Core & Data Engine Squad

Overview We are seeking a Senior Backend Engineer passionate about database modernization, performance optimization, and strategic refactoring of mission‑critical systems. Join the DPS Core & Data Engine Squad to work on the system‑of‑record platform that powers internal and external claims management experiences. Salary Salary range: $106,277.25 - $147,000.00. Position is bonus and/or commission eligible. Key Responsibilities Database Engineering & Modernization (60%) Refactor complex stored procedures into smaller, testable units. Optimize SQL performance (query tuning, indexing strategy, execution plan analysis, data access patterns). Design backward‑compatible schema changes with safe rollout/rollback patterns. Create migration seams: facades, wrappers, anti‑corruption layers to enable gradual extraction of business logic into services. Legacy .NET Modernization (30%) Refactor .NET Framework code into maintainable, testable modules. Implement strangler‑fig patterns to incrementally move logic from the database service layer while maintaining production stability. Build domain‑aligned modules/services with clear contracts for extraction by the Domain & Services Squad. Establish patterns for dependency injection, observability, and error handling in legacy 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). Requirements 8+ years of professional software development experience in object‑oriented languages (C#/.NET required). Expert‑level SQL Server knowledge (2019): advanced query optimization, index tuning, execution plans, query hints. Proficiency in stored procedure, function, trigger development/refactoring. Experience in database design and normalization. Performance tuning at scale for multi‑million row tables and complex joins. Understanding of indexing strategies (clustered, non‑clustered, filtered, columnstore). SQL Agent jobs and automated workflow patterns. Transaction isolation levels, locking, and concurrency management. Solid C# and .NET Framework/.NET Core experience (legacy and modern). Experience refactoring established systems while maintaining production stability. SQL source control (migrations, schema version control). Highly desired: experience with strangler‑fig, anti‑corruption layer, façade patterns. Hands‑on experience migrating logic from stored procedures to service layer in production systems. Familiarity with domain‑driven design 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. Benefits Competitive compensation and benefits to support you and your families. 401(k) 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. EEO Statement If you require reasonable accommodation to complete a job application, please contact View phone number on click.appcast.io. #J-18808-Ljbffr CCC Information Services