DFA IT Product Specialist

Responsible for establishing, maintaining and optimizing the central infrastructure, application instances and databases that are required by both the AIRS Tax and AIRS DSMV systems. 

 

The scope of services will also include problem resolution, analysis and other support services at the discretion of the AIRS Information Systems Manager. This engagement will last for the existing term which runs through June 30th, 2019.

 

Roles and Responsibilities

•Minimum of nine (9) years of each item below:

•Experience working with GenTax application environments

•Installation/maintenance of GenTax applications and services and all GenTax tools

•Experience troubleshooting connection issues with AIRS (Arkansas Integrated Revenue) applications and web services and infrastructure includind AIRS – TAX and AIR DSMV (Drivers Services/Motor Vehicle)

•Experience building and troubleshooting AAMVA UNI application

•Minimum of nine (9) years of SQL Server installation, maintenance, and optimization experience

•Experience monitoring database server health and performance tuning of very large databases with high OLTP transactions/second

•Good knowledge of MSDTC

•Experience maintaining and managing SQL Server disk space to insure proper utilization of storage

•Experience with management of very large SQL databases

•Experience performing SQL database backup and recovery; establishing standards and schedules for backups; developing recovery procedures; and ensuring backup schedules meet recovery requirements

•Experience managing database users and security, and establishing and enforcing standards

•Experience with design and maintenance of SQL Server auditing

•Vast knowledge of TSQL, and the ability to tune queries and assist others in tuning their queries

•Experience rebuilding database indexes, index tuning, and updating database statistics using maintenance plans

•Experience performing database consistency checks

•Experience with log shipping, mirroring, high availability techniques like Always On

•Experience creating database mail profile, alerts, operators, linked servers

•Experience with design and maintenance of TDE Encryption and database compression

•Experience using integration services or SSIS packages to import and export data to/from SQL

•Minimum of five (5) years of Windows Server installation and maintenance experience in standalone, cluster, and VMware/HyperV environments

•Experience managing/maintaining VMware ESXI hosts, VMware guest servers, data stores, and vCenter

•Experience designing and testing disaster recovery plans

•Experience with file server and FTP server maintenance and troubleshooting

•Knowledge of SAN technologies and mount point storage assignment

•Knowledge of network infrastructure components, such as DNS Server, WINS Server, Time Server, ACL, VLAN, ASA, and VPN Tunnel

•Experience with F5 iRule maintenance

•Ability to write and review VB.Net code

•Strong oral and written communication skills

•Experience developing detailed technical infrastructure diagrams and specifications

•Ability to be on call to provide 24 hour support

•Education requirement of a BS degree in Computer Science, Information Technology or other equivalent education.

 

Skill

Required / Desired

Amount of Experience

SQL Server 2008 R2, 2012, 2016

Required

8 Years

SQL Server Profiler, Index Tuning Advisor, Configuration Manager, Database Maintenance Plans, Performance Tuning, MSDTC

Required

8 Years

SQL Server Jobs and Scheduling; rebuilding and tuning indexes; updating statistics; consistency check; alerts; operators; linked servers; Mail Profile

Required

8 Years

SQL Server Security administration, SQL Auditing, TDE Encryption

Required

8 Years

SQL database backup and recovery design, scheduling, and maintenance

Required

8 Years

TSQL

Required

8 Years

Windows Server 2008 R2, 2012, 2012 R2, 2016

Required

5 Years

Windows clustering, server administration, security updates

Required

5 Years

GenTax Application and Architecture

Required

5 Years

GenTax Tools and Services

Required

5 Years

Disaster Recovery design and testing

Required

5 Years

TSM, LiteSpeed, VMware, VB.Net, FTP

Required

5 Years

DNS Server, WINS Server, ASA, VPN Tunnels, VLAN, F5, SAN

Required

5 Years

Reach Out to a Recruiter


  • :
  • :
  • :