Sr. SQL DBA | Applicant Must Be Currently Local to Little Rock, AR | Relocation Not Allowed

NOTE: APPLICANT MUST BE ON OUR W2 OR 1099. C2C IS ALLOWED IF HAVING OWN CORPORATION ONLY. NOT ACCEPTING SUB-VENDORS. APPLICANT MUST BE CURRENTLY LOCAL TO LITTLE ROCK, AR AT THE TIME OF SUBMISSION. RELOCATION IS NOT ALLOWED.

Role: Sr. SQL DBA

Location: Little Rock, AR - Onsite

Duration: 7 Months w/Extensions

Interview: In-Person

NOTE:

·       ON-SITE INTERVIEWS ONLY

·       ON-SITE WORK ONLY

·       Expert Level SQL Database Administrator

·       Position is available for extensions.

·       This position requires candidates that have recent hands-on experience in ALL aspects of SQL DBA Administration.

Description:

The SENIOR SQL Database Administrator will be responsible for providing reliable, cost-effective, & secure enterprise-wide support for business-critical production & non-production databases for the Arkansas Integrated Revenue System (AIRS) .

MINIMUM: 4 Years Experience SQL Server 2022 (or later versions) database administration:

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

·       Performing routine database maintenance

o   Knowledge of SQL Server Agent and jobs

o   Monitoring error logs and event logs for database errors and warnings

·       SQL Server native tools and services

o   SQL Server Profiler

o   Index Tuning Advisor

o   SQL Server Configuration Manager

o   Extended Events

o   Performance Monitor

o   Dynamic Management View

o   SQL Server Broker Service

o   Linked Servers

o   MSDTC

o   SQL Server System Databases knowledge

o   SQL Server Health Checks and Policies

·       Managing SQL Server security and auditing

o   User security

o   Authentication methods

o   SQL Server and database auditing

o   Encryption at rest, transit, and backup

·       Capacity Planning for storage and database objects

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

o   Managing disk storage for Windows Failover Cluster Service (WFCS)

·       Database backup and recovery

o   Establishing standards and schedules for database backups

o   Developing recovery procedures to meet RPO and RTO

o   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

o   Experience with VLDB

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

o   Always On and AWS HA Zones

Required: 3 Years 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 Knowledge and Skills:

·       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

Skill                                   Required / Desired                                 Amount of Experience

·       SENIOR SQL Database Administrator Skills and Experience. – Required – 4 Years

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

·       Windows Server Administration experience (see sub-bullets in JD). – Required – 3 Years

·       Certifications - Required

·       24hr Support - Required

·       GenTax Software Application architecture and application maintenance - Desired