Azure Synapse (SQL+Azure)

Description

5 + years MS SQL Server database administration experience.

Prior experience of configuring large-scale deployment of SQL Server in Azure, Managed Instance/Azure SQL, in a 24X7 production support, development or test environments.

Experience with the provisioning/administration/operations of Azure Synapse Analytics/Dedicated SQL Pools.

Experience with Performance Analysis, query optimization & troubleshooting.

Identify, troubleshoot, and resolve performance issues including expensive SQL queries, blocking/deadlocking, excessive waits, etc.

Experience using monitoring software.

Experience working with users to resolve issues.

Understanding network interactions, including on premise to Cloud.

Understanding and experience working with ETL/ELT and data migration tools.

Experience with the Azure portal, Azure PowerShell.

Experience Supporting Azure Or Other Cloud-based Solutions.

Experience in PowerShell, TSQL Solid understanding of Database concepts, backups and restore.

Understanding of relational and dimensional data modeling Unix shell scripting skills.

Excellent written and verbal communication skills

Understanding and experience working with Active Directory/Azure Active Directory.

Previously experienced in a mid- to large-size firm and supporting multiple versions SQL Server environments.

Database security management, e.g. Design & implement Security framework, incl. database roles.

Experience creating Synapse resources, including schema creation.

Synapse Dedicated SQL Pool Workload Management.

Advanced performance monitoring and troubleshooting experience.

Strong problem solving and troubleshooting skills, an ability to use various data collection tools and methodologies to analyze problems, determine root cause and develop solutions.

Advanced performance monitoring and troubleshooting experience.