he wants to apologize for not mentioning that this position is for experienced developers only. The main focus is strong MSSQL desgining background.
The following skills are essential:
• Experience of the following stages of developing a database:
o Requirements analysis
o Design
o Modelling
o Build
• SQL / T-SQL, including the following areas:
o Designing and scripting tables and views
o Managing indexes
o Working with transactions
o Using SQL permissions
o Experience of working with transactions
o Scripting triggers
o Scripting functions
o Creating ad-hoc queries
o Debugging
• Solid understanding and use of DTS/SSIS packages, including scripting within the package
• Experience of data cleansing (e.g. de-duping)
• Experience of data migration (including the use of DTS/SSIS)
• SQL Performance tuning.
• Use of Microsoft SQL Server Reporting Services
• Experience of working with XML both as an input data source, and producing it as an output
• Implementation experience
• Experience of working with Web Developers
