At a Glance
- Tasks: Develop and maintain Oracle applications, troubleshoot issues, and enhance database performance.
- Company: Join a collaborative tech company that values innovation and teamwork.
- Benefits: Enjoy competitive benefits, training opportunities, and a supportive work environment.
- Other info: Inclusive workplace committed to diversity and personal growth.
- Why this job: Make a real impact by working on exciting projects with cutting-edge Oracle technologies.
- Qualifications: Experience in PL/SQL, SQL, and Oracle application maintenance is essential.
The predicted salary is between 45000 - 55000 € per year.
We are seeking an experienced Oracle Database 19c Developer / Application Maintenance Engineer to support and enhance bespoke applications built on Oracle technologies. This role focuses on maintaining and improving existing systems, resolving production issues, implementing enhancements, and ensuring the stability and performance of Oracle-based business applications. The ideal candidate will have strong hands-on expertise in Oracle Database 19c, PL/SQL, and application maintenance, along with experience supporting and developing solutions using Oracle Forms, Oracle Reports, Oracle WebLogic, Oracle APEX, and reporting tools such as Crystal Reports.
Responsibilities
- Oracle Database Development & Maintenance
- Develop, maintain, and enhance PL/SQL packages, procedures, functions, triggers, and database scripts in Oracle 19c.
- Write and optimize complex SQL queries to support application functionality and reporting requirements.
- Perform database object maintenance including tables, views, indexes, sequences, and constraints.
- Support data fixes, data migration, and data validation activities in production and non-production environments.
- Ensure database code aligns with best practices, performance standards, and security guidelines.
- Application Maintenance & Production Support
- Provide day-to-day support and maintenance for Oracle-based applications across multiple environments.
- Troubleshoot and resolve application incidents related to database logic, Oracle Forms, Reports, and WebLogic deployments.
- Conduct root cause analysis for recurring issues and implement permanent fixes.
- Support batch processes, scheduled jobs, and integration feeds to ensure business continuity.
- Work closely with business users to analyse defects and translate requirements into system enhancements.
- Oracle Forms & Reports Development
- Maintain and enhance legacy Oracle Forms and Oracle Reports applications.
- Debug and modify Forms triggers, procedures, and Reports logic.
- Support migration efforts, patching, and modernization initiatives involving Oracle Forms/Reports systems.
- Oracle APEX Development
- Develop, enhance, and maintain Oracle APEX applications.
- Create interactive reports, dashboards, and forms using APEX components.
- Integrate APEX applications with existing Oracle database objects and PL/SQL APIs.
- Support user access, authentication, and role-based security in APEX.
- WebLogic Server Administration & Support
- Support deployment and maintenance of Oracle applications hosted on Oracle WebLogic Server.
- Assist in troubleshooting WebLogic-related issues such as application availability, performance, configuration, and connectivity.
- Coordinate deployments and configuration changes across development, test, and production environments.
- Reporting & Business Intelligence Support
- Develop and maintain reports using Crystal Reports to support business reporting needs.
- Analyse reporting requirements and ensure accurate data extraction from Oracle databases.
- Maintain existing reporting solutions and implement enhancements for improved performance and usability.
- Performance Tuning & Optimization
- Identify and resolve database performance issues using tools such as AWR, ADDM, SQL Trace, and Explain Plan.
- Improve performance through indexing strategies, query optimization, and code refactoring.
- Assist with database monitoring, performance baselines, and capacity planning.
- Documentation & Change Management
- Document technical designs, support procedures, fixes, and enhancements.
- Support release management activities including deployment planning, scripting, and production validation.
- Ensure compliance with change control processes and audit requirements.
Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).
Essential skills
- Strong hands-on expertise in PL/SQL and SQL development.
- Working knowledge of Oracle Forms and Oracle Reports development and maintenance.
Desired skills
- Familiar with other development platforms.
- Exposure to Azure management/administration.
Experience
- Experience in Oracle development and application maintenance/support.
- Experience supporting enterprise applications in production environments.
- Strong experience with Oracle Database 19c.
- Experience with Oracle WebLogic Server in application deployment and support.
- Experience developing and supporting Oracle APEX applications.
- Experience creating and maintaining reports using Crystal Reports.
Benefits
- Collaborative working environment – we stand shoulder to shoulder with our clients and our peers through good times and challenges.
- We empower all passionate technology loving professionals by allowing them to expand their skills and take part in inspiring projects.
- Expleo Academy - enables you to acquire and develop the right skills by delivering a suite of accredited training courses.
- Competitive company benefits.
- Always working as one team, our people are not afraid to think big and challenge the status quo.
- As a Disability Confident Committed Employer we have committed to:
- Ensure our recruitment process is inclusive and accessible.
- Communicating and promoting vacancies.
- Offering an interview to disabled people who meet the minimum criteria for the job.
- Anticipating and providing reasonable adjustments as required.
- Supporting any existing employee who acquires a disability or long term health condition, enabling them to stay in work.
- We are an equal opportunities employer and welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation or age. We treat everyone fairly and equitably across the organisation, including providing any additional support and adjustments needed for everyone to thrive.
Oracle Developer in Preston employer: Expleo
At Expleo, we pride ourselves on fostering a collaborative and inclusive work environment where technology enthusiasts can thrive. Our commitment to employee growth is evident through the Expleo Academy, offering accredited training courses that empower you to expand your skills while working on inspiring projects. With competitive benefits and a strong focus on teamwork, we ensure that every team member feels valued and supported in their career journey.
StudySmarter Expert Advice🤫
We think this is how you could land Oracle Developer in Preston
✨Tip Number 1
Network like a pro! Reach out to your connections in the tech world, especially those who work with Oracle technologies. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Oracle projects, PL/SQL scripts, and any cool applications you've developed. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common Oracle-related questions and scenarios. Practice explaining your past experiences with database maintenance and application support clearly and confidently.
✨Tip Number 4
Don't forget to apply through our website! We love seeing passionate candidates who are eager to join our team. Plus, it makes it easier for us to keep track of your application and get back to you quickly.
We think you need these skills to ace Oracle Developer in Preston
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with Oracle Database 19c, PL/SQL, and any relevant application maintenance skills. We want to see how your background aligns with the role, so don’t be shy about showcasing your expertise!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about Oracle development and how your skills can benefit us at StudySmarter. Keep it engaging and relevant to the job description.
Showcase Your Problem-Solving Skills:In your application, mention specific examples of how you've tackled production issues or improved existing systems. We love candidates who can demonstrate their ability to troubleshoot and enhance applications effectively.
Apply Through Our Website:We encourage you to apply directly through our website for a smoother process. It helps us keep track of your application and ensures you don’t miss out on any important updates from us!
How to prepare for a job interview at Expleo
✨Know Your Oracle Stuff
Make sure you brush up on your Oracle Database 19c, PL/SQL, and application maintenance skills. Be ready to discuss specific projects where you've developed or maintained Oracle applications, and don't shy away from talking about any challenges you faced and how you overcame them.
✨Showcase Your Problem-Solving Skills
Prepare to share examples of how you've troubleshot and resolved production issues in the past. Think of a couple of incidents where you conducted root cause analysis and implemented permanent fixes. This will show that you can think critically and act decisively under pressure.
✨Familiarise Yourself with Tools
Get comfortable with tools like Crystal Reports, AWR, and SQL Trace. Be ready to explain how you've used these tools to enhance performance or create reports. Showing familiarity with these tools will demonstrate your hands-on experience and technical prowess.
✨Engage with the Interviewers
Don't just wait for questions; engage with your interviewers! Ask insightful questions about their current projects or challenges they face with Oracle technologies. This shows your genuine interest in the role and helps you assess if the company is the right fit for you.
