Azure Synapse Infrastructure Operations DBA

  • Salary

    $120,000 - $130,000 Per Year

Experience

5 to 12 Years

Posted On

Feb 14, 2023

Company

Long Finch Technologies

Travel Requirements

0%

Job Overview

Required Skills

  • MS SQL Server
  • Azure SQL
  • Azure
  • Azure Synapse
  • Azure Active Directory
  • ETL/ELT
  • TSQL
  • KQL
  • PowerShell
  • DBA

Job Type

Full-time

Location

Illinois City, IL

Job Description

Job 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
  • 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
  • Experience with Performance Analysis, query optimization & troubleshooting
  • 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 and, KQL
  • Solid understanding of Database concepts, backups and restore
  • 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
  • Ability to follow standards
  • Understands the importance of security
  • Ability to perform operations DBA activities

Job ID: LF221482

  • Posted By

    Sarah Ferry

Designation

HR Manager

Company

Long Finch Technologies

Last Login

Apr 26, 2024

Posted On

Feb 14, 2023


Related Jobs