PLSQL Developer (Oracle, PLSQL, Unix L4)

Direct Responsibilities
Oracle Developer will be performing:
- Consistent work experience of 9 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
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.
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
 

Specific Qualifications:
Graduate degree in computer science 

Skills Referential (Required knowledge, skills and abilities)
Technical Skills:
  . Oracle SQL/PLSQL
. DB design& Modeling
. Oracle performance tuning/Debugging
. Develop schemas, tables, indexes, sequences, constraints, functions, and procedures, Packages, Collections, Users and Roles
. Cloud/DevOps

Behavioral Skills:
. Adaptability
. Ability to deliver / Results driven
. Creativity & Innovation / Problem solving
. Ability to share / pass on knowledge
   
Education Level: Bachelor Degree or equivalent