SHORT DESCRIPTION:

The SENIOR SQL Database Administrator will be responsible for providing reliable, cost-effective, & secure enterprise-wide support for business critical production & non-production databases for the Arkansas Integrated Revenue System (AIRS) .

COMPLETE DESCRIPTION:

Minimum: 7 Years Experience SQL Server 2016 (or later versions) database administration:

• Installing and upgrading SQL Servers, including applying service packs
• Performing routine database maintenance

· Creating and scheduling SQL Server jobs to perform database maintenance activity
· Rebuilding indexes
· Updating statistics
· Consistency checks

· Monitoring error logs and event logs for database errors

• SQL Server native tools and services

· SQL Server Profiler
· Index Tuning Advisor
· SQL Server Configuration Manager
· Extended Events
· Performance Monitor
· Dynamic Management View
· SQL Server Broker Service
· Linked Servers

REQUIRED: 5 YEARS WINDOWS SERVER ADMINISTRATION EXPERIENCE:

• Building and maintaining Windows Host and Guest Servers
• Installing and managing end point protection
• Nessus configuration and vulnerability scans
• Application Server, Web Server, File Server, and FTP Server configuration and maintenance
• Utilizing PowerShell for administration tasks
• Windows Failover Cluster configuration and maintenance
• Windows Server Roles and Features
• .NET Framework Components

PREFERRED KNOWLEDGE AND SKILLS:

• Experience with FAST GenTax/DS-VS architecture and application maintenance
• Familiarity with industry security standards (PUB1075, FIPS, and PII)
• Cloud computing knowledge

· Cloud storage, backup, and restore mechanisms

• F5 administration
• Firewall administration and maintenance
• SAN, RAID Controller, and other storage device maintenance knowledge
• Active Directory knowledge (GPO, FQDN, DNS Server, SPN)
• Email, SMTP, and Proxy Server troubleshooting
• Web Services development and support
• Availability to provide 24 hour support
• Strong communication skills, both oral and written

Please refer the Job description for details