HamburgerMenu
hirist

Senior SQL Developer - Database Performance Tuning

Posted on: 11/11/2025

Job Description

Description :

Role : SQL Developer

Position : Full Time

Job Location : Hyderabad

Experience : 8 to 11 Years

General Shift : 10Am - 7PM.

Interview : 2-3 rounds (L1 Virtual & L2 in-person, followed by Manager round)

Position Summary :

We are seeking an experienced SQL Developer with 8 +years of proven expertise in designing, developing, and optimizing enterprise-level databases. The ideal candidate will have strong command over T-SQL, legacy refactoring, and modern database practices, with the ability to collaborate closely with cross-functional teams. This role will focus on ensuring high performance, scalability, and maintainability of databases that support mission-critical applications.

What you`ll do :

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

- Perform data modeling, schema design, and schema evolution to support application growth.

- Conduct performance tuning and troubleshoot bottlenecks using tools such as SQL Profiler and Extended Events.

- Collaborate with .NET/API teams to ensure seamless integration between application and database layers.

- Break down monolithic SQL codebases into modular, maintainable components during modernization initiatives.

- Implement database decoupling strategies to support microservices and bounded contexts.

- Ensure data integrity and consistency during migration and modernization projects.

- Manage schema changes, migrations, and rollbacks using tools like Flyway, Liquibase, or SSDT.

- Contribute to Agile/Scrum ceremonies including sprint planning, backlog grooming, and code reviews.

- Leverage AI tools (e.g., GitHub Copilot) to document SQL code, generate boilerplate scripts, and suggest optimizations.

What we are looking for?

- SQL Development : 8+ years of hands-on experience as a SQL Developer supporting enterprise-level applications

- T-SQL Mastery : Expert in writing complex queries, stored procedures, views, functions, and triggers using T-SQL

- Legacy Optimization : Skilled in analyzing and refactoring legacy stored procedures for performance and maintainability

- Database Design : Strong ability to translate business requirements into scalable, normalized database architectures

- Data Modeling : Proficient in relational modeling, normalization, and schema evolution

- Performance Tuning : Experienced in identifying and resolving bottlenecks using tools like SQL Profiler and Extended Events

- Collaboration : Comfortable working closely with .NET/API teams to ensure cohesive integration between app and DB layers

- Communication : Able to explain complex database concepts to both technical and non-technical audiences

- Agile Practices : Experience in Agile/Scrum teams, participating in sprint planning, backlog grooming, and code reviews

- AI-Enhanced Development : Familiar with using AI tools (e.g., GitHub Copilot) for documenting SQL code, suggesting optimizations, and generating boilerplate scripts

Additional Skills for Legacy Monolithic Applications :

- Legacy Refactoring : Experience breaking down monolithic SQL codebases into modular, maintainable components

- Database Decoupling : Skilled in isolating shared schemas and stored procedures into bounded data contexts for microservices

- Data Integrity Strategies : Knowledge of maintaining data consistency during modernization and migration

- Change Management : Experienced with schema migration tools and rollback processes to support safe transitions

- SQL in CI/CD : Familiar with versioning and automating database changes using tools like Flyway, Liquibase, or SSDT

Optional Skills :

- Experience with Azure SQL Database or Azure SQL Managed Instance

- Familiarity with DevOps scripting and automation tools

- Experience designing data access layers with Entity Framework or Dapper

Nice to Have :

- Exposure to the Azure ecosystem beyond SQL

- Understanding of event-driven/distributed systems and how they interact with relational databases

- Experience with replication, sharding, or partitioning strategies in large-scale environments


info-icon

Did you find something suspicious?