Senior MS SQL Database Administrator
- United States
Applications open in a new tab.
Job details
- Posting language
- English
Original job description
We are seeking an experienced Senior SQL Database Administrator (SQL DBA) to manage, maintain, secure, and optimize enterprise-level SQL Server databases across production and non-production environments. The ideal candidate will have strong hands-on experience with SQL Server 2022 or later, Windows Server administration, database performance tuning, high availability, disaster recovery, and AWS storage systems.
Key Responsibilities
- Install, configure, upgrade, and maintain SQL Server 2022 or later, including service packs and cumulative updates.
- Perform routine database maintenance, monitor server health, review error logs, and troubleshoot database issues.
- Optimize database performance using SQL Server Profiler, Extended Events, Dynamic Management Views (DMVs), Performance Monitor, and Index Tuning Advisor.
- Manage SQL Server Agent jobs, linked servers, Service Broker, MSDTC, system databases, security, and auditing.
- Implement database security, authentication, encryption, and compliance controls.
- Manage database storage, capacity planning, Windows Failover Clusters, and AWS storage resources.
- Develop and maintain database backup, recovery, and disaster recovery strategies aligned with RPO and RTO requirements.
- Perform point-in-time database recovery and regularly test disaster recovery procedures.
- Develop and optimize T-SQL queries, database objects, and ETL processes.
- Implement and maintain SQL Server high-availability solutions, including Always On Availability Groups and AWS availability-zone configurations.
- Support very large databases (VLDBs) and troubleshoot high-volume transactional and batch-processing systems.
- Build, configure, and maintain Windows Servers and AWS EC2 instances.
- Manage Windows Server roles, features, endpoint protection, application servers, web servers, file servers, and FTP servers.
- Configure and maintain Windows Failover Clustering and automate administrative tasks using PowerShell.
- Provide production support and participate in on-call or 24-hour support as required.
Required Qualifications
- Minimum 4 years of hands-on SQL Server database administration experience with SQL Server 2022 or later.
- Strong experience in SQL Server installation, upgrades, maintenance, monitoring, troubleshooting, and performance tuning.
- Proficiency in T-SQL development, query optimization, and ETL methodologies.
- Experience with SQL Server security, auditing, encryption, backup and recovery, high availability, and disaster recovery.
- Hands-on experience with Always On Availability Groups, Windows Failover Clustering, and large-scale database environments.
- Experience managing database storage and AWS storage systems.
- Minimum 3 years of Windows Server administration experience, including Windows Server builds, EC2 instances, server configuration, and maintenance.
- Experience with PowerShell, Windows Server roles and features, and .NET Framework components.
- Strong analytical, troubleshooting, communication, and documentation skills.
- Ability to work onsite in Little Rock, Arkansas, and participate in 24-hour support when required.
Preferred Qualifications
- Experience with FAST GenTax/DS-VS architecture and application maintenance.
- Familiarity with security and compliance standards, including PUB1075, FIPS, and PII.
- Knowledge of cloud computing, cloud storage, and backup and recovery solutions.
- Experience with firewall administration and maintenance.
- Knowledge of Active Directory, Group Policy (GPO), FQDN, DNS, and SPN.
- Experience troubleshooting email, SMTP, proxy servers, and web services.
Important Information
- This is a long-term onsite contract position in Little Rock, Arkansas.
- The interview process is in-person only.
- Candidates must meet the SQL Server 2022+ and Windows Server administration experience requirements.