Oracle PL/SQL Developer

About Phi Partners

Phi Partners is a leading global consultancy specialising in treasury and capital markets technology. With more than 500 professionals worldwide, we are recognised as the largest specialist consultancy dedicated to Sophis. For over 20 years, we have supported tier-one financial institutions in delivering complex transformation initiatives, regulatory programmes, and front-to-back platform modernisation projects across global markets.

Our technical capability spans database engineering, platform automation, and regulatory development within capital markets environments. We work as embedded engineers within our clients' squads, bringing specialist Oracle and SQL expertise to high-impact programmes.

The Programme

Phi Partners has been engaged by a leading European financial institution to support the delivery of SPARK, a major strategic programme that implements significant changes across the Sophis platform. SPARK drives wide-ranging impact across Finance and Regulatory Reporting (RTR), Equity Commodities, and Risk, requiring both functional and technical expertise to translate business requirements into platform-ready solutions across the Front office, back office and Risk squads. The programme operates under an Agile delivery model, with squads working end-to-end across the backlog using sprint ceremonies including planning, refinement, retrospectives, and demos.

Phi's consultants act as embedded members of the client's delivery squads, collaborating closely with internal stakeholders, business SMEs, and other technology teams to deliver high-quality outcomes within a fast-paced, regulated environment.

Roles and Responsibilities

As an Oracle SQL Developer within the Sophis Risk Squad, you will be responsible for SQL and PL/SQL development, query optimisation, performance tuning, and automation in support of the SPARK programme, including FRTB-related developments within the risk platform.

Key responsibilities include

• Design, develop and optimise complex SQL and PL/SQL queries, stored procedures, and database objects to support Risk programme requirements.
• Lead performance tuning across the Sophis risk platform, diagnosing and resolving slow queries and processing bottlenecks using execution plans and database diagnostics.
• Contribute to FRTB-related SQL and database developments within the Sophis Risk platform, working closely with risk developers and business analysts.
• Investigate and resolve data-related incidents, providing root cause analysis and remediation.
• Collaborate with the Risk squad on sprint planning, refinement, and delivery, contributing database and tooling expertise to the backlog.
• Design and implement automation tooling and CI/CD practices to streamline database development, testing and deployment, promoting automated testing and release governance.
• Maintain up-to-date documentation for database schemas, automation scripts, tuning decisions and development standards.
• Support SIT and UAT phases by providing database investigation, diagnostic queries, and data-level fixes within agreed timelines.

Key Skills

Must have

• Proven Oracle SQL and PL/SQL development experience, including complex query writing, stored procedures and database object design, ideally within a capital markets or financial services technology environment.
• Demonstrable performance tuning expertise, including execution plan analysis, indexing, partitioning and query optimisation on large data volumes.
• Experience developing automation tooling to support database development and deployment and reduce manual processes.
• Experience working within an Agile delivery squad, contributing to sprint ceremonies and backlog management.
• Proactive, assertive communicator with strong written and spoken English.

Nice-to-Have:

• Experience with Sophis at the database or data-model layer.
• Familiarity with Sophis risk architecture, batch processing, calculation grids, and risk reporting data flows.
• Understanding of FRTB or other regulatory risk frameworks from a data perspective.
• Knowledge of DevOps tooling and CI/CD pipelines within a financial services platform context.
• Exposure to PowerShell, Python, or shell scripting for database automation.
• Knowledge of Dutch or French in addition to English.

Next Steps

This role offers the opportunity to apply specialist Oracle and SQL expertise within a high-impact risk technology programme at a leading European financial institution, contributing to the performance and reliability of critical risk platform processing. We are always on the lookout for talented professionals who thrive in a dynamic, collaborative environment.

By joining Phi Partners, you will be part of the largest dedicated Sophis practice globally, working on a high-impact strategic programme within a demanding investment banking environment.