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.
