Role Overview And Core Responsibilities
Building and maintaining optimised and highly available database platforms.
Building and continuously improving CI/CD Pipelines to ensure 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.
Troubleshooting data issues, providing consultancy in the area of data growth and ongoing maintenance.
Proof of Concept development to enhance and support the work of the UK IT Ops DBA team.
Contribute to community best practices.
Ensure that 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 requires, as part of the DBA on-call rota duties
Required Knowledge And Experiences
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 on database migrations and upgrades.
Advanced use of T-SQL (stored procedures, SQL Agent Jobs, Deployment automation)
Experience of configuring and supporting High Availability / Disaster Recovery technologies (Mirroring, Always On Availability Groups)
Experience of 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/fault resolution skills.
Good interpersonal and communication skills.
Willingness to learn and embrace industry developments and practices from both a Development and Operations background.
TransUnion Overview
At TransUnion, we encourage and are committed to creating a real, positive impact and shared sense of purpose within our Workforce for Good, which empowers our people to grow, innovate and contribute to a better future for our communities and customers. We strive to build an environment where our associates are in the driver’s seat of their professional development— while having access to help along the way. We recognize that success comes when our associates thrive both professionally and personally; that’s why we prioritize work/life flexibility and offer resources for our teams across the globe to collaborate and drive excellence.
Be a part of our Workforce for Good – you’ll work with great people, pioneering products and cutting-edge technology.
TransUnion Job Title
Lead Engineer, Database Engineering