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#, 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. Good knowledge of Linux/Unix OS & its commands. Strong interest in understanding the business needs. Source code refactoring. Strong analytical skills. Quality-focused. 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 employer: Lorien
Join a leading banking client in London as an Oracle Database Developer, where you will thrive in a hybrid working environment that promotes flexibility and work-life balance. The company fosters a collaborative culture, offering ample opportunities for professional growth and development while working with cutting-edge technologies in a dynamic team setting. With a focus on innovation and excellence, this role provides a unique chance to contribute to high-availability systems and engage with stakeholders across the globe.
StudySmarter Expert Advice🤫
We think this is how you could land Oracle Database Developer
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work at companies you're interested in. A friendly chat can lead to insider info about job openings or even a referral.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your technical skills. We recommend setting up mock interviews with friends or using online platforms to get comfortable with the process.
✨Tip Number 3
Don’t underestimate the power of follow-ups! After an interview, drop a quick thank-you email to express your appreciation and reiterate your interest in the role. It keeps you fresh in their minds.
✨Tip Number 4
Apply through our website for the best chance at landing that Oracle Database Developer role. We make it easy for you to showcase your skills and connect with potential employers directly!
We think you need these skills to ace Oracle Database Developer
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 up with 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. Let us know what excites you about this opportunity!
Showcase Your Problem-Solving Skills:In your application, be sure to highlight specific examples of how you've tackled challenges in past projects. Whether it's performance engineering or incident resolution, we love to see how you approach problem-solving and ensure minimal service disruption.
Apply Through Our Website:We encourage you to apply 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. Plus, it’s super easy to do!
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 challenges you faced and how you overcame them.
✨Showcase Your Collaboration Skills
Since this role involves working closely with both on-shore and off-shore teams, prepare examples that highlight your teamwork and communication skills. Think of situations where you successfully engaged stakeholders or resolved conflicts.
✨Prepare for Problem-Solving Questions
Expect questions that assess your analytical abilities and problem-solving skills. Practice explaining your thought process when tackling complex issues, especially in high-availability systems or during performance tuning.
✨Understand the Business Context
Familiarise yourself with the banking sector and how database development fits into the trade lifecycle. Being able to connect your technical skills to business needs will show that you're not just a coder, but someone who understands the bigger picture.
