Azure Synapse Optimization Specialist

We are seeking a high-level 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.