SQL Server DBA

Illinois  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

SQL Server DBA

This is a contract position for a SQL Server Database Administrator who will assist with implementing and supporting database solutions including upgrades, migration, implementation, setting security, management, configuration, performance tuning and optimization

Project management

Expertise in managing SQL Server 2005, 2008, 2012, 2014
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using SQL Server monitoring utilities such as Idera SQLdm, BMC Patrol, NewRelic, Spotlight, SQLSentry
Ability to detect/troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering
Experience with AlwaysON Availability groups, clustering, replication, log shipping, mirroring and storage replication technologies
Expert experience in implementing operational automation
Strong knowledge of indexes, index management, integrity checks, configuration, patching
Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
Solid acquaintance with windows server, security delegation, SPNs, storage components
Working knowledge of Business Intelligence (BI) platforms including SSIS, SSAS and SSRS
Any skills in open source and/or No SQL databases
Experience with Cloud database hosting providers AWS EC2, Azure VM and Azure SQL Database
Excellent written and verbal communications skills are necessary.
Highly organized, structured, and process oriented.
Ability to work independently as well as with a team.
Strong interpersonal skills with a desire to collaborate with internal and external business/technical teams.

Start date
n.a
Duration
1 year
From
Request Technology - Robyn Honquest
Published at
26.04.2017
Project ID:
1331826
Contract type
Freelance
To apply to this project you must log in.
Register