Resumo da vaga

Senior Data Engineer

Requisitos e responsabilidades

Conteúdo da vaga extraído em seções para revisão mais rápida.

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
Vagas similares

Mantenha uma lista reserva.

Ver stack
FocoData EngineeringÁrea da vaga
Sinal de senioridadeSeniorNível do candidato
StackAzure, SQLSkills principais
Localização1 país aceitoElegibilidade

Stack

Use estas tags para comparar vagas remotas similares.

Elegibilidade de localização

Candidatos devem aplicar apenas quando o país do perfil estiver listado aqui.

Seu perfilPaís não definidoEntre para comparar seu país com esta vaga.

Fluxo de contratação

O WithMira mostra a vaga e depois envia candidatos para a aplicação da empresa.

1Confira fit da vaga, stack e elegibilidade de localização no WithMira.
2Abra a página de aplicação da empresa pelo link rastreado.
3Salve a vaga ou assine oportunidades similares antes de sair.
Aplicar no site da empresaSite da empresaAbrir link