SQL Developer

Role:  SQL Developer Position: Full Time Job Location:  Hyderabad Experience: 8-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