Sr. SQL DBA

Vitaver and Associates • Little Rock, AR

19h • Onsite

About The Position

The Sr. SQL DBA provides reliable, cost-effective, and secure enterprise-wide support for business-critical production and non-production SQL Server databases supporting the Arkansas Integrated Revenue System (AIRS). The role installs, upgrades, secures, maintains, monitors, and troubleshoots SQL Server environments and related Windows and AWS infrastructure. It also supports database capacity planning, storage management, high availability, backup and recovery, and disaster recovery. The position is onsite at the client’s Little Rock, Arkansas site 100% of the time, with no telecommuting or remote work. Candidates must be able to relocate as required. The temporary project is estimated to last 12 months, with possible extensions, and requires availability to provide 24-hour support.

Requirements

• Availability to work 100% of the time onsite at the client’s site in Little Rock, Arkansas; candidates must be able to relocate as required.
• At least 4 years of experience administering SQL Server 2022 or later.
• At least 3 years of Windows Server administration experience.
• Experience installing and upgrading SQL Servers, including applying service packs and cumulative updates.
• Experience performing routine database maintenance.
• Experience with SQL Server Agent and jobs.
• Experience monitoring error logs and event logs for database errors and warnings.
• Experience with SQL Server native tools and services, including Profiler, Index Tuning Advisor, Configuration Manager, Extended Events, Performance Monitor, Dynamic Management Views, Broker Service, Linked Servers, MSDTC, system databases, health checks, and policies.
• Experience managing SQL Server security and auditing, including user security, authentication methods, SQL Server and database auditing, and encryption at rest, in transit, and in backups.
• Experience with capacity planning for storage and database objects.
• Experience maintaining and managing SQL Server disk storage and Amazon Web Services (AWS) storage systems.
• Experience managing disk storage for Windows Failover Cluster Service (WFCS).
• Experience with database backup and recovery, including establishing standards and schedules, developing recovery procedures to meet RPO and RTO, and point-in-time recovery.
• Experience creating and testing disaster recovery plans.
• Experience with Transact-SQL (T-SQL) coding, tuning, and ETL methodologies.
• Experience with SQL Server high-availability methods, including Always On and AWS HA Zones.
• Experience with very large databases (VLDB).
• Experience monitoring, supporting, and troubleshooting high-intensity systems with online and batch transactions.
• Experience building and maintaining Windows Servers and EC2 instances.
• Experience installing and managing endpoint protection.
• Experience configuring and maintaining application, web, file, and FTP servers.
• Experience using PowerShell for administration tasks.
• Experience configuring and maintaining Windows Failover Clusters.
• Experience with Windows Server roles and features.
• Experience with .NET Framework components.
• Availability to provide 24-hour support.

Nice To Haves

• Experience with FAST GenTax / DS-VS architecture and application maintenance.
• Experience with industry security standards, including PUB1075, FIPS, and PII.
• Experience with cloud computing.
• Experience with cloud storage, backup, and restore mechanisms.
• Experience with firewall administration and maintenance.
• Experience with Active Directory, including GPO, FQDN, DNS Server, and SPN.

Responsibilities

• Provide reliable, cost-effective, and secure enterprise-wide support for business-critical production and non-production SQL Server databases for the Arkansas Integrated Revenue System (AIRS).
• Install and upgrade SQL Server instances, apply service packs and cumulative updates, and perform routine database maintenance.
• Monitor SQL Server Agent jobs and review error and event logs for database errors and warnings.
• Manage SQL Server security and auditing, including user security, authentication methods, SQL Server and database auditing, and encryption at rest, in transit, and in backups.
• Establish backup standards and schedules; develop recovery procedures to meet RPO and RTO targets; perform point-in-time restores; and create and test disaster recovery plans.
• Plan capacity for storage and database objects, maintain SQL Server disk storage on AWS and Windows Failover Cluster Service, and ensure storage is properly utilized.
• Support high-availability configurations, including Always On and AWS HA Zones, and VLDB environments.
• Monitor, support, and troubleshoot high-intensity systems handling both online and batch transactions.
• Provide 24-hour support.

What This Job Offers

• Career Level: Senior
• Education Level: No Education Listed