Objectives

The primary objective of this tender is to appoint a qualified service provider to support and maintain the Oracle Database, Oracle Application Server, and Microsoft SQL Server environments at Joburg Market for a period of 36 months. The aim is to ensure continuous system availability, optimal performance, security, and support for critical business operations, including sales processing, producer payments, data warehousing, and enterprise resource planning (ERP) systems.

Scope

The scope encompasses comprehensive database and application server administration, including:

• Routine monthly maintenance activities such as backups, performance tuning, security checks, and patching.
• System upgrades, patches, and version migrations as required.
• Support for Oracle Data Guard, Data Pump, RMAN, and other advanced features like RAC, Active Data Guard, and partitioning.
• Support for Oracle Forms, Reports, BI Publisher, Weblogic, and Oracle APEX environments.
• Support for Microsoft SQL Server systems supporting current and future applications.
• Disaster recovery testing, data migrations, and system expansions.
• Application server management including Weblogic and Oracle Application Express.
• Support for integration points between Oracle and JDE Edwards systems.
• Ad-hoc support for new implementations, software upgrades, and cloud provisioning as needed.

Technical Requirements

The technical requirements specify that the service provider must:

• Possess proven expertise in Oracle Database 19c or higher, Oracle Forms, BI Publisher, Weblogic, and Oracle APEX.
• Have experience with Oracle Data Guard, Data Pump, RMAN, RAC, Active Data Guard, and partitioning.
• Be capable of performing daily, weekly, monthly, and quarterly database and application server tasks, including backups, performance tuning, patching, upgrades, and failover testing.
• Support Oracle on Unix/Linux/Solaris environments, with shell scripting and automation skills.
• Maintain Microsoft SQL Server environments, with expertise in performance tuning, backups, patching, and troubleshooting.
• Adhere to specified response times based on system classification (Mission Critical, Important, Normal, Low).
• Implement change management, escalation procedures, and ensure compliance with Joburg Market’s policies.
• Provide documentation, training, and knowledge transfer to Joburg Market staff.

Skills Requirements

The successful bidder must demonstrate:

• Strong technical expertise in Oracle Database administration, including advanced features and high availability solutions.
• Experience with Oracle Application Server, Weblogic, BI Publisher, and Oracle APEX.
• Proficiency in SQL Server management, performance tuning, and troubleshooting.
• Shell scripting and automation skills for Unix/Linux environments.
• Experience with disaster recovery, backup and restore procedures, and system failover testing.
• Ability to perform system upgrades, patches, and migrations with minimal downtime.
• Excellent problem-solving, communication, and documentation skills.
• Capacity to work within strict response times and adhere to change management protocols.
• Relevant certifications such as Oracle Certified Professional (OCP), Oracle Certified Database Administrator, and Microsoft Certified Solutions Expert (MCSE) are preferred.