What are the responsibilities and job description for the SQL Database Administrator position at WiserHunt Inc.?
Title/Role: DFA Sr. SQL DBA (814572)
Address: W 7th St. Little Rock, Arkansas, USA 72201
Work Location: Onsite
Interview: Onsite only
Short 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) .
Complete Description:
On-Site Work Only
Expert Level SQL Database Administrator
NOTE: This position requires candidates that have recent hands-on experience in ALL aspects of SQL DBA Administration.
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
-
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
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
Screening Criteria: Arkansas Police Background Check Required
|
Skills |
Required / Desired |
Years of Experience required |
Candidate 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 |
Required |
|
|
|
|
|
|
|