SQL DBA I (SQL, SSIS, Visual Studio)

SQL DBA I (SQL, SSIS, Visual Studio) - Chicago

Base Location - Chicago, IL

Job Description:

Mandatory:

• Has 5+ years of experience in database development and support in MS SQL Server environments.

• SQL Development ability to write and troubleshoot complex SQL code

• Experience writing SSIS packages.

• Experience designing stored procedures, functions, tables, views, triggers, indexes, constraints

• Strong knowledge of normalization, primary and foreign key constraints

• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.

• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

• Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.

• Knowledge of SQL Server tools ( Profiler, SSIS, SSMS, PerfMon, DMVs)

• Experience working with JSON and XML

• Documentation skills for processes and procedures (creating KBs, whitepapers, topology diagrams)

Preferred:

• Experience working with Visual Studio Database Projects desired

• Experience working in a Windows Azure Environment

• Knowledge of both Azure SQL Database as well as IAAS SQL Servers are desired