Senior SQL Server DBA — HA/DR Specialist in Austin

Robotic Technologies Automation; Austin (TX); On-site; USD 76,000 - 108,000; Full time

Job summary

Robotic Technologies Automation in Austin, TX is seeking a Senior Database Administrator to lead SQL Server environments across production and non-production systems. You will design high-availability and disaster-recovery solutions, tune performance, and automate maintenance with PowerShell and T-SQL, collaborating with app dev and network teams.

This contract role offers exposure to AOAG/WSFC and complex ETL pipelines in a fast-paced environment.

Qualifications

• Strong Microsoft SQL Server administration and engineering.
• Install, configure, maintain, patch, and upgrade Microsoft SQL Server environments across production and non-production systems.
• Build and configure new SQL Server environments and provide ongoing administration and support for existing business-critical databases.
• Strong stored procedures, views, triggers and query troubleshooting.
• Performance tuning, indexing and execution-plan analysis.
• Security, logins, roles/permissions and database access management.
• Develop, Support, and troubleshoot SSIS and ETL processes, including failed jobs, connectivity problems, data processing issues, and performance problems.
• Ongoing maintenance of existing databases: monitoring, health checks, index and statistics maintenance, integrity checks, SQL Server Agent jobs, and capacity/storage management.
• Troubleshooting and resolving database incidents, outages, blocking/deadlocks, failed jobs and performance issues, including root-cause analysis.
• Supporting SQL Server on Windows Server across internal networks, including service accounts, Windows/Active Directory authentication, ports and firewall rules.
• Working with network and infrastructure teams to resolve firewall and connectivity issues between users, application servers and database servers.
• Develop and maintain backup and recovery strategies using full, differential, and transaction log backups.
• Design, implement, administer, support, and troubleshoot SQL Server High Availability and Disaster Recovery (HA/DR) solutions.
• Implement and support SQL Server Always On Availability Groups (AOAG) and Windows Server Failover Clustering (WSFC)
• Support multi-node and multi-datacenter Availability Group architectures, including synchronous and asynchronous commit modes
• Understand and support WSFC quorum configurations, including File Share Witness and Cloud Witness
• Support and troubleshoot log shipping and other SQL Server disaster recovery technologies where applicable
• Conduct periodic DR exercises, failover testing, and failback testing to validate database recoverability and operational readiness
• Develop, test, maintain, and improve detailed HA/DR procedures and disaster recovery runbooks
• Understand business requirements for Recovery Point Objective (RPO) and Recovery Time Objective (RTO) and ensure database recovery strategies support those requirements
• Scripting with PowerShell, T-SQL and batch to automate and maintain databases and applications on servers (maintenance, deployments, monitoring and alerts)
• Supporting application releases, including database changes, deployment and post-release checks
• Documenting database designs, configurations, support procedures and runbooks
• Working closely with application, development and testing teams on defect triage and fixes

Responsibilities

• Administer SQL Server across production and non-prod systems.
• Implement backups, restores, and disaster recovery strategies.
• Configure High Availability and AOAG/WSFC deployments.
• Troubleshoot incidents, performance, and blocking.
• Coordinate with network/infra to resolve connectivity.
• Automate chores with PowerShell and T-SQL.
• Support application releases and database changes.
• Document runbooks and procedures.

Skills

SQL Server administration

Production support

T-SQL

PowerShell

Backup and recovery planning

HA/DR concepts

Tools

SQL Server

Windows Server

Job description

Robotic Technologies Automation in Austin, TX is seeking a Senior Database Administrator to lead SQL Server environments across production and non-production systems. You will design high-availability and disaster-recovery solutions, tune performance, and automate maintenance with PowerShell and T-SQL, collaborating with app dev and network teams.

This contract role offers exposure to AOAG/WSFC and complex ETL pipelines in a fast-paced environment.