Senior Oracle Consultant
Senior Oracle Consultant

Senior Oracle Consultant

London Full-Time 48000 - 84000 £ / year (est.) No home office possible
H

At a Glance

  • Tasks: Lead the migration of Oracle databases to .NET, transforming complex logic into maintainable code.
  • Company: Join HCLTech, a global tech leader with over 219,000 employees and $13 billion in revenue.
  • Benefits: Enjoy a collaborative culture, AI tools, and opportunities for professional growth.
  • Why this job: Be part of a high-impact digital transformation that shapes the future of technology.
  • Qualifications: 5+ years in Oracle PL/SQL, experience in migrating to .NET, strong problem-solving skills required.
  • Other info: Work in a hybrid environment during the transition, ensuring stability while innovating.

The predicted salary is between 48000 - 84000 £ per year.

HCLTech is a global technology company, home to 219,000+ people across 54 countries, delivering industry-leading capabilities centered on digital, engineering and cloud, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of $13+ billion.

Role: Senior Oracle Developer – Oracle to .NET (C#) Migration Project

About the Project

We are modernising a long-standing enterprise system built on PHP and Oracle, transitioning to a modern .NET (C#) architecture. A key focus of this transformation is the migration of a large and complex Oracle database, which includes over 240 stored procedures and extensive embedded business logic. The existing Oracle database will be migrated to Postgres or MySQL and testing this will be critical.

This is not a straightforward lift-and-shift. The migration involves:

  • Re-engineering procedural logic from PL/SQL into C# application code within a .NET environment.
  • Decoupling business logic from the Oracle database , transforming it into maintainable, testable services.
  • Mapping Oracle data types and structures to .NET equivalents , ensuring data integrity and performance.
  • Preserving critical logic from stored procedures, triggers, and packages as it is migrated into the application layer.
  • Maintaining a hybrid environment during the transition, with both Oracle and the new .NET system temporarily coexisting.
  • Supporting BAU operations while migration is in progress.

We are leveraging AI-assisted tools to accelerate code analysis, documentation, and transformation. We are seeking Oracle experts with deep technical insight and practical experience to help guide this complex and high-impact initiative.

Key Responsibilities

  • Analyse, maintain, and optimise the existing Oracle PL/SQL codebase throughout the migration.
  • Translate and refactor Oracle stored procedures and other database logic into efficient and maintainable C# code.
  • Work closely with software engineers and business analysts to accurately capture and re-implement business logic in the new architecture.
  • Troubleshoot issues arising from differences in execution behaviour between PL/SQL and .NET environments.
  • Support the creation of migration plans, technical documentation, and testing strategies to ensure parity and quality.
  • Assist in managing a hybrid Oracle/.NET environment during phased rollout.
  • Contribute to BAU operations and the stability of the legacy system while migration activities are underway.

Required Skills & Experience

  • 5+ years of experience developing in Oracle PL/SQL, including deep knowledge of stored procedures, triggers, and packages.
  • Proven experience in migrating business logic from Oracle to .NET (C#), with a focus on re-architecture rather than direct translation.
  • Strong understanding of Oracle internals and how database logic integrates with external systems.
  • Experience migrating data from Oracle to other databases especially Postgres/MySQL.
  • Ability to work collaboratively in a cross-functional team environment.
  • Strong problem-solving ability and attention to technical detail.
  • Excellent communication skills, with the ability to document and explain complex systems clearly.

Desirable Skills

  • Experience working with legacy PHP systems and their integration with Oracle.
  • Exposure to AI-assisted development tools for code analysis and migration.
  • Familiarity with data modelling, version control of database logic, and CI/CD practices for backend services.
  • Background in agile development and experience with phased transformation or brownfield projects.
  • Proficiency in C# and the .NET framework, with experience building service-oriented architectures or backend systems.

What We Offer

  • A central role in a high-impact digital transformation initiative.
  • A collaborative and forward-thinking engineering culture.
  • Opportunities to work with AI-enabled development tools and modern best practices in software delivery.

Senior Oracle Consultant employer: HCLTech

HCLTech is an exceptional employer, offering a dynamic work environment that fosters innovation and collaboration among its 219,000+ global workforce. As a Senior Oracle Consultant, you will play a pivotal role in a high-impact digital transformation project, with access to cutting-edge AI-assisted tools and opportunities for professional growth within a supportive culture that values your expertise and contributions.
H

Contact Detail:

HCLTech Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Senior Oracle Consultant

✨Tip Number 1

Familiarise yourself with the specific challenges of migrating from Oracle PL/SQL to .NET (C#). Understanding the nuances of both environments will help you articulate your experience and how it aligns with the role.

✨Tip Number 2

Network with professionals who have experience in similar migration projects. Engaging with them can provide insights into best practices and common pitfalls, which you can reference during discussions.

✨Tip Number 3

Stay updated on AI-assisted development tools that can aid in code analysis and migration. Being knowledgeable about these tools will demonstrate your commitment to leveraging modern technologies in your work.

✨Tip Number 4

Prepare to discuss your problem-solving strategies for troubleshooting issues that arise during migration. Highlighting your analytical skills and attention to detail will resonate well with the hiring team.

We think you need these skills to ace Senior Oracle Consultant

Oracle PL/SQL Development
Stored Procedures, Triggers, and Packages
Migration from Oracle to .NET (C#)
Re-architecture of Database Logic
Oracle Internals Knowledge
Data Migration to Postgres/MySQL
Cross-Functional Team Collaboration
Problem-Solving Skills
Attention to Technical Detail
Technical Documentation Skills
Communication Skills
Legacy PHP Systems Integration
AI-Assisted Development Tools
Data Modelling
Version Control for Database Logic
CI/CD Practices for Backend Services
Agile Development Methodologies
C# Proficiency
.NET Framework Experience
Service-Oriented Architecture Design

Some tips for your application 🫡

Understand the Role: Before applying, make sure to thoroughly understand the responsibilities and requirements of the Senior Oracle Consultant position. Familiarise yourself with the migration project details, especially the transition from Oracle to .NET (C#).

Tailor Your CV: Highlight your relevant experience in Oracle PL/SQL development and any previous migration projects you've worked on. Emphasise your problem-solving skills and ability to work in cross-functional teams, as these are crucial for this role.

Craft a Compelling Cover Letter: In your cover letter, explain why you're interested in this specific role at HCLTech. Mention your experience with Oracle and .NET, and how you can contribute to the migration project. Be sure to convey your enthusiasm for working with AI-assisted tools.

Proofread Your Application: Before submitting, carefully proofread your CV and cover letter for any spelling or grammatical errors. A polished application reflects your attention to detail, which is essential for the technical nature of this position.

How to prepare for a job interview at HCLTech

✨Showcase Your Oracle Expertise

Make sure to highlight your extensive experience with Oracle PL/SQL, especially your work with stored procedures and triggers. Be prepared to discuss specific challenges you've faced in previous migrations and how you overcame them.

✨Demonstrate Your C# Knowledge

Since the role involves migrating Oracle logic to .NET (C#), it's crucial to showcase your proficiency in C#. Prepare examples of how you've re-architected business logic from one environment to another, focusing on maintainability and performance.

✨Understand the Migration Process

Familiarise yourself with the complexities of migrating from Oracle to databases like Postgres or MySQL. Be ready to discuss your approach to data integrity, performance mapping, and how you would handle a hybrid environment during the transition.

✨Communicate Clearly

Excellent communication skills are essential for this role. Practice explaining complex technical concepts in simple terms, as you'll need to collaborate with software engineers and business analysts. Clear documentation of your processes will also be key.

Senior Oracle Consultant
HCLTech
H
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>