Vacancy expired!
Job Title : Azure Synapse application support 2. 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. 3. Shift : regular 4. Roles & Responsibilities : same as JD 5. Demand requires Travel? : No 6. Certification(s) Required : Good to have Azure certification Hours : 8:00am to 5:00pm Education : Additional Job Details : Must Have Skills Azure Synapse Analytics Portals and Systems Good To Have Skills Spark
Vacancy expired!