Senior SQL Developer

Job Title: Senior SQL Developer

Experience:

Location:

Notice Period:

Cab Facility:

Position Summary

Senior SQL Developer

Responsibilities

• Design, develop, optimize, and maintain complex SQL queries, stored procedures, views, functions, and triggers using

  T-SQL

  .
• Analyze and refactor legacy SQL codebases to enhance performance, scalability, and long-term maintainability.
  
• Create scalable and normalized database architectures based on evolving business requirements.
  
• Lead data modeling, schema design, and schema evolution for growing applications.
  
• Conduct performance tuning and troubleshoot database bottlenecks using

  SQL Profiler

  ,

  Extended Events

  , and other diagnostic tools.
• Partner with

  .NET/API teams

  to ensure seamless integration between database and application layers.
• Break down monolithic SQL structures into modular, maintainable components as part of modernization initiatives.
  
• Implement database decoupling strategies to support microservices and bounded context architectures.
  
• Ensure data integrity, consistency, and reliability during system migrations, upgrades, and refactoring.
  
• Manage schema changes, migrations, and rollbacks using tools such as

  Flyway

  ,

  Liquibase

  , or

  SSDT

  .
• Participate actively in Agile/Scrum ceremonies including sprint planning, backlog refinement, and code reviews.
  
• Utilize

  AI tools

  (e.g., GitHub Copilot) to document SQL code, generate boilerplate scripts, and support optimization tasks.

Required Skills & Qualifications

• SQL Development:

  8+ years working as a SQL Developer in enterprise environments.

• T-SQL Expertise:

  Strong proficiency in writing complex queries, stored procedures, triggers, and functions.

• Legacy Optimization:

  Proven experience refactoring and modernizing legacy stored procedures and database code.

• Database Design:

  Ability to translate business requirements into normalized, scalable, production-ready architectures.

• Data Modeling:

  Skilled in relational modeling, normalization, and schema evolution.

• Performance Tuning:

  Experience identifying and resolving performance issues using profiling and monitoring tools.

• Collaboration:

  Ability to work closely with backend (.NET/API) teams for cohesive system integration.

• Communication:

  Strong ability to articulate database concepts to both technical and non-technical stakeholders.

• Agile/Scrum Experience:

  Hands-on experience contributing to Agile processes and team ceremonies.

• AI-Enhanced Development:

  Familiarity with GitHub Copilot or similar tools for code assistance and optimization.

Additional Skills for Legacy & Modernization Projects

• Expertise in breaking down

  monolithic SQL applications

  into modular components.
• Experience decoupling shared schemas and stored procedures into bounded contexts for microservices.
  
• Strong understanding of data integrity and consistency strategies during modernization and migration.
  
• Experience with schema migration/versioning using

  Flyway

  ,

  Liquibase

  , or

  SSDT

  .
• Familiarity with

  CI/CD pipelines

  incorporating SQL versioning and automated deployments.

Optional / Good-to-Have Skills

• Experience working with

  Azure SQL Database

  or

  Azure SQL Managed Instance

  .
• Familiarity with DevOps tools, scripting, and automation.
  
• Experience building data access layers using

  Entity Framework

  or

  Dapper

  .
• Exposure to the Microsoft Azure ecosystem beyond SQL services.
  
• Understanding of event-driven or distributed systems and their interaction with relational databases.
  
• Experience with replication, sharding, or partitioning strategies in large-scale environments.