SQL DBA / Business Intelligence Developer

Sector:
IT
Job Type:
Full Time
Region:
South East
County:
Surrey

Town/City:
Guildford, Surrey
Salary:
£35,000 to £48,000 per annum

Our client, based in Guildford, is looking for an experienced SQL DBA / Business Intelligence Developer.

Key Purpose:
Business Intelligence Development, Database Management and Administration.

Key Tasks:
Design and Development of Data Warehouse and associated ETL processes, cubes and dashboards.
Work with stakeholders to define reporting requirements and translate them into dimensional models.
Troubleshooting SQL errors/issues on Production and Development Environments.
SQL Server Performance Tuning / Optimisation.
Automation of Administrative Tasks utilising T-SQL and PowerShell.
Database Design and Architecture.
Responsible for the security and availability of the SQL Server environment.
Review and improve existing processes, procedures and infrastructure.

Qualifications:
Degree in Computing or equivalent desirable.
MCP, MCSA or MCSE in Data / Analytics desirable

Experience:
Design and development of solutions utilising the Microsoft Business Intelligence Stack (SQL, SSIS, SSAS, SSRS and Power BI).
Kimball data warehousing methodology and dimensional modelling.
SQL Server Administration (performance tuning, optimisation, HA/DR and backups) in versions from 2008 R2 to 2016.
Knowledge of C# ASP.NET MVC web application development to assist in communication with other developers would be beneficial.

Knowledge & Skills:
Microsoft BI Stack - T-SQL, SSIS (with BIML), SSAS (Tabular), SSRS, Power BI and DAX
Power BI Report Server.
PowerShell.
Dimensional Modelling.
SQL Server Administration (performance tuning, optimisation, HA/DR and backups).
Failover Clustering and AlwaysOn Availability Groups.
Microsoft Team Foundation Server.
Agile development (Kanban).
Exposure to other Microsoft software (SharePoint and Dynamics).

Index Recruiters is acting as an Employment Agency in relation to this vacancy.

If you would like to apply please send your CV to fleet@indexrecruiters.co.uk together with your salary requirements, notice period and reasons for leaving past and present employment.

"Due to the high volume of applications we currently receive, we are unable to respond to all candidates. If you do not hear from a Consultant within 5 working days unfortunately you have been unsuccessful on this occasion".

You may return to your current search results by clicking here.

Latest Job Listings