Senior Oracle Developer

Indsafri; South Africa; On-site; ZAR 700,000 - 1,100,000; Full time

Job summary

Indsafri in South Africa is seeking a Senior Oracle Developer to design, develop, and maintain Oracle database solutions that support the company's investments objectives. You will work with stakeholders to deliver scalable, secure data platforms and ensure data integrity while optimizing performance.

You will lead complex SQL/PL-SQL development, mentor junior developers, and collaborate across IT and business teams to deliver reliable database services, backups, upgrades, and security control.

Qualifications

• 7+ years of experience designing, developing, and optimizing Oracle database solutions.
• Strong SQL/PL-SQL proficiency and performance tuning capabilities.
• Experience with data migration, ETL processes, and database integration.
• Bachelor's degree in CS/IT or related field; Oracle Certified Professional is a plus.

Responsibilities

• Design and implement Oracle database schemas, tables, indexes, and procedures.
• Develop and optimize complex SQL/PL-SQL queries to meet business needs.
• Perform backups, restores, upgrades, and ensure data security.
• Collaborate with project managers and IT teams to deliver scalable solutions.
• Mentor junior developers and provide technical leadership.

Skills

Oracle Database Architecture

SQL

PL/SQL

Performance Tuning

Data Migration

ETL

Database Design

Query Optimization

Analytical Skills

Problem-Solving

Communication Skills

Leadership

Mentorship

Documentation

Education

Bachelor's degree in Computer Science/Information Technology or related field

Oracle Certified Professional (nice to have)

Tools

Oracle SQL Developer

Oracle Tools

Monitoring Tools

ETL Tools

Job description

As a Senior Oracle Developer, you will be responsible for designing, developing, and maintaining Oracle database solutions that support the company's investments 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 and work outputs:

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.

Qualifications, Knowledge & Experience

• Education:
• Bachelor's degree in Computer Science, Information Technology, or a related field. Advanced degree or relevant certifications (e.g., Oracle Certified Professional) is a plus.
• Experience:
• 7+ years of experience as an Oracle Developer, with a strong background in designing, developing, and optimizing Oracle database solutions.
• Proven experience with Oracle database tools and technologies (e.g., Oracle SQL, PL/SQL, Oracle Performance Tuning).
• Experience with data migration, ETL processes, and database integration.
• Skills:
• Advanced knowledge of Oracle database architecture, design, and development.
• Strong proficiency in SQL and PL/SQL programming, with a focus on performance optimization.
• Excellent analytical and problem-solving skills, with the ability to address complex database challenges.
• Effective communication and interpersonal skills, with the ability to collaborate with stakeholders and team members.
• Experience with database management and monitoring tools.
• Business Acumen
• Client/Stakeholder Commitment
• Drive for Results
• Leads Change and Innovation
• Impact and Influence
• Self-Awareness and Insight
• Diversity and Inclusiveness

Skills

Oracle Database Solutions SQL PL/SQL database design Database Development Database Optimization Query tuning Indexing Resource management performance tuning Scalability Database Maintenance Database backups Database Restores Database Upgrades Troubleshooting Database security Access controls Project Management Collaboration Technical Leadership Mentorship Documentation Reporting Oracle Technologies Industry Trends data migration ETL Processes database integration Database Architecture analytical skills problem-solving skills communication skills interpersonal skills Database Management Tools Database Monitoring Tools Business Acumen Client/Stakeholder Commitment Results-driven change management Innovation Impact and Influence Self-Awareness Insight Diversity and Inclusiveness