Senior engineer - DBA -SQL

TransUnion's Job Applicant Privacy Notice

What We'll Bring:

Key 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 ensuring High Availability and Fault Tolerant systems.
• Identify and execute on opportunities for automating relevant processes.
• Troubleshooting data issues, providing consultancy in the area of data growth and ongoing maintenance.
• Proof of Concept work to enhance and support the work of the System Build team.
• Contribute to and evangelise community best practices.
• Establish yourself as the Subject Matter Expert for the Product area you are embedded within.
• Ensuring that systems are compliant (SOX, PCI etc.).
• Manage own workload.
Your role will entail installing and configuring applications, automating all manual steps to ensure that deployments are repeatable, reliable and rapid. The role will not just see you provide this as an initial service but you will then provide the means to which the development function can self serve to perform these installations via performant automated pipelines.
Along the way, you will be required to proactively assist Product Delivery teams to troubleshoot issues within Route to Live environments, provide consultancy in the area of Route to Live pipelines and their ongoing maintenance.
As solutions develop you will assist development teams to ensure the operability of those solutions, often providing a bridge between development and operational teams.

What You'll Bring:

Essential Skills and Experience

• Held a DBA role for five or more years working with SQL Server (2017, 2019, 2022)
• Experience with SQL Server migrations and upgrades.
• Advanced use of T-SQL (stored procedures, SQL Agent Jobs, Deployment automation)
• Experience of High Availability / Disaster Recovery technologies (Mirroring, Always On Availability Groups)
• Experience of 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.
• Basic level of PowerShell scripting.
• 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

Impact You'll Make:

Desirable Skills and Experience:

• Held a DBA role for two or more years working with a range of On-Prem / Azure hosted Database technologies (Azure SQL Database / Managed Instance)
• Good knowledge of OLAP and SSIS.
• Familiarity with either Octopus Deploy, TFS/Azure DevOps Server.
• Monitoring toolsets (Splunk, Foglight etc.)
• Agile, Scrum, Kanban processes and methodologies
• Advanced PowerShell

This is a hybrid position and involves regular performance of job responsibilities virtually as well as in-person at an assigned TU office location for a minimum of two days a week.

TransUnion Job Title

Sr Engineer, Development Ops