Database Administrator (Ref: 355708)
Company Name:
Professional Technology Integration Inc
Position: Database Administrator (Ref: 355708)
Location: Little Rock AR 72201
Salary: $35 /hr.
Duration: 8
Year - Contract
Local candidates preferred, but not required.
Face-to-face interviews for local candidates, skype or phone for out-of-state.
Years of
Experience: 3 to 5 years
Education: 4 year college degree or equivalent technical study
Responsibilities:
Installing and Upgrading SQL Servers including applying Service Packs
Monitoring the Database Servers 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
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 identify 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
Strong communication skills; both written and spoken
Execution of all responsibilities with little direct supervision of Team Lead.
Software Knowledge:
Windows Server 2003
SQL Server 2000, SQL Server 2005 and SQL Server 2008
Quest Spotlight Performance Monitoring software
Required / Desired Skill
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 desiredEstimated Salary: $20 to $28 per hour based on qualifications.
Professional Technology Integration Inc
Position: Database Administrator (Ref: 355708)
Location: Little Rock AR 72201
Salary: $35 /hr.
Duration: 8
Year - Contract
Local candidates preferred, but not required.
Face-to-face interviews for local candidates, skype or phone for out-of-state.
Years of
Experience: 3 to 5 years
Education: 4 year college degree or equivalent technical study
Responsibilities:
Installing and Upgrading SQL Servers including applying Service Packs
Monitoring the Database Servers 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
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 identify 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
Strong communication skills; both written and spoken
Execution of all responsibilities with little direct supervision of Team Lead.
Software Knowledge:
Windows Server 2003
SQL Server 2000, SQL Server 2005 and SQL Server 2008
Quest Spotlight Performance Monitoring software
Required / Desired Skill
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 desiredEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
