Job Title

BNP is looking for a Oracle PL/SQL Developer! Location - Chennai (Perungudi) Years - 5 - 8 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:- Experience in SQL and PL/SQL development - Oracle Database - 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