Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop and optimise Oracle databases, write scripts, and manage data migration projects.
- Company: Join a dynamic tech company focused on innovative database solutions.
- Benefits: Enjoy flexible working hours, remote work options, and competitive pay.
- Why this job: Be part of exciting projects that enhance your coding skills and impact real-world applications.
- Qualifications: Experience with Oracle RDBMS, SQL, PL/SQL, and UNIX scripting is essential.
- Other info: This is a contract position, perfect for gaining valuable industry experience.
The predicted salary is between 36000 - 60000 £ per year.
Job Requirements:
- Oracle RDBMS - version 19 or later: good knowledge of its structure and capabilities
- SQL - knowledge/experience of writing scripts, queries, DML & DDL
- PL/SQL - coding experience for stand-alone scripts, procedures, packages and triggers
- ETL/Data Migration - experience of data migration projects and working with large data sets
- Data load Utilities - SQL*Loader plus use of Database Links
- Performance Tuning - code analysis and execution plan optimisation
- UNIX - knowledge of the OS shells along with experience writing/maintaining scripts. Maybe some experience scripting in PHP & PERL
Oracle Database Developer - Contract employer: Lorien
Contact Detail:
Lorien Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Oracle Database Developer - Contract
✨Tip Number 1
Brush up on your Oracle RDBMS knowledge, especially version 19 or later. Familiarise yourself with its structure and capabilities, as this will be crucial during any technical discussions or interviews.
✨Tip Number 2
Practice writing SQL scripts, queries, and DML/DDL commands. Being able to demonstrate your coding skills in PL/SQL, including procedures and triggers, can set you apart from other candidates.
✨Tip Number 3
Gain hands-on experience with ETL processes and data migration projects. Having real-world examples of how you've worked with large datasets will help you showcase your expertise effectively.
✨Tip Number 4
Familiarise yourself with performance tuning techniques, particularly code analysis and execution plan optimisation. Being prepared to discuss these topics can demonstrate your depth of knowledge and problem-solving abilities.
We think you need these skills to ace Oracle Database Developer - Contract
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Oracle RDBMS, SQL, and PL/SQL. Include specific examples of projects where you've used these skills, especially in data migration and performance tuning.
Craft a Strong Cover Letter: In your cover letter, emphasise your relevant experience with ETL processes and large data sets. Mention any specific achievements or challenges you've overcome in previous roles that relate to the job requirements.
Showcase Technical Skills: Clearly list your technical skills related to UNIX, SQL*Loader, and any scripting languages like PHP and PERL. Providing examples of how you've used these skills in past projects can set you apart.
Proofread Your Application: Before submitting, carefully proofread your application for any errors or typos. A polished application reflects your attention to detail, which is crucial for a role involving database development.
How to prepare for a job interview at Lorien
✨Brush Up on Oracle RDBMS
Make sure you have a solid understanding of Oracle RDBMS version 19 or later. Be prepared to discuss its structure and capabilities, as well as any specific features you've worked with in past projects.
✨Showcase Your SQL Skills
Be ready to demonstrate your SQL knowledge by discussing your experience with writing scripts, queries, DML, and DDL. You might even be asked to solve a problem on the spot, so practice common SQL scenarios beforehand.
✨Highlight Your PL/SQL Experience
Discuss your coding experience with PL/SQL, including stand-alone scripts, procedures, packages, and triggers. Prepare examples of how you've used these in previous roles to solve real-world problems.
✨Familiarise Yourself with Performance Tuning
Performance tuning is crucial for an Oracle Database Developer. Be ready to talk about your experience with code analysis and execution plan optimisation, and consider bringing examples of how you've improved performance in past projects.
