Job Details

ID #19762545
State Illinois
City Naperville
Job type Permanent
Salary USD TBD TBD
Source SmartIT Frame
Showed 2021-09-17
Date 2021-09-17
Deadline 2021-11-15
Category Et cetera
Create resume

Azure Synapse architect

Illinois, Naperville, 60540 Naperville USA

Vacancy expired!

Position: Azure Synapse architect Location: Naperville, IL (Remote till Covid) Type: Contract Job Summary :

  • Understand Azure Synapse Analytics architecture and component integrations
  • Proactively monitor Synapse workload (Dedicated SQL pool and Spark pool) and engage internal / external teams as appropriate to resolve errors / failures / throughput bottleneck
  • Execute Change Tasks including but not limited to security provisioning schema creation DB role creation DDL execution data restoration etc.
  • Assist Application developers and testers with re-engineering / deploying code from Infrastructure Support standpoint
  • Review workload and provide recommendations for performance optimization and operational efficiency - Identify troubleshoot and resolve issues / backlogs related to slow / failed / abended jobs in both Spark and Dedicated SQL pools.
  • Proactively adjust capacity based on current utilization and upcoming usage guestimate projections
  • Document and advise developers and end-users about best practices and housekeeping
  • Support ingestion pipelines from Infrastructure Engineering / Operational Support standpoint
  • Work on incidents / onboarding issues related to Pivoting to Cloud from on-prem datastores.
  • Be able to identify performance bottlenecks Monitor Azure Synapse Analytics using Dynamic Management Views
  • Build performing data with Table Distribution and Index types Partition tables using partitioning strategy
  • Creating and optimizing star schema models in a Dedicated SQL Pool - Configure and manage workload classification and resource classes
  • Ensure overall system stability reliability and manageability of Azure Synapse Analytics deployments.
Suneel Yadav Smart IT Frame - An Everify Employer 220 Davidson Ave, Suite #313, Somerset, NJ 08873 Direct: 732-992- 3147 | (Fax) 201-987-7575 suneel@smartitframe.com | www.smartitframe.com

Vacancy expired!

Subscribe Report job