Full Stack Developer ( SQL Server / DBA focus)

Role summary: Work as full stack .NET developers in a module pod while owning database health for the programme design, performance, replication, monitoring and production troubleshooting on SQL Server.

Responsibilities

Develop .NET 8 services and React screens like the rest of the team, with a focus on dataheavy modules

Design per-service database schemas, indexes and data access patterns as services are split from the monolith

Write and tune stored procedures, queries and execution plans; fix slow queries and blocking

Detect, analyse and resolve deadlocks (deadlock graphs, Extended Events, lock/isolation strategy)

Set up and support replication, log shipping and Always On availability groups for reporting and HA

Monitor SQL Server health: waits, CPU/IO, tempdb, index fragmentation, job failures, growth; set alerts

Plan backups, restores, maintenance jobs and data migration scripts; review DB changes before release

Must have

3+ years in C#/.NET and React, with strong hands-on SQL Server (2017+) work

Advanced T-SQL, stored procedures, execution plans, indexing and statistics

Practical deadlock and blocking troubleshooting in production

Experience with replication (transactional/snapshot), log shipping or Always On

SQL Server monitoring with DMVs, Query Store, Extended Events or tools like SolarWinds/ Redgate

Backup/restore strategy, SQL Agent jobs and maintenance plans

Good to have

High-volume transactional systems (banking, remittance, payments)

Partitioning, In-Memory OLTP, columnstore indexes

Microsoft certification (DP-300 Azure Database Administrator or equivalent)

PowerShell/dbatools automation

Education: B.Tech/B.E./MCA in Computer Science or related field