Sr. SQL DBA

Vitaver & Associates, Inc.; Little Rock (AR); On-site; USD 90,000 - 130,000; Full time

Job summary

Vitaver & Associates, Inc. seeks a Sr. SQL DBA for a 12‑month onsite project in Little Rock, AR. Start ASAP. Requires 4+ years of SQL Server admin, SQL Server 2022 experience, Windows Server, backups, DR planning, and Always On availability.

You will install/upgrade SQL Server instances, monitor logs, manage security, perform tuning, and coordinate AWS storage. On-site only with possible relocation as needed.

Qualifications

• 4+ years of SQL Server database administration
• Experience with SQL Server 2022 (or later)
• Experience with Windows Server administration (>3 years)
• Experience with installing and upgrading SQL Servers
• Experience with routine database maintenance
• Experience with SQL Server Agent and jobs
• Experience with monitoring error/event logs
• Experience with SQL Server native tools and services (Profiler, Extended Events, Performance Monitor, etc.)
• Experience with security/auditing (encryption, authentication)
• Experience with capacity planning for storage/db objects
• Experience with AWS storage and Windows Failover Clustering
• Experience with backup/recovery and DR planning
• Experience with T‑SQL coding and ETL methodologies
• Experience with VLDBs and high-availability methods
• Experience with on-prem and AWS environments

Responsibilities

• Provide reliable, secure enterprise-wide support for AIRS production/data servers
• Install and upgrade SQL Server instances and perform routine maintenance
• Manage SQL Server security, auditing, and encryption
• Establish backup standards and recovery procedures to meet RPO/RTO
• Plan storage capacity and maintain disk storage on AWS and WFCS
• Support high-availability configurations (Always On, VLDB)
• Monitor and troubleshoot high-intensity systems with online and batch workloads
• Provide 24-hour support as needed

Skills

SQL Server administration

Windows Server administration

T‑SQL coding

Backup and recovery planning

High availability (Always On)

Performance monitoring

Security and auditing

Capacity planning

AWS storage management

Disaster recovery planning

Tools

Profiler

Index Tuning Advisor

SQL Server Configuration Manager

Extended Events

DMV tools

MSDTC

Linked Servers

Job description

14992 - Sr. SQL DBA (Onsite) - Little Rock, AR

Start Date: ASAP

Type: Temporary Project.

Estimated Duration: 12 months with possible extensions

Work Setting: 100% of the time at the Client's site. No telecommuting or remote work. This is a non‑negotiable requirement from the client. Only candidates able to relocate as required should apply to avoid removal from future consideration. Our client is filling this contract position exclusively through approved staffing partners, so this opportunity is not available by applying directly with the client. If you're interested, we'd be happy to represent you throughout the hiring process.

Required:

• Availability to work 100% of the time at the Client's site in Little Rock, AR (required).
• Experience with SQL Server 2022 (or later versions) database administration (4+ years).
• Experience with Windows Server Administration (3+ years).
• Experience with Installing and upgrading SQL Servers, including applying service packs and cumulative updates.
• Experience with Performing routine database maintenance.
• Experience with SQL Server Agent and jobs.
• Experience with Monitoring error logs and event logs for database errors and warnings.
• Experience with SQL Server native tools and services (Profiler, Index Tuning Advisor, Configuration Manager, Extended Events, Performance Monitor, Dynamic Management View, Broker Service, Linked Servers, MSDTC, System Databases, Health Checks and Policies).
• Experience with Managing SQL Server security and auditing (user security, authentication methods, SQL Server and database auditing, encryption at rest, transit, and backup).
• Experience with Capacity Planning for storage and database objects.
• Experience with Maintaining and managing SQL Server disk storage and Amazon Web Services (AWS) storage systems.
• Experience with Managing disk storage for Windows Failover Cluster Service (WFCS).
• Experience with Database backup and recovery (establishing standards and schedules, developing recovery procedures to meet RPO and RTO, point in time recovery).
• Experience with Creating and testing Disaster Recovery plans.
• Experience with Transact-SQL (TSQL) coding, tuning, and ETL methodologies.
• SQL Server High Availability Methods (Always On and AWS HA Zones).
• Experience with Very Large Databases (VLDB).
• Experience with Monitoring, supporting, and troubleshooting high intense systems with both online and batch transactions.
• Experience with Building and maintaining Windows Servers and EC2 Instances.
• Experience with Installing and managing end point protection.
• Experience with Application Server, Web Server, File Server, and FTP Server configuration and maintenance.
• Experience with PowerShell for administration tasks.
• Experience with Windows Failover Cluster configuration and maintenance.
• Experience with Windows Server Roles and Features.
• Experience with .NET Framework Components.

Preferred:

• Experience with FAST GenTax /DS-VS architecture and application maintenance.
• Experience with Industry security standards (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 (GPO, FQDN, DNS Server, 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, including applying service packs and cumulative updates, and perform routine maintenance, including monitoring SQL Server Agent jobs and reviewing 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, AWS HA Zones, and VLDB environments, and monitor and troubleshoot high‑intensity systems handling both online and batch transactions.
• Availability to provide 24 hour support