This opportunity is closed for applications

The deadline was Thursday 12 May 2022
UK Shared Business Services Ltd (06330639)

DDaT22030 Oracle Development Team

5 Incomplete applications

4 SME, 1 large

2 Completed applications

2 SME, 0 large

Important dates

Published
Thursday 28 April 2022
Deadline for asking questions
Thursday 5 May 2022 at 11:59pm GMT
Closing date for applications
Thursday 12 May 2022 at 11:59pm GMT

Overview

Off-payroll (IR35) determination
Supply of resource: the off-payroll rules will apply to any workers engaged through a qualifying intermediary, such as their own limited company
Summary of the work
Maintain all the existing Oracle Applications databases, and the associated hardware and storage to the latest versions to ensure we have a high performing on-premise capability.
Maintain our current cloud functionality that we have progressed.
Latest start date
Thursday 30 June 2022
Expected contract length
24-months.
Location
South West England
Organisation the work is for
UK Shared Business Services Ltd (06330639)
Budget range
The value is up to £1,250,000.00 excluding VAT.

About the work

Why the work is being done
The Business Plan 2021-2024 UK SBS outlines the need to have a Resilient Infrastructure and Security for the services it provides to UK SBS and its clients.
Problem to be solved
The current systems need to be maintained, patched and enhanced to improve user experience, maintain supportability and security, while ensuring high performance and ease of maintenance.
Who the users are and what they need to do
As a worker, I need to access the system to process various stakeholder requirements through our ERP system efficiently and in line with SLAs. As an organisation, we need to simplify and modernise ways of working and ensure systems are scalable, high performing and secure so that users can leverage advantages of automation, current cloud infrastructure and updated software.
Early market engagement
N/A
Any work that’s already been done
N/A
Existing team
4 individuals currently complete this work, which have been contracted by a serviceby. This has been predominately working with UKSBS permanent staff, but are required, from time to time, to work with FTC and other temporary staff. There will also be the requirement to assist with engagement of solution suppliers, such as Oracle.
Current phase
Not applicable

Work setup

Address where the work will take place
UK SBS, Polaris House, North Star Avenue, Swindon, SN2 1FF
Working arrangements
The team will be required to be onsite as requested for face-to-face team meetings, with remote working being the normal working arrangement and agreed with the team manager. This is due the collaborative nature of the work and requirement to engage with many internal teams on a daily basis.

Office hours are between 07:00 and 19:00 Monday - Friday, with an 8-hour day to be completed within that time, 5-days per week, excluding bank holidays. Specific start and finish times to be agreed in-post with the team manager.
Security clearance
All team members must have SC clearance.

Additional information

Additional terms and conditions

Skills and experience

Buyers will use the essential and nice-to-have skills and experience to help them evaluate suppliers’ technical competence.

Essential skills and experience
  • Demonstrate understanding and experience with Linux 5 -8 supporting Oracle DB and apps for bare metal and VMs on OVM, OLVM, relevant kernel parameters, OS/kernel updates. [15 points]
  • Demonstrate monitoring and diagnosing performance and other problems of Oracle Linux and NFS servers, including related network infrastructure such as Cisco and 802.3AD/802.1Q (LACP and VLAN). [10 points]
  • Demonstrate your experience in building I/O performant systems / storage. [5 points]
  • Demonstrate your deep understanding and experience with NFS server/client/dNFS, ZFS, and its volume performance settings, and NetApp Cluster-mode in an Oracle environment. [15 points]
  • Demonstrate your experience with ZFS within both Oracle, Tegile & open-source (such as TrueNAS core) appliances [10 points
  • Demonstrate good experience of scripting & automation using BASH, awk, sed, Python, Jython, JSON, WLST, Java and Ant scripts [10 points]
  • Demonstrate your experience of analytics and reporting using OBIEE, OBIA, OAC, and Microsoft Power BI with functional knowledge of CRM, HR, Finance, Procurement, Service, and projects reporting [15 points]
  • Demonstrate your experience of building Oracle BI Performance testing & test automation - using .NET & Scripting [10 points]
  • Demonstrate your experience in upgrading OBIEE from 11g version to 12c, and OAC (Oracle Analytics Cloud) [15 points]
  • Demonstrate your experience of building and extending data load processes using the ELT tools and technologies of OBIA 7.9.6 - Oracle DAC 11g, and Informatica 9/10. [15 points]
  • Demonstrate experience working with Oracle SOA suite 12c (12.2.1.3 or 12.2.1.4) with Design and Development capabilities of BPEL (DB Adapters, File Adapters, Enqueue, Dequeue, etc) and BPM. [15 points]
  • Demonstrate your experience with development of Web Services (SOAP and REST) using Java 1.8, SOAP and JSON libraries and experience using Oracle Cloud API’s. [15 points]
  • Demonstrate experience in XSLT and develop XSL transformations using the XML Schemas and custom XSLT functions. [10 points]
  • Demonstrate your deep understanding and experience with Oracle/Non-Oracle integration (EBS, OBI, OWC, Siebel) with OAM & OKTA, across domain enterprise IDM solutions using SAML, OAUTH & OpenId [15 points]
  • Demonstrate your experience EBS 12.1.x to 12.2 upgrade and performance tuning, and integration with OWC (AXF), FMW & OBI [5 points]
  • Demonstrate your deep understanding and experience with Oracle Cloud (Gen1 & Gen2) [PAAS, SAAS, IAAS] & implementing ADFS with OAM & Okta. [10 points]
  • Demonstrate your deep understanding and experience with implementing Microservice approach (API Manager, API Gateway, Kubernetes, Docker & ORDS) [15 points]
  • BI Publisher Integrations - Demonstrate deep understanding of customisations to be able to fix any Grants data warehouse BI Publisher issues. [15 points]
  • Grants Financial System (GFS) Integrations - Demonstrate deep understanding of customisations to be able to fix Grants data warehouse and ETL GFS issues. [15 points]
Nice-to-have skills and experience
  • Demonstrate your deep understanding and experience with applications and database performance tuning. [15 points]
  • Demonstrate your experience of working with shared service instances of large multiple Oracle ERP, OBIA, EBS, OLTP, and Siebel CRM implementation, including understanding of Data model. [15 points]
  • Demonstrate your experience of working with Grants management system including approval, monitoring, payment, sanction, and reconciliation processes using real time integration with payment processing system. [15 points]
  • Demonstrate experience with replacing current ETL mapping from EBS to bespoke Cloud solution, fetching Grants (project/finance) module data and mapping new data model with existing OBIEE repository/reports. [15 points]
  • Demonstrate your deep understanding and experience with upgrading oracle databases (11g to 19c and 12c to 19c). [15 points]
  • Demonstrate your experience in working with evaluation of the state of Storage, DB & Apps backup and methods to rectify any data corruptions. [10 points]
  • Demonstrate experience of DR design/planning/implementation and testing, including knowledge of mirroring technologies and / or Dataguard and other technologies. [10 points]
  • Demonstrate experience with DR failover with the given RTO/RPO [15 points]
  • Demonstrate experience with Dell hardware / iDRAC / racking & stacking [10 points]
  • Demonstrate experience with XFS Filesystem / LVM / grub2 / backup & restore (particularly when cloning physical servers) [10 points]
  • Demonstrate networking experience and troubleshooting skills, including DNS/NTP/ email (smtp/exim) / snmp [10 points]
  • Demonstrate experience in scripting with Shell / Python / Perl/ WLST [5 points]
  • Demonstrate experience with ansible / git and other “devops” utilities [5 points]
  • Demonstrate your experience in technical and functional upgrade of OBIA 7.9.x versions. [15 points]
  • Demonstrate your experience in integrating cloud data applications with on-premise applications. [10 points]
  • Demonstrate your experience in migrating Informatica and DAC to Oracle cloud infrastructure and connecting on on-premise applications. [10 points]
  • Demonstrate your experience and knowledge of working with Oracle, Microsoft SQL Server, and Postgres databases. [5 points]
  • Demonstrate your experience and knowledge of working with Amazon AWS. [5 points]
  • Knowledge of Build and Release, Documentation and Unit Testing. [5 points]
  • Knowledge of Networks, load balancers, Storage and oracle applications. [5 points]

How suppliers will be evaluated

All suppliers will be asked to provide a written proposal.

How many suppliers to evaluate
3
Proposal criteria
  • Proposed approach - In brief, how you'll manage the work and maintain quality, meet user needs and organisational policy or goals [15 points]
  • Team structure – In brief, describe who’ll be doing the work and how they’ll work together. List the roles, responsibilities, and number of people per role. [15 points]
  • Risk and Dependencies – In brief, describe any risks and dependencies, how you’ll manage them and how this will ensure successful delivery of the project. [15 points]
Cultural fit criteria
  • Demonstrate how you will collaborate with existing teams and service stakeholders [10 points]
  • Explain how you will approach challenges made of your work [10 points]
  • Explain how you intend to share knowledge and experience [5 points]
Payment approach
Time and materials
Additional assessment methods
Case study
Evaluation weighting

Technical competence

70%

Cultural fit

10%

Price

20%

Questions asked by suppliers

1. Who from your team will be scoring applications for this opportunity and what positions do they hold?
Job titles of evaluators are: Head of Architecture; DBA Operations Manager and Head of D&I Oracle Estates Support. Names of evaluators are not deemed essential to enable bidders to submit a response.
2. Could you please advise who conducted the Discovery work?
Work was undertaken by employees with relevant knowledge and experience of UK SBS strategic business plans, with familiarity of the managed services IT estate, and with an understanding of systems, processes, networks, infrastructure, hardware and software applications that underpin said estate.
3. Who is the incumbent and how long they have been the incumbent?
Proventeq are the current supplier and have held the contract since 30th June 2020.
4. Can you please provide an anticipated timeline for this procurement that includes dates for: 1) Shortlisting Notification for Stage 2 2) Submission Deadline for Stage 2 3) Presentation 4) Evaluation period 5) Award Notification
The anticipated timeline for this procurement is as follows:

Closing date for applications: Thursday 12th May 2022 at 23:59
Shortlisted suppliers invited to Stage 2, and issue of unsuccessful letters: Tuesday 31st May 2022
Receive responses to Stage 2: Friday 10th June 2022 by midday
Review and approve outcome of Stage 2 evaluations: Friday 17th June 2022
Estimated Award date (Letters issued): Tuesday 21st June 2022
5. Can you confirm if shortlisted suppliers will have the opportunity to present?
No. Presentations do not form part of the assessment for this requirement.
6. Has any external supplier been involved in the initial scoping work? If so, who?
No. No external supplier was involved with the initial scoping work.
7. Upon award of the successful contract, will SBS be the sponsor for obtaining the required SC Clearance?
Yes. UK SBS will sponsor SC clearance for the successful bidder's proposed team, as required.
8. We are aware the core office hours are listed, but as a lot of upgrades are required, will there be a need for work out of the core hours specified and if so do have an idea about the amount/frequency?
From time to time there may be a requirement to work outside core hours, at evenings and weekends. Work assignments, client needs and resourcing considerations dictate frequency and duration.
For the purposes of this requirement, shortlisted bidders will be evaluated on pricing for core hours only. Other rates may be requested for information only purposes.
9. What is meant by serviceby? Will the supplier be expected to do something with this engagement?
This is a spelling error within the Existing Team section and should have said 'service'. This procurement is to replace the existing service.
10. There is a summary of the work, but what would the UK SBS consider the key deliverables for this engagement? For example is a break fix managed service required of the Application Databases, or is support just from a project perspective?
The provision of a mixture of support to resolve complex and complicated bugs, to provide support to standard/minor change work, to provide support to more complex and complicated change work, and to support the development of continuous improvement activities pursuant to the areas listed under the summary of work
11. Is there any further information on the hardware that runs the application databases? Is the hardware under support and is there any expectation for the supplier to support the hardware?
All pertinent information has been supplied. Hardware support is out of the scope of this requirement.
12. The grants system is that within Oracle EBS or Fusion and or a bespoke system? Are you able to provide further information on the solution?
The Grants payment and Grants Funding Service (GFS) are standalone, non-EBS solutions that allow the UK science community to tender for grants for scientific research, a service administered by UKRI. The successful bidder would need to understand Siebel and .net applications in order to support and implement change to GFS as well as the supporting bespoke Joint Electronic Submission's (J-eS) system, and the Electronic Document Distribution (EDD) system, responsible for the review and document push/pull interactions
13. There is a large number of technology skills mentioned, would the UK SBS be open to suppliers partnering to deliver the work?
Suppliers may submit a bid that involves subcontracting or a consortium; however, UK SBS would contract with one lead bidder responsible for other parties.