Oracle Developer (Senior) - Insure Systems at Discovery Limited

About Insure Systems

Discovery Insure Systems is a young dynamic team. We are constantly evolving and running with multiple projects simultaneously. We pride ourselves in the quality of work that we deliver and the ease and speed at which we can do it. Our aim to set the benchmark for efficiency in everything we set out to do.

Key Purpose

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

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.


 

Personal Attributes And Skills
Technical Competencies

• Data Modelling specifically related to OLTP
• PLSQL
• SQL
• XML
• Dynamic SQL
• SQL and PLSQL performance tuning
• Report writing
• BI/Warehouse/ETL
• Java SE

 

Essential
Education and Experience

• 5-7 years of consistent Oracle PL/SQL experience .
• Some knowledge and experience of PostgreSQL

 

Working Knowledge Of

• Software development within SDLC
• Unit Testing
• Data modelling and design of database structures

 

Advantageous

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