Database Design for Fleet Management

Description

Summary:We are looking for an experienced freelance Database Engineer to create a high-performance database tailored for managing operational data from our truck fleet. The role involves collaborating with the Original Equipment Manufacturer (OEM) of the trucks to integrate our internal server with theirs. This integration will facilitate the transfer of real-time operational data. The primary goal is to store this data in our internal database, enabling data analytics to optimize fleet operations.
+++
Scope of Work:The project will be executed in four main stages, with the initial contract focusing on the first two stages:
1. Database Design and Development: Design and implement a high-performance database hosted on our internal servers. This database will be linked to real-time data on the servers of the truck's OEM, ensuring seamless synchronization and data integrity.2. Data Visualization and Reporting: Develop basic visualization and reporting capabilities to allow for easy interpretation and analysis of the collected data. This will include the creation of dashboards or reports that highlight key metrics and trends.
(Future Stages to be Scoped Separately)3. Develop a web portal, hosting data reports developed in stages 1 and 2.4. Develop a mobile app, hosting data reports developed in stages 1 and 2.
+++
Deliverables: 1. Develop and host a database on an internal server that maintains a consistent and complete dataset of real-time operational data.2. Establish and document automatic synchronization between the internal database and the servers hosted by the OEM. 3. Create a basic dashboard for visualizing the operational data stored in the database, featuring essential metrics and real-time updates.
+++
Key Responsibilities:• Analyze and understand the structure of the existing data on the OEM servers.• Design a scalable and secure database architecture. • Implement the database on our internal servers, ensuring real-time data synchronization with the OEM servers.• Develop basic tools or dashboards for data visualization and reporting.
+++
Skills and Qualifications:• Proven experience in database design and development, especially with large and complex datasets.• Proficiency in database management systems (e.g., SQL, NoSQL) and data visualization tools.• Excellent analytical and problem-solving skills.• Ability to work independently and in collaboration with cross-functional teams.• Effective communication skills, with the ability to document and explain technical details clearly.
+++
Project Timeline:The initial scope of the project (stages 1 and 2) is expected to be completed over the course of eight (8) full time days within a one-month timeframe (April 29th – May 31st). This period allows for actual development, with additional time allocated for necessary engagements with external stakeholders at the OEM.
+++
Application Process:Interested candidates are invited to submit a proposal outlining their approach to the project, including a timeline, budget estimate, and a portfolio of relevant work. Shortlisted candidates may be invited for an interview to discuss the project in further detail.
+++
About Us:At Bisedge we provide, maintain and operate mainly electric material and cargo handling equipment for companies in Africa.