Performance Engineer ( Oracle PL/SQL ) - FX, Commodities, Settlements

Position Purpose

.

The system guarantees that every announcement, confirmation, payment and accounting entry is posted within seconds, 24??7. As the business expands with ever-evolving settlements perimeter involving CLSNET, CLSMain, we need a performance-focused PL/SQL expert to keep the engine fast, reliable, and future-ready.

.

This application consists of a .NET based front end communicating with backend written in Pro*C, PL/SQL and Python. The Database is Oracle 19c. The backend consists of performance critical processes and batches which implement core of the system. As the business is growing, new functionalities and features need to be incorporated which not only exceed user expectations but also meet the stringent performance and security requirements. A successful candidate would have a unique opportunity to be part of a global team located across multiple locations (Mumbai, London, Paris & Lisbon) to develop and implement large scale changes. The role also offers an opportunity to understand and strengthen capabilities across the capital markets technology landscape.

Responsibilities

• Design & develop

  high-quality, maintainable PL/SQL modules that meet functional and non-functional (performance, security) requirements.

• Performance engineering

  Profile, tune, and optimise SQL statements, execution plans, and PL/SQL code using AWR/ASH, DBMS_PROFILER, SQL*Plus, and Oracle Optimizer hints.

• Documentation & standards

  Produce technical design documents, perform code-review, and ensure adherence to SDLC, risk-management and security policies.

• Level-3 support

  Quickly investigate production incidents, deliver hot-fixes or work-arounds, and mentor L1/L2 support teams.

• Cross-team liaison

  Partner with upstream data-feed teams, downstream accounting platforms, and infrastructure groups (Linux/Unix) to ensure end-to-end stability.

Technical

• 5+years of professional PL/SQL development (Oracle?19c experience mandatory).
• Deep knowledge of RDBMS concepts, execution-plan analysis, indexing, partitioning, and query optimisation.
• Proficient with Linux/Unix command line, shell scripting, and basic system monitoring.
• Strong verbal and written communication; ability to translate business needs into technical solutions.
• Passion for performance engineering and a continuous-learning mindset.

Behavioural

• Analytical Thinking break down complex performance problems into actionable steps.
• Ownership take end-to-end responsibility for delivery and post-production health.
• Collaboration thrive in multi-location teams, share knowledge freely.
• Agile Mindset adapt quickly to changing priorities and deliver iteratively.

Transversal

• Continuous Improvement propose and implement process enhancements.
• Data-Driven Decision-Making use metrics (AWR, latency logs) to guide optimisation.
• Conflict Resolution navigate differing opinions to reach consensus
• Nice to have (would be given preference):
• Experience in an Investment Bank or Financial Services environment.
• Exposure to Python (for automation) or C++ (for high-performance utilities).
• Hands-on experience with Linux commands.

Why youll love this role

• Global impact

  Your work powers a multi-asset, multi-region trading operation used by thousands of front-office users.

• Cutting-edge tech stack

  Oracle?19c, Pro*C, .NET front-end, Python automation, high-throughput batch processing.

Skills Referential

Behavioural Skills: (Please select up to 4 skills)

• Ability to collaborate / Teamwork
• Creativity & Innovation / Problem solving
• Critical thinking
• Adaptability

Transversal Skills: (Please select up to 5 skills)

• Ability to understand, explain and support change
• Analytical Ability
• Ability to set up relevant performance indicators

Education Level:

Bachelor Degree or equivalent.