Sr. SQL Server Database Administrator

Title

Sr. SQL Server Database Administrator

Location

Little Rock, AR

Duration

7+ Months

Job Description

• Install, configure, upgrade, and maintain Microsoft SQL Server 2022 environments, including service packs and cumulative updates
• Perform routine database administration, monitoring, maintenance, and troubleshooting activities
• Manage SQL Server Agent jobs, monitor error logs and event logs, and proactively resolve database issues
• Utilize SQL Server native tools and services including SQL Server Profiler, Index Tuning Advisor, SQL Server Configuration Manager, Extended Events, Performance Monitor, and Dynamic Management Views
• Administer SQL Server security, auditing, authentication, encryption, and compliance controls
• Develop and maintain database backup, recovery, and retention processes to achieve business RPO and RTO objectives
• Create, test, and maintain disaster recovery plans and recovery procedures
• Perform database performance tuning, T-SQL optimization, and ETL process support
• Support SQL Server high availability solutions including Always On Availability Groups and AWS-based HA architectures
• Monitor and support very large databases (VLDBs) and high-volume transactional and batch processing systems
• Manage Linked Servers, MSDTC, Service Broker, system databases, health checks, and SQL Server policies
• Perform capacity planning activities and manage database storage utilization across SQL Server and AWS storage platforms
• Administer Windows Failover Cluster Services and clustered storage environments
• Build, configure, maintain, and troubleshoot Windows Servers and AWS EC2 instances
• Utilize PowerShell automation for administrative and operational tasks
• Install and manage endpoint protection solutions and maintain server roles and features
• Support application, web, file, and FTP servers as required
• Participate in on-call support and provide 24-hour production support when necessary
• Collaborate with infrastructure, application support, security, and business teams to ensure reliable system operations

Required Skills

• 4+ years of hands-on SQL Server database administration experience with SQL Server 2022, SQL Server 2019, SQL Server 2017, or SQL Server 2016
• Experience installing, upgrading, patching, and maintaining SQL Server environments
• Strong knowledge of SQL Server security, auditing, encryption, backup, recovery, and disaster recovery practices
• Experience with SQL Server performance monitoring, tuning, and troubleshooting
• Advanced T-SQL development and optimization skills
• Experience supporting SQL Server high availability technologies, including Always On Availability Groups
• Experience managing large-scale or mission-critical database environments
• 3+ years of Windows Server administration experience
• Experience building and maintaining Windows Servers and AWS EC2 instances
• Experience with Windows Failover Clustering and clustered environments
• Proficiency with PowerShell administration and automation
• Strong understanding of server roles, features, and .NET Framework components
• Relevant technical certifications
• Availability to provide 24-hour support as needed
• Strong verbal and written communication skills

Preferred Skills

• Experience with FAST GenTax / DS-VS architecture and application maintenance
• Knowledge of AWS cloud services and cloud computing concepts
• Experience with cloud storage, backup, and recovery solutions
• Familiarity with security standards including PUB1075, FIPS, and PII requirements
• Active Directory administration experience, including GPOs, DNS, FQDN, and SPN management
• Firewall administration and maintenance experience
• Experience troubleshooting email, SMTP, and proxy servers
• Web services development or support experience
• Experience supporting government tax, revenue, or regulatory systems