Oracle Database Developer
Hybrid Working - London - 2 days a week on site.
Financial Services
Lorien's leading banking client is looking for a 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 is based in London.
This role will be Via Umbrella.
Working in a Hybrid Model of 2 day a week on site.
Core Accountabilities of Role
Development Planning & Design
1. Effort Estimation - Produce realistic time‑ and resource‑estimates for all development assignments.
2. Requirement Elaboration - Work hand‑in‑hand with the Business Analyst to clarify and expand functional specifications.
3. High‑Level Architecture - Create and maintain high‑level design artefacts that outline system structure, data flows, and integration points.
4. Traceability Management - Implement and sustain end‑to‑end traceability, linking every requirement to its corresponding design, code, and test artefacts.
Code Development & Quality Assurance
5. Component Development & Testing - Build product components, execute comprehensive functional tests, and verify that they meet the defined acceptance criteria.
6. 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.
7. Architectural Reviews - Participate in design‑review sessions, contribute capacity‑planning insights, and define indexing/partitioning strategies for high‑volume batch jobs.
Documentation, Standards & Governance
8. Technical Documentation - Produce clear design specifications, interface contracts, and deployment guides.
9. 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
10. Task Status Updates - Keep work‑item statuses current in the project‑tracking system, highlighting progress, impediments, and completed deliverables.
Support & Incident Resolution
11. 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.
12. Escalated Application Support - Participate in higher‑severity support activities as required, ensuring minimal service disruption.
Cross‑Team Collaboration
13. 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.
Essential Skills
14. Strong PL/SQL programming skills - developing complex packages, stored procedures, functions and implementing best practices in PL/SQL programming
15. Development expertise in Unix/Linux C or Pro*C and SQL
16. Use of unit-testing strategies
17. Educated to degree-level at minimum in a numerate or technical discipline
Desirable Skills
18. Python
19. Good knowledge Linux/Unix OS & its commands
20. Strong interest in understanding the business needs
21. Source code refactoring
Competencies:
22. Strong analytical skills.
23. Good communication skills.
24. Quality-focussed.
25. Ability to prioritise work effectively in a dynamic, ever-changing, environment.
26. Confidence in working closely with both business and IT stakeholders.
27. Open and hands-on approach.
28. Strong teamwork focus
Conduct:
29. Demonstrate proactivity, transparency and accountability for identifying and managing conduct risks
30. Consider the implications of your actions on colleagues, partners and clients before making decisions, and escalate issues to your manager when unsure.
IND_PC3
Guidant, Carbon60, Lorien & SRG - The Impellam Group Portfolio are acting as an Employment Business in relation to this vacancy.