Completado

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.

Thanks,

C.

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:
( 3 comentarios ) St Austell, United Kingdom

Nº del proyecto: #22129211

Adjudicado a:

roadroll

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)
3.3

19 freelancers están ofertando un promedio de €166 por este trabajo

tangramua

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
(77 comentarios)
7.0
raj00565

"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
(46 comentarios)
6.3
ShiaFirst

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
(22 comentarios)
6.3
naravila

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)
5.4
smartarray

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)
5.6
freelancerbuzzo

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)
4.4
AlexeyKala

⭐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)
4.4
thbglbwsk

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
(4 comentarios)
4.0
jiteshparwal93

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
(3 comentarios)
3.6
greenguru2018

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
(5 comentarios)
3.5
jamesbrewsteruk

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
(2 comentarios)
3.3
skywolf86

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)
0.6
never2giveup

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)
0.6
jojuahb

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)
0.0
Dveersingh

I have experience in sql, linux, MySQL. I can do it easily. Relevant Skills and Experience Hiii, I am a professional database administrator and programmer. I have 4 years of experience.

€44 EUR en 2 días
(0 comentarios)
0.0
yuguuk

MySQL professional here. With more than 10 years’ experience designing and implementing relational databases in MySQL. My breadth of experience makes me an ideal choice for your project. An appreciation of relational d Más

€167 EUR en 4 días
(0 comentarios)
0.0
basid22

Hi, I have 10 years in database admin and sql. I can complete the job according to your requirement.

€111 EUR en 3 días
(0 comentarios)
0.0
awsbarker

*MYSQL* I've made similar 'realtime' dashboards for patient monitors and aircraft, updating 10 to >10k lines every few seconds. But I'd use python mysql client to make the background calculations and post back into Más

€270 EUR en 3 días
(0 comentarios)
0.0