Database Developer

Role Overview<\/b>
<\/p>

We are looking for a Database Developer who is an expert in\nT\-SQL and database architecture. You will be responsible for the full\ndevelopment lifecycle of our data layer\u2014from designing optimized table\nstructures to debugging complex business logic within stored procedures. You\nshould be comfortable working in high\-concurrency environments where\nperformance and data integrity are paramount.
<\/p>

Key Responsibilities<\/b>
<\/p>

• Schema\n Design:<\/b> Design and implement relational database schemas with a\n focus on normalization, data integrity, and future scalability.
  <\/li>
• Complex\n Programmability:<\/b> Write and maintain sophisticated Stored\n Procedures<\/b>, User\-Defined Functions (UDFs)<\/b>, and Triggers<\/b> to\n handle complex business rules.
  <\/li>
• Advanced\n Debugging:<\/b> Identify and resolve logic errors and performance\n bottlenecks in existing legacy code using SQL Profiler and Execution\n Plans.
  <\/li>
• Optimization:<\/b> Implement\n advanced indexing strategies and partitioning to ensure rapid data\n retrieval as datasets grow.
  <\/li>
• Integrity\n & Constraints:<\/b> Ensure robust data validation through the\n strategic use of constraints and error\-handling patterns (TRY/CATCH).
  <\/li><\/ul>

  Technical Skills Required<\/b>
  <\/p>

  <\/b>
  <\/p>

  Skill\nArea \n: <\/b>Requirements
  <\/p>

  T\-SQL\nMastery \n: <\/b>Advanced JOINs, CTEs, Window Functions, and Dynamic SQL.
  <\/p>

  Logic &\nAutomation : <\/b>Expertise in DML\nTriggers (instead of/after) and multi\-step Stored Procedures.
  <\/p>

  Performance \n: <\/b>Deep understanding of Execution Plans, and avoiding cursors.
  <\/p>

  Debugging \n: <\/b>Proficiency in using SSMS debugging tools and DMV\-based\ntroubleshooting.
  <\/p>

  Modeling \n: <\/b>Experience with ER diagrams, primary/foreign key relationships, and\ndata types.
  <\/p>

  <\/b>
  <\/p>

  Preferred Experience<\/b>
  <\/p>

  • Experience\n working with backend frameworks like Django<\/b> or .NET<\/b> (understanding\n how the application interacts with the DB).
    <\/li>
  • Experience\n in environments with frequent "blocking" issues and knowledge of\n how to minimize lock escalation.
    <\/li><\/ul>

    
    <\/p>

    Educational Background<\/b>
    <\/p>

    • Degree:<\/b> Bachelor\u2019s\n degree in Computer Science, Information Technology, Software Engineering,\n or a related field.
      <\/li><\/ul>

      
      <\/p>

      
      <\/div><\/span>