Find Jobs
Hire Freelancers

database optimization queries speed - HA setup

$30-250 USD

Completed
Posted about 1 year ago

$30-250 USD

Paid on delivery
I need an experienced database professional to help me optimize the speed of my queries and configure a high availability setup on a MySQL database. The optimization will focus on the queries being used by default. The high availability setup should cover all aspects of disaster recovery and data protection, with appropriate failover protocols. The ideal candidate has extensive experience in database optimization as well as working with MySQL databases to ensure a successful outcome. If you have experience creating or working with databases using other technologies (NoSQL, for example), that could be beneficial too. The expected result of this project is a database that can run quickly and reliably, providing maximum uptime and eliminating costly downtime from system outages. The performance of the queries should be improved, and failure scenarios should be addressed with a robust HA setup. Experience in troubleshooting and debugging databases is a plus, as is demonstrating a track record of successful performance improvement projects. I'm looking forward to a great result and prompt turnaround time. Please reach out with any questions - I'm excited to get started!
Project ID: 36261727

About the project

22 proposals
Remote project
Active 1 yr 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
Hello, I have read your project description about Database Design. I am an expert in database systems and I have developed many database systems including but not limited to a database system for a School, County Bursary, Pos System and Sacco system. I have used tools such as SQL Developer, SQL Plus, SQLYog, MySQL Workbench, SSMS etc. Am confident I can handle your project. Kindly open a discussion with me so that we talk the best way to work. If you award me the project I will work closely with you throughout the whole project life span, communicating continuously at every stage with updates until the project comes to fruition, in perfect condition, and ready for submission. Hope to work with you soon! Thanks Nyaronyari
$140 USD in 5 days
4.9 (30 reviews)
4.9
4.9
22 freelancers are bidding on average $172 USD for this job
User Avatar
hello i am full stack web developer with 10 years of experience i ensure the best quality with fast delivery you can check my profile here : https://www.freelancer.com/u/VasileDarmaz/ Hope to work with you sincerely
$140 USD in 2 days
5.0 (12 reviews)
5.6
5.6
User Avatar
Hi I can make ms Access as the front end with SQL as the back end. Best Zurab
$250 USD in 7 days
4.6 (27 reviews)
5.6
5.6
User Avatar
Hello! I am skilled SQL developer with skills including MySQL, Database Programming, Internet Security, Linux and Database Administration. C#, ASP.net, ETL, BI, DBA, SQL and PL/SQL Expert 15+ years experience in software development, database programming and administration, and project management. Specialist: SQL, PL/SQL, T-SQL, PL/pgSQL, ETL, Database Migration, SQL Optimization, Stored Procedure , C# , ASP.NET, AWS, Google Cloud, Microsoft Azure Database Expertise: MySQL, MariaDB, Oracle, MSSQL Server, PostgreSQL, EnterpriseDB, DB2, MS Access Database Administration and Programming: Install, configure and administration database server Design and Implement real time database replication and clustering Design and Implement data warehouse solution Database load balancing Database backup and recovery Database performance tuning and optimization Database Migration SQL Optimization Creating procedure, functions, triggers and packages Web Application Development: ASP.net, C#, HTML, CSS, Java Script, Ajax, Jquery, Entity Framework, Crystal Report, Microsoft Reporting Desktop Application Development: VBA, VB6, VB.net, C#, Crystal Report, Microsoft Reporting Application Server and Middle-ware: IIS, Apache Tomcat, HaProxy, PgPool-II, Proxy SQL Cloud Computing: Google Cloud, AWS & Azure. Operating System: Red-hat Linux, Centos, Ubuntu, Windows DevOps and Automation: Ansible, Python, Bash Shell Script, Jenkins, Apache Airflow ERP and CRM: Microsoft Dynamic Great Plan (GP) Microsoft Dynamic CRM Customized ERP Please send a message to discuss more regarding this project. Thanks
$150 USD in 1 day
4.7 (11 reviews)
5.2
5.2
User Avatar
Hi three, I've been working as DBA for more than 10 years - different DBs (Oracle, MySQL, PostgreSQL, DB2, MSSQL etc). I'll be happy to help you with your case - both optimization and HA cluster setup. I'll need access to you system to get its usage profile and will suggest possible ways forward.
$230 USD in 7 days
5.0 (13 reviews)
4.6
4.6
User Avatar
⭐⭐⭐⭐⭐YOU'RE LOOKING FOR ME!!!⭐⭐⭐⭐⭐ Hello dear. Hope you are doing well. I've 7+ years of experience in web development and database administration. I've extensive experience and expertise in both relational and non relational db management. Checking your project description carefully and thought that I can help you to complete this project perfectly to satisfy your requirement. I'd like to have a chat to discuss about your project in more detail. Waiting for your reply. Regards
$250 USD in 2 days
5.0 (2 reviews)
4.0
4.0
User Avatar
Hello ! I'm senior developer, I can work on mobile apps development for Android/iOS and REST api. I'm an experienced full-stack web developer specializing in Linux, PHP, Flutter, Java, MYSQL, Oracle, WordPress, Laravel, CAKEPHP, MAGENTO, CodeIgniter, Django/Python, Opencart, Prestashop, Shopify, WIX, AWS, cloudflare, VPS, WHM/cPanel. Best Regards, Andy
$140 USD in 7 days
4.8 (6 reviews)
4.0
4.0
User Avatar
Hello there! I am a good fit for this project due to my strong skills and experience in PHP, jSON and MySQL. Gladly waiting to serve you with my extensive skills. Thank you for reading my proposal Hello client, I have read your post that you want to receive the data on webhook which is sent from the other server.
$140 USD in 7 days
4.9 (8 reviews)
3.9
3.9
User Avatar
I am confident that I am able to help you optimize the speed of your queries and configure a high-availability setup on the MySQL database. I have extensive experience in database optimization, working with MySQL databases, and creating or working with databases using other technologies. Thank You
$250 USD in 7 days
5.0 (8 reviews)
3.6
3.6
User Avatar
I would like to outline the steps I would take to meet your requirements. 1: Analysis of current setup I would first analyze your current setup to identify the performance bottlenecks and the current configuration of the MySQL database. This would involve gathering data on the queries that are being used and the current database infrastructure. 2: Query optimization After the analysis, I would focus on optimizing the speed of the queries being used by default. This would involve identifying slow queries, analyzing query execution plans, and optimizing the database schema design to improve query performance. 3: High availability setup Once the query optimization is complete, I would configure a high availability setup on the MySQL database. This would cover all aspects of disaster recovery and data protection, including replication, clustering, and load balancing. Appropriate failover protocols would also be put in place to ensure minimal downtime in the event of a system outage. 4: Testing and validation After completing the optimization and high availability setup, I would perform thorough testing and validation to ensure that the system is functioning optimally. This would involve testing queries under different load conditions and testing the failover protocols to ensure they are working correctly. Thank you for your consideration. Sincerely,
$600 USD in 7 days
5.0 (1 review)
3.4
3.4
User Avatar
Hello, Drew C. I have checked your job post. I have many experiences in Internet Security, Linux, Database Programming, MySQL and Database Administration. I am sure I can complete your project perfectly. Why don't we work together? I'd love to hear from you. Thanks
$30 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir or mam, As a Full Stack Web Developer,I have 7 years experience with web dev. Espesially, I have rich experience in font-end texhniques such as html,css,jquery,bootstrap,ajex,javascript. And Back-End techniques such as Php,Mysql,Javascript,Node.js,C#. ✔️ Experience with Html, Css, bootstrap. ✔️ Experience with Php, Mysql, javascript. ✔️ Experience with All php frameworks and CMS: Laravel, CodeIgniter, Wordpress, Shopify. ✔️ Experience with Ecommerce platforms: woocommerce, shopify, magento, opencart. ✔️ Experience with Salesforce, DevOps, AWS, Azure, Big Data, Embedded Solutions, Bots, Machine Learning. ✔️ Experience with Angular, vue.js/vuex. ✔️ Experience with React Navigation / React Native Router Flux as navigation I never give up, constantly learn, easy communication. I am focused on adding real value to our client's projects. Our belief is clear that if we focus on client's success we are automatically successful. Hope to work for great people and making them happy through my work and that is my sole priority to bring smiles to the people who choose me and give me the opportunity to serve them with my skills. I’m working more than 40 hours per week and available in your time zone so communication will never become a problem. Thank you.
$40 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi There, will be happy to help, step 1 - will look at information schema to understand the use of objects and general housekeeping set-up step 2 - look up all queries you want to optimise step 3 - Sanity check of all DDL of objects. So to start with I need DDL's (all related objects) and query execution plans if you have any done or we can talk about setting up my access for the work period so I could start troubleshooting. Regards, Nik
$200 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear client! I am interested in your project database optimization queries speed - HA setup I have completed similar papers in the past and can assure you of exceptional and original work within the agreed deadline. I have skills in Database Programming, MySQL, Internet Security, Linux and Database Administration. please contact me to discuss your project in detail. Thanks & regards.
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have read your job description carefully and found my skills related to your project. I am confident that I can deliver high quality results on time. I am very interested in your project. Thank you,
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! I'd be happy to help you with your MySQL database optimization and high availability setup. As an experienced database professional, I have worked extensively with MySQL and NoSQL databases, and I am confident that I can help you achieve a quick and reliable database with maximum uptime. I have a proven track record of successful performance improvement projects and have experience troubleshooting and debugging databases. I understand that the optimization will focus on the queries being used by default, and I will ensure that the high availability setup covers all aspects of disaster recovery and data protection with appropriate failover protocols. I am committed to providing a great result and prompt turnaround time. Please let me know if you have any questions or would like to discuss the project further.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Have bast experience on MySQL query optimization, but to go on I need to know if you deployment is on AWS/Azure/GCP or an ad-hoc installation on a server on This depends the difficult of the HA configuratión (10 clicks on a cloud platform, much more time on an ad-hoc installation)
$140 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will complete this project within 7 days. I am professional mysql DBA and have been working in this background for about 8 years. If u agree with my proposal we can sit for meeting.
$200 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
hemet, United States
5.0
54
Payment method verified
Member since Jan 29, 2018

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.