Oracle Developer at Discovery Limited

Job description

Key Purpose of the role

Design and implement robust, scalable and optimally performing systems using Oracle related technologies, according to provided specifications, standards and procedures, while ensuring compliance with the architectural standards and guidelines laid out by Discovery.

Areas of responsibility may include but not limited to

• Design:
• Translate business requirements into technical designs adhering to Discovery Insure processes, standards and guidelines, taking cognisance of performance, security and scalability requirements. Deliver within agreed timeframes.
• Liaise with relevant parties where clarification of business requirements or resolution to technical issues is needed
• Research and find effective solutions to technical issues that arise
• Estimate development timelines based on business requirements
• Development:
• Construct robust, maintainable, scalable, optimally performing system code in line with technical specifications, following prescribed process, standards and procedures. Deliver within agreed timeframes
• Conduct unit testing and fix any defects found
• Testing:
• Verify build stability and quality with development team before releasing to test team, aiming to release with zero defects
• Assist the Business analyst in ensuring the test pack includes relevant scenarios and test data.
• Consult and assist in reviewing risk / impact of defects found in testing, and assist with fixing where necessary
• Support / Troubleshooting:
• Assist system users with technical support issues and handle according to defined procedures
• Ability to effectively analyse root cause of system errors (data errors, performance and stability issues)
• Mentoring / Team development:
• Actively coach other developers to understand and apply the Insure coding and architectural standards correctly, as well as any technologies in use
• Perform code review to ensure logical correctness, maintainability, scalability, performance, compliance with architectural standards and frameworks
• Assist in identifying training needs of team members [Senior only]
• Personal development:
• Keep abreast of current technological trends and how these might be applied in the Discovery environment
• Constant improvement of knowledge of the various applications, their functionalities and data models
• General:
• Ability to communicate clearly, constructively and effectively. Easily able to follow and participate in technical, business process, and other discussions
• Able to build business relationships with other members of team and the business areas we support.

Behavioural Competencies

Required Core Competencies

Using a rating scale of 1 to 5 (where 1 = beginner and 5 = expert)

• Data Modelling specifically related to OLTP [Mid Level=3)
• PLSQL [Mid Level=3)
• SQL [Mid Level=3)
• XML [Mid Level=3)
• Dynamic SQL [Mid Level=2)
• SQL and PLSQL performance tuning [Mid Level=3)
• Report writing [Mid Level=3)

Advantageous Experience

• BI/Warehouse/ETL [Mid Level=2)
• Java SE [Mid Level=2,)
• Short Term Insurance [Mid Level=2)
• Working knowledge of:
• Software development within SDLC
• Unit Testing
• Data modelling and design of database structures-

Education

Essential:

3-5 years of consistent experience in the listed core competency areas.

Advantageous:

• BSc Computer Science or equivalent 3 year qualification
• Oracle Certified Professional Advanced PLSQL developer