Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the migration from Oracle to PostgreSQL in a public sector environment.
- Company: Join a dynamic team focused on innovative database solutions.
- Benefits: Remote work, competitive pay, and flexible hours.
- Why this job: Make a significant impact by optimising database performance and stability.
- Qualifications: 5+ years of DBA experience with Oracle and PostgreSQL migration expertise.
- Other info: Opportunity for professional growth and hands-on project execution.
The predicted salary is between 36000 - 60000 £ per year.
We are seeking an experienced Oracle & PostgreSQL DBA to deliver a full migration from a legacy Oracle estate to Azure Database for PostgreSQL within a public sector environment. This is a hands-on, execution-led contract focused on successful migration, stability and optimisation.
Key Responsibilities:
- Review and refine existing migration strategy and POC
- Assess current Oracle environment and define migration path
- Execute full Oracle to PostgreSQL migration
- Implement backup, rollback and validation processes
- Resolve compatibility and performance issues
- Optimise and right-size remaining Oracle infrastructure
Experience:
- Strong Oracle & PostgreSQL DBA background (5+ years)
- Proven Oracle to PostgreSQL migration delivery
- Experience with RAC, Data Guard and CDB/PDB
- PostgreSQL performance tuning expertise
- Migration tooling (ora2pg, pg_dump, pg_restore)
- Azure exposure
6 months | Outside IR35 | Remote with occasional travel | Start within 2 weeks preferred
Oracle DBA - PostgreSQL migration employer: ARCA
Contact Detail:
ARCA Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Oracle DBA - PostgreSQL migration
✨Tip Number 1
Network like a pro! Reach out to your connections in the Oracle and PostgreSQL communities. Attend meetups or webinars, and don’t be shy about asking for introductions. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your previous migration projects, especially any Oracle to PostgreSQL work. This can really set you apart from other candidates and give potential employers a taste of what you can do.
✨Tip Number 3
Prepare for interviews by brushing up on common DBA scenarios. Be ready to discuss your experience with RAC, Data Guard, and performance tuning. Practising answers to technical questions will help you feel more confident when it’s time to shine.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might just be perfect for you. Plus, applying directly can sometimes give you a better chance of getting noticed by hiring managers.
We think you need these skills to ace Oracle DBA - PostgreSQL migration
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Oracle and PostgreSQL, especially any migration projects you've worked on. We want to see how your skills match the job description, so don’t hold back on showcasing your relevant expertise!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for this role. Mention specific experiences that relate to the key responsibilities, like your hands-on work with migration strategies or performance tuning.
Showcase Your Technical Skills: In your application, be sure to mention any tools and technologies you’ve used, like ora2pg or Azure. We’re looking for someone who can hit the ground running, so let us know how your background aligns with our needs!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it makes the process smoother for both of us!
How to prepare for a job interview at ARCA
✨Know Your Migration Tools
Familiarise yourself with the migration tools mentioned in the job description, like ora2pg and pg_dump. Be ready to discuss your hands-on experience with these tools and how you've used them in past migrations.
✨Showcase Your DBA Expertise
Highlight your strong background in both Oracle and PostgreSQL. Prepare specific examples of previous projects where you successfully executed migrations, resolved compatibility issues, or optimised performance.
✨Understand the Public Sector Environment
Research the public sector environment and its unique challenges. Be prepared to discuss how your experience aligns with these challenges and how you can contribute to a stable and optimised migration process.
✨Prepare for Technical Questions
Expect technical questions related to RAC, Data Guard, and CDB/PDB. Brush up on these topics and be ready to explain your approach to performance tuning in PostgreSQL, as this will demonstrate your depth of knowledge.