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 and experience migrating to .NET required.
- Other info: Work in a hybrid environment during the transition, ensuring stability and innovation.
The predicted salary is between 48000 - 72000 £ 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
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 to .NET. Understanding the nuances of PL/SQL and how they translate into C# will give you a significant edge during interviews.
✨Tip Number 2
Showcase your experience with hybrid environments. Be prepared to discuss how you've managed transitions between different database systems, as this role requires maintaining both Oracle and .NET systems simultaneously.
✨Tip Number 3
Highlight any experience you have with AI-assisted development tools. Since the project involves leveraging these tools for code analysis and migration, demonstrating familiarity can set you apart from other candidates.
✨Tip Number 4
Prepare to discuss your problem-solving strategies in detail. Given the complexity of the migration, being able to articulate how you've tackled similar challenges in the past will be crucial in impressing the hiring team.
We think you need these skills to ace Senior Oracle Consultant
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Oracle PL/SQL, C#, and any relevant migration projects. Use specific examples that demonstrate your problem-solving skills and technical expertise.
Craft a Compelling Cover Letter: In your cover letter, explain why you're interested in the Senior Oracle Consultant role at HCLTech. Mention your experience with migrating databases and how you can contribute to their digital transformation initiative.
Showcase Relevant Projects: If you've worked on similar migration projects, describe them in detail. Highlight your role, the challenges faced, and the outcomes achieved, especially focusing on your experience with Oracle to .NET migrations.
Highlight Soft Skills: Since the role requires collaboration with cross-functional teams, emphasise your communication skills and ability to work well in a team environment. Provide examples of how you've successfully collaborated in past projects.
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 Migration Knowledge
Since the role involves migrating from Oracle to .NET, be ready to explain your approach to re-architecting business logic rather than just translating it. Share examples of past projects where you've successfully managed similar transitions.
✨Communicate Clearly
Excellent communication skills are crucial for this position. Practice explaining complex technical concepts in a straightforward manner, as you'll need to collaborate with software engineers and business analysts throughout the migration process.
✨Prepare for Problem-Solving Scenarios
Expect to encounter questions that assess your problem-solving abilities, particularly regarding differences in execution behaviour between PL/SQL and .NET. Think of specific instances where you've had to troubleshoot issues and be ready to discuss your thought process.