Job Title: Senior SQL Database Administrator (DFA Sr. SQL DBA)
Location: Little Rock, AR (Onsite)
Position Type: Contract (Extension Possible)
Must Have Skills
- Minimum 4 years of hands-on SQL Server DBA experience, including SQL Server 2022 or later.
- Minimum 3 years of Windows Server Administration experience.
- Expertise in SQL Server installation, configuration, upgrades, patching, and routine database maintenance.
- Proficiency in SQL Server Agent, SQL Profiler, Index Tuning Advisor, Extended Events, Performance Monitor, and Dynamic Management Views (DMVs).
- Strong knowledge of SQL Server security, authentication, auditing, and encryption.
- Experience with SQL Server backup, restoration, point-in-time recovery, and disaster recovery planning.
- Expertise in SQL Server High Availability, Always On Availability Groups, AWS Availability Zones, and Windows Failover Clustering.
- Experience managing Very Large Databases (VLDBs) and high-volume OLTP and batch processing environments.
- Proficiency in T-SQL development, performance tuning, and ETL methodologies.
- Experience with SQL Server capacity planning, disk storage management, and AWS storage systems.
- Hands-on experience building, configuring, and maintaining Windows Servers and AWS EC2 instances.
- Proficiency in PowerShell scripting, Windows Server roles, .NET Framework, and endpoint protection.
- Experience configuring and maintaining application, web, file, and FTP servers.
- Knowledge of SQL Server Broker, Linked Servers, MSDTC, system databases, and database health checks.
- Relevant technical certifications required.
- Availability to provide 24-hour support as needed.
Desired Skills
- Experience with FAST GenTax/DS-VS architecture and application maintenance.
- Familiarity with security and compliance standards, including IRS Publication 1075, FIPS, and PII protection.
- Knowledge of cloud computing infrastructure and AWS services.
- Experience with cloud storage, backup, and restoration mechanisms.
- Understanding of firewall administration and maintenance.
- Knowledge of Active Directory, Group Policy Objects (GPO), FQDN, DNS, and Service Principal Names (SPN).
- Experience troubleshooting email, SMTP, and proxy servers.
- Knowledge of web services development, integration, and support.
- Strong verbal and written communication skills.
- Excellent analytical, troubleshooting, and problem-solving abilities.
Job Responsibilities
- Administer, maintain, and support business-critical production and non-production SQL Server databases for the Arkansas Integrated Revenue System (AIRS).
- Ensure enterprise database environments remain secure, reliable, highly available, and cost-effective.
- Install, configure, upgrade, patch, and maintain SQL Server database instances.
- Perform database health checks, monitor system performance, and resolve database errors and operational issues.
- Manage SQL Server Agent jobs, scheduled maintenance tasks, and database optimization activities.
- Implement and maintain database security policies, user permissions, authentication, auditing, and encryption.
- Develop and execute database backup, recovery, and disaster recovery strategies aligned with RPO and RTO requirements.
- Configure, monitor, and troubleshoot SQL Server Always On Availability Groups and Windows Failover Clusters.
- Monitor and optimize database performance, SQL queries, indexes, and resource utilization.
- Manage database capacity planning, storage allocation, and AWS storage infrastructure.
- Support large-scale transactional and batch-processing database environments.
- Develop, maintain, and optimize T-SQL scripts, stored procedures, and ETL processes.
- Administer Windows Server environments, AWS EC2 instances, and associated infrastructure components.
- Automate database and server administration tasks using PowerShell.
- Troubleshoot database connectivity, replication, performance bottlenecks, and infrastructure-related issues.
- Collaborate with application development, infrastructure, and security teams to ensure seamless database operations.
- Maintain technical documentation, operational procedures, and database configuration standards.
- Provide 24-hour production support when required to maintain business continuity.