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 prac