Senior Software Engineer - Oracle PL SQL

NEC Software Solutions (India); Mumbai; On-site; INR 900,000 - 1,300,000; Full time

Job summary

NEC Software Solutions (India) is looking for an experienced PL/SQL Developer to join our development team in India. The role involves translating LLD into code, building robust PL/SQL components, and writing unit tests to ensure high quality software.

The ideal candidate will have 5-7 years of software development experience, strong analytical and problem-solving abilities, and a track record of taking ownership of technical issues and delivering solutions on time.

Qualifications

• 5-7 years of experience in software development.
• Strong PL/SQL programming skills and XML/HTML experience.
• Experience writing database packages, stored procedures, functions and triggers.
• Experience in a product environment.
• Ability to translate LLD into code and write unit tests.

Responsibilities

• Produce quality code by team members and ensure timely delivery.
• Follow current quality standards and procedures.
• Ensure own work is peer reviewed and perform peer reviews.
• Carry out unit tests and coordinate with Testing and Product teams to resolve issues.
• Escalate issues to Team Lead/Project Manager in a timely manner.
• Suggest improvements to development practices to increase productivity and quality.
• Manage release and configuration procedures to ensure correct code versions are available for build.

Skills

Translate LLD into code

Analytical skills

Problem-solving

Unit testing

Ownership of issues

Code to specification

Education

Bachelor's degree

Tools

Oracle SQL

PL/SQL

Toad/SQL Developer

Oracle APEX

Explain Plan/Trace tools

XML/HTML

Job description

Company Description

Our philosophy is to understand our customers’ business first before we get to the technology. This approach leads to clever software; streamlining old processes, saving money and delivering positive change. Our technology has helped the NHS screen millions of babies for hearing loss, ensures hundreds of housing providers are managing their homes efficiently and helps officers in over a dozen different police forces to make better decisions at the frontline. Based in the UK but working around the world, our 2,000 employees help improve the services that matter most. We are now part of the NEC corporation, a leader in the integration of IT and network technologies that benefit businesses and people worldwide – this brings in new opportunities without limits for growth and innovation.

Job Description

Role Summary

The team is tasked to deliver new projects driven by customer requirements, modifications/enhancements to existing areas of the applications, bespoke solutions directly to specific clients and support & maintenance, either through bug fixing or working with the Customer Management group on more technical issues raised by customers.

• Ability to translate LLD into code.
• Should have strong Analytical Skill.
• Should be able to write technical design specifications/documents and test cases.
• Producing code to the specification within agreed estimates and timescales.
• Ability to create Unit Test cases.
• Is able to do understand Impact of code in relevant modules.
• Familiarity with Functional Hierarchy Diagrams, Entity Relationship models and server model design.

Total Experience - 5-7yrs

Technologies Hands-on Experience (Years) Priority

• Ability to translate LLD into code and able to write Unit Test Cases.
• Should have strong Analytical Skill and problem-solving skills
• A proven track record of taking ownership of technical issues/assignments and delivering solutions through to conclusion
• Producing code to the specification within agreed estimates and timescales
• Is able to do understand Impact of code in relevant modules.
• Experience of XML, HTML and HTML DB experience.
• Experience working in a product environment.

• ORACLE SQL 5+ 1
• PL/SQL - Strong PL/SQL Programming Skills,
• experience in writing Database Packages,
• Stored Procedures, Functions, Triggers,
• Views, Objects/Collections in PL/SQL 5+ 1
• Databases: ORACLE 10g, 11g, 12c5+1
• Explain Plan and Trace tools for SQL
• performance tuning 2+ 1
• SQL*Plus 1+ 1
• Oracle APEX [3.0,4.0] 1+ 2
• Toad/SQL Developer 2+ 2
• XML/HTML 1+ 1

Overall Project/Task Description

• Production of Quality Code by team members including
• Producing code to the specification within agreed estimates and timescales
• Following current quality standards and procedures
• Ensure his/her own work is peer reviewed
• Carrying out peer reviews
• Carrying out Unit Tests
• Liaising with Testing and Product to resolve simple issues
• Escalating other issues to the Team Lead/Project Manager in a timely manner
• Continuous Improvement including
• Suggesting improvements to the Development practices to increase productivity and quality
• Release Management including
• Following current configuration management procedures so that correct versions of the code are available for build

Qualifications

Any Graduate

Additional Information

NA