Sr. SQL DBALocation: W. 7th Street, Little Rock, AR 72201The 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).On-site work for at least the first 3 months, remote allowed after that.Expert level SQL database administrator.
Position is available for extensions.Minimum: 7 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: 5 years Windows Server Administration experience:Building and maintaining Windows host and guest serversInstalling and managing endpoint protectionNessus configuration and vulnerability scansApplication server, web server, file server, and FTP server configuration and maintenanceUtilizing PowerShell for administration tasksWindows failover cluster configuration and maintenanceWindows server roles and features