SQL (MariaDB/MySQL flavour) specialist needed

Hi there,

I have a MariaDB 10.3.16 database in which data is received, from many electrical meters, each minute, in the format shown in the attached image.

I need an SQL expert to create the needed views/triggers/stored procedures, so that, to have some other tables/views populated on-the-fly (in realtime) from this shown table, as such:

- energyDelta field should be filled in as the difference between energyOrig at each minute, for each meter.

- I need to offer these energy consumption data per 5/15/30 minutes too, i.e. the data should be processed including the energy deltas too.

- I need to present the data taking into account a certain timezone (not UTC as it is now in tsOrig), according to other tables that contain this info (joined by meter id);

- other data manipulations and complication that will be introduced to the chosen freelancer.

The final purpose is to have the resulting tables/views used as a back-end for PowerBI (in Azure) but PowerBI is not part of this project.

Please note that:

- I prefer programmers from Europe (including Eastern Europe), due to time zone differences.

- I need someone comfortable in linux command line (mysql client).

- English mastering is required, as we need to communicate!

- the first bullet above is actually solved already; however I'll use it as a test, so that I can evaluate your understanding of the task and asses the skills level. I have solved this via SQL/MySQL only, myself, so I need someone who is more skilled than I am.

I need a price per hour and estimated number of hours for the first 3 bullet points above. Any further developments will be discussed/negotiated individually.

Please start message with "MySQL" to help me avoid automatic repliers that did not read this thoroughly.



Habilidades: MySQL, SQL, Linux, MariaDB

Ver más: best transfer sql server mysql, replicacion sql server mysql, sql server mysql transfer, sql developer mysql integration, conver xml sql table mysql, marketing specialist needed, import sql server mysql, seo specialist needed russia, sql export mysql database, oracle sql server mysql provider, export sql mssql mysql, convert sql 2008 mysql, synchronisation sql lite mysql, sql injection specialist needed urgent

Información del empleador:
( 0 comentarios ) Bucharest, Romania

Nº del proyecto: #22129211

25 freelancers están ofertando el promedio de €158 para este trabajo


Hi there. I got really excited with your project and I can say that really matches to my skills. Along as my worth experience of Mysql programs, I can help and support you 100% bringing fully satisfactory result. I ass Más

€200 EUR en 1 día
(22 comentarios)

Hello, This project is quite easy for me, but I got couple of questions to clear before we proceed [login to view URL] message me to have a quick chat.

€250 EUR en 3 días
(19 comentarios)

"MySQL" Dear Client, I read through the job details extremely carefully. As an Oracle certified DBA, I would like to apply for this task. I have hand-on experience in Linux Administrator, Build/Release Management, Sof Más

€200 EUR en 3 días
(38 comentarios)

I am European Dear Sir, Our team is interested in developing your project and we can easily do it for you. The main part of our technical team is located in Ukraine, so we can work together in one time zone. Our team Más

€250 EUR en 7 días
(56 comentarios)

I am European. You are specifically asking for a solution using database triggers and stored procedures. My preference to implement your requirements would be a PHP script or any other application that can access yo Más

€60 EUR en 3 días
(8 comentarios)

Dear sir! ⭐I am very interested in your project and I am exciting. ⭐I read your project details carefully and I though that I am the best fit developer for your project. ⭐I have rich experience about your proj Más

€100 EUR en 1 día
(11 comentarios)

⭐Full Stack Guru here. ⭐ I am good at Frontend and Backend. [login to view URL] [login to view URL] afrikbid.com. -> mobile [login to view URL] [login to view URL] [login to view URL] [login to view URL] are all my successful portfolios. I have more than 7 yea Más

€250 EUR en 7 días
(6 comentarios)

MySQL Hi, there is no image I can see in the project description. So my bid is based on the text provided. Each point will take 1 hour to complete and cost 40€.

€120 EUR en 3 días
(11 comentarios)

Hi, Dear (✿◠‿◠) :) I am happy to put my bid on your project. I am DB expert I have 6+ years highly experience to deliver quality work with Website design and MySQL/MsSQL/NoSQL project successfully. It's very worthwhile Más

€50 EUR en 1 día
(5 comentarios)

MYSQL, To start with, I am a Full Stack SQL developer having expertise in creating triggers and all. I am based out of India, but EST time suits me as I get free and works as freelancer in this timezone only. Let's ha Más

€222 EUR en 20 días
(2 comentarios)

Hello, How are you? My pleasure to bid your project. I've read carefully your project description. I have more than five years experience in development related with your project. Your satisfaction with the project is Más

€140 EUR en 7 días
(4 comentarios)

MySQL. Hello, i have rich experience in this area and ready to work. Please contact me to further discuss. Regards, Alex

€100 EUR en 3 días
(8 comentarios)

MySQL Hi there, This sounds really interesting. I'm a cloud architect with 10 years experience on Azure, based in the UK. I think there's a better way to solve this problem that would save you money in the long run Más

€166 EUR en 10 días
(1 comentario)

I am European Welcome to your job! I read your description carefully and i am very interested in your project. I'd like to get more details in chat. I have rich experiences and flexible skills in sql query. I can start Más

€140 EUR en 7 días
(2 comentarios)

⭐ Hello, Sir! ⭐ Nice to meet you. I am a fullstack web developer with over 5 years on web development. ****In SPECIAL Very familiar with Linux, SQL, MySQL***** I am ready for your project now. I can do it and start rig Más

€140 EUR en 7 días
(1 comentario)

Hello , i've already did something similiare for another combany about smart energy monitor , device recognition and so on your 3 bullet can be done in 5 or 6 hours my price is 50$/hours but i cannot work on it eve Más

€250 EUR en 1 día
(1 comentario)

I am European Hi Dear, I am very interested in your project. I can develop your project by using the cron tab with laravel. I am ready to start your project with my best. Could you please share your details? Please s Más

€140 EUR en 7 días
(1 comentario)

I am European Hello. I am very interested in your job. Even though new freelancer, I am web development expert who have enough experience. Especially SQL is my favorite thing. I can start right now and will finish on t Más

€60 EUR en 1 día
(1 comentario)

You are asian. Welcome to your job! I read your description carefully and i am very interested in your project. I'd like to get more details in chat. I have rich experiences and flexible skills in sql query. I can star Más

€140 EUR en 7 días
(1 comentario)

I am European -The price per hour is 10.50 EUR. -The estimated time is from 16 to 22 hours. I look forward to you comments.

€180 EUR en 5 días
(0 comentarios)