DFA Sr. SQL DBAThe Senior SQL Database Administrator will be responsible for providing reliable, cost-effective, and secure enterprise-wide support for business-critical production and non-production databases for the Arkansas Integrated Revenue System (AIRS).Expert Level SQL Database AdministratorPosition is available for extensions.NOTE: This position requires candidates that have recent hands-on experience in ALL aspects of SQL DBA Administration.MINIMUM: 6 Years Experience SQL Server 2016 (or later versions) database administration:Installing and upgrading SQL Servers, including applying service packsPerforming routine database maintenanceCreating and scheduling SQL Server jobs to perform database maintenance activityRebuilding indexesUpdating statisticsConsistency checksMonitoring error logs and event logs for database errorsSQL Server native tools and servicesSQL Server ProfilerIndex Tuning AdvisorSQL Server Configuration ManagerExtended EventsPerformance MonitorDynamic Management ViewSQL Server Broker ServiceLinked ServersMSDTCSQL Server System DatabasesDatabase MailSQL Server Health Checks and PoliciesManaging SQL Server security and auditingUser securityDatabase rolesAuthentication methodsSQL Server and database auditingEncryption at rest, transit, and backupCapacity Planning for storage and database objectsMaintaining and managing SQL Server disk space to ensure storage is properly utilizedIndex and statistics usageManaging disk storage for Windows Failover Cluster Service (WFSC)Database backup and recoveryEstablishing standards and schedules for database backupsDeveloping recovery procedures to meet RPO and RTORestoring databases with point in time recoveryCreating and testing Disaster Recovery plansProficient in TSQL coding, tuning, and ETL methodologiesSQL Server High Availability MethodsMirroringAlways OnRequired: 4 Years Windows Server Administration experience:Building and maintaining Windows Host and Guest ServersInstalling and managing end point protectionApplication Server, Web Server, File Server, and FTP Server configuration and maintenanceUtilizing PowerShell for administration tasksWindows Failover Cluster configuration and maintenanceWindows Server Roles and Features