Lead Data Engineer - Data Migration

ZipRecruiter; London; On-site; GBP 70,000 - 90,000; Full time

Job summary

A leading consultancy is seeking a Lead Oracle Data Engineer to spearhead a complex DB2 to Oracle Exadata migration project. The role involves leading a feature team, ensuring data integrity, and implementing best practices in database modernization. The ideal candidate will have extensive experience in Oracle databases and a collaborative approach to work with cross-functional teams.

Qualifications

• Proven experience as an Oracle DBA, with significant experience in Oracle Exadata.
• Strong knowledge of Oracle Database architecture and features.

Responsibilities

• Lead planning and execution of Oracle database migration.
• Oversee database architecture design and optimisation.
• Conduct testing and validation of migrated data.

Skills

SQL

PL/SQL

Analytical Skills

Problem Solving

Communication

Education

Oracle Database Administration Certification

Tools

Oracle Exadata

AWS RDS

Azure SQL Database

Job description

Job Description

The Role:

We are seeking an experienced Lead Oracle Data Engineer to work on a complex brownfield DB2 to Oracle Exadata migration project at Digiterre. In this key role, you will be responsible for leading a feature team involving Oracle databases, ensuring smooth transition and integration with new systems while maintaining data integrity and security. You will work closely with cross-functional teams to implement best practices in database modernisation, conversion and migration management, performance tuning, and capacity planning during migration processes.

Key Responsibilities:

• Lead the planning and execution of Oracle database modernisation/conversion/migration, ensuring adherence to project timelines and objectives.
• Oversee database architecture design, assessment, and optimisation during migration tasks.
• Collaborate with development and architecture teams to streamline database processes and ensure efficient data flow.
• Conduct thorough testing and validation of migrated data to ensure accuracy and completeness.
• Develop and maintain documentation for database modernisation/conversion/migration processes and best practices.
• Provide technical leadership and mentorship to project team members.

Essential Requirements:

• Proven experience as an Oracle DBA, with significant experience in Oracle Exadata.
• Strong knowledge of Oracle Database architecture, features and tools.
• Experience with data migration methodologies and tools.
• Ability to design and implement performance tuning strategies for database optimization.
• Expertise in SQL and PL/SQL programming.
• Experience with backup/recovery strategies and disaster recovery planning.
• Strong analytical and problem-solving skills.
• Excellent communication skills, with the ability to work collaboratively across different teams.

Desirable Qualifications:

• Experience with cloud database solutions such as Oracle Cloud, AWS RDS, or Azure SQL Database.
• Certifications in Oracle Database Administration
• Familiarity with agile methodologies and project management tools

About Digiterre

Digiterre is a software and data engineering consultancy that enables technological and organisational transformation for many of the world’s leading organisations - be they commodity or energy traders, banks or investment managers, digital disruptors or public sector providers. We envisage, design and deliver software and data engineering solutions that users want, need and love to use. We achieve “Agility. At Greater Velocity” because we care about taking ownership for solving the toughest technical challenges and creating outstanding outcomes. As a consequence of this approach, we typically deliver high-risk, high-profile and time-constrained projects in less time than competitors, often significantly so.

Digiterre has won at least ten different industry awards including Best MiFID II Solution – Trade and Transaction Reporting awarded by HFM European Hedge Fund Services.

Our working culture is highly collaborative, consultative, and respectful. We fully understand our client’s needs as they evolve through the development lifecycle and use modern tools, methodologies, and technologies to enable us to work closely with in-house experts, and their end users, to maximise the benefits to all involved.

Our Values:

Our values are Care, Quality and Leadership.

Like all great professional services organisations, our aim is to delight our clients through the delivery of excellence and adherence to the highest levels of accountability in all that we do. In short, through keeping our promises and by over-delivering against our commitments wherever possible. Underpinning those aims is an all-encompassing passion for technology and data-led transformation. We are driven to demonstrate the point that brilliant software and data engineering, which meets the precise requirements of business users is, not only possible, but is the standard against which all initiatives should be measured; without compromise.

We aim to add business value far in excess of the cost of delivery, project after project. We are constantly seeking to hire additional team members who, like us, celebrate continuous learning and who want to work in a high-respect environment to contribute significantly to delivering the change that our clients have come to expect of Digiterre