Job Title: Senior SQL Developer
Experience: 8+Years
Location: Hyderabad
Notice Period: Immediate Joiners Only
Cab Facility: Available
Position Summary
We are seeking an experienced SQL Developer with 8+ years of expertise in designing, developing, and optimizing enterprise-level databases. The ideal candidate will have deep knowledge of T-SQL, legacy modernization, and database optimization practices. This role involves collaborating with cross-functional teams to deliver scalable, high-performance, and maintainable data solutions supporting mission-critical business applications.
Key Responsibilities
- 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 and application requirements.
- Perform data modeling, schema design, and schema evolution to support application growth and modernization.
- Conduct performance tuning and troubleshoot bottlenecks using tools such as SQL Profiler and Extended Events.
- Collaborate with .NET/API teams for seamless integration between application and database layers.
- Break down monolithic SQL codebases into modular and maintainable components.
- Implement database decoupling strategies to support microservices and bounded contexts.
- Ensure data integrity and consistency during migration and modernization initiatives.
- Manage schema changes, migrations, and rollbacks using tools like Flyway, Liquibase, or SSDT.
- Participate actively in Agile/Scrum processes including sprint planning, backlog grooming, and code reviews.
- Use AI-assisted tools (e.g., GitHub Copilot) for documentation, boilerplate generation, and performance optimization.
Required Skills & Qualifications
- 8+ years of hands-on experience as a SQL Developer supporting enterprise applications.
- Expert-level T-SQL skills complex queries, stored procedures, functions, views, and triggers.
- Strong experience in legacy optimization and refactoring old SQL codebases.
- Solid knowledge of database design, data modeling, and schema evolution.
- Proven expertise in performance tuning and troubleshooting using SQL Profiler and Extended Events.
- Strong collaboration skills with application (.NET/API) teams.
- Excellent communication and ability to explain database concepts to diverse stakeholders.
- Familiarity with Agile/Scrum methodologies and collaborative development practices.
- Exposure to AI-assisted development tools for SQL optimization and documentation.
Additional Skills for Legacy Monolithic Applications
- Experience in breaking down monolithic SQL architectures into modular, scalable designs.
- Knowledge of database decoupling and bounded data contexts for microservices.
- Understanding of data integrity and consistency strategies during migration.
- Experience using schema migration tools (Flyway, Liquibase, SSDT) with rollback support.
- Familiarity with CI/CD integration for database versioning and automation.
Optional / Nice-to-Have Skills
- Experience with Azure SQL Database or Azure SQL Managed Instance.
- Familiarity with DevOps scripting and automation tools.
- Experience designing data access layers using Entity Framework or Dapper.
- Understanding of event-driven/distributed systems and their database interactions.
- Knowledge of replication, sharding, or partitioning strategies in large-scale environments.
