At a Glance
- Tasks: Develop and optimise Oracle SQL and PL/SQL solutions for robust database systems.
- Company: Join a dynamic local client in Glasgow with exciting projects.
- Benefits: Competitive daily rate, flexible contract, and opportunities for professional growth.
- Other info: Engage in a hands-on role across the full software development lifecycle.
- Why this job: Make an impact by delivering high-quality database solutions in a collaborative environment.
- Qualifications: Strong experience with Oracle SQL, PL/SQL, and Oracle Forms/Reports.
The predicted salary is between 40000 - 52000 £ per year.
Hays are now looking for a Senior Oracle Developer for one of our local clients.
We are looking for a hands-on Oracle Developer to support the development and delivery of robust database solutions. This role will involve working across the full development lifecycle, contributing to both development and optimisation of Oracle-based systems.
What you will be doing:
- Develop and maintain Oracle SQL and PL/SQL solutions
- Build and enhance procedures, packages, functions, cursors, and views
- Work on Oracle Forms and Reports (10g/11g) development
- Support database development on Oracle 19g and data warehousing projects
- Manage and monitor Oracle Jobs (creation, scheduling, auditing)
- Optimise queries and improve PL/SQL performance
- Work across the full SDLC, from design through to deployment
- Analyse and interpret entity relationship diagrams (ERDs) and data models
- Collaborate with team members to deliver high-quality database solutions
What we are looking for:
- Strong hands-on experience with Oracle SQL and PL/SQL development
- Proven experience with Oracle Forms/Reports (10g/11g) and Oracle 19g
- Solid understanding of data warehousing concepts
- Experience with query optimisation and performance tuning
- Ability to work independently across the software development lifecycle
- Strong knowledge of ER diagrams and data mapping
- Experience managing Oracle Jobs and scheduling
Senior Oracle Developer employer: Hays Technology
Join a dynamic team in Glasgow as a Senior Oracle Developer, where you will thrive in a collaborative work culture that values innovation and professional growth. Our company offers competitive daily rates, flexible working arrangements, and opportunities to enhance your skills through hands-on experience with cutting-edge Oracle technologies. With a focus on employee development and a supportive environment, we are committed to helping you achieve your career aspirations while delivering impactful database solutions.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Oracle Developer
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and join online forums. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Oracle SQL and PL/SQL projects. This will give potential employers a taste of what you can do and set you apart from the competition.
✨Tip Number 3
Prepare for interviews by brushing up on common Oracle development questions. Practice explaining your experience with Oracle Forms and Reports, and be ready to discuss how you've optimised queries in past roles.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might just be the perfect fit for you. Plus, it’s a great way to ensure your application gets seen by the right people.
We think you need these skills to ace Senior Oracle Developer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your hands-on experience with Oracle SQL and PL/SQL. We want to see how your skills match the job description, so don’t be shy about showcasing your relevant projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for the Senior Oracle Developer role. Mention specific experiences that relate to the development lifecycle and database solutions.
Showcase Your Problem-Solving Skills:In your application, give examples of how you've optimised queries or improved PL/SQL performance in past roles. We love seeing how you tackle challenges and deliver high-quality solutions!
Apply Through Our Website:Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. We can’t wait to hear from you!
How to prepare for a job interview at Hays Technology
✨Know Your Oracle Inside Out
Make sure you brush up on your Oracle SQL and PL/SQL skills before the interview. Be ready to discuss your hands-on experience with Oracle Forms and Reports, as well as any projects you've worked on involving Oracle 19g. They’ll likely want to hear about specific challenges you faced and how you optimised queries.
✨Showcase Your SDLC Knowledge
Since this role involves working across the full software development lifecycle, be prepared to talk about your experience in each phase. Share examples of how you've contributed from design through to deployment, and highlight any collaborative efforts with team members that led to successful database solutions.
✨Prepare for Technical Questions
Expect some technical questions related to query optimisation and performance tuning. Brush up on your understanding of data warehousing concepts and be ready to explain how you’ve managed and monitored Oracle Jobs in past roles. Practical examples will help demonstrate your expertise.
✨Understand ER Diagrams and Data Models
Familiarise yourself with entity relationship diagrams (ERDs) and data mapping, as these are crucial for the role. Be ready to discuss how you've analysed and interpreted these diagrams in previous projects, and how it has influenced your database development work.