Oracle PLSQL Developer

Synechron; Chennai District; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Synechron is seeking an experienced Oracle SQL/PLSQL developer in our Chennai office to lead database design and implementation. The role requires deep expertise in schemas, indexes, sequences, and security, with a strong focus on performance tuning.

With overall responsibilities spanning development, testing, and production support, you will work closely with offshore and on-site teams to deliver robust data solutions and mentor peers in best practices.

Qualifications

• Nine years of experience 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 translate into database models.
• Knowledge of data security, recovery, permissions and monitoring.

Responsibilities

• Develop and maintain database schemas and objects to meet business requirements.
• Perform capacity analysis and database tuning for performance improvements.
• Write complex queries and participate in code reviews.
• Collaborate with developers to implement best practices and improve applications.
• Provide training and knowledge sharing to the development team.
• Maintain databases for development, testing, pre-production, and production usage.

Skills

Oracle SQL/PLSQL

DB design

Performance tuning

Java understanding

Cloud/DevOps

Education

Bachelor's degree in Computer Science

Tools

Oracle Database

Job description

Responsibilities

Direct Responsibilities

• 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