Description

You will provide enterprise-wide support for business-critical production and non-production databases for the Arkansas Integrated Revenue System.

Responsibilities

• Install and upgrade SQL Servers, including applying service packs and managing Windows Failover Cluster Service.
• Perform routine maintenance including index rebuilding, statistics updates, consistency checks, and monitoring error logs.
• Manage SQL Server security, auditing, encryption at rest, transit, and backup, and user roles.
• Execute capacity planning for storage and database objects to ensure proper disk space utilization.
• Develop and test disaster recovery plans, backup schedules, and point-in-time recovery procedures.

Required Skills

• 7+ years of experience in SQL Server 2016 (or later) database administration.
• Expertise in SQL Server native tools including SQL Server Profiler, Extended Events, Performance Monitor, and Dynamic Management Views.
• Proficiency in T-SQL coding, tuning, and ETL methodologies.
• Experience with High Availability methods including Mirroring and Always On.
• 5+ years of Windows Server Administration experience, including building and maintaining host and guest servers.
• Hands-on experience with Windows Failover Cluster configuration and maintenance.
• Proficiency using PowerShell for administration tasks.
• Experience configuring and maintaining Application, Web, File, and FTP servers.
• Knowledge of Active Directory, Nessus vulnerability scans, and endpoint protection.
• Ability to provide 24-hour support.

Preferred Skills

• Experience with FAST GenTax/DS-VS architecture and application maintenance.
• Knowledge of cloud computing, storage, and backup mechanisms.
• Familiarity with industry security standards such as PUB1075, FIPS, and PII.

Key Skills

Education

Any Graduate