BNP Paribas Looking for ALMT IT – Steering & Referential – Oracle DBA at Mumbai, Maharashtra Full Time

Job Description – Oracle DBA – Steering and Referential

About BNP Paribas Group:
BNP Paribas Group is a leading European bank with a strong global footprint across 72 markets and more than 202,000 employees. The Group provides corporates, institutional and private investors with product and service solutions tailored to their specific needs. It offers a wide range of financial services covering corporate & institutional banking, wealth management, asset management, insurance, as well as retail banking and consumer financing through strategic partnerships.

About BNP Paribas India Solutions:
Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas Group, a leading bank in Europe with an international reach. With delivery centers located in Mumbai and Chennai, we are a 24×7 global delivery center. We partner various business lines of BNP Paribas such as Corporate and Institutional Banking, Wealth Management, Retail Banking through three verticals – Information Technology, Operations and Finance Shared Services.

About Businessline/Function :
Steering and Referential takes care of the Interest Rate Risk and Liquidity Risk for the Bank. Its operations are mainly divided into 1) Own Operations which are fed by Kondor+ and 2) Acquired Operations which are fed by multiple Accounting and Back offices representing other BNPP business lines like IRB, FRB, CIB, WM, PF etc.

Job Title:
Technical Lead

Date:
25-Jan-2023

Department:
ALMT IT – Steering and Referential

Location:
ISPL, Mumbai

Business Line / Function:
ALMT IT

Reports to:
(Direct)

Team Lead/Project Manager

Grade:
(if applicable)

(Functional)

Number of Direct Reports:
Directorship / Registration:
NA

POSITION PURPOSE

To contribute as a programmer on application development, enhancements, maintenance and support activities for multiple applications across all SDLC phases.

Responsibilities

DIRECT RESPONSIBILITIES

Assist in Database Performance management

Should be able to write queries using complex joins, filter criteria, type cast when required

Should be able to code using various procedural constructs such as Packages, Procedures, Functions etc.

Perform SQL query tuning and refactoring.

Perform PLSQL procedural programming and tuning

Should be able to debug issues in SQL queries or any of the database constructs

Should carry out detailed unit testing based on the scenarios provided.

Database Schema Creation and Management

Perform Datadump, Rman backups

Perform Database Capacity planning

Should be equipped with writing Shell Scripts

Should be comfortable to work using Database development tools

Should create technical documentation such as the entity relationship diagrams, unit-testing documentation and technical design specifications for the deliverables.

CONTRIBUTING RESPONSIBILITIES

Should participate in stand ups and contribute to various project and organizational processes defined

Would be good to have IT experience in Finance domain

TECHNICAL & BEHAVIORAL COMPETENCIES

MANDATORY TECHNICAL SKILLS:
Strong knowledge on Oracle Database performance management

Strong knowledge on SQL and PLSQL tuning

Strong knowledge on Database schema creation and management

Strong knowledge on database migration using rman, rman duplicate, datapump etc.

Strong knowledge on Database capacity planning

Good Shell Scripting skills

Good Understanding on CI/CD Pipeline

Strong knowledge of version control tools, preferably Bitbucket

Ability & willingness to learn & work on diverse technologies (languages, frameworks, and tools)

Thorough understanding of complete Software Development Lifecycle

Self-motivated, good interpersonal skills and inclination to constantly upgrade on new technologies and frameworks.

Good Communication Skills

NICE TO HAVE SKILLS:
General systems management and networking skills – Job Scheduling, Network Management etc.

Good Sybase IQ skills

SPECIFIC QUALIFICATIONS (IF REQUIRED)

Skills Referential

Behavioural Skills: (Please select up to 4 skills)

Attention to detail / rigor

Ability to collaborate / Teamwork

Adaptability

Critical thinking

Transversal Skills: (Please select up to 5 skills)

Analytical Ability

Ability to understand, explain and support change

Ability to develop and adapt a process

Choose an item.

Choose an item.

Education Level:
Bachelor Degree or equivalent

Experience Level

At least 10 years

Other/Specific Qualifications (if required)

PRIMARY LOCATION

IN-MH-Mumbai

JOB TYPE

Standard / Permanent

JOB

INFORMATION TECHNOLOGY

EDUCATION LEVEL

Bachelor Degree or equivalent (>= 3 years)

EXPERIENCE LEVEL

At least 10 years

SCHEDULE

Full-time

REFERENCE

CIB007356

APPLY

(REF: CIB007356)