Azure Synapse Optimization SpecialistSesheng, LLC • New York, New York, United States
Cette offre d'emploi n'est plus disponible
Azure Synapse Optimization Specialist
Sesheng, LLC
- New York, New York, United States
- New York, New York, United States
À propos
Azure Synapse Optimization Specialist
for an urgent, high-impact contract. This role is designed for a self-starting consultant capable of leading a client through complex technical hurdles. Your primary mission is to audit, tune, and stabilize an existing
Azure Synapse
environment, specifically focusing on large-scale data ingestion and
CDC-based replication . You will act as the technical authority to ensure performance, cost-efficiency, and operational stability. As a subject matter expert, you will diagnose performance bottlenecks and implement architectural refinements within Azure Synapse Dedicated SQL Pools. You will bridge the gap between high-volume data ingestion (specifically
Oracle-to-Synapse CDC ) and seamless BI reporting. Key Responsibilities
Infrastructure Tuning:
Evaluate DWU sizing, workload management, and pause/resume automation to balance performance with cost Architecture Optimization:
Refine table designs using advanced distribution strategies (Hash, Round Robin, Replicated) and partitioning for large-scale fact tables. Performance Engineering:
Identify and resolve data movement issues, skew, and tempdb pressure; optimize complex joins and aggregations to reduce shuffles. Capacity Planning:
Develop scaling strategies tailored for initial loads, ongoing CDC pipelines, and concurrent BI workloads. Governance & Documentation:
Create actionable runbooks and cost-control frameworks to ensure long-term operational health. Required Experience & Skills
Expertise:
5+ years in large-scale data warehousing; 3+ years of deep, hands-on experience with
Azure Synapse (Dedicated SQL Pools) . MPP Mastery:
Advanced understanding of Massively Parallel Processing (MPP) concepts, including data movement and parallel execution. Pipeline Optimization:
Proven track record of tuning high-volume data ingestion and Change Data Capture (CDC) pipelines. Azure Ecosystem:
Proficiency in Azure Data Factory (ADF), Azure Storage, and Azure Monitor. Consultative Leadership:
Ability to operate independently and lead stakeholders through technical transformations. Preferred Qualifications
Experience with
Oracle GoldenGate
or similar CDC tools. Understanding of Power BI concurrency and its impact on Synapse performance. Background in regulated or high-availability environments. Type: Contract. Location: Remote (US-Based). Start Date: Immediate. We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.
#J-18808-Ljbffr
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre a été publiée par l’un de nos partenaires. Vous pouvez consulter l’offre originale ici.