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 finance.
- 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.
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
Contact Detail:
Salt Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior .NET/C# Developer (Oracle to PostgreSQL migration)
✨Tip Number 1
Familiarise yourself with the specific challenges of migrating from Oracle to PostgreSQL. Understanding the nuances of PL/SQL and how to effectively translate stored procedures into C# will set you apart from other candidates.
✨Tip Number 2
Showcase your experience with AI-assisted tools in your discussions. Highlighting your familiarity with tools like GitHub Copilot or ChatGPT can demonstrate your innovative approach to problem-solving during the migration process.
✨Tip Number 3
Prepare to discuss your previous experiences in hybrid environments. Be ready to share examples of how you've successfully integrated legacy systems with modern architectures, as this is crucial for the role.
✨Tip Number 4
Network with professionals in the finance sector who have undergone similar migrations. Engaging in conversations about their experiences can provide valuable insights and may even lead to referrals for the position.
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, particularly in backend services and data access layers. Emphasise any previous work on migrating legacy systems, especially 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# code. 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, be sure to include these details. Use specific examples to demonstrate your skills and contributions.
Prepare for Technical Questions: Anticipate technical questions related to .NET/C#, PL/SQL, and PostgreSQL during the interview process. Brush up on your knowledge of software architecture and integration strategies to showcase your expertise.
How to prepare for a job interview at Salt
✨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# Expertise
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 mention any experience you have with tools like GitHub Copilot or ChatGPT. Share how these tools have helped you in your development process, particularly in code translation and optimisation.
✨Collaboration and Communication Skills
This role involves working closely with business analysts and stakeholders, so emphasise your communication skills. Prepare examples of how you've successfully collaborated in cross-functional teams to ensure functional parity and identify enhancement opportunities.