System Build Database Engineer

TransUnion

  • Leeds
  • Permanent
  • Full-time
  • 30 days ago
What We'll Bring: TransUnion UK provides the data, analytics and software that enable businesses to build more valuable customer relationships.We specialise in managing consumer data for businesses across every sector. We focus on developing innovative products and services that help businesses make smarter and more informed decisions throughout the customer lifecycle.We’re TransUnion and we believe in Information for GoodWhat You'll Bring:Working alongside and collaborating with Product Delivery teams on a daily basis you will be focused on helping to deliver new and key capabilities into the business.You will play a critical role in ensuring that systems are tuned and built to scale with proper controls in place to ensure high availability.Your role will entail building and maintaining optimised and highly available database platforms, 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 lead or 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 plus ensuring that teams understand the critical importance of oversight in how data is managed and secured.As solutions develop you will assist development teams ensure the operability of those solutions often providing a bridge between development and operational teams.For the avoidance of doubt, this role will involve you providing support during core business hours Monday to Friday with no expectation that you will provide on-call out of hours support. You will however be required to assist with performing deployments out of core business hours as and when required.Day-to-Day you will:
  • 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.
Skills and Experience
  • Held a DBA role for five or more years working with SQL Server (2014, 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.
Desirable Skills and Experience:
  • Held a DBA role for two or more years working with a range of Azure/AWS hosted Database technologies (Azure SQL Database / Managed Instance, Cosmos DB, Dynamo DB)
  • 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
Essential Certification:Candidate should either possess or can demonstrate they are working towards the following:
  • Any recent Microsoft SQL Certification
Desirable Certification:Candidate should either possess or can demonstrate they are working towards any of the following:
  • AWS Cloud Practitioner
  • AWS Database Specialty
Impact You'll Make:What’s In It For you?At TransUnion you will be joining a friendly, forward thinking global business.We’re happy to talk flexible working. We operate a hybrid model allowing you to explore the balance of work and hours from home and/or from our offices in Leeds or London.26 days’ annual leave + bank holidays (increasing with service)Global paid wellness days off + a bonus day off to celebrate your birthdayA generous contributory pension scheme + access to the TransUnion Employee Stock Purchase PlanPrivate health care + a variety of physical, mental and financial fitness wellbeing programmes such as access to mindfulness toolsAccess to our diversity forums and communities so you can get involved in causes close to your heart.TransUnion – a place to grow:If there’s something on the list of essential / desirable skills that you can’t quite tick off, don’t let that put you off applying. We are open to exploring training and development opportunities for the right candidate to ensure you are successful.We know imposter syndrome is real, lets confront it so we can continue to grow and thrive togetherFlexibility at TU:We recognise that our people need the freedom to balance their day-to-day lives with their work. This is why we’ve set out to create inclusive and flexible policies and practices for you to accommodate all your responsibilities and needs: children, family and beyond. If the role is advertised as full time, don’t let this stop you from applying. Let us know if you’re looking for a part time or flexible working arrangement and we can discuss this with you.Additional support:
At TransUnion, we’re committed to fostering an inclusive and diverse workplace where all individual’s talents and perspectives are valued. When you apply for a position with us, you’re not just joining a team, you’re becoming part of a community that celebrates differences and embraces equality. We understand that everyone has different needs, which is why we offer a range of reasonable adjustments to our recruitment process. Please let us know if you require any reasonable adjustments to help you through the application process or to attend an interview with us by contactingInterview & Hiring ProcessMost of our recruitment processes are virtual, so you’ll get to know our hiring managers and teams over the phone and through video. If we need you to attend a physical in person interview your recruiter will inform you of this.We do not accept any unsolicited CV’s from recruitment agencies. If you are a recruitment agency on our PSL our talent team will contact you directly should we require any assistance.#LI-HybridTransUnion Job TitleEngineer, Development Ops

TransUnion