Creation of Data Models and output within AWS copy - Date Extension

Tender description

Why the Work is Being Done We are changing the way we migrate, store, access and share data within the DVSA and this work will provide us with the development skills to begin this journey. By the end of December 2019 we will need to turn conceptual data models, built based on underlying business processes into physical data models in Aurora in AWS. Problem to Be Solved Business processes are currently supported within an Oracle DB and we are moving to a cloud based environment. As a result, we will need to build new data models in AWS to support the business going forward. The current processes do not necessarily conform with acceptable standards. Who Are the Users As a Reporting Analyst I need to be able to access a central data model to produce reports for people across the DVSA. As a member of the enforcement team I need to be able to produce a risk score for operators, expose this to various end points and ensure that up to date information is available to all those end points. As an analyst I need to be able to access data within a MySQL DB to answer questions posed by the business. Early Market Engagement All of the research conducted so far has been done internally within the DVSA, with some support from our existing DB suppliers ATOS Work Already Done To date we have been mapping business processes, defining the dependent tables in our existing DB and have started to build the conceptual data models to support the business processes. We have also started to test the migration of the data from Oracle DB into Aurora on AWS. Existing Team We currently have the following DVSA staff in place: Head of Data Senior Data Architect Project Manager Data Business Analyst Security Architect Current Phase Beta Work Location The developers will need to be based in the DVSA building in Swansea. Working Arrangments Developers should be onsite 4 days a week and will work closely with the Data Architect and Business Analyst. Support will be provided when needed by the Head of Data and the Project Manager will conduct the daily stand ups and ensure that work is progressing as expected. Security Clearance We will organise all of the relevant internal clearances required to access our data sources and databases. Security Clearance will be required due to the data that will be accessed. Additional T&Cs Standard contracts will apply Skills & Experience provide SQL developers who have experience with Aurora or MySQL ensure that developers are highly proficient with SQL ensure that QA is a fundamental part of all development have a working understanding of AWS and associated languages be able to develop physical data models and advise and implement based on best practices provide someone familiar with DMS and Schema Conversion Tool in AWS Nice to Haves work in an Agile environment provide evidence of rebuilding data processes in the past No. of Suppliers to Evaluate 5 Proposal Criteria Approach and Methodology Timeframes Team structure suitable for the project Versatility of the team proposed Cultural Fit Criteria be comfortable working in a team be comfortable working to deadlines be used to working with internal DVSA / Government employees Payment Approach Capped time and materials Assessment Method Written proposal Evaluation Weighting Technical competence 70% Cultural fit 10% Price 20% Questions from Suppliers Budget range £250k all for developers to aid with migration into aws from oracle