Senior SQL Developer

Job Description Job Title: Senior SQL Developer Experience: 811 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.