Full Stack Developer ( SQL Server / DBA focus)

Codepoint Remittance Solutions; Ernakulam; On-site; INR 1,500,000 - 2,200,000; Full time

Job summary

Codepoint Remittance Solutions in India is seeking full stack .NET developers to own database health and service design for data-heavy modules. You will build .NET 8 services and React screens, while shaping per-service database schemas and performance tuning.

Responsibilities include writing optimized SQL, monitoring health metrics, and implementing replication/Always On for high availability. Strong T-SQL and production debugging are essential, along with experience in maintenance plans and

Qualifications

• 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

Responsibilities

• Develop .NET 8 services and React screens with a focus on data-heavy 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

Skills

C#/.NET

React

SQL Server

T-SQL

Deadlock debugging

Replication/Always On

Query Store/DMVs

Maintenance plans

Education

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

Job description

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