Senior Oracle PL/SQL Performance Engineer

About BNP Paribas India SolutionsEstablished in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas SA, European Union's leading bank with an international reach. With delivery centers located in Bengaluru, Chennai and Mumbai, we are a 24x7 global delivery center. India Solutions services three business lines: Corporate and Institutional Banking, Investment Solutions and Retail Banking for BNP Paribas across the Group. Driving innovation and growth, we are harnessing the potential of over 10000 employees, to provide support and develop best-in-class solutions.About BNP Paribas GroupBNP Paribas is the European Union's leading bank and key player in international banking. It operates in 65 countries and has nearly 185,000 employees, including more than 145,000 in Europe. The Group has key positions in its three main fields of activity: Commercial, Personal Banking & Services for the Group's commercial & personal banking and several specialised businesses including BNP Paribas Personal Finance and Arval; Investment & Protection Services for savings, investment, and protection solutions; and Corporate & Institutional Banking, focused on corporate and institutional clients. Based on its strong diversified and integrated model, the Group helps all its clients (individuals, community associations, entrepreneurs, SMEs, corporates and institutional clients) to realize their projects through solutions spanning financing, investment, savings and protection insurance. In Europe, BNP Paribas has four domestic markets: Belgium, France, Italy, and Luxembourg. The Group is rolling out its integrated commercial & personal banking model across several Mediterranean countries, Turkey, and Eastern Europe. As a key player in international banking, the Group has leading platforms and business lines in Europe, a strong presence in the Americas as well as a solid and fast-growing business in Asia-Pacific. BNP Paribas has implemented a Corporate Social Responsibility approach in all its activities, enabling it to contribute to the construction of a sustainable future, while ensuring the Group's performance and stabilityCommitment to Diversity and InclusionAt BNP Paribas, we passionately embrace diversity and are committed to fostering an inclusive workplace where all employees are valued, respected and can bring their authentic selves to work. We prohibit Discrimination and Harassment of any kind and our policies promote equal employment opportunity for all employees and applicants, irrespective of, but not limited to their gender, gender identity, sex, sexual orientation, ethnicity, race, colour, national origin, age, religion, social status, mental or physical disabilities, veteran status etc. As a global Bank, we truly believe that inclusion and diversity of our teams is key to our success in serving our clients and the communities we operate in.About Business Line/FunctionGlobal Markets IT is the complete gamut of IT solutions that facilitate and enable the Global Markets business of BNP Paribas. Within Global Markets IT, Trade Processing is the domain, which comprises of the range of asset-specific applications that manage the lifetime and workflow of deals right from their capture through to their settlement and reporting.Job TitleSenior Oracle PL/SQL Performance EngineerDate06 Oct 2025DepartmentGMITLocation:Bagmane, BengaluruBusiness Line / FunctionFX, Commo, SettlementsReports To(Direct)Sagarkumar KANSARAGrade(if applicable)AVP / VP(Functional)Number Of Direct ReportsNoneDirectorship / RegistrationNAPosition PurposeWe 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.ResponsibilitiesDirect ResponsibilitiesDesign & 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 CompetenciesTechnical≥ 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.BehaviouralAnalytical 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.TransversalStakeholder 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 consensusNice 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 you'll love this roleGlobal 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.Skills ReferentialSpecific Qualifications (if required)Behavioural Skills: (Please select up to 4 skills)Ability to collaborate / TeamworkCreativity & Innovation / Problem solvingCritical thinkingAdaptabilityTransversal Skills: (Please select up to 5 skills)Ability to understand, explain and support changeAnalytical AbilityAbility to set up relevant performance indicatorsChoose an item.Choose an item.Education LevelBachelor Degree or equivalentExperience LevelAt least 10 years