![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Database Administrator / Back-end Developer Required
- or -
Post a project like this- Posted:
- Proposals: 22
- Remote
- #4208194
- OPPORTUNITY
- Expired
![Top Seller with earnings over £100k Top Seller with earnings over £100k](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/6848fd9e0514ae9277cce59806b79dc5.png)
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
![Serhii D.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/8c5756a14f5dacc101f0257350ad0426_70x70.png)
![Amit J.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/1234fd2b2bf2475e020804597d0daee8_70x70.jpg)
![Bohdan S.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/8ea759d0d4f3ee1f068c32930562814c_70x70.png)
![Matthew G.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/142f421b152c4a52929b3a129003b0ab_70x70.jpg)
Description
I am looking for a Database Administrator / Back-end Developer to complete the given below requirements:
Scenario:
1. The store is based on Magento 2.4.6-p3 with all necessary server requirements such as Nginx 1.22, MariaDb 10.6, Varnish cache 7.3, php 8.1, Composer 2.2, Elasticsearch 8.5, MySQL 10.6, RabbitMQ 3.11, Redis 7, etc.
2. The website is hosted on CCX53 on Hetzner Cloud: 32 CPU, 128 GB RAM (dedicated resources)
Here are the details of the products present in the database:
1. The store has 320 million products in 411 GB database. There are no product attributes, or variables. Just simple products.
2. There are no product images
3. Each product is a company information page i.e. the products are digital and it provides information on companies globally. I will share the sample product page link once you submit your proposal.
Magento Modules Installed and configured:
1. Amasty Elasticsearch: https://amasty.com/elasticsearch-for-magento-2.html
2. Amasty Google Speed Optimiser Pro: https://amasty.com/google-page-speed-optimizer-for-magento-2.html
3. Amasty Varnish Full Page Cache Warmer: https://amasty.com/full-page-cache-warmer-for-magento-2.html
Requirements:
1. Import the product database of 411 GB database. I will provide the database in SQL format.
2. Optimise the Elasticsearch and page load
3. We expect 100 concurrent users anytime throughout the day
4. Elasticsearch should index all the products
5. Optimize website performance. Current score on Google page speed insight is 47 on mobile and 83 on Desktop.
6. Product search result should be less than 3 seconds
7. Suggest if the job requires server change
![Mr. Sam D.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/da3a3a14cee8575e911fd596804b92d5_150x150.jpeg)
Mr. Sam D.
96% (50)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can you provide more details about the current database schema? Are there any specific tables or structures that require optimization or maintenance?
How frequently are new products added to the database? Is there a process in place for managing product updates and deletions?
Are there any specific performance issues or bottlenecks that need to be addressed? Have there been any recent incidents or outages related to the database or back-end systems?
Can you provide access to the Magento admin panel and server logs for further analysis?
Are there any specific security requirements or compliance standards that need to be followed for database and back-end development?