Senior SQL Server DBA & Cloud Performance Engineer

Datavail; Oregon; Hybrid; USD 110,000 - 160,000; Full time

Job summary

Datavail is seeking a Senior Database Engineer/SQL Server DBA to support mission-critical database systems across diverse clients and industries. This role emphasizes automation, cloud-native strategies, and proactive problem prevention.

Travel up to 20% domestic (US) for client onsite visits is expected. The position involves acting as a trusted technical advisor, leading service delivery, and owning the end-to-end database lifecycle with a strong emphasis on performance tuning and architecture

Qualifications

• T-SQL query optimization: read/modify execution plans, parameter sniffing, statistics issues, Query Store tuning.
• Rewrite/refactor existing T-SQL code and stored procedures for performance, including set-based approaches.
• Design/maintain indexing strategies: clustered/nonclustered/covering indexes, columnstore usage, fragmentation/maintenance.
• Root-cause performance diagnosis: wait-stats, CPU/memory/I/O bottlenecks, tempdb contention, blocking/deadlock resolution.
• Tuning for cloud-native platforms: Azure SQL Database, Azure SQL Managed Instance, AWS RDS for SQL Server sizing and IOPS.
• Establish baselines and monitor performance to catch degradation before incidents.
• Proactive automation and remediation to prevent recurring issues.

Responsibilities

• Serve as trusted advisor to clients, proactively identifying performance and security risks.
• Advise on cloud database architecture, migration, and cost optimization (AWS and Azure).
• Lead architecture design, DR planning, and capacity forecasting initiatives.
• Own end-to-end database service lifecycle: backup, HA/DR, tuning, roadmap.
• Define and track SLOs for availability and performance, drive automated remediation.
• Lead root-cause analyses and post-incident reviews for major issues.
• Design scalable database structures, including partitioning and audits.
• Develop deployment/rollback scripts and coordinate version updates across environments.
• Build automation (Python, PowerShell) for backup validation, monitoring, and reporting integrations.

Skills

T-SQL tuning

Query optimization

SQL Server admin

Azure SQL

AWS RDS for SQL Server

Performance analysis

Automation

Python

PowerShell

Tools

SSMS

SSIS

SSAS

Azure SQL Database

Azure SQL Managed Instance

AWS RDS for SQL Server

Power BI

Job description

Datavail is seeking a Senior Database Engineer/SQL Server DBA to support mission-critical database systems across diverse clients and industries. This role emphasizes automation, cloud-native strategies, and proactive problem prevention.

Travel up to 20% domestic (US) for client onsite visits is expected. The position involves acting as a trusted technical advisor, leading service delivery, and owning the end-to-end database lifecycle with a strong emphasis on performance tuning and architecture