MySQL Database optimization and speed up of some queries

We have a fairly large database (MySQL) with some of the tables having 1.5 million to 2 million records. We are accessing this DB from a django application, sometimes running SQL queries from the app and at other times using the django ORM. The process is very sluggish at the moment, and we want this to be remedied so that we can get the results in a few seconds (ideally within 3 seconds) at least. We would like someone with excellent database optimization skills plus a working knowledge of django apps. In addition to solving the above mentioned issue, we would also like to have the following points addressed:

1) Enhancing the scalability and performance of existing database architecture.

2) Protecting data by developing data security and restoration policies, procedures, and controls.

3) Conducting diagnostic tests and evaluating performance metrics.

4) Developing procedures to ensure data integrity and quality.

5) Performing database maintenance, migration, and upgrading hardware and software.

We would disclose further details about the database during the interview process.

Thanks for your time.

Навыки: Python, MySQL, Django, Управление базами данных

О клиенте:
( 0 отзыв(-а, -ов) ) Greater Noida, India

ID проекта: #33735153

8 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹8938


Hi We are Bhopal based software company and provide lot of support to companies across the world on database and query optimizations, please connect and share the details of sql queries to be optimized, i would be ha Больше

₹12500 INR за 7 дней(-я)
(2 отзывов(-а))

Here is a Telecommunication Engr will provide you a 100% satisfactory work. I have already worked on a lot of projects relating PYTHON, PANDAS, DJANGO, PYSPARK, PYTORCH, TENSOR FLOW, THEANO, APACHE SPARK, PYGLET, ALGOR Больше

₹12500 INR за 3 дней(-я)
(1 отзыв)

Hello, I can help you with MySQL queries optimization and Django. Have used Django to develop personal blog: [login to view URL] Have been working with MySQL as a Data Scientist in Banking. Develo Больше

₹7000 INR за 3 дней(-я)
(1 отзыв)

Hello, .I would love to be your freelancer for the project you mention on freelancing portal. I’m interested in the position of software developer you recently posted. I’m a professional software developer, having 5 ye Больше

₹4000 INR за 4 дней(-я)
(0 отзывов(-а))

Dear, Client I have checked the project description carefully, I am very interested to work with you now. As I am a senior full-stack developer with 10+ years of experience, I have worked many web applications using fr Больше

₹7000 INR за 7 дней(-я)
(1 отзыв)

Hi Thanks for looking at our [login to view URL] are interested to work on your [login to view URL] we discuss futher on skype google [login to view URL] let us know our availability. Thanks & Regards Asutosh

₹12000 INR за 7 дней(-я)
(0 отзывов(-а))

Hi I am senior sql programmer and big data app developer. [login to view URL] I can provide required solution. would like to deliver quality product. Looking forward for your respo Больше

₹4000 INR за 7 дней(-я)
(0 отзывов(-а))

Hello I found your job posting and read the description and as with one of our experienced PL/SQL developer, Power BI professional and Python programing developer, I could be the right fit. Check the developer profile Больше

₹12500 INR за 7 дней(-я)
(0 отзывов(-а))