Senior Backend Engineer – DPS Core & Data Engine Squad

Key Responsibilities

• Database Engineering & Modernization (60%)
  • 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
  • Create 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)

Requirements

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