Senior Oracle PL/SQL Performance Engineer

BNP Paribas

10 - 15 years

30 - 45 Lacs

bengaluru

Posted:3 days ago| Platform:

Apply

Skills Required

linux shell scripting sql development query optimization unix css rdbms concepts performance engineering sql plsql java xml html mysql python rdbms oracle indexing performance tuning javascript sql server partitioning .net agile oracle sql sdlc awr

Work Mode

Work from Office

Job Type

Full Time

Job Description

Position Purpose

We are looking for an energetic, proactive & competent candidate to fulfil the role of an Oracle PLSQL developer for the global markets trade processing department
.
Application
is a real-time multi-asset settlement platform that processes >500k?OTC derivatives trades daily covering FX, Equities, Credits, Rates & Commodities.
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.
We are looking for an energetic, proactive & competent candidate to shape the next-gen settlement engine that processes half-a-million OTC derivative trades every day
.
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

Direct 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.
Architectural reviews
Participate in design sessions, provide capacity-planning inputs, and define indexing/partitioning strategies for large batch jobs.
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 & Behavioral Competencies

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
Stakeholder Management influence business partners and technical leads.
Mentoring coach junior developers on best-practice PL/SQL coding.
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.
Architectural ownership
Design, refactor, and optimise core PL/SQL components; influence roadmap and standards.
Career acceleration
Mentor junior developers, lead performance-tuning initiatives, and collaborate with senior architects globally.

More Jobs at BNP Paribas

BNP Paribas is hiring For Senior Support Analyst!

Bengaluru

4 - 8 yrs

INR 10 - 19 Lacs

Senior Support Analyst

Bengaluru

4 - 8 yrs

INR 10 - 18 Lacs

Java Full Stack Developer - Looking For Immediate joiner

Chennai

6 - 11 yrs

INR 0 - 1 Lacs

BNP Paribas is looking For a Product Owner!

Chennai

8 - 13 yrs

INR 15 - 25 Lacs

Full Stack Engineer

Chennai, Tamil Nadu, India

Experience: Not specified

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Java Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.