Senior Software Engineer - Oracle PL SQL

Posted Yesterday
Be an Early Applicant
Mumbai, Maharashtra, IND
Hybrid
Senior level
Software • Consulting
The Role
Design, develop and maintain Oracle-based applications: translate low-level designs into PL/SQL code, write packages/procedures/functions/triggers, produce unit tests and technical specifications, perform peer reviews, assist testing and product teams, and support performance tuning and release/configuration management.
Summary Generated by Built In
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.

 

Technologies

Hands-on

                                                                                 (Years)                                           Priority

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

Skills Required

  • Total experience 5-7 years
  • Strong PL/SQL programming skills (packages, stored procedures, functions, triggers, views, objects/collections)
  • Oracle SQL (5+ years)
  • Experience with Oracle databases (10g, 11g, 12c)
  • SQL performance tuning using Explain Plan and Trace tools (2+ years)
  • SQL*Plus (1+ years)
  • Oracle APEX (3.0/4.0) (1+ years)
  • Toad or SQL Developer (2+ years)
  • XML/HTML/HTML DB experience (1+ years)
  • Ability to translate Low Level Design (LLD) into code and produce unit test cases
  • Ability to write technical design specifications and test cases
  • Experience working in a product environment
  • Graduate degree (Any Graduate)
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Hemel Hempstead
1,380 Employees

What We Do

Innovation when it matters most. We build software and services that help keep people safer, healthier, and better connected worldwide. Our customers are national governments and international health bodies. They’re also police forces, emergency services, local authorities, and housing providers, all working to prevent harm and provide the right support. Our software and services get them great outcomes

Similar Jobs

In-Office
Mumbai, Maharashtra, IND
1380 Employees

MetLife Logo MetLife

Platform Engineer

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Hybrid
Pune, Maharashtra, IND
43000 Employees

MetLife Logo MetLife

Platform Engineer

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Hybrid
Pune, Maharashtra, IND
43000 Employees

MetLife Logo MetLife

Platform Engineer

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Hybrid
Pune, Maharashtra, IND
43000 Employees

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account