Accessability Links

SQL DBA

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

SQL DBA Developer needed to join Capita Data Services which 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 SQL DBA's to fill Development DBA roles.

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

The role requires participation in an on-call scheme as the team operates a call out rota 24/7x365 where overtime is funded. This includes attending onsite for call out for secure clients on occasion.

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

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
Data Migration Analyst
Reading, Berkshire £35000 - £55000 per annum + benefits
Apply
Data Migration Engineer - SQL / Microsoft Dynamics 365
Reading, Berkshire Up to £0.00 per day
Apply
Back to Top