Azure Cloud Microsoft SQL Server Application DBA(differs To core DBA)

****We are looking for Azure Cloud MS SQL Server Application DBA***

*** This role DIFFERS from a general SQL Server DBA(Core DBA) ***

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.

MS SQL Server on Azure

A SQL Server Application DBA is a specialized database administrator focused on the database aspects of enterprise business applications that utilize Microsoft SQL Server.This role differs from a general SQL Server DBAby its deep involvement in the entire application lifecycle, from design and development to deployment, maintenance, and enhancement, with a specific emphasis on how the application interacts with the SQL Server database

Preferred candidate profile

Key Role & Responsibilities of a SQL Server Application DBA include:

• Logical Database Design:

  Collaborating with application developers to design and optimize the database schema, tables, indexes, and relationships to support application requirements and performance.

• SQL Development and Optimization:

  Writing, debugging, and optimizing complex SQL queries, stored procedures, functions, and triggers to ensure efficient data retrieval and manipulation by the application.

• Performance Tuning:

  Identifying and resolving database performance bottlenecks related to application queries, server configuration, and indexing strategies.

• Database Administration for Applications:

  Managing database security, backups, recovery, and high availability solutions specifically tailored to the needs of the applications they support.

• Collaboration with Development Teams:

  Working closely with application developers to integrate database requests into application code, ensuring data integrity and optimal performance.

• Deployment and Support:

  Assisting with the deployment of database changes and providing ongoing support for application-related database issues.

• Reporting and Analytics:

  Designing and implementing solutions for reporting and analytics based on the application's data.

• Understanding Application Requirements:

  Possessing a strong understanding of the business logic and data flow within the applications to make informed database decisions.

• Required Skills & Experience:

• Hands on experience with SQL Tools: SQL Sentry One, SQL Profiler, Dynatrace, Redgate.
• Expertise in packaging and deploying SQL changes across 100s of databases as part of product releases.
• Experience in Elastic Jobs and Run Books.
• Must have Expert level hands-on database development experience and skills and database maintenance experience in Azure MS SQL Server.
• Excellent in indexing, finding and resolving potential for database deadlocks.
• Proficiency with SQL Server security models, backups, restores, and HA/DR strategies.
• Experience using Azure Monitor, Log Analytics, and SQL Insights.
• Working Experience in PaaS Databases like Azure SQL single database, elastic pools and Managed instances in Azure Cloud.
• Having very good experience and good knowledge on Pricing models of DTU (Database Transaction Unit)/vCore/Serverless/Elastic Pools.
• Experience in Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.
• Monitored Azure SQL performance using Azure Monitor and Log Analytics; developed custom dashboards and real-time diagnostics with Kusto Query Language (KQL).

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