Senior Database Performance Engineer

🔥 9 minutes ago

🇺🇸 United States – Remote

💵 $100k - $170k / year

⏰ Full Time

🟠 Senior

👷🏻‍♀️ Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

AmeriSave Mortgage Corporation

WebsiteLinkedInAll Job Openings

5001 - 10000 employees

Founded 2002

💸 Finance

🏠 Real Estate

Finance • Real Estate

AmeriSave Mortgage Corporation is a leading online mortgage lender offering a variety of home financing solutions, including first and second mortgages, home equity loans, and refinancing options. With 20 years of mortgage experience, AmeriSave has served over 733,603 borrowers across 49 states in the U. S. The company prides itself on providing easy and fast mortgage processes with access to quick quotes and approvals, low rates, and secure rate locks. AmeriSave is committed to helping its clients achieve financial freedom and better financial positions through responsible home equity usage and effective mortgage solutions. The company is well-regarded for its excellent customer service and accessibility, offering support in multiple languages and emphasizing easy online interactions for customer convenience.

📋 Description

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

🏖️ Benefits

• 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