Senior Oracle Developer MMH261001-11

Momentum; Centurion; On-site; ZAR 900,000 - 1,200,000; Full time

Job summary

Momentum is seeking a Senior Oracle Developer to design, develop, and maintain Oracle database solutions that support Momentum Investments’ business objectives. You will ensure data integrity, security, and high performance while collaborating with stakeholders and IT teams.

The role requires 7+ years in Oracle development, 2+ years with Oracle Apex, and strong SQL/PL SQL capabilities. You will lead projects, optimize queries, and contribute to system architecture enhancements.

Qualifications

• Bachelor’s degree in Computer Science, IT, or related field; advanced degree or certifications is a plus.

Responsibilities

• Design and implement Oracle database solutions including schemas, tables, indexes, and procedures.
• Develop and optimize SQL queries, PL/SQL, and database functions to meet performance standards.
• Ensure data security, integrity, and aligned with industry best practices.
• Monitor and optimize database performance, including indexing and resource management.
• Provide maintenance, backups, restores, and upgrades for databases.
• Lead and mentor junior developers and collaborate with project teams.
• Create and maintain comprehensive documentation and reporting on database systems.

Skills

Oracle Apex

SQL

PL/SQL

Performance tuning

Analytical skills

Communication

Database monitoring

Education

Bachelor’s degree in Computer Science/IT

Oracle Certified Professional (OC:P) or equivalent

Tools

Oracle Apex

Oracle SQL

PL/SQL

Oracle Performance Tuning

Job description

Role Purpose

As a Senior Oracle Developer, you will be responsible for designing, developing, and maintaining Oracle database solutions that support Momentum 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.

Requirements

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.
• 2+ years of solid experience with Oracle Apex.
• 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.

Duties and 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.

Continuous Improvement

• 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