SQL DBA – BI focused environment – Leeds – £45k – REF CYCLE 440
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
Benefits:
1. Shuttle bus from major train station
2. Break out areas with gaming
3. Purchase and sell holiday entitlement
4. Family benefits with flexi benefits
5. Succession planning – great career prospects – growing company
Responsibilities
We are looking for a SQL DBA to support our business operations, identifying improvements that can be made throughout the organisation. As the organisation is rapidly expanding, a major part of this role will be to ensure we have capacity for future growth and stability.
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 proactively review and evaluate new technologies to maintain the database infrastructure that meets 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 an annual bonus.
Experience Required
1. Demonstrable, recent experience of troubleshooting, optimizing SQL Server and associated client tools and systems based on SQL Server 2008, 2008 R2, 2012, and 2014 – Enterprise.
2. Experience of both project and 1st, 2nd, and 3rd tier support work on SQL Server.
3. Migration and upgrades of SQL Server Instances.
4. Managing both company “home-grown” and application-driven databases supported by SQL Server/Data Warehouse.
5. Demonstrated experience of problem-solving around query performance improvement, locking behaviour, blocking behaviour, deadlocks behaviour, and scheduled task failure.
6. SQL Server Development and database design/optimisation.
7. Experience of working in a fast-moving, energetic, commercially oriented environment will be advantageous.
8. Exposure to XML based data.
9. Any C# or VB.Net will be valuable.
10. Powershell Scripting will be advantageous.
Responsibilities
Reporting to the Data Services Manager, your responsibilities will include:
1. Day-to-day management and preventative maintenance of SQL Server Instances/Data warehouse estate.
2. Work with SQL/Data Warehouse development teams to improve service design, capacity planning, and code performance.
3. Performance monitoring, optimization, identifying bottlenecks, responding to ad hoc alerts, and troubleshooting of databases/data warehouse and business-critical applications.
4. Work with third-party/infrastructure team/storage engineers to improve hardware configuration/resilience and performance.
5. Expert knowledge of Microsoft SQL Reporting Services (SSRS), Microsoft SQL Integration Services (SSIS), and Microsoft SQL Analysis Services (SSAS).
6. Expert knowledge of Microsoft Visual Studio 2008 & Business Intelligence Development Studio 2008 (BIDS 2008).
7. Expert knowledge of Microsoft Visual Studio Team System 2008 & Team Foundation Server (TFS).
8. Create and manage SQL Agent System/Task Scheduler maintenance jobs for overnight ETL processes.
9. Performance tuning of new/existing indexes, statistics, and stored procedures used in current ETL processes and existing SSRS reports.
10. Operation of security schema and user access, extending the schema as required/appropriate.
11. 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 be willing to study towards this accreditation.
Skills / Experience Requirements
1. Excellent interpersonal communication at all levels.
2. Strong prioritisation and time management skills.
3. Highly motivated and able to approach challenging situations in a calm, logical, and methodical manner.
#J-18808-Ljbffr