SQL Server install and configuration using best practices (DB Engine, SSRS, SSIS, Full Text), etc. on stand-alone VM, MSCS, Always On, etc.
Tools used for troubleshooting such as, but not limited to: SQL Profiler/Trace Events, Spotlight (or similar) Playback, DMVs, Windows Events, etc.
T-SQL such as for, but not limited to, identifying and removing duplicate records, breaking apart stored procedures and running as direct queries to resolve an issue, etc.
Creating and managing Linked Servers
SSRS: identifying the queries involved in the reports, making minor changes to the report structure, etc.
SSIS: locating and managing dtsx packages to resolve issues
Diagnostic and troubleshooting skills
Required 2+ years of experience with Microsoft Exchange Server Administration and Engineering to include Enterprise versions 2010, 2013, and Office 365.
Required 3+ years of experience with Windows Server Administration and Engineering to include Standard and Enterprise versions of Windows Server 2008 and above.
Preferred 5-8 years of Microsoft Active Directory experience
Preferred 5-8 years of experience in virtualization using VMWare Server Virtualization to include ESX Versions 3.X - 5.X.
Minimum of 4 years of experience in MS Patching, troubleshooting and maintaining.
