Lead Engineer

Overview

Lead Engineer in the IT Ops DBA team, delivering and supporting database platforms for TU UK, building automated, highly available database environments and providing technical and supervisory leadership to other engineers.

What you'll do

• Build and maintain optimised and highly available database platforms.
• Build and continuously improve CI/CD pipelines so databases are deployed and configured using automation technologies.
• Establish consistent standards for providing highly available and fault tolerant systems.
• Identify and execute on opportunities to automate and streamline processes.
• Troubleshoot data issues and provide consultancy on data growth and ongoing maintenance.
• Develop proofs of concept to enhance and support the work of the UK IT Ops DBA team.
• Contribute to community best practices.
• Ensure systems are secure and compliant (SOX, PCI etc.).
• Provide supervisory and technical leadership for other engineers in the team.
• Provide UK business hours support for TU UK database platforms.
• Provide out of hours support as required, as part of the DBA on-call rota.

What you'll need

• At least five years' experience working as a Senior SQL Server DBA, with MS SQL Server (2014-current).
• Experience of supporting PostgreSQL in an enterprise environment.
• Experience with planning and delivering database migrations and upgrades.
• Advanced use of T-SQL (stored procedures, SQL Agent Jobs, deployment automation).
• Experience configuring and supporting High Availability / Disaster Recovery technologies (Mirroring, Always On Availability Groups).
• Experience configuring and supporting Replication (especially transactional with centralised distribution).
• Proven experience of working with sensitive data in a secure manner.
• Solid understanding of DevOps, Agile, Scrum, Kanban processes and methodologies.
• Familiarity with use of source control, especially around database projects (including branching, workflow, peer reviews etc.).
• Good technical understanding of TFS/Azure DevOps Server and Octopus Deploy.
• Good level of experience of PowerShell scripting and automation.
• Excellent troubleshooting and fault resolution skills.
• Good interpersonal and communication skills.
• Willingness to learn and embrace industry developments and practices from both a Development and Operations background.

Details

• Hybrid position: a minimum of two days a week in person at an assigned TU office location, with the remainder virtual.
• Includes DBA on-call rota duties for out of hours support.