Azure SQL Server Database Developer-Performance Optimization, scalable

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

Apply now and become a part of a mission-driven team creating tech that makes a real imp…