Database Design Jobs

My MySQL 5.5.18 instance is limping along after a corruption event—system tables open, but every InnoDB table throws errors. The server is only “partially functional,” so I have powered it down and kept all data files intact (ibdata, ib_logfile*, .frm, .ibd, relay/binlogs, ). Remote log-in isn’t possible; you will need to walk me through everything step-by-step while I work directly on the box. What I need is a complete, reliable FULL backup of every database, including the damaged InnoDB tables, so I can spin up a fresh 5.7+ server later. I am comfortable following detailed terminal commands; I just need an expert plan and real-time guidance to: • Mount the data directory in a safe environment (ideally using Percona XtraBackup, mysqlbackup, or a comparable t...

I need an end-to-end iGaming solution aimed at the Chinese-speaking market. The job covers both the customer-facing front end and the operational back-office. I can provide URLs and credentials to our current sites so you can mirror the best features that already exist in the industry. Front-end scope • Build three responsive templates: Sports Betting, Casino Games, and Poker Room. • Each template must support live streaming, user profile pages, and full multi-language toggling (with Chinese as the default locale). • Templates should share a component library so future skins can be added quickly. Back-office scope • User management (KYC workflow, role/permission matrix, player segmentation tools). • Payment processing that accommodates common Asian gateways...

I need a solid PostgreSQL-backed RESTful API to drive the Solar TwinPro web application. Your task is to design the database schema and expose clean, versioned endpoints that cover full CRUD functionality for each core resource in the system. The web front-end will consume JSON, so consistent status codes and clear error handling are important. Please structure the project so it can be deployed easily (Docker preferred, but I am open to other simple approaches) and include concise documentation; an OpenAPI/Swagger spec is ideal so the front-end team can plug in without guesswork. Deliverables • PostgreSQL schema (DDL) and seed data • REST endpoints covering create, read, update, delete for all defined entities • Environment and run instructions (e.g., Dockerfile or...

I need a cloud-hosted CRM built from the ground up for a growing laundry franchise. The core priority is robust multi-store franchise management, so every branch can operate independently while still feeding real-time data to head office. Key workflow: • Each store logs in through its own portal to record orders, update statuses, and see today’s targets. • A live sales dashboard rolls those numbers up instantly so I can compare performance across branches from any browser or mobile device. Billing & invoicing must be friction-free. The system should generate fully customizable invoices that reflect our branding and service codes, then trigger automated payment reminders until a balance is cleared. From the central admin console I want the power to: • Add or ...

I need a complete, production-ready accounting system built from the ground up for small-business use. The core of the application must revolve around an intuitive cashbook, with seamless links to the General Ledger, Accounts Receivable/Payable, and an automated Bank Reconciliation workflow. Beyond day-to-day entries, I expect a solid reporting engine that can quickly generate the standard financial statements small companies rely on—think balance sheet, income statement, cash flow, and any custom summaries management may request. While those reports weren’t pre-selected in the questionnaire, please architect the platform so adding or modifying report templates is straightforward. The flow I have in mind: • Transactions land in the cashbook → post to the GL in...

Industrial AI Integration Platform – ERP & Manufacturing Systems Connectivity If your work rate is not 2-3$ per hour, please don’t apply!!!! Project Overview We are developing an advanced industrial software platform focused on improving operational efficiency within manufacturing environments. We are looking for an experienced developer/architect who can help us build the integration layer between our platform and existing enterprise manufacturing systems. The project involves connecting our solution with widely used industrial software ecosystems, enabling secure data exchange, real-time communication, and scalable integration with different production environments. This is a long-term and strategically important project for us, and we are looking for someone who und...

I’m working on a university assignment that calls for a fully-functional Microsoft Access (.accdb) database. The scenario revolves around three core entities—Products, Customers, and Orders—so those will be the three related tables, each with its own primary key and enforced referential integrity. I already have partial field lists in mind but need a bit of guidance on tightening data types and any additional fields that would make the relationships robust. The assignment requirements are straightforward: • Three related tables (Products, Customers, Orders) with primary keys and proper relationships • 15–20 sample records in every table • At least two meaningful queries that demonstrate the relationships • One clean data-entry form for da...

**Project Title:** Complete Cab Booking App (Customer, Driver & Admin) I am looking for an experienced mobile app developer or development team to build a production-ready cab booking solution for Android and iOS. The project should include three separate interfaces connected to a single secure backend: **Customer App** * User registration/login * Book a cab * Real-time driver tracking * Ride scheduling * Secure in-app payments * Ride history * Push notifications **Driver App** * Registration and verification * Accept/Reject ride requests * Live GPS navigation * Trip management * Earnings dashboard * Availability (Online/Offline) **Admin Panel** * Dashboard with real-time ride monitoring * User & driver management * Fare management * Analytics and reports * Payment & tr...

I am looking for an experienced full-stack PHP developer or development team to build a modern, secure, and scalable web platform similar to VoteNaija, but with significantly more features. The platform will allow organizers to create voting contests, sell event tickets, reserve VIP tables, sell music, and manage everything from a single dashboard. The system must be professionally developed, responsive, SEO-friendly, secure, and optimized for high traffic. # Preferred Technology * Core PHP 8.x (or Laravel if justified) * MySQL / MariaDB * HTML5 * CSS3 * JavaScript * Bootstrap or Tailwind CSS * jQuery/AJAX * REST API * Paystack Integration * Flutterwave Integration * QR Code Generation * GitHub Repository * cPanel Deployment Main Features 1. User Management * User Registration * Lo...

I need a web developer who can create a site that functions very much like the core of the project is a loyalty program, not a traditional e-commerce storefront. Members must be able to earn and redeem rewards seamlessly, with referral rewards generated after each completed transaction, just as we discussed. Here is what I expect to see: • A clean, responsive front end that mirrors the smooth user flow of the reference site. • A loyalty engine that supports my preferred “repeated” reward style, so customers keep accumulating benefits the more they interact. • Automatic referral crediting on every successfully finished purchase or service transaction. • An intuitive admin dashboard where I can monitor points, referrals, user tiers and adjust reward r...

I need a well-structured database focused on storing customer details for my company. I have not locked myself into any single platform, so I’m open to either a traditional SQL solution (MySQL, PostgreSQL, SQL Server) or a NoSQL option (MongoDB, Firestore) if you can explain why it’s the better fit. Scope of work • Analyse my current customer information flow and recommend the most suitable database architecture. • Design the schema to hold core customer data—at minimum names, phone numbers, and email addresses—plus space for additional fields such as purchase history or demographic insights that we may add later. • Build the database, populate it with a small sample dataset, and document the structure. • Provide clear instructions (or sim...

I’m building a configurable, multi-tenant enterprise platform from the ground up. The tech stack is React / with TypeScript on the front end and Python / FastAPI with PostgreSQL on the back end, wrapped in a CI-CD pipeline and deployed to a cloud environment. Core capabilities already planned include dynamic forms, rules and workflow engines, approvals, audit trails, role-based access, dashboards, Excel ingestion, third-party integrations and governed AI features. The roadmap starts with 8–10 foundational modules and is expected to expand well beyond that, so I need engineers who can take a feature from conception to production: front end, back end, database design, API contracts, automated testing, security hardening, performance tuning and deployment. This is real enterpris...

*Custom Billing Software for Fireworks Business - Indonesia* *1. Project Overview* I need a developer to build a cloud-based billing and invoicing software for a fireworks business in Indonesia. The system must be fast, easy to use for cashiers, and support multiple users with different access levels. *2. Key Features Required* - *Invoice Module*: Create, edit, and customize invoices with company logo, tax ID, and auto-calculation for 11% VAT, discounts, and tiered pricing: Wholesale, Retail, Reseller. - *Multi-User & Roles*: Admin, Cashier, Warehouse, Accounting with Role-Based Access Control. - *Inventory & Products*: Manage fireworks products by category with low-stock alerts. - *Customer Database*: Save customer data, NPWP, and purchase history. - *Reports*: Daily...

I am rolling out a full-scale MES in Ignition Perspective and need a specialist who can think at the ISA-88 level while still getting down to the tag-binding details. The job is to design a reusable, recipe-driven interface that supports recipe creation and modification, executes and tracks each run, and maintains strict version control. Alongside that interface, I expect robust OEE dashboards that surface Availability, Performance, and Quality in real time. Machine status must be visible at a glance and explorable in depth, so the Perspective views have to stream live status updates, surface detailed reports, and log everything historically for analysis. PLC faults and alarms should flow naturally into the same screens so operators never leave one environment to resolve issues. A plant...

I have a collection of CSV files that need to live in BigQuery and feed directly into Looker Studio dashboards. The workflow I have in mind is straightforward: create the initial dataset and tables in BigQuery, load the first batch of files, then automate a weekly refresh so each new CSV lands in the right spot without manual intervention. Once the data sits reliably in BigQuery, I’d like clean, visually clear reports in Looker Studio that focus on two areas—sales results and overall operational performance. Think trend charts, variance indicators, and drill-downs that anyone on the team can use without additional training. Deliverables • BigQuery dataset and table schema set up for incoming CSVs • Automated weekly load process (Cloud Console, Cloud Functions, o...

Looking for developers with experience in: * & React (Advanced) * TypeScript * PostgreSQL * Supabase * Database design & optimization * Authentication & Role-Based Access Control (RBAC) * API development * Real-time applications * Complex business logic implementation * Performance optimization * Git/GitHub workflow * VPS deployment (Linux) * Docker/Coolify deployment * Clean, scalable architecture * Business application development * Experience with aviation software is a bonus

I want a Microsoft Access relational database that lets my service team log every piece of client hardware the moment it arrives, follow it through each repair step, and close the loop when it ships back out—all without spreadsheets or paper forms. Core workflow • Intake: a simple form captures serial number, model, client name, date-in, and automatically assigns a job ID. • Live status tracking: technicians update the record as the unit moves through diagnosis, parts ordering, repair, testing, and dispatch, so anyone can see its current location and status in real time. • History at a glance: each asset’s full maintenance history should be retained and viewable from a single screen. • Daily summary report: at the click of a button I need an automat...

I’m working on expanding my product and now need a brand-new backend feature built from scratch. The focus is purely server-side: data handling, business logic, and secure API endpoints. I’ll share the existing codebase and functional requirements once we connect, but in broad strokes the job involves: • Designing the data model and logic for the feature • Implementing clean, well-documented code and tests • Exposing the necessary endpoints and making sure they slot smoothly into the current API You’re welcome to recommend the language or framework you believe is best for the task, so long as the final solution is performant, maintainable, and easy for my team to extend. If this sounds like your kind of challenge, tell me how you’d approac...

We are building a new mobile application and complete backend platform. We are looking for experienced Mobile App Developers to build the application, backend system, APIs, database, and admin dashboard. Required skills: - Flutter and Dart - Node.js - REST API development - Android and iOS app development - Database design and management - Firebase, PostgreSQL, MySQL, or MongoDB - User authentication and security - Notifications, maps, and payment integrations - Admin dashboard development - App publishing on Google Play and Apple App Store Responsibilities: - Build a scalable Flutter mobile application. - Develop secure backend APIs using Node.js. - Design and manage the database. - Build an admin control panel. - Integrate notifications, maps, payments, and external services. - Improv...

Saya ingin membangun sebuah aplikasi akuntansi berbasis desktop yang fokus pada pengelolaan gaji karyawan di perusahaan teknologi dan mampu meminimalkan potensi penipuan (salary scam). Gambaran singkat • Platform: desktop software (Windows diutamakan, cross-platform akan menjadi nilai tambah). • Lingkup: modul payroll lengkap—perhitungan gaji pokok, lembur, tunjangan, potongan, pajak; pencatatan jurnal akuntansi otomatis; serta dashboard audit internal untuk mendeteksi anomali pembayaran. • Fitur kunci: – Login berbasis peran (HR, Finance, Auditor). – Enkripsi data sensitif dan rekam jejak aktivitas pengguna (audit trail). – Ekspor laporan keuangan bulanan dan tahunan dalam format PDF/Excel. – Integrasi opsional dengan A...