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 support 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 & 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.
- Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience).
- Strong hands-on expertise in PL/SQL and SQL development.
- Working knowledge of Oracle Forms and Oracle Reports development and maintenance.
- Familiar with other development platforms.
- Exposure to Azure management/administration.
- 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.
- 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 Group
At Expleo, we pride ourselves on being an excellent employer, offering a collaborative working environment where technology enthusiasts can thrive. Our commitment to employee growth is evident through the Expleo Academy, which provides accredited training courses, and our inclusive culture ensures that all voices are heard and valued. With competitive benefits and a focus on innovation, we empower our Oracle Developers to take on inspiring projects while supporting their professional development in a dynamic setting.
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, so you can confidently demonstrate your expertise.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive and eager to join our team.
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 personal – we love a good story!
Showcase Your Problem-Solving Skills:In your application, highlight specific examples where you've resolved production issues or improved application performance. We’re looking for candidates who can think critically and tackle challenges head-on!
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’s super easy – just a few clicks and you’re done!
How to prepare for a job interview at Expleo Group
✨Know Your Oracle Stuff
Make sure you brush up on your Oracle Database 19c knowledge, especially PL/SQL and SQL development. Be ready to discuss your hands-on experience with Oracle Forms, Reports, and APEX, as well as any troubleshooting you've done in production environments.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've resolved application incidents or performance issues in the past. Highlight your approach to root cause analysis and how you implemented permanent fixes, as this will demonstrate your ability to maintain and enhance applications effectively.
✨Familiarise Yourself with Reporting Tools
Since reporting is a key part of the role, be ready to talk about your experience with Crystal Reports. Think of specific instances where you developed or maintained reports, and how you ensured accurate data extraction from Oracle databases.
✨Ask Insightful Questions
Prepare thoughtful questions about the company's use of Oracle technologies and their approach to application maintenance. This shows your genuine interest in the role and helps you understand how you can contribute to their success.
