SQL Server DBA

Job information SQL Server DBA from the Company Transport for London, this latest SQL Server DBA job vacancy is located in the city Hybrid work in London. This latest job opening is open to job seekers who have the latest education / graduate . Job Vacancies in this Engineering field have been opened and published up to the specified time.

Job Description :

SQL Server DBALocation: Hybrid - North Greenwich, London and home workingSalary: £52-58k (DOE) + on call allowance

Hybrid working within this role enables a balance of 50 per cent of time split between the office and home over a 4-week period. Hybrid working arrangements can evolve subject to business requirements.

An opportunity to join the Networks and Hosting Team within, Technology Service Operations (TSO) which is part of the Technology & Data business unit. Networks and Hosting are responsible for managing and maintaining TfL's core SQL Server database infrastructure. The infrastructure host over 40 Mission Critical and Business Critical services including the London Underground, Overground, Buses and Trams which ultimately keep TfL services to our customers running. The Team

The team is made up of approximately 5 SQL Server infrastructure DBAs and delivers technical expertise to aid the implementation, maintenance, and support of core technology

The Role:

As an Infrastructure Engineer, you will carry out day to day technical activities, guided by a Senior Engineer. The role also is required to work on projects implementing and enhancing databases for TfL applications. Some engagement with stakeholders such as Project Manager, Developers, End Users, Product Manager and Infrastructure engineers from other IT Infrastructure technologies is required. The team is responsible for the lifecycle support of current products versions and existing legacy ones.

There may also be requirement to support out of hours work and on-call for TfL's 24/7 supported services.

Skills:

• Experienced in planning own activities and input to larger team activities.
• Delivering to agreed plans.
• Highly skilled at analysing data to determine trends and patterns to proactively mitigate service affecting issues.
• Proven ability to convey technical information to non-technical people and the business risks and impacts. Ability to help influence decisions and outcomes at all levels.
• Knowledge of aligned platforms with SQL Server such a WINTEL to input into design reviews and approvals.
• Experience of working with Virtualisation Technologies such as VMWare.
• DBA experience: monitoring, backup and recovery, high availability, troubleshooting, capacity planning, security, upgrades (SQL versions/patches/hotfixes).
• Project work: installation and configuration, database upgrades/migrations/copies.
• TSQL scripting, PowerShell, SSIS - SQL Server Integration Services, SSRS - SQL Server Reporting Services,
• Performance Tuning: Performance monitor, SQL Server Profiler, DMVs, Resource Governor.
• Availability Groups, Clustering, Log Shipping, Replication, Encryption
• Extensive experience of supporting SQL Server Databases in a complex, multi-site, environments
• ITIL: experience working with incidents, service requests, changes, problems.
• Experience and available for 24/7 on-call rota and Out of Hours planned work.

Desirable

• Monitoring tools: SCOM. Azure Monitor, Dynatrace
• Backups tools: Avamar.
• Experience of key applications related to SQL Server: Remedy, SCOM, SharePoint, and Citrix. Web services.
• SSAS - SQL Server Analysis Services SSIS, SSRS - Ideally experience of PowerBI
• Relevant SQL Server certifications aligned to supporting TfL essential SQL Server technologies listed above.
• Project work: installation and configuration, database upgrades/migrations/copies.

Closing Date for applications: Tuesday 8th July @ 23:59

We are committed to equality, diversity and inclusion. We want to represent the city we serve, which will help us become a more innovative and efficient organisation. Our goal is to make our recruitment as inclusive as possible. We are a disability confident employer who guarantee an interview to any disabled candidate who meets all of the essential criteria. We also use anonymising software that removes identifying information from CVs and cover letters to make the process fair.

Please note that you must apply by using your CV (Word.docx format) and a covering letter (no more than two pages). Please think carefully about the skills, knowledge and experience outlined in the job description and ensure your CV reflects the requirements of the role. We will endeavour to give candidates as much notice as possible however some interviews/assessments will be organised at short notice and will require a degree of flexibility.

Benefits

In return for your commitment and expertise, you will enjoy excellent benefits and scope to grow. Our benefit package includes:

• Final Salary Pension Scheme
• Free travel for you on the TfL network
• A 75% discount on National Rail Season Ticket and interest free loan
• 30 days annual leave plus public and bank holidays
• Private Healthcare discounted scheme (optional)
• Tax-efficient cycle-to-work programme
• Retail, health, leisure and travel offers
• Discounted Eurostar travel