Description

You will manage and optimize SQL Server database administration tasks within Azure environments, focusing on query performance, pipeline support, and database design reviews.

This role is on-site.

Responsibilities

• Optimize SQL query performance by rewriting complex queries using joins, cross apply, aggregate queries, merge, and pivot.
• Manage and support Azure Data Factory pipelines, Databricks workspaces, and Azure security groups.
• Perform database design reviews to implement proper indexing, constraints, and performance enhancements.
• Troubleshoot and debug existing code, resolving deadlocks and performance bottlenecks.
• Maintain database processes through testing, bug fixes, and technical documentation.

Required Skills

• 4+ years of experience as a SQL Server Database Administrator in Azure.
• Proficiency in SQL Server and advanced SQL query tuning.
• Experience with Azure Data Factory and Databricks workspaces.
• Hands-on experience with Azure DevOps CI/CD pipelines.
• Ability to migrate Stored Procedures, Functions, and Views.
• Expertise in using table variables, temporary tables, and CTEs for large datasets.
• Strong ability to analyze and resolve query deadlocks.

Preferred Skills

• Any Graduate degree.

Key Skills

Education

Any Graduate