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.

Habilidades: Python, MySQL, Django, Administração de Bancos de Dados

Sobre o Cliente:
( 0 comentários ) Greater Noida, India

ID do Projeto: #33735153

8 freelancers estão ofertando em média ₹8938 nesse trabalho


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 Mais

₹12500 INR in 7 dias
(2 Comentários)

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 Mais

₹12500 INR in 3 dias
(1 Comentário)

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 Mais

₹7000 INR in 3 dias
(1 Comentário)

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 Mais

₹4000 INR in 4 dias
(0 Comentários)

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 Mais

₹7000 INR in 7 dias
(1 Comentário)

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 in 7 dias
(0 Comentários)

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 Mais

₹4000 INR in 7 dias
(0 Comentários)

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 Mais

₹12500 INR in 7 dias
(0 Comentários)