At a Glance
- Tasks: Join a team to migrate a legacy system from Oracle to PostgreSQL using .NET/C#.
- Company: A finance-focused company undergoing a strategic transformation.
- Benefits: Remote work, competitive rates, and the chance to work with cutting-edge technology.
- Why this job: Be part of a significant project that enhances your skills and impacts the future of the company.
- Qualifications: 5+ years in .NET/C#, experience with legacy migrations, and strong PL/SQL knowledge required.
- Other info: Opportunity to use AI tools for development and collaborate in a dynamic team environment.
Job Description
Senior .NET/C# Developer (Oracle to PostgreSQL migration) – Finance – Remote
Duration: 6 months
Rate: £500 – £600
Start: ASAP
My client is looking for a Senior Developer to join the team to help with a migration. They are undertaking a strategic transformation of a legacy system built on PHP and Oracle, migrating to a modern architecture using PostgreSQL and .NET (C#). This is not a simple lift-and-shift; the project involves re-engineering over 240 Oracle stored procedures, some highly complex, into performant, maintainable C# code. The new system will coexist with the legacy platform during the transition, requiring careful integration and support for business-as-usual (BAU) operations.
Key Responsibilities
- Collaborate with the existing team to re-engineer Oracle PL/SQL stored procedures into C# services.
- Design and implement .NET-based components that integrate with both legacy PHP systems and new PostgreSQL databases.
- Work closely with business analysts and stakeholders to ensure functional parity and identify opportunities for enhancement.
- Participate in the design of a hybrid architecture that supports phased migration.
- Use AI-assisted tools to analyse, translate, and optimize legacy code.
- Support BAU operations during the migration period, ensuring system stability and continuity.
- Contribute to code reviews, testing strategies, and documentation.
Required Skills & Experience
- 5+ years of experience in .NET/C# development, with a strong focus on backend services and data access layers.
- Proven experience in migrating legacy systems, especially from Oracle to PostgreSQL or similar.
- Strong understanding of PL/SQL and experience translating stored procedures into application logic.
- Familiarity with PostgreSQL, including performance tuning and SQL dialect differences.
- Experience working in hybrid environments where legacy and modern systems coexist.
- Comfortable using AI tools (e.g., GitHub Copilot, ChatGPT, code translators) to assist in development and migration tasks.
- Solid understanding of software architecture, design patterns, and integration strategies.
- Excellent communication skills and ability to work collaboratively in a cross-functional team.
Desirable Skills
- Experience with PHP, especially in legacy systems.
- Familiarity with DevOps practices, CI/CD pipelines, and containerization (Docker/Kubernetes).
- Exposure to domain-driven design and microservices architecture.
- Experience in agile development environments.
*Rates depend on experience and client requirements
Senior .NET/C# Developer Oracle to PostgreSQL migration employer: Salt Search
Contact Detail:
Salt Search Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior .NET/C# Developer Oracle to PostgreSQL migration
✨Tip Number 1
Make sure to highlight your experience with both Oracle and PostgreSQL in your discussions. Be prepared to discuss specific challenges you've faced during migrations and how you overcame them, as this will demonstrate your expertise in the area.
✨Tip Number 2
Familiarise yourself with the tools and technologies mentioned in the job description, especially AI-assisted tools like GitHub Copilot. Being able to discuss how you've used these tools in past projects can set you apart from other candidates.
✨Tip Number 3
Prepare to showcase your understanding of software architecture and design patterns. You might be asked to explain how you would approach integrating legacy systems with new architectures, so having a clear strategy in mind will be beneficial.
✨Tip Number 4
Since communication is key for this role, think of examples where you've successfully collaborated with cross-functional teams. Being able to articulate your teamwork experiences will help demonstrate that you're a good fit for their collaborative environment.
We think you need these skills to ace Senior .NET/C# Developer Oracle to PostgreSQL migration
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with .NET/C# development, especially in backend services and data access layers. Emphasise any previous work on migrating legacy systems, particularly from Oracle to PostgreSQL.
Craft a Compelling Cover Letter: In your cover letter, explain why you're the perfect fit for this role. Mention your familiarity with PL/SQL and your experience translating stored procedures into C#. Highlight your ability to work in hybrid environments and your comfort with AI tools.
Showcase Relevant Projects: If you have worked on similar migration projects or have experience with performance tuning in PostgreSQL, make sure to include these details. Use specific examples to demonstrate your skills and contributions.
Prepare for Technical Questions: Be ready to discuss your technical expertise during the interview process. Brush up on software architecture, design patterns, and integration strategies, as well as your experience with DevOps practices and agile development.
How to prepare for a job interview at Salt Search
✨Showcase Your Migration Experience
Be prepared to discuss your previous experiences with migrating legacy systems, particularly from Oracle to PostgreSQL. Highlight specific challenges you faced and how you overcame them, as this will demonstrate your capability to handle the complexities of the project.
✨Demonstrate Your .NET/C# Proficiency
Since the role requires strong .NET/C# skills, be ready to provide examples of your work in backend services and data access layers. Discuss any relevant projects where you designed and implemented .NET components, especially those that integrate with legacy systems.
✨Familiarity with AI Tools
As the job mentions using AI-assisted tools, make sure to talk about your experience with tools like GitHub Copilot or ChatGPT. Share how you've used these tools to enhance your development process or assist in code translation during migrations.
✨Collaboration and Communication Skills
This role involves working closely with business analysts and stakeholders, so emphasise your ability to communicate effectively within a cross-functional team. Prepare examples of how you've collaborated on projects to ensure functional parity and identify enhancements.