Sesheng Company · 23 hours ago
Azure Synapse Optimization Specialist
United States
Contract
Remote
Senior Level
5+ years expSesheng Company is seeking a high-level Azure Synapse Optimization Specialist for an urgent, high-impact contract. The primary mission of this role is to audit, tune, and stabilize an existing Azure Synapse environment, focusing on large-scale data ingestion and CDC-based replication, while acting as the technical authority to ensure performance and operational stability.
Management Consulting
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
Qualification
Required
5+ years in large-scale data warehousing
3+ years of deep, hands-on experience with Azure Synapse (Dedicated SQL Pools)
Advanced understanding of Massively Parallel Processing (MPP) concepts, including data movement and parallel execution
Proven track record of tuning high-volume data ingestion and Change Data Capture (CDC) pipelines
Proficiency in Azure Data Factory (ADF), Azure Storage, and Azure Monitor
Ability to operate independently and lead stakeholders through technical transformations
Preferred
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
Company
Sesheng Company
Driven by a team of leading experts with a combined experience exceeding 200 person-years, Sesheng Company specializes in IT, Healthcare, Business, and Digital Transformation Consulting.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase