SQL DBA – BI focused environment – Leeds – £45k – REF CYCLE 440

·
Full time
Location: Wakefield
·
Job offered by: Interface Recruitment UK
·
Category: IT & Technology
Job Location

- 2 Globe Road, Tower Works, Leeds, LS11 9QG Qualifications

- Any MS Quals Salary : £40,000 - £45,000 per annum + 3% flexible benefits + on target bonus of 5% + contributory pension Shuttle bus from major train station Break out areas with gaming Purchase and sell holiday entitlement Family benefits with flexi bens Succession planning – great career prospects – growing company Responsibilities

We are looking for a SQL DBA to support our business operations, looking to identify improvements that can be made throughout the organisation. As the organisation is rapidly expanding, the systems need to expand with it, so a major part of this role will be to ensure we have capacity for future growth and to ensure stability. Working closely with the team, the SQL DBA will ensure that all IT policies and procedures are maintained in line with PCI DSS and ITIL guidelines. The successful candidate will also proactively review and evaluate new technologies so that the Database infrastructure can maintain the current and future business needs. We have a strong track record of sustainable growth which is set to continue - the team that helps to deliver that will be rewarded for their contributions with a competitive package including market rate salaries, flexible benefits and annual bonus. Experience Required

Demonstrable, recent experience of troubleshooting, optimizing and SQL server and associated client tools and systems based on SQL Server 2008, 2008 R2, and SQL Server 2012 SQL Server 2014 – Enterprise. Experience of both project and 1st, 2nd and 3rd tier support work on SQL Server - 2008 R2, SQL Server 2012, SQL Server 2014 – Enterprise. Migration and upgrades of SQL Server Instances - Microsoft SQL Server 2008, 2008 R2, SQL Server 2012 SQL Server 2014 – Enterprise. Managing both company “home-grown” and application driven databases supported by SQL Server/ DataWarehouse. Demonstrate recent experience of problem solving around query performance improvement, locking behaviour, blocking behaviour, deadlocks behaviour, and scheduled task failure and server performance management. SQL Server Development – and database design/optimisation. Experience of working in a fast-moving, energetic, commercially orientated environment - will be advantageous. Exposure to XML based data. Any c# or VB.Net will be valuable. Powershell Scripting - will be advantageous. Responsibilities

Reporting to the Data Services Manager your responsibilities will include: Day to day management and preventative maintenance of SQL Server Instances/ Data warehouse estate. Work with SQL/Data Warehouse development teams to improve service design, capacity planning and improve code performance. Performance monitoring, Optimization, identifying bottlenecks, respond to ad hoc alerts, and trouble-shooting of Databases/Data warehouse and Business critical applications. Work with Third party/infrastructure team/Storage engineers to improve hardware configuration/resilience and performance. Expert knowledge of Microsoft SQL-Reporting Services (SSRS), Microsoft SQL Integration Services (SSIS) and Microsoft SQL Analysis Services (SSAS). Expert knowledge of Microsoft Visual Studio 2008 & Business Intelligences Development Studio 2008 (BIDS 2008). Expert knowledge of Microsoft Visual Studio Team System 2008 & Team Foundation Server (TFS). Created and Manage SQL Agent System/Task Scheduler maintenance jobs for overnight ETL processes. Performance tuning of New/Existing indexes/Statistics and stored procedures used in current ETL process and existing SSRS reports on both SQL Server/Data warehouse etc. Operation of security schema and user access, extending the schema as required/appropriate. Preparing and deploying SQL batch scripts and management utilities and support of Development Life Cycles. Qualifications

Candidates will preferably hold Microsoft certification, MCTS (Microsoft Certified Technology Specialist) or MCITP (Microsoft Certified IT Professional) or willing to study towards this accreditation. Skills / Experience Requirements

Excellent interpersonal communication at all levels. Strong prioritisation and time management skills. Highly motivated and able to approach challenging situations in a calm, logical and methodical manner.

#J-18808-Ljbffr

Recent Jobs

London (On site) · Full time

Are you a smart, driven professional who takes pride in making a difference in local communities? Turner & Townsend’s Real Estate division is experiencing significant growth and we’re looking for an experienced industry professional with health project experience to join our high-performing and collaborative Project Management team. Why Join Us? Impactful Work: Contribute to social [...]Read More... from Assistant Project Manager – Healthcare See details

Chasetown (On site) · Full time

My client, Autosmart International are a manufacturing success story! Site Operations Manager – leading fast-paced manufacturing and warehousing About Our Client Autosmart International is a manufacturing success story, leading the field in vehicle cleaning products. We are the No.1 choice of automotive trade customers across the UK. We have doubled in size in the last [...]Read More... from Site Operations Manager See details

London (On site) · Full time

CSS are looking for an experienced duty officer to join our client’s team who are a local council responsible for all areas within the Tendering district. Working hours: All shifts are 8 hours long with various start times available: Monday to Friday – start times between 6AM – 3PM Saturday & Sunday – 6AM – [...]Read More... from Duty Officer See details