Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in chennai
>
BNP Paribas
>
PLSQL Developer

PLSQL Developer

BNP Paribas

5 - 8 years

20 - 25 Lacs

chennai

Posted:2 months ago| Platform:

Apply

Skills Required

sql development data management plsql pl / sql development oracle sql performance tuning plsql development sql database design software development life cycle java er diagrams oracle database technical analysis debugging capacity analysis agile

Work Mode

Work from Office

Job Type

Full Time

Job Description

Position Purpose

This position is for Tax processing application development. The candidate should pose the relevant technical skills to develop code for various flagship and technical migration projects.

Candidate should develop a good understanding of the existing application (functional and technical)

Responsibilities

Direct Responsibilities

Oracle Developer will be performing:

Consistent work experience of 8 years in Oracle SQL and PL/SQL development.
Develop schemas, tables, indexes, sequences, constraints, functions, and procedures, Packages, Collections, Users and Roles.
Understand business requirements and accordingly develop database models.
Provide optimal design solutions to improve system quality and efficiency.
Follow best practices for database design.
Perform capacity analysis and oversee database tuning.
Maintain technical documentations for reference purposes.
Write complex codes and queries and participate in code reviews.
Perform design review, modify codes and test upgrades.
Work closely with other developers to improve applications and establish best practices.
An ability to understand front-end users requirements(Java) and a problem-solving attitude
In-depth understanding of data management (e.g. permissions, recovery, security and monitoring).
Provide training and knowledge sharing with the development team.
Maintains all databases required for development, testing, Pre-Production and production usage.
Takes care of the Database design and implementation.
Implement and maintain database security (create and maintain users and roles, assign privileges).
Performance tuning and monitoring, proactively propose solutions.
Perform Data anonymization

Technical & Behavioral Competencies

Knowledge and/or experience of the financial services industry
Good understanding of software development life cycle and Agile/Iterative methodology
Technical competency in the following:

SQL

- Good understanding of ER Diagrams, Data Flows

- Good to have experience on DB design & modelling

- Hands-on on performance tuning tools and debugging

Ability to perform technical analysis, design and identify impacts (functional/technical)

Prior experience in High Volume / Mission critical Systems is a plus

Contributing Responsibilities

Work in duet with our offshore and in-site technical team to coordinate the database initiatives.
Perform detailed technical analysis with impacts (technical/functionally) and prepare Technical specification document.
Mentor and carry out database peer code reviews of development team.
Bug fixing & performance optimization
Keep the development team up-to-date about the best-practices and in-site feedbacks.
Challenge the time-response performance and the maintainability of the treatments/queries.
Maintains data standards and security measures and anonymize Production data and import in Development and Testing environments.
Performance tuning and Monitoring of All databases and proactively propose solutions in case of issues.

Develop and unit test the code :

Develop the Code to suffice the business requirements
Unit test the code and bug fix all the defects arising out of the unit testing
Properly check in the code to avoid issues arising out of configuration management

Deploy and Integrate test the application Developed :

Deploy the developed code into the IST Environments and perform the Integration testing by working with the cross teams
Fix all the defects arising out of IST and UAT Testing.

Keep the development team up-to-date about the best practices and feedback.

Specific Qualifications (if required)

Skills Referential

Behavioural Skills:

Adaptability

Ability to deliver / Results driven

Creativity & Innovation / Problem solving

Ability to share / pass on knowledge

Transversal Skills:

Ability to manage / facilitate a meeting, seminar, committee, training

Ability to understand, explain and support change

Analytical Ability

Ability to develop others & improve their skills

Ability to develop and adapt a process

Education Level:

Bachelor Degree or equivalent

Experience Level

At least 5 years

More Jobs at BNP Paribas

BNP Paribas is hiring For Senior Support Analyst!

Bengaluru

4 - 8 yrs

INR 10 - 19 Lacs

Senior Support Analyst

Bengaluru

4 - 8 yrs

INR 10 - 18 Lacs

Java Full Stack Developer - Looking For Immediate joiner

Chennai

6 - 11 yrs

INR 0 - 1 Lacs

BNP Paribas is looking For a Product Owner!

Chennai

8 - 13 yrs

INR 15 - 25 Lacs

Full Stack Engineer

Chennai, Tamil Nadu, India

Experience: Not specified

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Java Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.