Senior Database Performance Engineer

AmeriSave Mortgage Corporation

Senior Database Performance Engineer responsible for database performance and incident response at AmeriSave Mortgage Corp. Leading monitoring initiatives and coordinating database operations for stability and performance.

Posted 6/5/2026full-timeRemote • 🇺🇸 United StatesSenior💰 $100,000 - $170,000 per yearWebsite

Tech Stack

Tools & technologies

MS SQL ServerSQL

About the role

Key responsibilities & impact

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

What you’ll need

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)

Benefits

Comp & perks

401(k)
Dental insurance
Disability insurance
Employee discounts
Health insurance
Life insurance
Paid time off
12 paid holidays per year
Paid training
Referral program
Vision insurance

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Microsoft SQL ServerT-SQLQuery Storewait statisticsExtended Eventsincident managementroot-cause analysisexecution plan analysisautomation scriptingindex strategy

Soft Skills

leadershipcommunicationproblem-solvingorganizational skillsincident triage