SQL Database Administrator

Wiserhunt • Little Rock, AR

5d • Onsite

About The Position

The Senior SQL Database Administrator provides reliable, cost-effective, and secure enterprise-wide support for business-critical production and non-production databases for the Arkansas Integrated Revenue System (AIRS). This is an onsite-only position requiring recent hands-on experience across all aspects of SQL database administration. The role also includes Windows Server administration and may require availability to provide 24-hour support.

Requirements

• At least 4 years of SQL database administration experience, including SQL Server 2016 or later; the description also specifies a minimum of 4 years administering SQL Server 2022 or later.
• Hands-on experience installing and upgrading SQL Servers, applying service packs and cumulative updates, and performing routine database maintenance.
• Knowledge of SQL Server Agent and jobs, native tools and services, Profiler, Index Tuning Advisor, Configuration Manager, Extended Events, Performance Monitor, Dynamic Management Views, SQL Server Broker Service, linked servers, MSDTC, and system databases.
• Experience with SQL Server health checks and policies, security and auditing, authentication methods, and encryption at rest, in transit, and for backups.
• Experience with storage capacity planning and SQL Server disk storage management, including AWS storage systems and storage for Windows Failover Cluster Service.
• Experience establishing backup standards and schedules, meeting recovery point and recovery time objectives, point-in-time database recovery, and disaster recovery planning and testing.
• Proficiency in T-SQL coding and tuning and ETL methodologies.
• Experience with SQL Server high-availability methods, very large databases, and monitoring, supporting, and troubleshooting high-intensity online and batch transaction systems; experience with Always On and AWS Availability Zones.
• At least 3 years of Windows Server administration experience, including building and maintaining Windows Servers and EC2 instances; installing and managing endpoint protection; configuring and maintaining application, web, file, and FTP servers; using PowerShell; managing Windows Failover Clusters, Server Roles and Features, and .NET Framework components.
• Strong oral and written communication skills.
• Must pass an Arkansas Police Background Check.

Nice To Haves

• Experience with FAST GenTax/DS-VS architecture and application maintenance.
• Familiarity with security standards including PUB1075, FIPS, and PII.
• Cloud computing knowledge, including cloud storage and backup and restore mechanisms.
• Firewall administration and maintenance experience.
• Active Directory knowledge, including Group Policy, FQDN, DNS Server, and SPN.
• Email, SMTP, and proxy server troubleshooting experience.
• Availability to provide 24-hour support.

Responsibilities

• Install and upgrade SQL Servers, including applying service packs and cumulative updates.
• Perform routine database maintenance and monitor database error and event logs.
• Use SQL Server tools and services to administer, monitor, and troubleshoot databases.
• Manage SQL Server security, auditing, authentication, and encryption.
• Plan database and storage capacity and manage SQL Server disk storage, including AWS storage systems and storage for Windows Failover Cluster Service.
• Establish database backup standards and schedules; develop recovery procedures to meet RPO and RTO; perform point-in-time restores; and create and test disaster recovery plans.
• Develop, tune, and support T-SQL code and ETL methodologies.
• Monitor, support, and troubleshoot high-intensity systems with online and batch transactions, including very large databases and high-availability configurations.
• Build and maintain Windows Servers and EC2 instances; install and manage endpoint protection; and configure and maintain application, web, file, and FTP servers.
• Perform Windows Server administration using PowerShell and configure and maintain Windows Failover Clusters, server roles, and features.
• Provide application architecture and maintenance support where applicable.
• Troubleshoot web services, email, SMTP, and proxy servers.
• Provide 24-hour support as needed.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed