Completed

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.

Skills: MySQL, SQL, Linux, MariaDB

See more: 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

About the Employer:
( 0 reviews ) Bucharest, Romania

Project ID: #22129211

Awarded to:

roadroll

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

€100 EUR in 3 days
(8 Reviews)
3.0

25 freelancers are bidding on average €158 for this job

limillion819

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 More

€200 EUR in 1 day
(22 Reviews)
6.9
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 in 3 days
(19 Reviews)
6.3
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 More

€200 EUR in 3 days
(40 Reviews)
6.3
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 More

€250 EUR in 7 days
(58 Reviews)
6.9
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 More

€60 EUR in 3 days
(8 Reviews)
5.6
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 More

€100 EUR in 1 day
(11 Reviews)
5.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 More

€250 EUR in 7 days
(6 Reviews)
4.4
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 in 3 days
(11 Reviews)
4.4
ironstar20311

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 More

€50 EUR in 1 day
(5 Reviews)
3.7
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 More

€222 EUR in 20 days
(2 Reviews)
3.3
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 More

€140 EUR in 7 days
(4 Reviews)
3.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 More

€250 EUR in 1 day
(2 Reviews)
2.9
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 More

€166 EUR in 10 days
(1 Review)
2.6
Chan1010

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 More

€140 EUR in 7 days
(2 Reviews)
2.3
mattjparker1104

⭐ 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 More

€140 EUR in 7 days
(1 Review)
1.8
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 More

€140 EUR in 7 days
(1 Review)
0.6
filipvelickovic5

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 More

€60 EUR in 1 day
(1 Review)
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 More

€140 EUR in 7 days
(1 Review)
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 in 5 days
(0 Reviews)
0.0
jackpol255

"MySQL" Dear Client, I've checked the requirement and understand that :) I've created S..I..M..I..L.A..R.... Project in past. Do you want to see the D.E.M.O.. ????? I'm not here most of the time so kindly pl More

€200 EUR in 2 days
(0 Reviews)
0.0