Responsibilities

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

- Valuable 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

📌 Oracle PLSQL Developer (Chennai)
🏢 Synechron
📍 Chennai