Senior SQL Developer

Job Title:

Experience:

Location:

Notice Period:

Cab Facility:

Position Summary

experienced SQL Developer

Key Responsibilities

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

  T-SQL

  .
• Analyze and refactor

  legacy stored procedures

  to improve performance, maintainability, and scalability.
• Design

  normalized and scalable database architectures

  aligned with business and application requirements.
• Perform

  data modeling, schema design, and schema evolution

  to support application growth and modernization.
• Conduct

  performance tuning

  and troubleshoot bottlenecks using tools such as

  SQL Profiler

  and

  Extended Events

  .
• Collaborate with

  .NET/API teams

  for seamless integration between application and database layers.
• Break down

  monolithic SQL codebases

  into modular and maintainable components.
• Implement

  database decoupling strategies

  to support microservices and bounded contexts.
• Ensure

  data integrity and consistency

  during migration and modernization initiatives.
• Manage

  schema changes, migrations, and rollbacks

  using tools like

  Flyway

  ,

  Liquibase

  , or

  SSDT

  .
• Participate actively in

  Agile/Scrum

  processes including sprint planning, backlog grooming, and code reviews.
• Use

  AI-assisted tools (e.g., GitHub Copilot)

  for documentation, boilerplate generation, and performance optimization.

Required Skills & Qualifications

• 8+ years

  of hands-on experience as a

  SQL Developer

  supporting enterprise applications.

• Expert-level T-SQL skills

  – complex queries, stored procedures, functions, views, and triggers.
• Strong experience in

  legacy optimization

  and refactoring old SQL codebases.
• Solid knowledge of

  database design

  ,

  data modeling

  , and

  schema evolution

  .
• Proven expertise in

  performance tuning

  and troubleshooting using SQL Profiler and Extended Events.
• Strong collaboration skills with

  application (.NET/API)

  teams.
• Excellent communication and ability to explain database concepts to diverse stakeholders.
  
• Familiarity with

  Agile/Scrum methodologies

  and collaborative development practices.
• Exposure to

  AI-assisted development tools

  for SQL optimization and documentation.

Additional Skills for Legacy Monolithic Applications

• Experience in

  breaking down monolithic SQL architectures

  into modular, scalable designs.
• Knowledge of

  database decoupling

  and

  bounded data contexts

  for microservices.
• Understanding of

  data integrity and consistency strategies

  during migration.
• Experience using

  schema migration tools

  (Flyway, Liquibase, SSDT) with rollback support.
• Familiarity with

  CI/CD integration

  for database versioning and automation.

Optional / Nice-to-Have Skills

• Experience with

  Azure SQL Database

  or

  Azure SQL Managed Instance

  .
• Familiarity with

  DevOps scripting

  and

  automation tools

  .
• Experience designing

  data access layers

  using

  Entity Framework

  or

  Dapper

  .
• Understanding of

  event-driven/distributed systems

  and their database interactions.
• Knowledge of

  replication, sharding, or partitioning

  strategies in large-scale environments.