Senior Database Engineer

Datavail is a leading provider of data management, application development, analytics, and cloud services. The company is seeking a Senior Database Engineer/SQL Server DBA to serve as a trusted technical advisor, proactively optimize mission-critical database systems, and guide clients on cloud architecture and strategy. The role includes leading database service delivery, automation, performance tuning, disaster recovery, migrations, and client-facing technical recommendations.

Responsibilities:

• Serve as a trusted advisor to clients, proactively identifying performance, availability, and security risks before they become incidents
• Advise clients on cloud database architecture, migration, and cost optimization across AWS and Azure (IaaS and PaaS)
• Lead architecture design, disaster recovery planning, and capacity forecasting initiatives
• Own the end-to-end database service lifecycle — backup strategy, HA/DR configuration, proactive tuning, and platform roadmap planning
• Define and track service-level objectives (SLOs) for database availability and performance, and drive automated remediation for recurring failure patterns rather than manually resolving the same issue repeatedly
• Lead root-cause analysis and post-incident reviews for major issues, translating findings into automation or process changes that prevent recurrence
• Design and implement scalable database structures, including partitioning strategies and audit specifications
• Develop and maintain deployment/rollback scripts and coordinate version updates across environments
• Build automation (Python, PowerShell) for backup validation, monitoring, alerting, and reporting integrations (e.g., Power BI)
• Migrate/support SSIS packages and SSAS cubes, and develop stored procedures for reporting
• Collaborate directly with client technical teams and executive stakeholders, translating technical findings into business-relevant recommendations

Requirements:

• Job Schedule: Full time
• Workplace Type: Remote
• 1. Boulder, CO, United States
• Travel: Up to 20% domestic (US) travel for client onsite visits — this role is relationship-driven, and in-person time with clients is part of building that trust
• T-SQL query optimization — reading and rewriting execution plans, resolving parameter sniffing, statistics/cardinality issues, and Query Store-based tuning
• Rewriting and refactoring existing stored procedures and T-SQL code for performance — not just tuning execution plans, but redesigning logic and set-based approaches where needed
• Indexing strategy — designing and maintaining clustered/nonclustered/covering indexes, evaluating columnstore where appropriate, and managing fragmentation/maintenance without breaking SLAs
• Root-cause performance diagnosis — wait-stats analysis, CPU/memory/I-O bottleneck isolation, tempdb contention, and blocking/deadlock resolution
• Cloud-native platform tuning — hands-on optimization specific to Azure SQL Database, Azure SQL Managed Instance, and AWS RDS for SQL Server: correct service tier/vCore or DTU sizing, storage throughput/IOPS tuning, elastic pool configuration, and working within PaaS resource-governor limits
• Proactive performance baselining — establishing and monitoring baselines so degradation is caught before it becomes a client-facing incident, not just reactive firefighting