|
Search Jobvertise Jobs
|
Jobvertise
|
SQL DBA I (SQL, SSIS, Visual Studio) Location: US-IL-Chicago Jobcode: dac35c90080dbb24a845e255499d29a0-122020 Email Job
| Report Job
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
Vegatron Systems
|