*Rate:- $40* *VISA & Photo ID Must*
USG direct client is looking for *Senior SQL Server Developer *at* Johnston, IA* *Skills / Development experience:* · Create database objects such as tables, views, stored procedures, triggers etc. using T-SQL · Create and maintain Entity Relationship Diagrams (ERD) · Understand the importance and identify methods to maintain referential, domain and column integrity · Identify columns for primary and foreign keys · Understand the value and impact triggers. Understand how to balance the pros / cons of implementing triggers · Performance tuning/Locking experience: · Ability to read and interpret query execution plans · Ability to define and execute appropriate steps to improve query performance from results of query execution plan · Define general performance recommendations for database development and index plans / maintenance · Understand the differences between stored procedures, views, and functions · Understand what leads to blocking, deadlocking in a single piece of code or across multiple areas (procedures / views / integration) · Understand how to write code to avoid locking / deadlocking situations. · Understand fill factors and general index maintenance strategies · Understand clustered vs. non-clustered indexes including underline structure · *Microsoft Azure experience.* *Please share your updated resume at *akansh...@usgrpinc.com* or feel free to contact me at **614-401-5194* -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at https://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.