A Multinational Corporate Bank is looking to employ an ORACLE DEVELOPER to develop and maintain database applications in Oracle PL/SQL. The ideal candidate will have 3 years SQL experience, 2 year Oracle development experience and have obtained a BSc degree in Information Technology or equivalent.Purpose of the Job:
To develop and maintain database applications in Oracle PL/SQL
Setup an Oracle Data base
Code application logic in PL/SQL according to acceptable quality standards
Design Test Matrices, Test Cases, and Test Data
Maintain Documentation
Maintain Code in Source Management Software
Profile Applications and optimise code
Ensure compliance with quality standards

 
Job Functions:
Generate reports from data using SQL
Develop and implement systems according to specifications
Test, debug and quality assure programmed code
Develop in a structured environment using versioning control
Support existing systems by investigating, identifying and rectifying problems.
Customer Interfacing
Responsibilities within Team

 
Competencies
Technical Skills & Competencies
Ability to work within a team
Intelligent
Responsible
Communication skills
Methodical
Logical deduction and reasoning
Results driven and quality focused
Problem solving and Analysis
Advanced Documentation Skills

 
Knowledge and skills
Oracle RDBMS 9i Release 2 and its utilities (SQLPLUS, SQLLOADER)
PL/SQL
SQL

 
Expertise
GUI:
Program Structure
•  Logical level
•  Class
•  Modules
Program Language Features
•  Methods
•  Properties
•  Inheritance
 
WEB:
HTML
XML
Frames
Java Script
Java SP
Active X
 
Data Base (Programming)
Relational Model
Data Definition (DDL)
Optimisation of Code
Data Manipulation (DML)
Transactioning
•  Short
•  Long
DB Coding Standards
Exception Handling
Multi Dimensional
•  Cube
•  Rollup
Pseudo Code on DB
 
Multi Tier: (Advanced Programming Skills)
Tiering & Layering
Persistence
Application Services
Threading & Multiprocessing
Services & Connections
Scalability
Fail over Safety
 
Methodology:
Application Featuring
Data
Function
Process
Object Modeling
State
Pseudo Code
Program Structures
Spec development
Documentation
Coding Standards
Testing
 
Project Life Cycle Knowledge & Tools:
Application Segmentation
Development Schedule
Development Estimation
Development Project Plan
Knowledge of Development Life Cycle
WBS
Time Recording
Version Control
Source Code Management
Debug Tools
Profiling Tools
Testing & Tools
 
Team Functioning:
Documenting Skills
Team interaction
Commitment
Participation
Dedication, etc
 
Experience
3 years SQL experience
2 year Oracle development experience

 
Industry Experience
Financial Services and/or Banking, Investments, Insurance, etc.
Retail Sector – Supply Chain Management, Logistics, Warehousing,
Distribution, Retail, Procurement, Cost Modeling, Financial Modeling, etc.
Manufacturing

 
Location
Head Office based in Sandton
Will work offsite at Client Sites most of the time.
Travelling in SA and Abroad for long term and short term projects from time to time – passport a must

 
Education
BSc degree in Information Technology or equivalent is required
 
General
Candidates must be able to work well structured and follow strict methodological processes
Candidates must also be able to model and think in a conceptual manner