Senior SQL Developer

Overview

Job Title: Senior SQL Developer

Experience: 8–11 Years

Location:

Hyderabad
Notice Period: Immediate Joiners Only
Cab Facility: Available
Position Summary

We are seeking an accomplished Senior SQL Developer with 8+ years of experience in designing, developing, and optimizing enterprise-grade databases. The ideal candidate will possess deep expertise in T-SQL, legacy database refactoring, modern data architecture principles, and performance tuning. This role requires close collaboration with cross-functional teams to ensure databases underpinning mission-critical applications remain efficient, scalable, and reliable.

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.