Oracle Developer at Discovery Limited

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 [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.

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]
• Dynamic SQL [Mid Level=2]
• SQL and PLSQL performance tuning [Mid Level=3]
• Report writing [Mid Level=3]

Advantageous Experience

• MSSQL server + SSIS
• BI / Warehouse/ ETL

Working Knowledge Of

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

Behavioural Skills

• Action orientated go-getter, hungry to learn and add real value
• Structured and analytical problem solver: Obsessive about finding solutions to problems: action oriented problem solver.
• Able to plan, organise and prioritize own work
• Able to multitask
• Able to work independently
• Able to work under pressure
• Team player: reliable, works actively with others towards common goal, communicates constructively, shares information, knowledge and experience, treats others in a respectful and supportive manner
• Flexible and able to adapt to changing requirements

Education And Experience

• 2-5 years of consistent experience in the listed core competency areas – Essential
• BSc Computer Science or equivalent 3 year qualification
• Oracle Certified Professional - Advanced PLSQL developer