Azure Cloud Microsoft SQL Server Application DBA

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.