Senior Oracle Developer – Oracle to Migration Project
Location: Nottingham/ London – Hybrid
Length: ASAP – Jan 2026 (6 months)
Rate: £586
Hours: 9-6pm
About the Project
We are modernising a long-standing enterprise system built on PHP and Oracle, transitioning to a modern .NET 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.