Lead Engineer

TransUnion; Pune District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

TransUnion is seeking a Lead Engineer, Database Engineering to join the IT Ops DBA team. You will build and optimise highly available database platforms, automate deployments, and lead on-call support for TU UK databases.

The role requires 5+ years as a Senior SQL Server DBA with MS SQL Server, PostgreSQL experience, and strong T-SQL, DevOps, and scripting skills. Hybrid work with periodic UK coordination is offered.

Qualifications

• Five+ years as a Senior SQL Server DBA with MS SQL Server 2014+
• Experience supporting PostgreSQL in an enterprise environment
• Planning and delivering database migrations and upgrades
• Advanced T-SQL (stored procedures, SQL Agent Jobs, deployment automation)
• Experience with High Availability / Disaster Recovery technologies
• Experience with transactional replication and centralized distribution
• Security-conscious handling of sensitive data
• Familiar with DevOps, Agile, Scrum, Kanban methodologies
• Knowledge of source control around database projects and reviews
• Experience with Azure DevOps Server and Octopus Deploy
• PowerShell scripting and automation experience
• Strong troubleshooting and fault resolution skills
• Excellent interpersonal and communication skills
• Willingness to learn and adapt to industry developments

Responsibilities

• Build and maintain optimised, highly available database platforms
• Develop and improve CI/CD pipelines for automated deployments
• Establish standards for highly available and fault-tolerant systems
• Identify opportunities to automate and streamline processes
• Troubleshoot data issues and advise on data growth and maintenance
• Develop PoCs to support UK IT Ops DBA initiatives
• Contribute to community best practices
• Ensure systems are secure and compliant (SOX, PCI, etc.)
• Provide supervisory and technical leadership for other engineers
• Offer UK business hours support for TU UK database platforms
• Provide out-of-hours support as part of the on-call rota

Skills

SQL Server DBA

PostgreSQL

T-SQL

DevOps/Agile

Troubleshooting

Data security

Source control

PowerShell

Communication

Continuous learning

Tools

Azure DevOps Server

Octopus Deploy

SQL Agent

Job description

TransUnion’s Job Applicant Privacy Notice

Team Overview

The IT Ops DBA team provide Database Platform delivery and support for TU UK.

As part of the DBA Team, 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. Working alongside and collaborating with Product Delivery and support teams on a daily basis, you will be focused on helping to deliver new and key capabilities into the business.

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 the database 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.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.

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