MS SQL Server 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

• T-SQL-development
• Procedures, Functions, Views, Trigger
• Transactions
• Error handling per RAISERROR, ROLLBACK and optional retry of the transaction
• Schema separation of modules
• Database design
• Tables, normal forms, foreign key relations
• Indexing technics (identification/determination of required indexes)
• SQL performance tuningo Index optimization, usage of clustered index vs. non clustered index
• Execution plans & STATISTIC IO,TIME
• Extended events & dynamic management views for SQL Server >= 2012
• Programming rules to avoid blocking and deadlocks