AVP- Oracle PL/SQL Developer - Collateral IT

Overview

Job Title: Assistant Vice President – Oracle PL/Sql Developer – Collateral Management

Department: Global Markets IT

About Business Line/Function

The Global Markets business of BNP Paribas helps its corporate and institutional clients leverage capital markets across the globe for their financing, risk management and investment needs. This encompasses a wide range of financial products ranging from Foreign exchange to complex Equity Derivatives that are traded in financial markets across the globe 24/7. IT systems are integral to the business and are a key part of the value proposition to clients. These IT systems range from industry standard products for standard process automation to internally developed, often, market leading IT applications. The IT teams owning these IT systems are made up of functions that include Technical and Application production support, Business Analysis & Project Management, Development & Maintenance and Quality Control. BNP Paribas India Solutions is an equal partner in these IT functions along with colleagues in other locations including Paris, London, New York, Tokyo, Singapore & Hong Kong. This partnership ranges from sharing the IT workload, executing global strategy to owning global applications offshore. The technology and engineering landscape is wide, encompassing almost all techniques and platforms. It continues to evolve and transform with the market with the business continuing to invest in it.

Position Purpose

The position is for a senior SQL Developer in Oracle with Application DBA experience. The candidate would be responsible for designing, developing and optimizing existing SQL queries. This may involve close collaboration with the System DBAs to implement changes as direct access to change all System DB Parameters is restricted. This role requires a good knowledge of RDBMS concepts, SQL optimization and experience with SQL programming in Oracle. The candidate should be able to utilize CBO, tuning, execution plan analysis, TKPROF and AWR reports to solve and predict performance issues. The role also requires one to have an appreciation of the underlying data and business to understand the reports being developed and suggest better ways of sourcing the data. Some knowledge of how Java applications connect to the database is preferred but not mandatory.

Responsibilities

Direct Responsibilities

• Write optimized Oracle SQL queries for reports.
• Design and implement database schemas, tables, indexes, and constraints.
• Perform database tuning and performance optimization for existing queries by monitoring current
• performance and slowly degrading queries.
• Perform migration from Sybase to Oracle based queries as per requirement
  
  

Contributing Responsibilities

• Work closely with software developers, business analysts to understand requirements.
• Provide technical support and guidance on database best practices.
• Document database structures, processes, and procedures.
  
  

Technical & Behavioral Competencies

• Strong proficiency in Oracle SQL writing skills
• Knowledge of database performance tuning, indexing, and query optimization
• Experience with Oracle. Sybase experience is optional
• Some knowledge of how Java applications connect with the Database.
• Good communication skills and be able to work as part of a team
  
  

Specific Qualifications

• Minimum 10 years of experience along with Bachelor's Degree - in Engineering
• Prior experience in similar domain.
  
  

Technical Skills

Skills Referential (Required knowledge, skills and abilities)

• • Oracle PL/Sql
  • Performance Tuning knowledge
  • Knowledge of Oracle System tables
    

Behavioral Skills

• • Communication
  • Analytical Ability
  • Team Player
    

Education Level: Bachelor Degree or equivalent

Location: Bengaluru

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 specialized 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.

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.

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. 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.