Oracle Developer at Capitec Bank

Purpose Statement
Enhance and future-proof the application database(s) for Capitec product offerings through:

• Fulfilling the role of a subject matter expert and senior database advisor on all matters relating to tuning, index design, data archiving and performance optimisation. Providing subject matter expertise and insights towards development, and to perform CRUD (Create, Read, Update and Delete) operations for database applications.
• Administering and performance tuning databases that run on top of the database platform, and ensuring it is optimally configured to sustain current and anticipated future growth.
• Developing, maintaining and ensuring best practices are followed by the Product Team members.
• Report writing and building functionality to current applications 

Experience
MINIMUM:

• 3- 5 years’ experience in PL-SQL programming and Oracle performance tuning and optimisation
• Previous experience in coaching, mentoring and guidance of team members
• Training staff and end-users on data storage and retrieval processes.
• Experience in data management

IDEAL:

• 5+ years’ experience in PL-SQL programming, Oracle performance tuning and optimisation
• Previous experience as a Data Specialist

Qualifications (Minimum)

• Grade 12 National Certificate / Vocational

Certification
Qualifications (Ideal or Preferred)

• Bachelor's Degree in Information Technology - Systems Engineering or Information Technology - Computer Science

Knowledge
MINIMUM:

• Familiarity with a variety of development platforms
• In-depth knowledge of data retrieval and storage systems.
• Performance tuning and optimisation
• Oracle management systems performance and capacity analysis
• Oracle  Internals
• PL-SQL Programming Server Internals
• Advanced database concepts

A sound understanding of:

• Oracle design and administration
• IT systems development processes (SDLC lifecycle)
• Business continuity planning
• IT Operations

IDEAL:

• Cloud platforms for AWS/Azure
• Application Delivery Controllers
• Automation, scripting (Ansible)
• Monitoring tools
• Capacity Planning
• BCP Concepts
• Containers
• Data warehousing
• Big data
• Powercard

Skills

• Attention to Detail
• Communications Skills
• Decision making skills
• Problem solving skills
• SQL Skills

Conditions of Employment

• Clear criminal and credit record