Role Overview

We are looking for a Database Developer who is an expert in
T -SQL and database architecture. You will be responsible for the full
development lifecycle of our data layer—from designing optimized table
structures to debugging complex business logic within stored procedures. You
should be comfortable working in high -concurrency environments where
performance and data integrity are paramount.

Key Responsibilities

- Schema
Design: Design and implement relational database schemas with a
focus on normalization, data integrity, and future scalability.

- Complex
Programmability: Write and maintain sophisticated Stored
Procedures, User -Defined Functions (UDFs), and Triggers to
handle complex business rules.

- Advanced
Debugging: Identify and resolve logic errors and performance
bottlenecks in existing legacy code using SQL Profiler and Execution
Plans.

- Optimization: Implement
advanced indexing strategies and partitioning to ensure rapid data
retrieval as datasets grow.

- Integrity
& Constraints: Ensure robust data validation through the
strategic use of constraints and error -handling patterns (TRY/CATCH).






Technical Skills Required

Skill
Area
: Requirements

T -SQL
Mastery
: Advanced JOINs, CTEs, Window Functions, and Agile SQL.

Logic &
Automation : Expertise in DML
Triggers (instead of/after) and multi -step Stored Procedures.

Performance
: Deep understanding of Execution Plans, and avoiding cursors.

Debugging
: Proficiency in using SSMS debugging tools and DMV -based
troubleshooting.

Modeling
: Experience with ER diagrams, primary/foreign key relationships, and
data types.

Preferred Experience

- Experience
working with backend frameworks like Django or .NET (understanding
how the application interacts with the DB).

- Experience
in environments with frequent "blocking" issues and knowledge of
how to minimize lock escalation.

Educational Background

- Degree: Bachelor’s
degree in Computer Science, Information Technology, Software Engineering,
or a related field.