Hello, Sir. I read carefully about your project.
I have ever developed similar project which you need. If you want, I can show my working result to you.
My skills are as follows:
-Embedded software for 7+ years experience.
Raspberry pi: Rasbian, python, flask web server development, Sqlite and Sqlarlchemy.
IoT implementation practice Arduino, PIC, dsPIC, arm firmware writting.
Lora practice(RN2483,RFM95W,SX1274/1276,...) radio communication practice PCB design
RS232/485,SPI,I2C,USB1.1/2.0, ethernet, Modbus practice
c/c++, python programming language,git Android/iOS app writing
I hope to discuss more detail with you by chatting about your project.
Best regards.