Azure Synapse Application Support

Description

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