At a Glance
- Tasks: Join a leading bank as an Oracle Database Developer, integrating local and global settlement activities.
- Company: Dynamic banking client in London with a hybrid working model.
- Benefits: Enjoy competitive pay, flexible work, and opportunities for professional growth.
- Other info: Collaborative environment with excellent career advancement potential.
- Why this job: Make a real impact on the trade lifecycle using cutting-edge technologies.
- Qualifications: Strong software development skills, especially in PL/SQL, C/Pro-C, and SQL.
The predicted salary is between 60000 - 80000 £ per year.
Hybrid Working - London - 2 days a week on site. Lorien's leading banking client is looking for an Oracle Database Developer to join them. This role is to integrate the local Settlement activity into the Global Settlement platform, covering the entire trade lifecycle.
The ideal candidate should possess strong software-development and analytical abilities, with a proven history of collaborating closely with both on-shore and off-shore teams and engaging stakeholders confidently. Experience with high-availability systems is essential. The back-end components are primarily built using C/Pro-C, SQL, and Oracle PL/SQL, while the front-end is developed in C#/.NET, so solid familiarity with these technologies is desirable.
This role will be via Umbrella. Working in a Hybrid Model of 2 days a week on site.
Core Accountabilities of Role
- Development Planning & Design
- Effort Estimation - Produce realistic time- and resource-estimates for all development assignments.
- Requirement Elaboration - Work hand-in-hand with the Business Analyst to clarify and expand functional specifications.
- High-Level Architecture - Create and maintain high-level design artefacts that outline system structure, data flows, and integration points.
- Traceability Management - Implement and sustain end-to-end traceability, linking every requirement to its corresponding design, code, and test artefacts.
- Code Development & Quality Assurance
- Component Development & Testing - Build product components, execute comprehensive functional tests, and verify that they meet the defined acceptance criteria.
- Performance Engineering - Profile, tune, and optimise SQL statements, execution plans, and PL/SQL logic using tools such as AWR/ASH, DBMS_PROFILER, SQL*Plus, and Oracle Optimiser hints.
- Architectural Reviews - Participate in design-review sessions, contribute capacity-planning insights, and define indexing/partitioning strategies for high-volume batch jobs.
- Documentation, Standards & Governance
- Technical Documentation - Produce clear design specifications, interface contracts, and deployment guides.
- Code Review & Standards Enforcement - Conduct peer reviews, ensure adherence to coding standards, and verify compliance with the SDLC, risk-management, and security policies.
- Project & Task Management
- Task Status Updates - Keep work-item statuses current in the project-tracking system, highlighting progress, impediments, and completed deliverables.
- Support & Incident Resolution
- Level-3 Production Support - Investigate critical production incidents swiftly, deliver hot-fixes or work-arounds, and mentor Level-1/Level-2 support teams on root-cause analysis and remediation techniques.
- Escalated Application Support - Participate in higher-severity support activities as required, ensuring minimal service disruption.
- Stakeholder Liaison - Partner with upstream data-feed providers, downstream accounting platforms, and infrastructure groups (Linux/Unix) to guarantee end-to-end system stability and seamless data flow.
Strong PL/SQL programming skills - developing complex packages, stored procedures, functions and implementing best practices in PL/SQL programming. Development expertise in Unix/Linux C or Pro*C and SQL. Use of unit-testing strategies. Educated to degree-level at minimum in a numerate or technical discipline. Python. Good knowledge Linux/Unix OS & its commands. Strong interest in understanding the business needs. Source code refactoring. Strong analytical skills. Quality-focussed. Ability to prioritise work effectively in a dynamic, ever-changing environment. Confidence in working closely with both business and IT stakeholders. Open and hands-on approach. Strong teamwork focus.
Conduct
Demonstrate proactivity, transparency and accountability for identifying and managing conduct risks. Consider the implications of your actions on colleagues, partners and clients before making decisions, and elevate issues to your manager when unsure.
Oracle Database Developer in London employer: Lorien
Lorien's leading banking client offers a dynamic and supportive work environment in London, where employees benefit from a hybrid working model that promotes work-life balance. With a strong focus on employee growth, the company provides opportunities for professional development and collaboration across diverse teams, ensuring that every team member can thrive while contributing to innovative solutions in the banking sector.
StudySmarter Expert Advice🤫
We think this is how you could land Oracle Database Developer in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the banking and tech sectors. Attend meetups or webinars related to Oracle Database Development. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your projects, especially those involving PL/SQL, C/Pro-C, and SQL. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge and soft skills. Be ready to discuss your experience with high-availability systems and how you've collaborated with teams. Confidence is key!
✨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 get noticed by our hiring team directly.
We think you need these skills to ace Oracle Database Developer in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Oracle Database Developer role. Highlight your experience with C/Pro-C, SQL, and PL/SQL, and don’t forget to mention any high-availability systems you've worked on. We want to see how your skills match what we're looking for!
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. Talk about your collaborative experiences with on-shore and off-shore teams, and how you engage stakeholders confidently. We love a good story!
Showcase Your Problem-Solving Skills:In your application, give examples of how you've tackled complex issues in past projects. Whether it's performance engineering or incident resolution, we want to know how you approach challenges and ensure minimal service disruption.
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 Lorien
✨Know Your Tech Inside Out
Make sure you brush up on your skills with C/Pro-C, SQL, and Oracle PL/SQL. Be ready to discuss specific projects where you've used these technologies, as well as any performance tuning you've done. This will show that you not only understand the tools but can also apply them effectively.
✨Showcase Your Collaboration Skills
Since this role involves working closely with both on-shore and off-shore teams, be prepared to share examples of how you've successfully collaborated in the past. Highlight any experiences where you engaged stakeholders confidently and resolved conflicts, as this will demonstrate your teamwork focus.
✨Prepare for Scenario-Based Questions
Expect questions that ask how you would handle specific situations, like investigating production incidents or managing project tasks. Think through your past experiences and be ready to explain your thought process and the outcomes of your actions.
✨Understand the Business Context
Having a strong interest in understanding business needs is crucial. Research the banking sector and the specific challenges they face with settlement activities. This knowledge will help you connect your technical skills to real-world applications during the interview.
