Tony Rogerson's ramblings on SQL Server

There is a job going in Bristol (see below), if you are interested and experienced enough for the role then please email me tonyrogerson@sqlserverfaq.com and I'll forward your details onto the agent - note; obviously - do so before the end of June 2009 as google will index this and the job position may filled quickly. UK folks only!

Job Title - MS SQL DBA OLAP developer
Position - Permanent
Location - Bristol

XXX is a leading distributor of digital media with clients throughout the world.  We are responsible for the complete hosting and distribution process of digital media from receipt from copyright holder to distribution to end users, revenue collection, royalty payments and a multitude of steps in between. We are currently undertaking a number of cutting edge development projects within the areas of PC, mobile and services; and are therefore looking to expand our already impressive development team.  We are looking for a MS SQL DBA OLAP developer to help us grow and develop our MS SQL Server Data Warehouse to support the predicted volumes and proposed new business models. Required technical experience:

• Extensive experience with SQL Server as a database developer
• Ability to produce technical documentation to support solutions implemented
• Commercial experience with
• MS Business Intelligence studio
• MS SQL 2005 Analysis Services as a cube designer (including working knowledge of MDX)
• MS SQL 2005 Reporting Services
• MS SQL 2005 Integration Services
• Visual Studio Team Edition 2005 for Database Professionals
• Designing, testing, developing and delivering Kimball-style star schema data warehouses – including good dimensional modelling experience.
• Financial reporting systems
• Management information systems
• Team Foundation Server
• Multi-terabyte SQL databases

• Developing reporting and business intelligence solutions using the MS SQL 2005 Business Intelligence product stack
• Ability to analyse and maintain existing solutions
• Strong working knowledge and understanding of software development lifecycles

Personal traits:

·         Self motivation and drive
·         Strong team working skills
·         Be able to deliver technology solutions within a dynamic environment
·         An excellent level of attention to detail
·         A strong sense of ownership
·         Excellent communication skills, both verbal and written 

• .NET development (C#, VB etc)
• SQL2008 server
• Distributed architecture (hardware and software)
• Test driven development techniques
• Working within cross functional agile project teams

• Development of the data warehouse solutions using MS SQL 2005 business intelligence platform
• Delivering appropriate technical solutions to meet business needs
• Providing accurate technical documentation and estimates
• Working in collaboration with other colleagues to deliver solutions that bring business value