Find Jobs
Hire Freelancers

SQL (MariaDB/MySQL flavour) specialist needed

€30-250 EUR

Completed
Posted over 4 years ago

€30-250 EUR

Paid on delivery
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.
Project ID: 22129211

About the project

18 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
5.0 (11 reviews)
3.5
3.5
18 freelancers are bidding on average €169 EUR for this job
User Avatar
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 has a huge experience in Linux, MySQL, SQL, so we can professionally do this project for you. Having the required skills, we will be glad to help you. We have 20 years of strong experience in outsourced web development, software development, managed services and 24/7 technical support. We guarantee Canadian quality. Please, review our profile to find detailed information about our company and our portfolio. Feel free to contact me and discuss all details. We wait for further information from you in order to start cooperation. Best regards, Diana Tangram Canada Inc
€250 EUR in 7 days
4.9 (145 reviews)
8.0
8.0
User Avatar
"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, Software Configuration and Cloud Platform. With a wide range of experience, I have involved in Planning, Requirement Analysis, Design, Building, Continuous Integration, Continuous Deployment, Development, Testing and Release of various Enterprise-Wide Software Applications. I am working as a DevOps engineer for a Canadian Company. I charge $ 20/hour, and for the first 3 points it would take up to 4 hrs. Please initiate the chat to discuss more on it so that I can start it asap. Waiting for your reply. Raj.
€200 EUR in 3 days
4.8 (51 reviews)
6.4
6.4
User Avatar
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 your database. Please comment on whether you can accept such a solution. Following your descriptions: 1. One SQL statement 2. Views must be created and populated for each mentioned timezones. 3. Please describe the "other tables" and how the information should be presented. An initial estimate is part of this message. Please contact me for more information.
€60 EUR in 3 days
4.9 (17 reviews)
5.9
5.9
User Avatar
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 project, so I have the clear way to complete the project. ⭐Your project is very fit for my skill sets. ⭐If you are willing to award the project to me, I will always be ready to complete it perfectly.
€100 EUR in 1 day
5.0 (11 reviews)
5.4
5.4
User Avatar
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 have a small mock session so that you can trust on my skills.
€222 EUR in 20 days
5.0 (4 reviews)
3.8
3.8
User Avatar
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 every day and a cannot work full time since my main job assorb a lot of time in this period of the year
€250 EUR in 1 day
5.0 (4 reviews)
3.9
3.9
User Avatar
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 my top priority! If you give me a chance to work with you, then I will try my best level for your project to run successfully. Waiting for your kind response. Best Regards.
€140 EUR in 7 days
4.8 (5 reviews)
3.5
3.5
User Avatar
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, by using different cloud technologies to capture and manipulate this data, rather than all in SQL. I would be happy to talk you through some of my ideas on Messager. Hope to hear from you. -jb
€166 EUR in 10 days
5.0 (2 reviews)
3.2
3.2
User Avatar
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 start right now and work full time. I think I am the right person you are looking for. If you hire me, I'll make great efforts for you. I'm looking forward to hearing from you. Thanks and Regards.
€140 EUR in 7 days
5.0 (1 review)
0.6
0.6
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 database design would be a great asset in creating views, triggers and stored procedures that are consistent and reliable. With regard to your project, an intimate appreciation of date/time manipulation would be an added skill to have. Over the years, I have preferred a command line interface when interacting with MySQL/MariaDB databases; that seems to be the best way to quickly get information and understand the scope of a system. In addition to some experience of dealing with data that need accurate date and time manipulation, I am also within your preferred time zone. I would like to submit my bid for this project and look forward to your favorable response. Sincerely, Emmanuel Taban
€167 EUR in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have 10 years in database admin and sql. I can complete the job according to your requirement.
€111 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
*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 the mariadb, this would enable other add-ons and 'complications' to be made with more flexibility. The first draft could be done in a couple of hours, then adjusted on your feedback and finalised on 3rd work day.
€270 EUR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
St Austell, United Kingdom
4.9
3
Payment method verified
Member since Jan 26, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.