SQL (MariaDB/MySQL flavour) specialist needed -- (take 2)

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: Linux, MariaDB, MySQL, SQL

Ver más: marketing specialist needed, seo specialist needed russia, magento specialist needed, specialist needed, effects specialist needed, photoshop specialist needed, adwords specialist needed, mysql php skills needed, crm infusionsoft specialist needed, seo specialist needed, dtp specialist needed, sql injection specialist needed urgent, joomla specialist needed, indesign specialist needed, mail specialist needed, mysql server specialist, data entry specialist needed immediately, crm specialist needed, network specialist needed

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

Nº del proyecto: #22189661

12 freelancers están ofertando el promedio de £17/hora para este trabajo


"MySQL" Hello C, We are TEAM OF EXPERT FULL STACK DEVELOPERS having depth expertise in SQL, MariaDB 10.3.16, Linux command line, etc . So, we can definitely Help you for this development to views/triggers/stored Más

£10 GBP / hora
(301 comentarios)

Dear Sir, Your project is easy for our experts. We have a huge experience in MySQL, Linux, Apache, Asterisk, VoIP, Windows Server, System Admin, Software Architecture, and Network Administration, so we can do this f Más

£20 GBP / hora
(56 comentarios)

Hi, Greeting of day. I m Expert Professional Full stack developer Having 8+ Years Experience ***You will just see my reviews..!!!

£10 GBP / hora
(47 comentarios)

"MySQL" Hi, there Nice to meet you. High Quality, Reasonable Budget!! have read your requirements carefully. and interested in your job. I have many experiences with projects like your project. And can complete your wo Más

£15 GBP / hora
(11 comentarios)

MySQL Hello, I read your proposal carefully and I am confident I can finish your task perfectly In fact, I developed several back ends by using MariaDB. For detailed quote, I need to hear your explanation from you in Más

£18 GBP / hora
(4 comentarios)

MySQL I am old certificated .NET/C# programmer working with .NET 18 years. All ASP.NET MVC versions including [login to view URL] and WEB API are well me known. Data base processing I can do with pure [login to view URL], Dapper, Linq t Más

£12 GBP / hora
(2 comentarios)

Hi. MYSQL I've checked your requirements and I think I am the perfect match for this task. As an experienced server tech, I'm skillful with Linux server administration, domain/ssl setup, email system, WHM/Webmin setup Más

£20 GBP / hora
(1 comentario)

⭐Dear Sir, Thanks for your positng. It seems to be an interesting work and good opportunity to show my skills to work with you in future as well. I have read your description carefully with good experiences in the skil Más

£15 GBP / hora
(3 comentarios)

Glad to meet you. I have checked your project description and requirements carefully. I am a senior web developer has 8+ years of good experience. I will never make you disappointed. If you give me a chance to work wit Más

£15 GBP / hora
(3 comentarios)

HI I am experienced in Linux SQL MySQL etc I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your reply

£15 GBP / hora
(0 comentarios)

we have team of experts

£33 GBP / hora
(0 comentarios)

Mysql forever. Hi. I'm developer from East Europe, and my experience in databases development and reporting systems. I worked as outsorcing developer also. This task can be implemented within 3*8=24 hours, and my price Más

£16 GBP / hora
(0 comentarios)