Sr. MS SQL Server Remote DBA
Looking for a Sr. Microsoft SQL Server DBA that would be able to quickly get up to speed with the current ERP environment. Must have SSIS and SSRS experience, Data Warehouse/SSAS experience a plus, but no required. This is a 12 month 1099 opportunity in Chicago. The first month will be required onsite, after can work remotely. • Has 5+ years of experience in database development and support in MS SQL Server environments. • Strong experience in Database Administration in SQL Server ( 2005 and 2008 ) • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, log shipping issues, connectivity issues. • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. • Ability to detect and 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, Database mirroring, Replication. • Expert experience in implementing operational automation. • Strong knowledge of how indexes, index management, integrity checks, configuration, patching. • Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs) • SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints ) • Solid acquaintance with windows server, security delegation, SPNs, storage components. • Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
Related projectsSearch for freelance jobs
can’t wait for more clients
and advertising. Thank you."