Oracle Database Developer – Lorien Impellam job at London Full Time

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

• 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.

Cross–Team Collaboration

• 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

• 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

Desirable Skills

• Python
• Good knowledge Linux/Unix OS & its commands
• Strong interest in understanding the business needs
• Source code refactoring

Competencies:

• Strong analytical skills.
• Good communication 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 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.