About BNP Paribas India Solutions:
Established 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 Group:
BNP 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 stability
Commitment to Diversity and Inclusion
At 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/Function:
IFS-IRP is responsible for providing investment reporting and performance services to the BP2S clients. It serves with timely and accurate information to the stakeholders and helping them to come up with the investment strategy.
Job Title:
Oracle DBA
Date:
01/08/2024
Department:
IFS - IRP
Location:
Chennai
Business Line / Function:
BP2S-IFS/IRP-ADM
Reports to:
(Direct)
Grade:
(if applicable)
(Functional)
Number of Direct Reports:
Directorship / Registration:
NA
Position Purpose
IRP team is a centralized team with a set of experts, across all IRP end to end streams starting from Acquisition, Calculation and Reporting (Static and Dynamic). The core activity lies in handling day-to-day live production queries/issues. The role is diverse, demands the ability and expertise of client reporting and performance functions. The individual will be responsible for both the production and delivery of various lines of financial reports such as Accounting Reports, Investment Reports, Performance Reports, Risk Reports, and Attribution etc. The role majorly requires timely and prompt coordination and communication with various stakeholders spread across the globe (UK/AU/EU/SG/US) such as Operations, IT Service Delivery and IT Development teams.
Responsibilities
Direct Responsibilities
·Manage various database environment to maintain high availability.
·Monitoring database health and take appropriate action whenever needed to maintain it in good shape.
·Explore database new features and Study best-applicable implementation to be apply on the project (e.g. technical POC).
·Challenge and review the coding activities of the development team.
·Organize part of the peer-review activities during the lifecycle of the project.
·Keeps the development team up to date about the database best practices and in-site feedbacks.
·SQL Performance tuning.
·Create primary database storage structures, designing and creating primary objects, modifying database structure as necessary for enhancements or performance,
·Creating documentation, designing interfaces, database objects, and creating plans.
·Monitor and optimize performance of the database.
·Plan for backup and recovery of the database and allocate system storage and plan future storage needs.
·Create database-related scripts and programs to support development and production environments.
·Research, evaluate, design, test, recommend, and plan implementation of new or improved RDBMS, ETL and database tools.
Contributing Responsibilities
·Deliver technical documentation & solutions in line with group standards.
·Work in a rapidly changing environment in achieving Team goals.
·Ability to work to tight deadlines.
·Teamwork skills.
·Ensure good relationships.
·Capability to setup and run training sessions.
·Rigor and respect of the procedures.
·Good quality of written and oral expression.
Technical & Behavioral Competencies
• Experience in supporting relational databases as a DBA, with a depth and focus on Oracle and related tools.
·Exposure and practice at using the DBMS to optimize performance of large databases for enterprise use is preferred.
·Ability to perform technical analysis, design and identify impacts (functional/technical)
·Expertise in Database like Oracle / SQL /PL/SQL and Unix.
·Oracle database skills are mandatory.
·Major experience of SQL and PL/SQL development.
·Expertise in writing complex SQL query.
·SQL Performance Tuning (Mandatory).
·Data Modelling (Good to have).
·Knowledge/Hands-on on database administration activities
Specific Qualifications (if required)
- Experience of the financial services industry will be a distinct advantage.
- Inclination to understand and learn application/business functionality.
- Good communicator, fast learner & a Team player
- Attention to detail, disciplined and reliable.
- High motivation and confidence levels
- Can do attitude and attention to detail
Skills Referential
Behavioural Skills: (Please select up to 4 skills)
Creativity & Innovation / Problem solving
Ability to deliver / Results driven
Communication skills - oral & written
Choose an item.
Transversal Skills: (Please select up to 5 skills)
Ability to understand, explain and support change
Analytical Ability
Ability to anticipate business / strategic evolution
Choose an item.
Choose an item.
Education Level:
Bachelor Degree or equivalent
Experience Level
At least 10 years
Other/Specific Qualifications (if required)
• First class Graduate in any discipline (Computer Science preferred) from a reputed university with a good background of software development and a minimum IT experience of 8 years and Maximum 12 years.
• Resource who is Enthusiastic, Energetic and with a lot of interest to learn and adapt to new technical framework
