Database Design for Fleet Management

2500.0 USD

2500.0 USD peopleperhour Technology & Programming Overseas
435 days ago

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.

关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

Files for this site can be accessed here: https://www.dropbox.com/scl/fo/8fa7t552q4nwdrdpbowuo/AOhFEx2eWHs7YML67fNpOuM?rlkey=p7ws7066jiya5zxsq18ta1mai&dl=0 The Review Page Go to https://prep-test.net/test/login.php (I will call this the “new site”) and log in as Mary Doe. Click the Review button in the navbar. Click the Algebra item under Quantitative. Now go to insightprep.net I will call this the “live site”) and log in again as Mary Doe. Click the Algebra item again. The layout and functions of this page in prep-test.net/test need to be the same as they are in insightprep.net/preptest except that there should be no Discuss with William button. That includes the position and format of the three panels, the Next button, the Dismiss button, and the Remaining Explanations number in the navbar. Currently, the Dismiss button in both the live site and the new site doesn’t work, so that functionality needs to be restored in both sites. The Heading above panel 1 should be removed. The Questions Page Click the Home button and select Quantitative and Prep Now. Note that the Percent Missed value in the navbar is 50%. That is because each time a student starts a session, the first question that appears is one that 50% of my students missed. Click the Not Sure answer and Submit. Now you see the explanation for the question you just answered. Then click the Next Question button in the navbar and note that the Percent Missed for this question is very close or equal to 50%. Because your Not Sure answer to the previous question wasn’t correct, this current question should have a percent missed value that is the greatest value of the set of questions having percent missed of less than 5 percentage points below that value of the previous question. For example, if the previous question had a percent missed of 50% and it was answered incorrectly, the next question should have a percent missed of the greatest value less than 45%. Likewise, if a question is answered correctly, the next question should have a percent missed that is the least value greater than 4 percentage points higher than the last question. The new site should also display “previously missed questions”, i.e. questions that the current student answered more than 7 days before the current session, along with new questions. This is not happening and needs to be done. The panels should be populated with the data in the corresponding panel fields in the Questions table. If a panel field contains only a “q”, the question and answer choices are displayed with radio buttons. If a panel field contains a “1”, the graphic associated with the question is displayed. All of that is working as intended. However, the panel layout on the questions page should be panels 6, 7 and 8 from left to right and panel 9 laying over panels 6 and 7. Only panels containing data should have a white background. The position of the panels is not now correct and needs to be corrected as stated. For example, the position of the panels in a Data Insights (Integrated Reasoning) question is not correct. The Explanations Page Click the Not Sure button on a questions page and Submit. The panels should be populated with the data in the corresponding Panelx fields in the Questions table. The panel layout on the explanations page should be panels 1, 2 and 3 from left to right and panel 4 laying over panels 1 and 2. Only panels containing data should have a white background. The position of the panels is not now correct and needs to be corrected as stated. Mobile Devices All pages should be optimized for other devices.
350.0 USD Technology & Programming peopleperhour Overseas
3 days ago