Remote Senior SQL Server Performance Engineer

Unosquare, Inc.; Miami, San Francisco (FL, CA); Hybrid; USD 150,000 - 190,000; Full time

Job summary

Unosquare, Inc. is seeking a Senior DBA/DBE Consultant to lead SQL Server performance engineering for high-volume financial databases. You will diagnose bottlenecks, optimize storage and memory, and shape HA/DR architectures while guiding and mentoring client DBAs.

In a remote/hybrid setup, you will collaborate with engineering, SRE, and security teams across locations, delivering measurable latency and stability improvements and driving best practices in SQL Server administration.

Qualifications

• 10+ years of hands-on SQL Server DBA or database engineering experience.
• 5+ years in a senior or principal-level, performance-focused role.
• Expert knowledge of SQL Server 2016–2022 internals.
• Proven tuning of large, high-concurrency OLTP systems (thousands of TPS, multi-TB databases).
• Experience in financial services, payments, or banking.
• Advanced T-SQL development and execution plan analysis.
• Hands-on design and operation of partitioning at scale.
• Deep production experience with Always On AGs and SQL Server Replication.
• Strong proficiency with Query Store, Extended Events, DMVs, and wait-stats methodology.
• Working knowledge of Windows Server, WSFC, SAN/NVMe storage, and virtualization.
• PowerShell scripting and automation (dbatools preferred).
• Experience with PCI-DSS, SOX, or similar audit controls.
• Strong written communication, including RCA reports and executive summaries.

Responsibilities

• Be the technical authority on SQL Server internals, performance engineering, and scalability.
• Support the client's highest-volume financial transaction databases with hands-on tuning.
• Diagnose hot spots, latch/lock contention, blocking, plan regressions, and I/O bottlenecks.
• Design durable fixes: partitioning, indexing standards, query redesign, and HA/DR architectures.
• Collaborate with application engineering, SRE, architecture, and security teams.
• Mentor the client's DBAs and serve as the escalation point.
• Own outcomes end-to-end with measurable improvements in latency, stability, and scalability.

Skills

SQL Server internals

Performance tuning

OLTP systems

Partitioning & indexing

Always On AGs / Replication

T-SQL development

PowerShell / dbatools

Windows Server / WSFC

Query Store / XE / DMVs

Security & compliance (PCI-DSS/SOX)

Tools

dbatools

PowerShell

SQL Server Management Studio

Job description

Unosquare, Inc. is seeking a Senior DBA/DBE Consultant to lead SQL Server performance engineering for high-volume financial databases. You will diagnose bottlenecks, optimize storage and memory, and shape HA/DR architectures while guiding and mentoring client DBAs.

In a remote/hybrid setup, you will collaborate with engineering, SRE, and security teams across locations, delivering measurable latency and stability improvements and driving best practices in SQL Server administration.