Database Developer

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 Dynamic 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.