Lead Database Engineer
Job Title Lead Database Engineer Reference UK002969 Town Liverpool Business Line IS & Change
Introduction
At RSA, we believe insurance is about people, not things. We provide our inspiring colleagues the support and opportunity to grow together, shape the future, and win as a team. We are going through a transformation journey, providing our people with opportunity to be integral to improving our service and delivering better products to brokers and customers. We are a proud member of the Intact family, we feel part of something bigger, with a presence in North America, the UK and Europe.
We have a bold ambition to become the best Commercial Lines business in the UK, demonstrated by our recent acquisition of NIG and Farmweb, allowing us to scale by leveraging our combined financial strength and importantly ensure our people feel the benefits of our joint capabilities.
We are currently recruiting for a Lead Database Engineer to join our established and experienced CIO team here at RSA on a hybrid basis.
Your Role
The Lead Database Engineer is responsible for leading the design, implementation, and optimization of large-scale ETL systems, with a strong focus on IBM Infosphere DataStage technologies.
The role involves guiding a team of engineers, overseeing critical operations, and ensuring the integrity, performance, and security of ETL systems. This role involves both hands-on technical work and leadership responsibilities.
The Lead Database Engineer collaborates closely with other platform teams and architects to gather requirements, define goals, and allocate resources effectively. The Lead Database Engineer also actively participates in technical discussions, code reviews, and decision-making processes to drive technical excellence and innovation within the platform team.
About You
We are looking for candidates that have:
1. Minimum 7+ years of experience in IBM Infosphere DataStage, with at least 2 years in a leadership or senior engineering role.
2. Strong hands-on experience with T-SQL, and PowerShell/Bash scripting in SQL Server environments.
3. Extensive experience with DataStage for ETL processes, including package design, deployment, and troubleshooting.
4. Strong proficiency in PowerShell/Bash scripting for automating database tasks, maintenance, and deployments.
5. Deep understanding of relevant regulatory requirements (e.g., GDPR) and how to ensure compliance through database architecture and management
6. Analytical skills to assess and optimize ETL performance and lead strategic decisions for scalability
We are looking for accountabilities such as:
ETL Design & Architecture
7. Lead the design and management of highly scalable data platform systems, ensuring adherence to industry standards
Database/ETL Design, Performance Tuning & Optimization
8. Work with Database Engineers to manage performance tuning strategies, optimizing queries, stored procedures, and databases using T-SQL.
Team Leadership & Mentorship
9. Conduct Performance review, goal setting and provide constructive feedback to enhance individual and team performance.
Collaboration & Stakeholder Engagement
Work with platform teams and architects to ensure that database systems support business objectives
Incident & Problem Management
10. Lead incident resolution for critical database issues, ensuring minimal downtime and impact on business operations.
11. Establish root cause analysis practices and ensure that solutions are implemented to prevent recurring issues.
12. Document and maintain knowledge of troubleshooting methods, contributing to a knowledge base for future problem resolution.
What we offer you
At RSA we put our people first. We have adopted hybrid working as standard, to give you a better work/life balance and an excellent flexible working mindset. That is on top of a comprehensive range of benefits, including pension contributions of up to 11% looking after you now, and in the future.
We will give you countless opportunities to continuously develop, alongside a diverse and passionate community of experts, the best the industry has to offer. You will be empowered to be your best self, do your best work, and make a meaningful impact. Our employee promise allows you to shape the future, win as a team, and grow with us.