Business Site Database & Upgrades
Employer not named by the sourceRemote
Frontier is not the employer and does not collect applications.
About this role
PHP, SQL, MySQL, HTML, PostgreSQL, Database Development, Web Development, Database Design · My corporate-style website is live but the back-end data layer is still a patchwork of spreadsheets and ad-hoc tables. I need a clean, well-structured database built from the ground up that can comfortably store two core data sets—customer information and product/service details—and also power a simple booking workflow for the services we offer.
Here’s what I’m looking for you to handle:
• Review the current site codebase, spot gaps, and propose the best database technology for long-term stability. • Design an ER diagram and schema that separates customer profiles, product/service listings, and booking records while preserving necessary relationships and security constraints. • Provide migration scripts or seed data so I can import existing CSVs without downtime. • Integrate the new database into the site, wiring up forms, queries, and any admin pages required to add, edit, or report on bookings. • Document everything clearly so in-house staff can maintain it after hand-over.
Success for me is a single source of truth for customers, services, and bookings, loading quickly and ready for future reporting needs. Please let me know the stack you’d prefer to use, any questi