Objective:
Develop an API that facilitates real-time communication between two critical systems: an on-premises database for an ERP and SAAS application (a safety management System).

You will be provided access to the on prem MSSQL Database for the ERP.
For the SAAS system, we have a read-only database as well as a REST API.

You will have access to subject matter experts who can provide you with information about both systems. You will liaise with the IT Director, who has experience with full-stack development, comprehensive knowledge of the MSSQL database schema and basic knowledge of the SAAS API.

Technical Requirements:

Ensure there is a secure connection to both the on-premises database and SAAS web API.
The API will:
Monitor changes in the on-premises database continuously.
Detect updates promptly.
Trigger actions in real time.
Ensure fault tolerance and graceful recovery.
Protect sensitive data during transmission.
Comply with best practices for API security.
API to run either on prem or in the cloud (with IPsec VPN to access the ERP database).

API Development Deliverables:
Design and build the API endpoints.
Install the API in our network or in the cloud.
Document the API specifications comprehensively.
Rigorously test the API under various scenarios & address any issues promptly.
Verify data consistency across systems.

Data Synchronisation Requirements:
Both applications contain Human Resource objects and various fields which need to stay in sync. For example, if the "Location" of a HR Resource changes in the ERP, it should be updated in the SAAS system. Initially, we want 1 way sync. The ERP value will override the SAAS value.
The SAAS database contains forms which are used to capture data. The API must retrieve data from some forms, pushing the data into MSSQL tables in the on-prem MSSQL server.
The ERP contains managed master-data lists. Copies of these lists exist in the SAAS database. Any changes made to the master-data must be reflected in the SAAS database. (One-Way Sync).

Collaboration:
Regular communication is essential.
Provide progress updates and seek clarification when needed.

Due to data protection requirements, we will only be able to work with individuals or organisations based in Australia.

Posted On: March 05, 2024 02:25 UTC
Category: Full Stack Development
Skills:API, API Integration, RESTful API, MySQL, Automation

Country: Australia

click to apply