Find Jobs
Hire Freelancers

Database design and implementation - Industrial IOT Solution

₹37500-75000 INR

Mbyllur
Postuar almost 3 years ago

₹37500-75000 INR

Paguhet në dorëzim
Database design for a condition monitoring IOT solution. Background: We are developing an end-end solution for monitoring (Sensor + SaaS app). Scope of work: 1. Define data schema 2. Implement data schema in AMW RDS using MySQL 3. Build data validations and 4. Facilitate & handhold during integration with production data 5. Make schema performant for CRUD and querying 6. Utilize AWS tools to troubleshoot performance issues 7. Detailed documentation and flowchart for the complete implementation 8. Known shortcoming assessment and mitigation strategies for/during scaling. 9. Data purging/ archival function implementation for old production data. 10. History table design & implementation. Data retrieval mechanism from the history table. Magnitude of work: Db details: 1. No of table 30 to 35 tables 2. Avg. 15 fields per table 3. 5-7 history tables 4. Data validations on very important fields. Transaction data (Real Time sensor data logging) : 1. no. of hardware sensors - 100k sensors 2. Frequency of transmission - 2 sec to 1 hr 3. Quantum of data - 5 MB/ day/ device Following data can be disclosed to interested candidates after formal NDA documentation: 1. Data flow schema 2. Excel sheet with all the dB tables. 3. Each table contains data name, data type, data validation extremities for each variable 4. Overall implementation of the system design. Additional notes: 1. The whole system is being built using server less architecture. 2. The entire system will be deployed using AWS cloud services. 3. DB will be deployed on amazon RDS 4. We welcome any changes in our proposed DB schema 5. Proposed workflow= Discuss and finalize schema, deliverable and mutually agreeable milestones -> execute 5% of the project as a prototype implementation -> based on successful prototype implementation full implementation starts -> Payment released based on agreed milestone. 6. Final bid can be submitted after detailed discussion. 7. Please submit a very brief introduction about yourself with details about experiences relevant to this project. 8. Approx. start date: Jun 1 9. Approx. end : Sep 15
ID e Projektit: 29919509

Rreth projektit

6 propozime
Projekt në distancë
Aktive 3 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
6 freelancers are bidding on average ₹88 171 INR for this job
Avatari i Përdoruesit
Hi, I read your detailed project description about the database system. The requirements listed are very clear and i understand them completely. After reading the requirements, i am certain that i can design and develop the entire database for each of the requirement item. I have over 9 years of experience working as a database developer using MySql and oracle databases. I have completed several similar projects in the past. Please see my profile for details. Moreover, i have deployed a few mysql database systems on AWS. Here are some of the highlights of the proposed solution - Complete Entity-Relational Diagram, with highest Normalization possible - Complete database scheme, with deployment on AWS and 100% testing - All Tables, Relationship, Triggers, etc will be designed and developed - All CRUD queries for all tables will be provided - Database/Query Optimization - Test cases for testing database operation, CRUD queries. - Complete documentation will be provided in PDF and Word format. I am more than ok to sign a NDA as i have done this in the past for other clients from India. I am willing to start this right away if project allows. Daily updates and support will be provided during Indian times. Thank You Parik 7000-10-7987
₹65 000 INR në 12 ditë
5,0 (8 përshtypje)
3,8
3,8
Avatari i Përdoruesit
I'm having 4 years of experience in the required skills. I can complete this project in two months and having Experience in writing complex SQL queries, Stored Procedures, data warehouse, data mining , data manipulation, data cleansing and automate the things, analyse and Visualize the KPIs.
₹77 778 INR në 60 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
HI I would like to work on this project for you, My name is Mbuyelo and i am a software developer with 12 years experience. I have extensive experience in SQL and have worked with both .Net and oracle technologies. I have worked in corporate mainly in the financial industry and I am looking to break into freelancing. I'd like to take this project on to help you design an adequate data base for your IoT solution. Regards Mbuyelo
₹75 000 INR në 60 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hi I have 15 years of SQL Server Database Development,MYSQL DB Developement Experience. I am working as an architect and built major Data Analytics platform. I have expert knowledge around SQL programming and Power BI. Please ping me to discuss further.
₹85 000 INR në 45 ditë
0,0 (1 review)
0,0
0,0
Avatari i Përdoruesit
I am a seasoned technology executive with proven expertise in IoT projects development and implementation. having knowledge of ThingsWorks and know how to. I have knowledge of thingsboard and its database, Also I have evaluated and impended various projects developed by Ecoaxis for varies industries.
₹56 250 INR në 7 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I can develop the data model and implement on AWS I can optimize OLTP data schema and provide history tables for querying if you wish in OLAP optimized
₹170 000 INR në 14 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i INDIA
Bengaluru, India
0,0
0
Anëtar që nga jan 21, 2021

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.