Role overview

Senior Data Engineer

Requirements and responsibilities

Readable role content extracted into sections for faster review.

Scope & Positioning

  • Role type: Technical architect + trusted advisor
  • Primary focus: SQL Server (on‑prem, Azure, hybrid), HA/DR, security, performance, design reviews
  • Customer engagement level: Design authority, escalation engineer, workshop/delivery lead
  • Typical audience: Senior DBAs, Infra Architects, CISOs, Platform Owners

Demonstrated mastery of:

  • SQL Server 2017–2025 (Windows & Linux)
  • Engine internals:Storage engine, buffer pool, log architectureTempDB internals & contention patternsQuery Optimiser behaviour (statistics, cardinality estimation)
  • Storage engine, buffer pool, log architecture
  • TempDB internals & contention patterns
  • Query Optimiser behaviour (statistics, cardinality estimation)
  • Advanced T‑SQL (windowing, CTEs, dynamic SQL, performance patterns)

Details

  • Storage engine, buffer pool, log architecture
  • TempDB internals & contention patterns
  • Query Optimiser behaviour (statistics, cardinality estimation)

Hands‑on design and troubleshooting of:

  • Always On Availability Groups (single + multi‑subnet)
  • Distributed AGs
  • Failover Cluster Instances
  • Backup/restore topology (RPO/RTO driven)
  • DR validation & game‑day testing

Strong operational depth in:

  • Query Store, Extended Events, DMVs
  • CPU, memory, IO bottleneck analysis
  • Index strategy (filtered, columnstore, compression)
  • TempDB pressure diagnostics
  • Parameter sniffing & workload instability

Enterprise‑grade SQL security design:

  • Authentication: Windows, Entra ID, contained users
  • gMSA / dMSA for SQL services (Windows)
  • Encryption: TDE, Always Encrypted, TLS hardening
  • Least‑privilege service & agent design
  • Auditing, SQL Vulnerability Assessment

5. Azure & Hybrid SQL

  • Azure SQL DB vs Managed Instance vs SQL on VM
  • Hybrid patterns (Arc‑enabled SQL, lift‑and‑shift vs refactor)
  • Network‑isolated (private endpoint) SQL designs
  • Cost and performance trade‑off analysis

6. Delivery & Communication

  • Lead L300/L350 workshops
  • Translate customer pain → Microsoft‑aligned solution
  • Write architecture decisions, risks & trade‑offs
  • Collaborate with Azure Architects & Security CSAs
Similar roles

Keep a backup shortlist.

Browse stack
FocusData EngineeringRole area
Seniority signalSeniorCandidate level
StackAzure, SQLPrimary skills
Location1 accepted countryEligibility

Stack

Use these tags to compare similar remote roles.

Location eligibility

Candidates should apply only when their profile country is listed here.

Your profileCountry not setSign in to check your country against this role.

Hiring flow

WithMira shows the role, then sends candidates to the company application.

1Check role fit, stack, and location eligibility in WithMira.
2Open the company application page from the tracked apply link.
3Save the role or subscribe for similar opportunities before leaving.
Apply on company siteCompany siteOpen link