We are looking for experience Azure and database developer with experience on synchronizing databases to develop a sync process that will migrate and continue uploading/updating data from an on-premises Interbase database to an existing Azure CosmoDB database in the cloud.
The current database is about 2gb compressed. It is located locally in our servers on-premise. The winner of this project will need to develop either through Microsoft Azure DataFactory or a WebJob using Azure app service or MS functions to perform this task.
This is ONE-way migration/uploading. Everything except attachments that are added or updated in the Interbase database will be uploaded or updated in the CosmoDB database. Deleting on Interbase will flag the record as deleted in CosmoDB , but it will not delete the record. Data will be moved multiple times a day and/or triggered manually by managers.
I should be able to connect PowerBI with this data and build reports with the necessary information.
The connection between Azure and our servers need to be secure and approved by our IT manager.
The winner will be responsible to provide guidance what is the best way of using implementing things as well as help deploying and rolling out the solution. Time for Knowledge transfer to walk through how things are going to be maintained and how to deploy are a must. Documentation of the solution must be provided for technical and for training purpose.
The final solution needs to be simple to be maintained and improved. Winner must provide quote for future maintenance/support if needed.
The application will need to be deployed in a test / training environment as well as production. Winner developer will provide documentation and support on the deployment phase for the two environments which will be hosted with Azure.