Almt IT

1 week ago

Mumbai, Maharashtra, India BNP Paribas Full time

ALMT IT - STEERING & REFERENTIAL - ORACLE DBA (

JOB NUMBER:
CIB007356)

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 24x7 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:

0

Directorship / Registration:

NA

Position Purpose

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, unittesting 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
  • Selfmotivated, 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