Sr. SQL DBA

Novalink Solutions LLC•Little Rock, AR

About The Position

The Senior SQL Database Administrator role requires recent hands-on experience across all aspects of SQL Server database administration. The position is available for extensions. Candidates must have at least four years of SQL Server 2022 or later database administration experience and three years of Windows Server administration experience. The posting also lists SQL Server 2016 or later as a required skill with four years of experience. The role covers SQL Server installation and upgrades; routine maintenance; use of SQL Server tools and services; security, auditing, and encryption; storage capacity planning; backup and recovery; disaster recovery planning; T-SQL coding and tuning; ETL methodologies; and high-availability support, including Always On and AWS HA Zones. Windows responsibilities include building and maintaining Windows Servers and EC2 instances, configuring server roles and features, managing endpoint protection, and maintaining Windows Failover Clusters. The posting lists GenTax software architecture and application maintenance as desired experience. Other preferred knowledge includes security standards, cloud technologies, firewall administration, Active Directory, email and proxy troubleshooting, and web services. Availability to provide 24-hour support and strong oral and written communication skills are also specified.

Requirements

At least 4 years of SQL Server database administration experience, including the listed administration responsibilities; SQL Server 2022 or later is specified in the job description.
At least 4 years of SQL Database administration experience with SQL Server 2016 or later, as listed in the requirements section.
At least 3 years of Windows Server administration experience, including the listed responsibilities.
Recent hands-on experience in all aspects of SQL DBA administration.
Availability to provide 24-hour support.
Strong oral and written communication skills.

Nice To Haves

Experience with FAST GenTax/DS-VS architecture and application maintenance; GenTax software application architecture and maintenance are listed as desired.
Familiarity with industry security standards, including PUB1075, FIPS, and PII.
Cloud computing knowledge.
Knowledge of cloud storage, backup, and restore mechanisms.
Firewall administration and maintenance experience.
Active Directory knowledge, including GPO, FQDN, DNS Server, and SPN.
Experience troubleshooting email, SMTP, and proxy servers.
Web services development and support experience.

Responsibilities

Install and upgrade SQL Servers, including applying service packs and cumulative updates.
Perform routine database maintenance, including managing SQL Server Agent jobs and monitoring database error and event logs.
Use SQL Server tools and services, including Profiler, Index Tuning Advisor, Configuration Manager, Extended Events, Performance Monitor, Dynamic Management Views, SQL Server Broker Service, Linked Servers, and MSDTC.
Manage SQL Server system databases, health checks, and policies.
Manage SQL Server security and auditing, including user security, authentication, database and server auditing, and encryption at rest, in transit, and in backups.
Plan capacity for storage and database objects; manage SQL Server disk storage and AWS storage systems, and manage disk storage for Windows Failover Cluster Service.
Establish database backup standards and schedules, develop recovery procedures to meet RPO and RTO, and restore databases using point-in-time recovery.
Create and test disaster recovery plans.
Develop, tune, and support T-SQL code and ETL methodologies.
Support SQL Server high-availability methods, including Always On and AWS HA Zones; monitor, support, and troubleshoot very large databases and high-intensity systems handling online and batch transactions.
Build and maintain Windows Servers and EC2 instances.
Install and manage endpoint protection.
Configure and maintain application, web, file, and FTP servers.
Use PowerShell for administration tasks.
Configure and maintain Windows Failover Clusters and manage Windows Server roles, features, and .NET Framework components.
Provide 24-hour support availability.
Communicate effectively, both orally and in writing.