If you love the challenge of strategic system evolution and want to participate in evolving the technical architecture of a multi-year transformation from monolithic database logic to service-oriented architecture—this role is for you.
Key Responsibilities
Database Engineering & Modernization (60%)
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
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
Establish 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)
