Refinement of the website on Laravel (backend, database, admin panel)
Project description:
There is a company website created on Laravel. The frontend has already been implemented and assembled according to the designs in Figma. Part of the backend and admin panel is ready, but there are issues with the logic of database relationships and data transfer between the frontend and the admin panel. The previous developer was unable to complete the work due to a lack of documentation on relationships and constant SQL conflicts.
An experienced Laravel developer is needed who can understand the existing code, restore/optimize the relationships in the database, connect all pages to the admin panel, and ensure the stable operation of the project.
⸻
What needs to be done:
1. Analysis and debugging of the database
• Identify all existing relationships between tables.
• Eliminate SQL conflicts and data duplication.
• Optimize ~300 data transfer fields, partially already defined by the previous developer.
2. Refinement of the backend and admin panel
• Connect the “Contacts” page to the database so that all data is pulled from the admin panel.
• Link other pages (reviews, winning cases, news, services, lawyer profiles, etc.) to the backend according to the requirements.
• Implement sorting, filtering, and dynamic content loading.
3. Optimization and security
• Protection against SQL injections, XSS, CSRF.
• Optimization of SQL queries for fast website operation.
⸻
Candidate requirements:
• At least 3 years of experience with Laravel.
• Deep understanding of Eloquent ORM and building complex relationships.
• Experience working with large databases without documentation.
• Ability to quickly understand someone else's code.
• Experience resolving SQL conflicts and optimizing queries.
• Ability to work via SFTP.
It would be a plus:
• Experience in reverse engineering database structure.
• Experience optimizing Laravel projects for high load.
⸻
Access:
• SFTP access to the server.
• Access to the admin panel.
• Access to the database.
⸻
Expected result:
• All pages work correctly and pull data from the admin panel.
• All content can be edited in the admin panel.
• No SQL conflicts or errors.
• The website operates stably and quickly.