Vitaver & Associates
14145 - DFA Sr. SQL DBA (onsite) - Little Rock, AR
Start Date
: ASAP Type:
Temporary Project Estimated Duration
:8 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
-ON-SITE ONLY -Expert Level SQL Database Administrator -Position is available for extensions. -NOTE: This position requires candidates that have recent hands-on experience in ALL aspects of SQL DBA Administration. MINIMUM: 6 Years Experience SQL Server 2016 (or later versions) database administration: • Installing and upgrading SQL Servers, including applying service packs • Performing routine database maintenance o Creating and scheduling SQL Server jobs to perform database maintenance activity o Rebuilding indexes o Updating statistics o Consistency checks o Monitoring error logs and event logs for database errors • 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 o Database Mail o SQL Server Health Checks and Policies • Managing SQL Server security and auditing o User security o Database roles 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 space to ensure storage is properly utilized o Index and statistics usage o Managing disk storage for Windows Failover Cluster Service (WFSC) • 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 Mirroring o Always On
Required: 4 Years Windows Server Administration experience: • Building and maintaining Windows Host and Guest Servers • 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
Start Date
: ASAP Type:
Temporary Project Estimated Duration
:8 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
-ON-SITE ONLY -Expert Level SQL Database Administrator -Position is available for extensions. -NOTE: This position requires candidates that have recent hands-on experience in ALL aspects of SQL DBA Administration. MINIMUM: 6 Years Experience SQL Server 2016 (or later versions) database administration: • Installing and upgrading SQL Servers, including applying service packs • Performing routine database maintenance o Creating and scheduling SQL Server jobs to perform database maintenance activity o Rebuilding indexes o Updating statistics o Consistency checks o Monitoring error logs and event logs for database errors • 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 o Database Mail o SQL Server Health Checks and Policies • Managing SQL Server security and auditing o User security o Database roles 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 space to ensure storage is properly utilized o Index and statistics usage o Managing disk storage for Windows Failover Cluster Service (WFSC) • 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 Mirroring o Always On
Required: 4 Years Windows Server Administration experience: • Building and maintaining Windows Host and Guest Servers • 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