Please reply to anki...@damcogroup.com
*Title: SQL SERVER DEVELOPER * *Duration: 6 months (& Can be extendable to 1 year)* *Location: Barrington, IL* *Must passport copy!!* · *Has 10+ years of experience in database development and support in MS SQL Server environments.* · Experience understanding the *healthcare/HL7 data* · Willingness to learn production DBA skills such as *High Availability* · SQL Development – ability to write and troubleshoot complex SQL code · Strong SSIS Development Experience a plus · Experience working with various reporting tools such as Tableau or Reporting Services · *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 -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at https://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.