Senior Database Performance Engineer

Responsibilities

• Stand up and own the monitoring platform, utilizing Query Store across databases, wait-statistics, file-I/O baselines, system health custom Extended Events sessions, and the performance dashboard
• Define and continuously tune alerting against established baselines to ensure alarms are trusted and acted upon
• Lead incident triage across the database estate
• Own the post-incident root-cause review process to drive issues to permanent resolution
• Author and maintain operational runbooks and establish a reliable on-call response practice
• Diagnose and remediate top resource-consuming and lock-holding queries using Query Store, procedure stats, and execution plan analysis
• Identify and resolve CPU pressure, Tempdb contention, memory-grant waits, and I/O bottlenecks via wait statistics and DMVs
• Refactor and harden high-impact stored procedures and queries to improve concurrency and reduce contention
• Own the index strategy, including usage analysis, fragmentation maintenance standards, and the disciplined evaluation of missing-index recommendations
• Own core production operations, including backups, recovery, patching, high availability, capacity planning, and the security baseline
• Coordinate broader database initiatives across engineering and reporting teams, reporting status and risk directly to the CIO

Requirements

• 7+ years administering and tuning Microsoft SQL Server in demanding production environments
• Expert-level execution-plan reading and query rewriting, with deep knowledge of SARGability, set-based design, and parameter-sniffing remediation
• Hands-on mastery of wait statistics, Query Store, Extended Events, Tempdb internals, and parallelism tuning
• Demonstrated experience building monitoring and alerting from SQL Server's built-in tooling or enterprise monitoring platforms
• Proven track record in incident management and root-cause analysis
• Strong proficiency in T-SQL and automation scripting
• High-speed internet required for remote work, Cable or Fiber ONLY with the ability to connect via Ethernet. Minimum speeds: 70/30 Mbps (basic), 200-300/35-70 Mbps (shared), 500-1,000/100+ Mbps (heavy use)