Accessability Links

SQL MI/BI Developer

  • Location: South East
  • Salary: £35000 - £45000 per annum + benefits
  • Job type: Permanent
  • Sector: IT & Information Security


MS SQL MI/BI Developer Job Description

Capita Data Services sits within Capita Application Services division and part of the Capita Software business. It serves as a Centre of Excellence within Capita Group providing a highly professional sales, support, project and consultancy services for over 85 internal and external clients. We support well in excess of 4000+ database server instances across multiple database technologies and versions, including the provision of end to end solution design capability through to business as usual support services. Data Services cover Database Administration and Consultancy, BI and Analytics, Data Warehousing and Data Migration services.

We are seeking to bolster the SQL DBA team in Chippenham or Reading and looking for talented and experienced MS SQL BI Developers to work alongside Development DBA roles.

The roles will report to the SQL DBA Team Leader, and will primarily be based out of Chippenham or Reading aligned to devOPS teams. Candidates may be expected to travel within the UK on an ad-hoc basis

The role requires any candidate to have the ability to attain SC level clearance.

Responsibilities

  • Input into the design and specification process to ensure best practice and standardisation of SQL builds
  • Install and configure SQL Server on single servers and clusters on physical and virtual (VMWare) environments
  • Using available tools (built in or 3rd party) and working with application support teams and vendors, health check SQL Server environments and propose recommendations for performance tuning and optimisation
  • Be able to review and tune SSIS code, SSRS and T/SQL to be more efficient
  • Create, maintain, optimize stored procedures, database and ETL processes
  • Develop and design BI Solutions to meet our customer needs
  • Develop SSIS packages
  • Debugging, monitoring and troubleshooting BI solutions
  • Writing relational and multidimensional database queries
  • Interact with report owners to establish/clarify their requirements and develop report specifications.
  • Provide technical assistance and cross training to other team members.
  • Impact assess change documents to identify deliverables and commercial impact
  • Work with the DBA support team to transition installations into ongoing support, including operational acceptance documentation
  • Keep abreast of new functionality that can be exploited by Support, Development and Applications teams to enhance the operability and/or performance of SQL-based applications
  • Contribute to the development of team processes, procedures and documentation and other continuous improvement initiatives
  • Support rest of team as required with general DBA support queries

Skills/Experience

Essential

  • Strong proficiency with T/SQL and the writing of Stored Procedures, reading query plans, tuning indexes and troubleshooting performance bottlenecks
  • Experience of Report Development (Microsoft SSRS)
  • Experience with package writing (Microsoft SSIS and ETL)
  • Installation, configuration of MSSQL up through SQL 2016
  • Have a clear understanding of n-tier application architecture and be able to recognise impacts or dependencies of related components on SQL server database architecture and efficiency
  • Experience of SQL HA Technologies
  • Experience of SQL DR Technologies
  • Experience of Backups, Restores and recovery models
  • Experience of working with Windows Server
  • Ability to obtain NPP3V and Security Clearances

Desirable

  • Analytics / OLAP Cube Development (Microsoft SSAS and MDX)
  • Data Warehouse / Solution Design
  • Dimensional Modeling
  • Understanding of Cloud Technologies ( Azure, AWS)
  • Understanding of Virtualisation Technologies
  • Experience of PowerShell
  • MS SQL Server Certification

Personal Attributes

  • Excellent written and verbal communication (English)
  • Excellent customer interaction skills
  • Excellent organisation and ability to prioritise time
  • Self-motivated and enthusiastic with a proactive approach to work
  • Able to work under pressure and to tight timescales
  • Analytical mind with a problem-solving aptitude

Capita IT Resourcing is acting as an Employment Agency in relation to this vacancy.

Start your search again

Similar jobs
.NET Developer
Hampshire £50000.00 - £75000.00 per annum
Apply
.Net Developer
Hertfordshire £50000 - £60000 per annum
Apply
.Net Developer
Reading, Berkshire £40000 - £60000 per annum
Apply
Back to Top