Senior Database Performance Engineer

AmeriSave Mortgage Corp.

1d•$100,000 - $170,000•Remote

About The Position

We are a mid-size financial services company running a high-volume Microsoft SQL Server environment, and we are investing heavily in the long-term stability, transparency, performance, and scalability of our data platform. We are hiring a senior, hands-on engineer to lead that effort. This is a combined reliability-and-performance role for an engineer who is equally comfortable owning the observability and incident-response practice across the estate, and getting deep into execution plans and wait statistics to keep the platform fast and resilient under load. You will be the technical center of gravity for the database platform: the person who ensures we see issues early, leads the response when they arise, and engineers durable solutions so they do not recur.

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).

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).