DFA Sr. SQL DBA

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.