Senior Infrastructure Engineer

Job title: Senior Infrastructure Engineer – SQL Server, DBA

Salary: £65-70k
Location: Pier Walk, North Greenwich - Hybrid
Contract Type: Permanent TFL Band 3

Overview of project/role 

An opportunity to join the Networks and Hosting Team within, Technology Service Operations (TSO) which is part of the Technology, Product and Operations. 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 SQL team is made up of approximately 6 SQL infrastructure DBAs and delivers technical expertise to aid the implementation, maintenance, and support of core technology.

The Role

Our culture is one of trust and empowerment. We are committed to developing our people and supporting them in their aspirations and career progression.

As a Senior Infrastructure Engineer, you will technically lead you team of 4 Infrastructure Engineers in the day- to- day delivery of SQL related work, working closely with other specialist areas and Senior Engineers.

You will also get involved in strategic decision making and planning for any MS SQL requirements. This includes acting as a “go to” point of contact that represents your function, for technical related topics. 

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

Skills

• Expert level knowledge and experience of SQL Server database administration; maintenance, security and support
• Highly experienced in planning team resourcing.
• 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.
• Proven ability to work with suppliers, internal teams and customers as necessary to reliably deliver component technologies that combine to form business services.
• Can demonstrate their ability to research, gather facts and data to support informed decision making and recommendations.

Essential

• SQL Server 2022, 2019, 2017, 2016 and legacy database SQL Servers versions
• Cloud: Azure; AWS, AWS RDS
• Background in database design and creation and maintenance of build standards and guides.
• Supporting the Infrastructure Manager with MIS Reporting, managing the lifecycle and roadmap with the Product Manager with industry best practice and creating standard building blocks.
• Scripting: T-SQL & PowerShell
• Experience in SQL Server licensing models and supporting software assurance management (SAM) Partner.
• 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.
• Monitoring, Backup and Recovery, HADR, troubleshooting, capacity planning, security, upgrades.
• 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, Query Store and Extended Events
• AlwaysOn Availability Groups, Clustering, Log Shipping, Replication, Encryption
• Extensive experience of supporting SQL Server Databases in a complex, multi-site, environments
• ITIL: experience working with incident management, service requests, change management and problem management
• SQL Server Service Improvements and Capacity Management.
• Experience and available for 24/7 on-call rota and Out of Hours planned work.

Desirable

• Monitoring tools: Dynatrace, SCOM. Azure Monitor
• Backups tools: AVAMAR EMC
• ITSM: Remedy
• Scripting: Python
• Experience/ Working knowledge of any open source object-relational databases system such as Postgres and document-oriented database such as MongoDB.
• Working knowledge of Azure local.

Equality, diversity and inclusion 

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.

Application Process  

• Please apply using your CV. Word format preferred and do not include any photographs or images 

The closing date for applications is 4/8/2025 @ 23:59 

Benefits

 
In return for your commitment and expertise, you will enjoy excellent benefits and scope to grow.  Rewards vary according to the business area but mostly include: 

• 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 
• EV Salary Sacrifice Scheme