Senior Database Performance Engineer

AmeriSave Mortgage Corporation is a mid-size financial services company focused on enhancing the stability and performance of their data platform. They are looking for a Senior Database Performance Engineer to lead efforts in observability, incident response, and performance engineering within a high-volume Microsoft SQL Server environment.

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 (SQL Agent performance-condition and severity alerts, blocked-process alerts, Database Mail) against established baselines to ensure alarms are trusted and acted upon
• Establish what "normal" looks like per workload and per time-of-day, alerting on statistical deviation rather than arbitrary thresholds
• 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
• Configure Automatic Plan Correction and act decisively on tuning 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
• Serve as the deep technical reviewer for the highest-risk queries before they reach the production environment
• Partner with compliance teams to ensure auditability, retention, and strict access controls for sensitive customer and nonpublic personal information (NPI)

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)