Database Management and Optimization of tables and queries

We have a fairly large database (MySQL) with some of the tables having 1.5 million to 2 million records. Over the next few months, we expect that the record count in these tables will go up to 9-10 million (in each table). We are accessing this DB from a django application, sometimes running SQL queries from the apps and at other times using the django ORM. We have done optimization of some of the queries, but the process is still a bit sluggish at some of the places, 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 проекта: #33802400

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


Hi, I'm an experence full stack python django developer. having plenty of knowledge working with variety of databases and optmization. as I read the project description I found myself quite eligible for this task as I Больше

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

Hello I can do this. Please share the details of the task so that I can check and confirm accordingly.

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

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 отзыв)

I have good experience in Database Management and worked on databases like MySQL, Oracle, Redshift, MongoDB. I have overall 11 plus years of experience in data engineering , will be able to do the task with ease.

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

"Greetings!! Thank you for sharing your project details. Our company has decent experience in Android, IOS, Flutter App Developments. Please share in a bit detail about your requirement what features you needed on the Больше

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

Hi, Hope you are doing great! I am Kumari Saroj, working as Sr. Business Development Manager at Test Yantra software Solutions India Pvt. Ltd. About Test Yantra:- Test Yantra is a fast-growing IT services company Больше

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