IT - Technology Architect | Database | SQL Tuning

Job Title .Net Full stack Senior Developers. Work Location & Reporting Address New York, NY 10003Vendor Rate $71.30/hr.Contract duration 6Target Start Date 01 Sep 2026Job Details:.NET Backend (8+ years)* - ASP.NET Core Web API on IIS; Entity Framework Core (advanced: migrations, temporal tables, schema isolation) - Domain-Driven Design in practice: aggregates, domain events, anti-corruption layers - API design (RESTful, contract-first, versioned, paginated) including API Gateway / BFF patterns - CQRS (MediatR), durable background jobs (Hangfire), real-time push (SignalR) * Angular Frontend (5+ years)* - Component architecture, lazy-loaded modules, reactive forms, RxJS - State management with NgRx; real-time UI via SignalR/WebSocket - Strong UX sensibility. Able to collaborate with operator SMEs and achieve mental-model parity with legacy screens * SQL Server (5+ years)* - Scalable schema design: high-volume tables, partitioning for growth, archival strategies, read/write separation - Core design craft: normalization (3NF+), schema-per-service, indexing strategies (clustered, filtered, covering), constraints, temporal tables - Performance optimization: Query Store, execution plan analysis, wait statistics, index tuning Minimum years of experience>10 yearsCertifications Needed :NoTop 3 responsibilities you would expect the Subcon to shoulder and executeOwn endtoend production health of applications supporting Operations.Lead major incident bridges, restoration coordination, and postincident reviews with ConEd leadership.Ensure strict adherence to SLAs, Regulatory expectations, and internal governance standards.Interview Process (Is face to face required?) Yes