Job ID :
2252
Company :
State of Arkansas
Location :
little rock, AR
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
5 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

Short Description:

 

The DBA will be responsible for maintaining multiple databases in support of the Department of Finance and Administration applications.

 

Complete Description:

The Client is using GenTax Software for this project.  Any previous experience with GenTax would be very helpful.

 

Years of Experience: 3 to 5 years

Education: 4 year college degree or equivalent technical study

 

Installing and Upgrading SQL Servers including applying Service Packs

Monitoring the Database Server’s Health and Tuning

  -Optimal server performance

  -Monitor the error log or event log for database errors

  -Routine database maintenance, and the overall system maintenance

Maintaining and Managing SQL Server Disk Space to make sure the storage utilized properly

Performing Backup and recovery

  -Establishing standards and schedules for database backups

  -Developing recovery procedures for each database

  -Making sure that the backup schedules meet the recovery requirements

Managing Database Users and Security

Working with Developers to tune queries, how to use indexes etc.

Log shipping Transaction Log

Transferring Data – Importing and Exporting data to and from the SQL Server.

Create and Scheduling SQL Server Jobs to perform database maintenance activity

Establishing and Enforcing Standards

Create and Test Disaster Recovery Plan

Providing 24 Hours support

 

Other Responsibilities:

Knowledge of using FTP Software to transfer files to and from FTP Servers

SQL Server RDMS Knowledge:

  -SQL Server Version: SQL Server 2000, 2005 and 2008

  -Good understanding of SQL Server Databases

  -How to do disk backup as well as TAPE backup

  -Knowledge of restoring databases with point in time recovery

  -Knowledge of Transaction Log shipping

  -Knowledge of SQL Server Profiler to run Trace to indentify performance issue

Index tuning 

Knowledge of using SQL Server Jobs and Scheduling

How to create Database Mail Profile, alerts and operators

Knowledge of Linked Servers

Knowledge of how to use integration services or SSIS Packages to import and export data from/to sql server database

Good TSQL Knowledge

 

Software Knowledge:

 

Windows Server 2003

SQL Server 2000, SQL Server 2005 and SQL Server 2008

Quest Spotlight Performance Monitoring software

 

Strong communication skills; both written and spoken

Execution of all responsibilities with little direct supervision of Team Lead.

 

Skills:

SQL Server 2000, SQL Server 2005 and SQL Server 2008

Required 5 Years

 

TSQL Programming

Required 5 Years

 

Transaction Log shipping

Required 3 Years

 

SQL Server Profiler to run Trace to indentify performance issue

Required 3 Years

 

Index tuning

Required 3 Years

 

SQL Server Jobs and Scheduling

Required 3 Years

 

Integration services or SSIS Packages to import and export data from/to sql

Required 3 Years

 

Restoring databases with point in time recovery

Required 3 Years

 

GenTax Tools like SQR, ACR/FCR, Migrations, Doc

Highly desired

 

GenTax Specific Services

Highly desired