Senior Oracle PL/SQL Developer

Boardroom Appointments; Cape Town; On-site; ZAR 800,000 - 1,200,000; Full time

Job summary

Boardroom Appointments is seeking a Senior Oracle PL/SQL Developer to design and implement high-performance database solutions. The role emphasizes Oracle PL/SQL mastery, SQL excellence, and data modelling in a high-volume environment.

The candidate will work within a technical team, plan development work, and contribute to SDLC processes, including unit testing, code reviews, and knowledge sharing. Collaboration with internal and external resources is required.

Qualifications

• Expertise in Oracle PL/SQL
• Strong SQL knowledge and data modelling skills
• Experience in high data volume environments
• Good communication and teamwork abilities
• Understanding of the full SDLC and disciplined code maintenance
• Experience with AWS RDS & Aurora
• Ability to work with internal and external resources
• Ability to plan, estimate effort, and deliverables
• Knowledge of data management strategies and reporting data usage
• Experience with unit testing and code reviews

Responsibilities

• Implement tactical design
• Analyze requirements and design specifications at system/enterprise level
• Provide effort estimates and impact analysis
• Develop in PL/SQL and MySQL
• Unit test developed code
• Conduct code reviews for PL/SQL and MySQL
• Review documents and design data management strategies
• Share knowledge with the team
• Provide 3rd line support
• Develop functional and technical specifications
• Assist with client proposals
• Attend project meetings and report progress
• Ensure performance and delivery of team members

Skills

Oracle PL/SQL

SQL

Data modelling

Data architecture

Analytical thinking

Communication skills

Team collaboration

SDLC understanding

Problem solving

AWS RDS & Aurora

Tools

MySQL

PL/SQL development tools

Job description

About the job Senior Oracle PL/SQL Developer

• Good technical understanding of data modelling, design and architecture principles and techniques
• Expert understanding of Oracle PL/SQL
• Experience in high data volume environments
• Expert understanding of SQL
• Excellent analytical and problem solving ability
• Professional and effective communication skills
• Ability to work within a technical team comprised of internal and external resources
• Ability to plan and organize development work and deliverables
• Understanding of the full SDLC
• Disciplined approach to code maintenance
• AWS RDS & Aurora

Responsibilities:

• Implementation of tactical design
• Requirements analysis and specification design at a system/enterprise level
• Effort estimates and impact analysis for self and others in line with organization objectives
• Development in PL/SQL and MySQL
• Unit testing of developed code
• Code Reviews of development done in PL/SQL and MySQL
• Document reviews
• Design & Implement Data Management strategies which include validation of source data and the use of data in management Reporting
• Knowledge sharing with team
• 3rd line support
• Development of Functional Specifications and Technical specifications
• Assist with proposals to client
• Attend project meetings and supply updates on progress
• Responsible for the performance and delivery of team members