Senior Oracle Developer

Indsafri; Johannesburg; On-site; ZAR 600,000 - 1,000,000; Full time

Job summary

Indsafri seeks a Senior Oracle Developer to design, develop and maintain Oracle database solutions that support business objectives. You will work with stakeholders, project managers, and IT teams to deliver scalable database solutions with data integrity, performance and security.

You will design schemas, implement PL/SQL programs, tune queries, perform backups and upgrades, and mentor junior developers while ensuring high availability and robust data protection.

Qualifications

• Design and develop Oracle database solutions with schemas, tables, indexes.
• Develop and optimize complex SQL queries, PL/SQL code, and database functions.
• Ensure database design aligns with best practices and industry standards.
• Backups, restores, upgrades and security measures are implemented and maintained.

Responsibilities

• Design and implement Oracle database solutions including schemas, tables, indexes, and stored procedures.
• Optimize complex SQL and PL/SQL code to meet performance standards.
• Monitor and maintain database health and performance using Oracle tools.
• Collaborate with stakeholders to gather requirements and deliver scalable database solutions.

Skills

Oracle database

Advanced SQL

PL/SQL

Performance optimization

Problem solving

Stakeholder communication

Tools

Oracle tools

Job description

As a Senior Oracle Developer, you will be responsible for designing, developing, and maintaining Oracle database solutions that support business objectives. You will work closely with stakeholders, project managers, and IT teams to deliver efficient and scalable database solutions, ensuring data integrity, performance, and security.

Responsibilities

• Database Design and Development:
  
  
  
  • Design and implement Oracle database solutions, including schemas, tables, indexes, and stored procedures.
  
  
  • Develop and optimize complex SQL queries, PL/SQL code, and database functions to meet business requirements and performance standards.
  
  
  • Ensure database design aligns with best practices and industry standards.
  
  
  
  


• Performance Tuning and Optimisation:
  
  
  
  • Analyze and optimize database performance, including query tuning, indexing, and resource management.
  
  
  • Identify and resolve performance bottlenecks and scalability issues to ensure high availability and reliability.
  
  
  • Monitor and manage database health and performance using Oracle tools and utilities.
  
  
  
  


• Database Maintenance and Support:
  
  
  
  • Perform routine database maintenance tasks, including backups, restores, and upgrades.
  
  
  • Provide support for database-related issues, including troubleshooting and resolving problems.
  
  
  • Implement and enforce database security measures and access controls to protect sensitive data.
  
  
  
  


• Project Management and Collaboration:
  
  
  
  • Collaborate with project managers, business analysts, and IT teams to gather requirements and deliver database solutions that support project goals.
  
  
  • Lead and participate in database development projects, ensuring timely delivery and adherence to project specifications.
  
  
  • Provide technical leadership and mentorship to junior developers and team members.
  
  
  
  


• Documentation and Reporting:
  
  
  
  • Create and maintain comprehensive documentation for database designs, development processes, and system configurations.
  
  
  • Prepare and present reports on database performance, project status, and development activities to senior management.
  
  
  • Stay current with Oracle database technologies, industry trends, and best practices.
  
  
  • Recommend and implement improvements to enhance database performance, security, and functionality.
  
  
  • Participate in post-implementation reviews to assess database solutions and gather feedback for future enhancements
  
  
  
  

Technical Skills

• Strong knowledge of Oracle database architecture, design, and development.


• Advanced SQL and PL/SQL programming skills with a focus on performance optimization.


• Experience with database monitoring and management tools.


• Excellent analytical and problem-solving abilities.


• Strong communication and stakeholder management skills.

Company Description

Indsafri believes in the limitless potential of individuals to create and build anything imaginable. They leverage their deep industry experience and cutting-edge technology to help organizations transform for growth. They work with some of the best organizations around the world and have a global network of partners and talents. Indsafri believes that technology is at its best when it makes people smile. This is a place where with passion and intelligence, anything is possible.