Senior SQL Server DBA (SQL Server 2022 / Always On / AWS)
Job Description
The OperAxis team is seeking a Senior SQL Server Database Administrator for an 8-month onsite contract with a state government client in Little Rock, AR. You will support a high-volume public sector tax application environment. This role is open to local candidates only, and interviews are held onsite. You will own the health, security, performance and recoverability of mission-critical SQL Server databases running on Windows Server and AWS, and you will be available for 24-hour support when needed. The ideal candidate is a hands-on senior DBA with deep SQL Server 2016+ experience, strong Windows Server administration skills and a track record supporting high-intensity OLTP and batch systems. Requirements: - Must have: SQL Server, SQL, DBA experience and Active Directory - 4+ years as a Senior SQL Database Administrator - 4+ years of SQL Server 2016 or later administration, including SQL Server 2022 installs, upgrades, service packs and cumulative updates - 3+ years of Windows Server administration, including EC2 instances, Failover Clustering and PowerShell - Proficient in T-SQL coding, tuning and ETL methodologies - High Availability (Always On, AWS HA zones) and VLDB experience - Availability for 24-hour support; relevant certifications - Must be local to Little Rock, AR; onsite interviews only - Nice to have: GenTax application experience, security standards (PUB 1075, FIPS, PII), firewall administration, and Active Directory GPO/DNS/SPN Responsibilities: - Install, upgrade and maintain SQL Server, SQL Server Agent jobs and routine maintenance - Monitor error and event logs and tune performance with Profiler, Extended Events, DMVs and Performance Monitor - Manage user security, authentication, auditing and encryption at rest, in transit and in backups - Plan capacity and manage disk storage, including AWS and Windows Failover Cluster storage - Define backup standards and schedules, perform point-in-time restores and meet RPO/RTO targets - Create and test disaster recovery plans - Build and maintain Windows Servers and EC2 instances, including endpoint protection and server roles - Take part in design and code reviews, identify risks and recommend best practices - Manage expectations of key stakeholders