SQL Developer - T-SQL

Job Description

Description Only Immediate Joiner - Within 7-10 days Hyderabad, IND (Onsite) 8+ Years Face to Face interview (Only apply if you are fine and currently at Hyderabad) Mandate: SQL with T-SQL expert 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 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 (ref:hirist.tech)