SQL Server Developer

Arrows Group Professional Ltd
19 Oct 2016
17 Nov 2016
Contract Type
I have an opportunity with an established broadcasting company. They are searching for SQL Server Developer with experience of SQL Server Integration Services. You will get a chance to work with large scale data migration projects (Microsoft SQL Server T-SQL).

Your responsibilities will include:

- Taking ownership of and working to complete a major transformation project to develop a single Commercial Airtime Sales data warehouse supporting major Commercial system changes.
- Working with the client's SME team to understand the existing Commercial databases, business context and future development needs
- Becoming an expert on client's Commercial data sets, the business meaning and context.
- Analysing data warehouses usage, growth pattern and redundant areas.
- Sizing database requirements and hardware platform with a 10-year lifetime view but with the possibility of migrating to the cloud at an earlier stage.
- Liaising with other client's infrastructure teams on the provisioning of hardware/software
- Designing and evolving warehouse database structures to accommodate changing requirements and to support other development team needs.
- Developing the ETL packages and custom coding needed to load data warehouse from external data sources
- Creating automated unit, integration and end-to-end testing for ETL packages and databases.

You will need to work well with technical and non-technical team members to deliver the right solutions as a team.

As part of a wider engineering community you'll have the opportunity to draw on support from people working in different areas of the business.

Client is looking for someone who:

- Has at least five years' experience designing, developing and implementing relational and non-relational DBMSs. This must include Microsoft SQL Server , MySQL, ProgreSQL, CouchDB, cloud databases and others are an advantage.
- Has specific knowledge of SQL Server 2014 onwards including Enterprise Edition features and performance optimisation features.
- Has some years' experience in designing and implementing data warehouse and data marts using ETL processes with SQL Server SSIS and other tools from external data sources.
- Is totally at ease with managing a large T-SQL code base, with hundreds of SSIS packages and stored procedures.
- Has experience of using report writing tools, e.g. SSRS, writing SQL to query data from data warehouse views and cubes.
- Is experienced with TDD methodologies and test automation as can be applied to database development
- Has knowledge of Continuous Integration techniques and application to database development