Job Title: SQL Server DBA (US Citizenís & GC Only)
Location: Little Rock, AR
Duration: 12 Months Contract
Start Date: ASAP
Interview Process: Phone Hire with (DIRECT CLIENT)
The DBA will be responsible for maintaining multiple databases in support of the client.
The Client is using GenTax Software for this project.
Any previous experience with GenTax would be very helpful.
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
Good TSQL Knowledge Software Knowledge: Windows Server 2003 SQL Server 2000, SQL Server 2005 and SQL Server 2008 Quest Spotlight Performance Monitoring software Required/Desired Skills that need to be noted on candidate for submission process *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 identify 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