Fermé

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.

Compétences : Python, MySQL, Django, Administration de Bases de données

Concernant le client :
( 0 commentaires ) Greater Noida, India

Nº du projet : #33735153

8 freelances font une offre moyenne de 8938 ₹ pour ce travail

pushar71

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(2 Commentaires)
4.5
Alihassann00

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(1 Évaluation)
3.0
OSolovyev

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(1 Évaluation)
2.2
neharathoor30

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 4 jours
(0 Commentaires)
0.0
alifarazwork786

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(1 Évaluation)
0.0
Magify

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
dasaradhreddyk

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
QuixSolution

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0