Sr. SQL DBA

Job Title:Sr. SQL DBA Location:Little Rock, AR Type: W2 Contract Interview Process: On-Site Interviews Only ***Only qualified Senior SQL DBA candidates located in the Little Rock, AR area will be considered due to the position requiring an on-site presence***

Required Skills

SENIOR SQL Database Administrator Skills and Experience (4 Years)

SQL Database administration (see sub-bullets in JD) SQL Server 2016 or later (4 Years)

Windows Server Administration experience (see sub-bullets in JD) (3 Years)

Certifications

24hr Support

SQL Server 2022 (or Later Versions) Database Administration

Installing and upgrading SQL Servers, including applying service packs, cumulative updates

Performing routine database maintenance

Knowledge of SQL Server Agent and jobs

Monitoring error logs and event logs for database errors and warnings

SQL Server native tools and services

SQL Server Profiler

Index Tuning Advisor

SQL Server Configuration Manager

Extended Events

Performance Monitor

Dynamic Management View

SQL Server Broker Service

Linked Servers

MSDTC

SQL Server System Databases knowledge

SQL Server Health Checks and Policies

Managing SQL Server security and auditing

User security

Authentication methods

SQL Server and database auditing

Encryption at rest, transit, and backup

Capacity Planning for storage and database objects

Maintaining and managing SQL Server disk storage and experience with AWS storage systems to ensure storage is properly utilized

Managing disk storage for Windows Failover Cluster Service (WFCS)

Database backup and recovery

Establishing standards and schedules for database backups

Developing recovery procedures to meet RPO and RTO

Restoring databases with point in time recovery

Creating and testing Disaster Recovery plans

Proficient in TSQL coding, tuning, and ETL methodologies

SQL Server High Availability Methods

Experience with VLDB

Experience monitoring, supporting, troubleshooting high intense systems with both online transactions and batch transactions

Always On and AWS HA Zones

Windows Server Administration Experience

Building and maintaining Windows Servers and EC2 Instances

Installing and managing end point protection

Application Server, Web Server, File Server, and FTP Server configuration and maintenance

Utilizing PowerShell for administration tasks

Windows Failover Cluster configuration and maintenance

Windows Server Roles and Features

• NET Framework Components
  
  

Preferred Skills

GenTax Software Application architecture and application maintenance

Experience with FAST GenTax/DS-VS architecture and application maintenance

Familiarity with industry security standards (PUB1075, FIPS, and PII)

Cloud computing knowledge

Cloud storage, backup, and restore mechanisms

Firewall administration and maintenance

Active Directory knowledge (GPO, FQDN, DNS Server, SPN)

Email, SMTP, and Proxy Server troubleshooting

Web Services development and support

Availability to provide 24 hour support

Strong communication skills, both oral and written

Job Responsibilities

Oversees the design, development, and maintenance of ASP.NET Web Forms applications

Maintain and enhance existing code

Perform and participate in design and code review

Identify risks and make recommendations for best practices

Meets with and manages expectations of key stakeholders