Database Design Jobs

Software Interface Development Requirement SecuGen HU20 Hamster Pro 20 Fingerprint Scanner to Wonderware InTouch Graphical Controls, Inc. is seeking a qualified programmer/developer to create a software interface between a SecuGen Model HU20 Hamster Pro 20 USB Fingerprint Reader and Wonderware InTouch SCADA HMI. The purpose of this project is to allow operators to authenticate using a fingerprint scanner and pass the authenticated user information into Wonderware InTouch for operator identification, access control, and event logging. Scope of Work The programmer shall develop a Windows-based software application or service that interfaces with the SecuGen HU20 fingerprint scanner using the SecuGen SDK. The application shall capture fingerprint scans, verify or identify the operator, and wr...

I have a fully-functional, web-based ASP.NET C# asset management system that now needs to grow. You will begin by cloning the current repository and exploring its layered architecture, paying close attention to how the SQL Server database is structured and how the data-access layer is wired up. From there, your mission is to extend core modules without disturbing what already works. Key goals are to introduce maintenance and work-order workflows, asset history with drill-down reporting, document and image uploads tied to each record, and—if the codebase allows—QR or barcode scanning for fast look-ups. In parallel, I want the main dashboard to feel snappier and more intuitive, so any refactoring that improves query performance, filter logic or UI polish is welcome. Expect to t...

I’m building a C# .NET full-stack application and the part slowing me down is database management. The project already has its front-end and API layers in place; what I need now is an experienced SQL Server specialist who can step in, assess the existing schema, and make the data layer rock-solid. You’ll be looking at tables created through Entity Framework migrations, several hand-written stored procedures, and a set of LINQ queries that are starting to show performance issues in production-like loads. I’d like you to refactor or redesign where necessary, tune indexes, and help establish best-practice patterns so the code stays maintainable. If you have a track record of solving similar SQL Server challenges inside .NET environments, let me know how you approached them...

I need a seasoned Pakistani freelancer to take charge of the M Rep app’s backend. While the project occasionally touches mobile-side tweaks and API integrations, your immediate focus is tightening up everything that happens server-side—database health, service uptime, security, and smooth release of new features. What matters most to me is clean, well-documented work and prompt, clear communication. If you spot a bug, I expect you to isolate it quickly, patch it safely, and push the fix without disrupting live users. When a new feature is ready, I want the rollout handled end-to-end, from schema changes to deployment and post-launch monitoring. Key deliverables: • A stable, optimized backend ready for production load • Clear documentation of any new endpoint...

Our real estate investment and short-term rental company manages a growing portfolio of high-end units and now needs Odoo to serve as the single source of truth for everything that happens inside each property. The first milestone is a rock-solid physical unit inventory module with live unit availability tracking that plugs seamlessly into the wider Odoo ecosystem. Once this foundation is in place, we will layer on maintenance, leasing, accounting, and short-stay workflows, but availability visibility is the immediate priority. Scope of work • Design a data model that captures every unit, room, and critical asset so availability can be shown in real time. • Configure and customise Odoo (preferably v16 or above) to surface that data through dashboards, calendars, and API endp...

I am building a web-based portal that bridges a wearable dysphagia-monitoring device and the clinicians who treat the patient. This will be a dummy site and does not need to be professional at this point. The top priority is clear, two-way communication between patient and clinician, so the experience on both dashboards must be equally intuitive, performant, and secure. Core workflow • The device streams or periodically uploads swallowing logs, symptom flags, and adherence stats. • Patients log in to see these metrics, receive therapy reminders, and acknowledge alerts. • Clinicians review trends, adjust diet or exercise plans, send secure messages, and schedule follow-up video calls—all inside the platform. • A rules engine triggers notifications when uns...

# Laravel Multi-Tenant Database Structure Upgrade ## Project Overview I already have an existing PHP Laravel web application currently running in production. Web Application Link:- At present, the application stores all companies’ data in the same database tables using a shared structure. For example: * Companies * Staff * Customers * Orders * Accounts All data is currently stored together in single tables with a company_id relation. I now want to upgrade the application architecture into a proper Multi-Tenant SaaS structure where each company has isolated and separate data storage. --- ## Current System Currently all companies’ records are stored in shared tables like: * customers * staff * orders * invoices using: company_id for separating records. --- ## Requ...

We are looking for a Senior .NET Full Stack Developer for a web application project and potential long-term collaboration. Requirements: Strong experience with ASP.NET Core / .NET 6+ Expert-level C# development skills Experience building scalable REST APIs and backend systems Strong knowledge of SQL Server and Entity Framework Frontend experience with React, Angular, or Blazor Experience with Azure or AWS cloud deployment Strong understanding of clean architecture, SOLID principles, and secure coding practices Experience with Git, CI/CD pipelines, and Agile workflows Fluent English communication skills (spoken and written) Scope of work: Full stack web application development Backend API development Frontend UI implementation Database design and optimization Performance improvements an...

More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Past work How soon do you need your project completed? ASAP

I need a full-featured B2C marketplace that lets me accept and manage payments from customers all over the world. Besides card payments from my own account, the platform must be able to process funds arriving from third-party business partners, online gateways, tax agents, freelancers—any source that fits standard compliance rules. Core functions I cannot launch without: • Vendor management system — simple onboarding, profile control, payout tracking, and suspension tools. • Flexible, customer-specific pricing — the same item may show different prices or discounts depending on who is logged in. • Direct integration with WorldFirst for cross-border settlement, currency conversion, and automated KYC checks. I am happy to discuss the tech stack you are...

I’m building a lean Android MVP called LifeNote and need a Firebase-powered backend put in place quickly. I have already created the Firebase project and will share the API key as soon as we start. What I need you to wire up: • Authentication – enable phone-number OTP login alongside the classic email-and-password flow, making sure both methods land in the same user collection. • Firestore – create tidy, scalable collections for:  – user profiles (name, profile picture URL, bio)  – posts (text or image URL) with sub-collections for likes and comments • Storage – configure buckets and folder paths for profile photos and uploaded post images, then surface the download URLs back to Firestore. • Basic security rules ...

Our team is standing up a dedicated SQL Server 2022 environment and I need the DBA work handled end-to-end. The scope covers: • Clean installation and configuration of the SQL Server 2022 engine and all required services. • Baseline performance monitoring, then ongoing tuning—index strategy, query optimisation, and server-level adjustments—to keep response times consistently low. • A documented backup and recovery plan with test restores that prove RPO/RTO targets are met. • Hardened security focused on user access management (role design, least-privilege enforcement) and comprehensive audit logging activated and validated. Deliverables are the completed server setup, scripts and documentation (PowerShell/T-SQL where relevant), plus a short runbook s...

I am looking for someone highly experienced in data analysis and database architecture to help build a well-structured and scalable database system for my project. The developer is not required to build the database completely from scratch manually. I will provide the full frontend of the system along with detailed explanations of the application flow, user types, features, and all important business logic related to the database structure. The main goal is to use AI-assisted development to: * Design and verify a database structure that is fully compatible with the frontend * Ensure the database architecture is efficient, scalable, and logically organized * Connect the frontend with Supabase properly * Build any small backend functionality required for the system to operate correctly T...

# Email Invite System for Existing + Supabase Web App ## Project overview We have an existing web application built in Lovable using , Supabase, and Tailwind CSS, deployed on Vercel. The app is a self-assessment tool used by companies, where each company has an admin user and one or more team members. We need to replace the current shared invite link flow with a personalized email invite system. Each invite must be tied to a specific email address, sent via transactional email, and only usable by the named recipient. This is a focused backend and integration project. No new visual design work is required. The existing dashboard UI will receive a functional update to the invite section, but the broader design system is already established. ## Current state The app already has: - Work...

I’m ready to move our data into a brand-new Azure SQL Database instance and need a seasoned SQL developer to take the lead from design through deployment. The job starts with a clean slate—no legacy SQL Server to worry about—so I want a solid, future-proof schema that follows best practices for normalization, indexing, and naming. Your work will cover: • Designing the database structure and providing the DDL scripts to create it in Azure SQL Database • Configuring the instance for performance, security, and scalability (firewall rules, Transparent Data Encryption, role-based access, automated backups, etc.) • Writing any necessary stored procedures, views, or functions to support day-to-day operations • Supplying clear documentation and a qu...

Migrate old MySql to Supabase (in ), need to migrate content from e commerce site, like products, services, users

I need a clean, scalable backend drafted from scratch, starting with a solid PostgreSQL schema. The heart of the project is a referral module that pays out cash rewards when invitees convert, so the data model, triggers, and calculation logic must revolve around that requirement. Here’s what I’m expecting: • Database design in PostgreSQL, including all DDL scripts and a concise ER diagram. • Core API endpoints (or documented stored procedures) that record a referral, verify the qualifying event, and trigger the cash-reward payout. • Clear unit or integration tests demonstrating the reward rules in action. While tracking links or status updates are not mandatory right now, structure the tables so those features can slot in later without rewrites. Hand-ove...

I need a web-based CRM that streamlines every step of our parcel flow—from merchant booking through dispatcher coordination to driver pickup and final delivery—with a clean, modern UI that works smoothly on desktop, tablet, and phone. Three role-specific portals sit at the heart of the build: • Dispatcher login – Manage all incoming bookings in real time – Track each parcel’s current location and status – Assign or reassign drivers with one click • Driver login – View today’s assigned pickups and drops – Update parcel status at each checkpoint (picked up, in transit, delivered, exception) – Launch route navigation directly from the job card (Google Maps or Mapbox) • Merchant login &nd...

I need to migrate mysql to lovable, but it get timeout, help to fix it

I am building a web-based application in .NET and need help completing the data-management layer. The system must store and manipulate two primary datasets—user information and transaction records—while enforcing role-based access for Admin and standard User accounts. Here is what I need from you: • Design or refine the database schema so both datasets are structured for scalability and easy reporting. • Build the API and back-end logic in ASP.NET (Core 6 or later preferred) with Entity Framework for data access. • Implement CRUD operations, search, basic filtering, and pagination for each data type. • Add role checks so Admins can see, create, update, and delete everything, while Users have read/write rights only to their own records. • Inte...

I need a lightweight, web-based school management application built with core PHP (latest stable version) and MySQL. The system has two must-have modules: • Student Information Management – create, edit, archive, and search full student profiles, including contact details, enrollment status, and custom fields I can add later. • Attendance Tracking – daily class attendance taken by teachers, stored in a central log, with quick summaries for administrators and a personal view for each student. Three distinct user groups will work inside the same code-base: Teachers, Students, and Administrators. Access must be controlled by a clean role-based permission layer so that, for example, teachers can manage attendance but cannot alter school-wide settings, while students...

Loyalty App — WhatsApp Gift Voucher Development | Developer Needed The Opportunity We’re looking for a talented developer or development team to add a powerful new feature to our Loyalty App — our existing digital loyalty platform (available on Apple App Store). Project Details What We’re Building A Gift Voucher feature with WhatsApp Integration that includes: WhatsApp Integration • Send vouchers directly via WhatsApp (instead of email) • Integration with Meta’s WhatsApp Business API • Automated message sending with real-time delivery tracking • Option to expand to multiple messaging channels later Gift Voucher with Multiple Items • Each voucher contains multiple services/products (not just one fixed value) • Example: Hair...

My current PHP site keeps everything in one large MySQL database. I now want to break that up so that all profile-related data lives in its own database while the rest of the application stays untouched. Concretely, I need: • A migration script that copies existing profile content into the new database and updates references inside the codebase. The split must keep User information separate from User posts exactly as outlined. • Support for every kind of post we allow—Text, Image and Video—so the script has to build the right tables, constraints and indexes for those. • An update to the admin dashboard that lets me bulk-add content to each newly created section; it should feel native to the current UI. • An AI-powered auto-tagging feature: when a use...

I need help setting up an almost pure-vanilla survival Minecraft server, with the exception of two lightweight, well-documented plugins built from scratch. 1. A clan plugin that lets players create and manage clans, level them up through shared playtime or completed goals, unlock higher clan ranks, and deposit items into a shared, protected storage. A simple in-game command set and minimal database footprint are important—everything should feel native to vanilla rather than a modded overhaul. While I am open to later additions such as clan chat or wars, the levelling/ranking and storage systems are the must-haves for this first release. Player Level Up System: - Burn specific items for experience points. Command /lup or /level will open a GUI menu where you will be able to place a...

I need a full-stack PHP developer who can take this project from a blank repository to a production-ready ERP web application. The site’s core purpose is business resource planning, so every decision—from database schema to front-end micro-interactions—has to serve speed, clarity, and data accuracy. Design I’m after a modern, minimalist interface: clean typography, a neutral colour palette, responsive layouts, and zero visual clutter. Think quick-loading dashboards where the most important metrics surface instantly on any device. Core modules Below are the five functional pillars the first release must cover: • Inventory management • HR management • Financial reporting • Process automation • Data input and display • At...

Saya membutuhkan bantuan untuk menyiapkan infrastruktur database dan melakukan tuning menyeluruh pada instance PostgreSQL kami. Fokus utama saya adalah mengatasi performa lambat yang mulai berdampak pada aplikasi produksi. Ruang lingkup pekerjaan: • Audit konfigurasi server dan parameter runtime (shared_buffers, work_mem, dll.) • Analisis EXPLAIN ANALYZE pada query paling berat, lalu optimasi indeks dan struktur tabel. • Implementasi metode caching, partitioning, atau vacuum strategi yang relevan. • Pembuatan skrip monitoring ringan (PgBouncer, pg_stat_statements, atau alat serupa) agar kinerja mudah dipantau ke depannya. Deliverable yang saya harapkan: 1. Laporan awal berisi temuan bottleneck utama. 2. Rekomendasi dan perubahan konfigurasi yang sudah diuji....

Ho bisogno di una singola applicazione web che mi permetta di registrare e tenere sotto controllo circa 40 uscite giornaliere dei nostri mezzi. Per ogni corsa devo poter inserire in modo rapido: • targa e tipologia del mezzo • orario di partenza e, se serve, di rientro • destinazione • nominativo dell’utente a bordo • azienda cliente servita • operatori interni coinvolti Il flusso è interamente desktop / browser-based: niente versioni mobile o installazioni locali. Gli operatori interni saranno gli unici utenti e necessitano di: 1. Maschere di inserimento dati essenziali, veloci da compilare. 2. Notifiche in tempo reale quando un mezzo parte, arriva o viene modificata una corsa (popup nel browser, e-mail o webhook: scelgo con te la ...

Saya membutuhkan bantuan Pengembangan perangkat lunak untuk membangun sebuah Aplikasi web yang berfokus pada penyajian Informasi atau konten. Gambaran singkat: Saya sudah memiliki ide dan struktur konten, namun memerlukan seorang developer yang dapat menerjemahkannya menjadi situs web modern, aman, dan mudah dikelola—baik di desktop maupun perangkat mobile. Cakupan kerja: • Merancang dan membangun front-end responsif (HTML5, CSS3, JavaScript atau framework setara). • Membangun back-end ringan yang memungkinkan saya menambah, mengedit, dan menghapus artikel atau halaman tanpa pengetahuan teknis mendalam (bisa menggunakan CMS kustom atau integrasi framework populer seperti Laravel, Node.js + Express, atau Django—mana yang paling efisien). • Menyiapkan struk...

La plataforma SoftGuard que administro dejó de conectarse a la base de datos SQL Server justo al momento de iniciar sesión; siempre devuelve “Tiempo de espera agotado”. Quiero que analices la infraestructura completa de SoftGuard y del motor SQL, identifiques la causa de la conexión fallida y la restaures sin afectar los datos ya existentes. Contexto – El fallo ocurre únicamente al loguearse; una vez que la aplicación supera ese punto (cuando lo logra en entornos de prueba) todo funciona. – Base de datos alojada en SQL Server; gestión habitual con SQL Server Management Studio. – No hay indicios de datos corruptos, por lo que el foco es la capa de conexión, autenticación, puertos o parámetr...