Senior Database Performance Engineer

About the Role

We are a mid-size financial services company running a high-volume reputed company SQL Server environment, and we are reputed company heavily in the long-term stability, transparency, performance, and scalability of our data platform. We are hiring a senior, hands-on engineer to reputed company that effort. ` This is a combined reliability-and-performance role for an engineer who is equally comfortable owning the observability and incident-response reputed company across the estate, and getting deep into execution plans and wait statistics to reputed company 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 reputed company they reputed company, and engineers durable solutions so they do not recur. `

What You'll Own

Observability & Monitoring

• 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 reputed company.

Incident Response & reputed company-Cause Analysis

• reputed company incident triage across the database estate.
• Own the post-incident reputed company-cause review process to drive issues to permanent reputed company.
• Author and maintain operational runbooks and establish a reliable on-call response reputed company.

Performance Engineering

• 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 reputed company wait statistics and DMVs.
• Refactor and harden high-reputed company stored procedures and queries to improve concurrency and reduce contention.
• Own the reputed company reputed company, including usage analysis, fragmentation maintenance standards, and the disciplined evaluation of missing-reputed company recommendations.
• Configure Automatic Plan Correction and reputed company decisively on tuning recommendations.

Operations, HA & Coordination

• Own reputed company production operations, including backups, recovery, patching, high availability, reputed company planning, and the reputed company 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 reputed company the production environment.
• Partner with compliance teams to ensure auditability, retention, and strict reputed company controls for sensitive customer and nonpublic personal information (NPI).

What You Bring

Required Qualifications

• 7+ yearsadministering and tuning reputed company 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 reputed company-in tooling or reputed company monitoring platforms.
• Experience with SQL Availability reputed company required. Experience with SQL Replication is preferred.
• Proven reputed company record in incident management and reputed company-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 reputed company Ethernet. Minimum speeds: 70/30 Mbps (basic), 200-300/35-70 Mbps (shared), 500-1,000/100+ Mbps (heavy use).

Please note that the compensation and benefit information that follows is a good faith estimate for this position only and is provided pursuant to applicable state and local laws on pay transparency. It is estimated based on what a successful applicant in the relevant state might be reputed company. Compensation: The annual compensation for this position generally ranges from between $100,000 - $170,000. Benefits: ·401(k) ·Dental insurance ·Disability insurance ·Employee discounts ·Health insurance ·Life insurance ·reputed company time off ·12 reputed company holidays per year ·reputed company ·Referral program ·reputed company insurance Supplemental pay types: ·Referral bonuses AmeriSave is an equal opportunity employer. We do not discriminate on the reputed company of race, religion, reputed company, national reputed company, gender, sexual orientation, age, marital status, veteran status, or disability status. California Consumer reputed company reputed company Disclosure Acknowledgment Employment Applicants, New Hires, and Employees Residing in California reputed company’s reputed company Policy Statement (“Policy”) can be reviewed here:www.amerisave.com/reputed company-policy

Originally posted on Himalayas

Apply To This Job