Technical Lead - Oracle DBA

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 Businessline/Function MTM , aka Money Transfer Management is an application that caters to Money Transfer needs for 16 branches in BP2S.It is used for both inter and intra bank money transfers via different messages like SWIFT, SIC, messages to ARPE, etc.Being an application used for Money transfer its considered as Tier I application in terms of Criticality in whole BNP Paris Group.

Job Title Technical Lead / Senior Technical Lead

Date 08/02/2024

Department CIB2S Location: Chennai

Business Line / Function HVP-MTM

Reports To (Direct)

Grade (if applicable) NA (Functional)

Number Of Direct Reports Directorship / Registration: NA Position Purpose We are looking for a passionate technologist to design, architect, develop and deploy software solutions. The successful candidate will be able to - Build high quality, innovative and fully performing software in compliance with coding standards and technical design.

• Design, architect, modify, refactor, develop, write and implement high quality software applications. Measure and tune application performance as per non-functional requirement. Perform code review to ensure high code quality.
• Support SDLC cycle, DevSecOps, integration with monitoring and observability tools. Good collaboration with Onshore and Offshore teams Requires a bachelor's degree in a related area and 10+ years of experience as an Oracle DBA. Has knowledge of commonly used concepts, practices and procedures within a particular field. Rely on instructions and pre-established guidelines to perform the functions of the job. Work under immediate supervision. Primary job functions do not typically require exercising independent judgment. Typically reports to a manager. Responsibilities

Responsibilities Direct Responsibilities

• Install, configure, and maintain Oracle databases.
• In charge of developing and implementing database backups and disaster recovery strategies.
• Optimize database performance by fine-tuning database settings.
• Troubleshoot and resolve database-related issues to contribute to continuous improvements.
• Develop, implement, and manage database security policies and procedures to guarantee a seamless and successful flow of activities.
• Work closely with team members to guarantee database operation and integrity.
• Introduce and deploy new database technology.
• Maintain database reports, visualizations, and dashboards to help existing workflows.
• Assess the suitability of data for storage and the best way to organize storage.
• Defines, documents, and implements standards and complicated models to monitor and improve the database's capacity and performance.
• Maintains knowledge of and assesses new and developing technologies and tools for field application
• Reduce database downtime and control parameters to ensure quick query responses.
• Ensure SLAs and operational KPIs are fulfilled, collaborating with internal and external support departments as needed when large events occur. Contributing Responsibilities
• Direct Responsibilities
• 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 Technical Skills; Proficiency in Oracle Database Server Architecture. Advanced understanding of database security, backup and recovery, and performance monitoring requirements Modeling of relational and dimensional data

PowerShell And Unix Shell Scripting Abilities Are Required. Strong written and oral communication abilities Knowledge of Linux Server infrastructures Knowledge of Oracle Real Application Clusters (RAC), ASM, and Active Data Guard. Prior knowledge of DBA case tools (frontend/backend) and third-party tools is required. Extensive knowledge of database standards and end-user applications and the ability to translate capacity needs into infrastructure deployment technologies.

Behavioral Skills

• End to end application tech ownership, maintain book of work, collaboration with global teams.
• Lead a team of developers and provide technical guidance, code review, and mentoring.

Specific Qualifications (if Required)

• At least 10 years of Hands on work experience in an Enterprise environment, preferably working in multi-location IT teams

Skills Referential Behavioural Skills: (Please select up to 4 skills) Ability to collaborate / Teamwork Adaptability Creativity & Innovation / Problem solving Resilience Transversal Skills: (Please select up to 5 skills) Analytical Ability Ability to understand, explain and support change Ability to develop and adapt a process Ability to anticipate business / strategic evolution Ability to inspire others & generate people's commitment

Education Level Bachelor Degree or equivalent Experience Level At least 10 years

Other/Specific Qualifications (if Required) B.E or equivalent