Job Description

:

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 DBA

by 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.

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 SentryOne, 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).

Nice to Have

Knowledge of SQL Server licensing and cost optimization strategies in Azure. Exposure to Redis Cache and MongoDB. Familiarity with Agile/Scrum development environments.

Education:

B.Tech/B.E - Computers, MCA - Computers, MS/M.Sc(Computers)

Experience:

5 - 7 years

Salary:

10-15 Lacs P.A.

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

We look forward to reviewing your profile.



If you're excited about startups and want to be part of a rapidly growing company, send your resume with CTC, Notice period and expected CTC to jobs@novayasoft.com