Azure SQL Server Database Developer- Hyd- Onsite - F2F Interview

Novaya Software; Hyderabad; On-site; INR 2,800,000 - 4,000,000; Full time

Benefits offered by this job

Hybrid options

Mentorship

Learning budgets

Job summary

Novaya Software in Hyderabad, India, is seeking a Senior Azure SQL Server Developer to join our Azure-focused team. You will design and optimize scalable Azure SQL schemas, write complex T-SQL, and drive performance tuning across high-volume applications.

Collaborate with developers, product owners, and QA to deliver reliable data platforms on Azure cloud, with emphasis on elastic pools, managed instances, and cost-aware DTU/eDTU pricing models. Hybrid work options available.

Qualifications

• 8+ years of hands-on database experience with Azure SQL Server.
• Strong ability to develop complex T-SQL queries, procedures, functions, and triggers on Azure SQL.
• Experience with performance tuning, query optimization, and bottleneck resolution.
• Design scalable database schemas for high-transaction apps on Azure SQL.
• Experience with Azure SQL elastic pools and managed instances.

Responsibilities

• Develop and optimize T-SQL queries, stored procedures, and functions on Azure SQL.
• Troubleshoot performance issues and tune queries for high-volume workloads.
• Design scalable database schemas and indexes to support applications.
• Collaborate with developers, QA, and product teams to meet requirements.
• Package and deploy SQL changes across multiple databases in product releases.

Skills

Azure SQL Server

T-SQL

Performance tuning

Query optimization

Database design

Stored procedures

Collaboration

Azure cloud

Tools

SQL Sentry One

SQL Profiler

Dynatrace

Redgate

Job description

Novaya has been engaged in providing turnkey software solutions and services to clients in the US since 2013. We specialize in web and mobile healthcare solutions for Acute and ambulatory clinics.

Our client is a US based Health Tech solution provider and they're on a mission to transform behavioral health through cutting-edge technology. The cloud-based SaaS platform helps care providers improve outcomes, streamline operations, and deliver better care.

We're looking for a SeniorAzure SQL Server Developer to join our Hyderabad team. This role is ideal for someone who thrives in a collaborative environment, enjoys solving real-world problems, and has hands-on experience in working with Azure SQL Server on Azure Cloud.

Responsibilities

• Excellent hands-on database 8+ experience and skills in developing complex T-SQL Queries, Stored Procedures, functions, triggers, views, T-SQL scripts etc on Azure SQL.
• Excellent hands-on MS SQL Server database development experience in troubleshooting, debugging, performance tuning, and query optimization in MS SQL Server.
• Design scalable database schema for high-transaction and high-volume applications on Azure SQL.
• Collaborating with application developers to design and optimize the database schema, tables, indexes, and relationships to support application requirements and performance.
• Writing, debugging, and optimizing complex SQL queries, stored procedures, functions, and triggers to ensure efficient data retrieval and manipulation by the application.
• Experience in troubleshot application performance issues and identify SQL Server bottlenecks. Performe index fragmentation and work on server performance tuning.
• Build complex queries, views, stored procedures, functions and triggers, optimized for high performance on Azure SQL.
• Analyze, improve and resolve slow running SQL queries in collaboration with application teams.
• Strong in performance tuning and query optimization using Profiler, Execution Plans, Query Store and Wait Stats.
• Identifying and resolving database performance bottlenecks related to application queries, server configuration, and indexing strategies.
• Experience in Create and configure PaaS Databases like Azure SQL single database, elastic pools and Managed instances in Azure Cloud.
• Having very good experience good knowledge on Pricing models of DTU/eDTU vs Vcore Model.
• Experience in Azure SQL Elastic Jobs and Run Books.
• Expertise in packaging and deploying SQL changes across 100s of databases as part of product releases.
• Must have Expert level hands-on database development experience and database maintenance experience in Azure MS SQL Server.
• Hands on experience with SQL Tools: SQL Sentry One, SQL Profiler, Dynatrace, Redgate.

Required Skills

• Excellent hands-on database 8+ experience and skills in developing complex T-SQL queries Server Stored Procedures, functions, triggers, views, T-SQL scripts etc.
• Excellent hands-on MS SQL Server database development experience in troubleshooting, debugging, performance tuning, and query optimization in MS SQL Server.
• Ability to hit the ground running and start contributing to deliverables immediately.
• Ability to work independently with a minimal supervision.
• Strong problem-solving skills, analytical, and debugging skills.
• Excellent communication skills and collaboration skills.
• Work closely with developers, product owners, and QA teams to understand requirements.
• Experience working in Agile/Scrum teams.
• Created alerts, monitored activity logs, and troubleshot issues using Azure Portal and Log Analytics and SQL Insights.
• Must have Expert level hands-on database development experience and database maintenance experience in Azure MS SQL Server.
• Experience in performing Database Maintenance activities like rebuilding/reorganizing indexes update statistics.
• Identifying and resolving database performance bottlenecks related to application queries, server configuration, and indexing strategies.

What We Offer

• Opportunity to work on a meaningful product in the behavioral health space
• Competitive salary and performance-based incentives
• Flexible work culture with hybrid options
• Professional growth through mentorship, learning budgets, and collaborative culture