MS SQL (T-SQL) database developer

Компания из Швейцарии ищет программиста с опытом работы MS SQL Server (T-SQL) зарплата по итогам собеседования

Рабочее время 9.00-18.00

Swiss company look for SQL Developer experienced in MS SQL Server (T-SQL)

Working time 9.00-18.00 

Requirements

o    T-SQL-development

o    Procedures, Functions, Views, Trigger

o    Transactions

o    Error handling per RAISERROR, ROLLBACK and optional retry of the transaction

o    Schema separation of modules

o    Database design

o    Tables, normal forms, foreign key relations

o    Indexing technics (identification/determination of required indexes)

o    SQL performance tuningo    Index optimization, usage of clustered index vs. non clustered index

o    Execution plans & STATISTIC IO,TIME

o    Extended events & dynamic management views for SQL Server >= 2012 

o    Programming rules to avoid blocking and deadlocks