Previous Job
Previous
SQL Server Database Administrator - Chicago, IL
Ref No.: 17-01447
Location: Chicago, Illinois
Job Title : SQL Server Database Administrator
Location : Chicago, IL
Position Type :
Contract
Rate : W2 or 1099

US Citizen, Green Card, EAD preferred... No Thirdpaty agencies corp to corp.

Skills Required:
  • 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.