Senior SQL Server Database Administrator

CAI•Little Rock, AR

5d•$45 - $50•Onsite

About The Position

CAI is hiring a Senior SQL Server Database Administrator to provide expert-level database administration, performance tuning, security management, backup and recovery planning, disaster recovery support, and Windows Server administration for critical enterprise systems. The role is full-time and onsite in Little Rock, Arkansas, with employees expected onsite five days per week and available to provide 24/7 support as needed. Candidates must have work authorization that does not require sponsorship now or in the future. The administrator will maintain Microsoft SQL Server environments and Windows Servers, support high-availability and disaster-recovery solutions, and help ensure reliable operations across enterprise systems. The role involves collaboration with infrastructure, application support, security, and business teams.

Requirements

At least 4 years of hands-on SQL Server database administration experience with SQL Server 2022, 2019, 2017, or 2016.
Experience installing, upgrading, patching, and maintaining SQL Server environments.
Strong knowledge of SQL Server security, auditing, encryption, backup, recovery, and disaster recovery practices.
Experience with SQL Server performance monitoring, tuning, and troubleshooting.
Advanced T-SQL development and optimization skills.
Experience supporting SQL Server high-availability technologies, including Always On Availability Groups.
Experience managing large-scale or mission-critical database environments.
At least 3 years of Windows Server administration experience.
Experience building and maintaining Windows Servers and AWS EC2 instances.
Experience with Windows Failover Clustering and clustered environments.
Proficiency with PowerShell administration and automation.
Strong understanding of server roles, features, and .NET Framework components.
Relevant technical certifications.
Availability to provide 24-hour support as needed.
Strong verbal and written communication skills.
Work authorization that does not require sponsorship now or in the future.

Nice To Haves

Experience with FAST GenTax / DS-VS architecture and application maintenance.
Knowledge of AWS cloud services and cloud computing concepts.
Experience with cloud storage, backup, and recovery solutions.
Familiarity with security standards including PUB1075, FIPS, and PII requirements.
Active Directory administration experience, including GPOs, DNS, FQDN, and SPN management.
Firewall administration and maintenance experience.
Experience troubleshooting email, SMTP, and proxy servers.
Web services development or support experience.
Experience supporting government tax, revenue, or regulatory systems.

Responsibilities

Install, configure, upgrade, and maintain Microsoft SQL Server 2022 environments, including service packs and cumulative updates.
Perform routine database administration, monitoring, maintenance, and troubleshooting.
Manage SQL Server Agent jobs, monitor error and event logs, and proactively resolve database issues.
Use SQL Server tools and services including SQL Server Profiler, Index Tuning Advisor, SQL Server Configuration Manager, Extended Events, Performance Monitor, and Dynamic Management Views.
Administer SQL Server security, auditing, authentication, encryption, and compliance controls.
Develop and maintain database backup, recovery, and retention processes to meet business RPO and RTO objectives.
Create, test, and maintain disaster recovery plans and recovery procedures.
Perform database performance tuning, T-SQL optimization, and ETL process support.
Support SQL Server high-availability solutions, including Always On Availability Groups and AWS-based architectures.
Monitor and support very large databases and high-volume transactional and batch processing systems.
Manage Linked Servers, MSDTC, Service Broker, system databases, health checks, and SQL Server policies.
Perform capacity planning and manage database storage utilization across SQL Server and AWS storage platforms.
Administer Windows Failover Cluster Services and clustered storage environments.
Build, configure, maintain, and troubleshoot Windows Servers and AWS EC2 instances.
Use PowerShell automation for administrative and operational tasks.
Install and manage endpoint protection solutions and maintain server roles and features.
Support application, web, file, and FTP servers as required.
Participate in on-call support and provide 24-hour production support when necessary.
Collaborate with infrastructure, application support, security, and business teams to ensure reliable system operations.