Database Administrator – Microsoft SQL / Kinetica

Job Title: Database Administrator – Microsoft SQL / Kinetica

Department: RISK IT

About Business line/Function:

The mission of Risk Systems is to provide Senior Management of the Group, of the Operating Divisions, and of RISK with full transparency and dynamic analysis of the risks and clients managed by Corporate Investment Banking (CIB) and Investment Solutions (IS) Business Units, as per the scope detailed below. 

On Market & Liquidity risks: it is Group-wide. Risk Systems comprehensively covers the CIB capital markets activities, ALM Treasury as well as the IS Business Units,  

On Counterparty risks: it is Group-wide. Risk Systems cover all counterparty risks arising from derivative and repo transactions,   

Depending on mandates given, Risk Systems also assumes, directly or indirectly, responsibility for the above risk categories in specific areas of the Retail Business Units. 

To provide a fully integrated market and counterparty risk management system, combining flexibility with industrial reliability, operating at the heart of the bank’s risk management framework helping to protect shareholder value and the integrity of investment banking activities

Position Purpose:

Within BNP Paribas, RISK group is responsible for calculating & providing Market and Credit Risk to traders, market, and risk analysts. We are looking for a Database Administrator responsible for the administration, optimization, and lifecycle management of multiple database instances. You will analyze all available sources of information, as well as liaising with colleagues to obtain technical & business knowledge in order to ensure quick resolution to run the business functions. The main objective is to consistently deliver high quality client services to Risk Systems users by combining industrial operational processes with sound risk knowledge. The team is responsible to ensure the correct risks are available in timely manner and to provide functional provision of the risk system to the users daily. As the bank moves toward an AI-integrated landscape, this role is designed to be forward-looking, seeking a professional who can leverage AI-enabled tools and AIOps methodologies to enhance database observability, automate complex workflows, and support the data requirements of emerging AI initiatives.

Responsibilities

Direct Responsibilities

• Providing technical support to users, developers, and application support teams for database topics.
• Providing support on how to improve/optimise sql queries, through better sql construction for the DDL/DML, including suggestions on DML improvements given data and query patterns
• Intervening in the event of incidents which limit the performance of databases or access to information
• Active participation in post-mortems for major and/or recurring database incidents
• Ensuring technological monitoring to maintain the suitability of performance and database specificities for meeting needs
• Maintain high availability (HA) and disaster recovery (DR) configurations, ensuring adherence to strict Banking RTO/RPO targets
• Assessing and deploying innovative solutions which permit the simplification, automation, or optimisation of database costs
• Automating recurrent database administration tasks, ensuring there is adequate monitoring and reporting for performance with a view on capacity management e.g. of disk, cpu, memory
• Familiarity with AI-enabled observability tools, AIOps platforms, or the use of Generative AI to augment technical workflows (coding, troubleshooting, or automation).
• Making database implementation choices, in accordance with the specifications and in collaboration with the various project players
• Appropriate and timely communication with all stakeholders 
• Ability to operate in Agile methodology and have an understanding on deliverables
• Maintain quality of deliverables to keep the key KPI and trends in check 
• Provide input to the implementation plans 
• Creative problem-solving ability, inquisitive mind-set, comfortable with working on ambiguous situation 
• Attention to detail and high-quality standards of documentation, processes and control of environment 

Technical & Behavioral Competencies

• Strong Database administrator experience for IT Production environment in Investment banking domain

• Hands-on experience in Microsoft SQL or Sybase IQ or Kinetika databases

• Hands-on experience in Unix/Linux systems and Shell or Python scripting

• Have worked in production systems with critical systems following SDLC lifecycle

• Team player with strong interpersonal, oral and written communication skills

• Experience of Java would be an added advantage

Specific Qualifications:

• Minimum 10-15 years of hands-on DBA support experience in Microsoft SQL or Sybase IQ or Kinetika database.

Skills Referential (Required knowledge, skills and abilities)

Technical Skills:

• Microsoft SQL / Kinetica / Sybase IQ 
• Unix / Python / Shell scripting
• Dynatrace (good to have) 

Behavioral Skills: 

• Communication
• Analytical Ability
• Team Player

Education Level: Bachelor Degree or equivalent

Location: Mumbai / Thane

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