Performance Tuning:

Job highlights

• Working Experience in PaaS Databases like Azure SQL single database,elastic pools and Managed instances in Azure Cloud
• Required Skills & Experience: Hands on experience with SQL Tools: SQL SentryOne,SQL Profiler,Dynatrace,Redgate .
• Experience using Azure Monitor,Log Analytics,and SQL Insights

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 applications 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).

• Knowledge of SQL Server licensing and cost optimization strategies in Azure.

• Exposure to Redis Cache and MongoDB.

• Familiarity with Agile/Scrum development environments.

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