데이터베이스 설계 Jobs

I need an end-to-end ERP platform designed and built around my company’s real-world processes. At this stage I am deliberately keeping the brief open because I want the chosen developer to explore my workflow, advise on the most suitable architecture, then deliver a solution that connects everything from sales and customer data through stock control and finance. Here is what I expect: • Discovery sessions to understand current processes, pain points, and future growth plans. • A clear proposal outlining the recommended stack, core modules, data model, and deployment approach. • Development of a modular, scalable web-based ERP that supports role-based access, real-time reporting, and seamless integration with any existing tools we decide to keep. • User...

**Title: Seeking a Senior Full-Stack Engineer to Review and Secure Our Claude-Built CRM & Websites** We're looking for an experienced full-stack engineer to review, test, and improve an existing CRM and multiple websites developed with Claude Code. The code is largely prepared, and we want an experienced engineer to help us identify issues, validate the architecture, and ensure the applications are reliable and secure before production deployment. **Scope of work:** - Review the existing codebase, architecture, and database design. - Identify bugs, security vulnerabilities, and architectural weaknesses. - Audit authentication and role-based access controls. - Validate privacy and data isolation between owners, admins, agents, callers, and sub-agents. - Review API endpoints, dat...

# BlindForward SaaS Blueprint & Proof of Concept (PoC) I am building BlindForward, a consent-based email-forwarding SaaS for Chartered Accountancy (CA) firms. I am looking for an experienced full-stack developer to establish a secure technical foundation before production development begins. ## Project Objective The initial engagement will deliver comprehensive technical documentation and a working Google-based Proof of Concept (PoC). The goal is to validate the proposed architecture, email forwarding workflow, security approach, and database integration before committing to full-scale development. ## Proposed Technology Stack - Google Apps Script - Gmail API and Google OAuth - Supabase PostgreSQL - HTML, CSS and JavaScript for dashboard planning and future development ## Require...

Freelance Project Brief Airtable Product Development & Catalogue Management System Client: Woodstock Laundry & Granadilla Swim Project overview We are a South African apparel business operating two brands, Woodstock Laundry and Granadilla Swim. We design, manufacture and sell clothing and swimwear through wholesale, retail and e-commerce channels. We are looking for an experienced Airtable developer to build a centralised product development and catalogue management system. Currently, our team manually creates and maintains PDF catalogues containing product photographs, CAD drawings, descriptions, colourways, fabric specifications, trims and other product information. We want to replace this manual process with a user-friendly, form-based system that allows our team to captu...

Developed a Pharmacy Management System using SQL to design and build a relational database for managing essential pharmacy operations and data. The project includes tables for Suppliers, Drug Categories, Medicines, Pharmacists, Invoices, and Invoice Details, with properly defined Primary Keys, Foreign Keys, and relationships between tables. Implemented data insertion, retrieval, filtering, sorting, and modification using SQL queries, including Aggregate Functions, GROUP BY, JOINs, and Subqueries, as well as INSERT, UPDATE, and DELETE operations. Technologies: SQL Server, Database Design, Relational Databases, SQL Queries.

I need a specialist who can wire several production-level databases together so that information flows in real time, is captured accurately, and remains easy to trace long after it lands in storage. The job starts with building the live integration layer: connections, transforms, and routing must update immediately as changes occur in the source databases (no batch or nightly jobs). Once the stream is flowing, I want a solid verification routine to run alongside it. Data consistency checks should flag mismatches, duplicates, or missing fields the moment they appear, then write clear exception logs I can review. This audit trail will be the backbone of weekly compliance reviews. All incoming files—whether produced by the integration or uploaded manually—should sit in an organi...

I’m building an “online rental boyfriend” service and need a mobile app developed from the ground up for both iOS and Android. The first release focuses on a polished profile-creation flow—think seamless sign-up, photo/video uploads, engaging bios, availability tags and quick edits. Once users submit a profile it should sit in an admin queue where I can approve, reject or edit before it goes live. You may use Flutter, React Native, native Swift/Kotlin or another performant stack; what matters most is clean architecture, readable code and smooth store approval. I will supply brand assets and rough wireframes, but I’m counting on you for intuitive UI/UX, back-end setup, database design and deployment to the App Store and Google Play. Deliverables • Univer...

1. Technical Features & Functional Scope • Core Architecture: Built using WordPress, WooCommerce, and Dokan Multi-Vendor / Webkul B2B ecosystem for optimized out-of-the-box marketplace management. • Supplier (Udyami) Onboarding: Smooth mobile OTP-based registration and a personalized vendor dashboard to upload factory details, images, and contact information. • Product Cataloging: Comprehensive display supporting bulk pricing tiers (tiered pricing), variants, custom category attributes, and a dedicated 'Price on Request' toggle. • Lead Generation (RFQ Module): Optimized 'Get Best Price' form embedded on every listing to capture absolute buyer parameters (quantity, location, budget, delivery timeline). • Low-Cost Communication: Masked visibil...

I’m building a compact registration system and need a skilled backend developer to complete the core infrastructure. The application must store registration data in a MySQL database, generate admit cards and registration slips in PDF format, and allow administrators to create manual entries that are saved just like online submissions. Key elements I want you to handle: • Database layer – design the schema and write the queries/ORM code to capture every registration field, plus logs for audit and troubleshooting. • Payment flow – integrate Razorpay so the user can pay, receive an on-screen confirmation, and trigger creation of the PDF registration slip only after a successful callback. • Admit card generation – automatically compile the stored...

I maintain several live databases that generate a steady stream of purely numerical records—transaction totals, sensor readings, and performance metrics. The raw pulls already sit in secure tables; what I need now is a sharp pair of eyes (and ideally a few smart scripts) to make sure every figure is trustworthy before it feeds our reporting pipeline. Your focus will be end-to-end validation rather than manual typing. You’ll connect to the databases remotely, run consistency checks, flag outliers, trace discrepancies back to source tables, and document any corrections you make. If you prefer working in SQL, Python (pandas), or even a robust Excel environment linked through ODBC, that is perfect; the key is delivering a clean, fully audited dataset that reconciles against the or...

My application suddenly stopped reaching its underlying database and any direct connection attempt times out or throws generic “unable to access database” errors. Credentials have not changed and the server process appears to be running, so I suspect something deeper—possibly configuration, permission conflicts, or corruption—but I need fresh eyes to pinpoint and resolve it quickly. You will start by investigating the connection path end-to-end, identify the exact obstacle, then apply the safest fix to restore full read/write access without data loss. Please document the steps you take and any changes you make so I can keep the system stable going forward. To jump in, let me know which diagnostic checks you would run first and any information you need from me (log...

I'm the founder of NILQuant, an independent record for NIL deals in college athletics. We're looking for a qualified, independent reviewer for a scoped technical review of our core verification engine before its first production release. Scope (summary; full scope attached): - Rebuild our PostgreSQL database from its migration files on your own machine and repeat our test suite and reproduction kit - Check append-only history, two-person release controls, fingerprinting (SHA-256), school-to-school data isolation and a scoped verification API - Test the hosted demo with six test accounts (no admin access) and try to break the controls - Confirm our outside timestamping and write-once storage settings - Written findings, one retest round and a signed scoped conclusion All data is...

Je souhaite mettre en place un site de gestion interne pour ma boulangerie-pâtisserie afin de piloter l’activité au quotidien depuis un seul espace en ligne. Le site devra être accessible depuis un navigateur classique (ordinateur ou tablette) et sécurisé par des comptes utilisateurs à droits différenciés. Modules essentiels à livrer : • Gestion des stocks : saisie des matières premières, alertes de seuil, historique des mouvements. • Suivi des ventes : enregistrement des ventes au comptoir ou en ligne, ventilation par produit, vue journalière et cumulée. • Gestion du personnel : planning des équipes, suivi des heures, fiche employé. Je veux une interface claire...

Job Title: Database Architect & Big Data Procurement Specialist Job Type: Freelance / Project-Based Duration: [e.g., 1–3 Months / Ongoing] Experience Level: Expert / Senior Location: Remote About the Project We are seeking an experienced Database Architect & Big Data Specialist to assist in constructing a robust database infrastructure and sourcing/procuring high-quality big data assets for our platform. If you have a strong background in data engineering, database design, and hands-on experience evaluating and procuring third-party data feeds/datasets, we would love to collaborate with you. Key Responsibilities Database Design & Construction: Design, build, and optimize scalable relational/non relational database architectures tailored to our operational needs. Big Data ...

I am building a complete smart-mailbox platform and need you to take care of every software layer. The web side must be developed in Laravel (latest stable/LTS) and will handle user registration, secure login, mailbox pairing, a live dashboard that shows whether the lid is open or closed, and a simple settings area where each user can enable or disable mobile push alerts. A companion app written in Flutter will run on both Android and iOS. After signing in, the user should instantly see the current mailbox status, browse a short history of recent events (the system only keeps records for a configurable, limited period), and receive push notifications whenever the Tuya smart switch detects a new “open” event. The delivery person from the postal company will be able to read a...

I need my web application, which provides company-related information and is currently integrated with a Firebird database, to be restructured. The database is embedded within the site code and needs to be separated so I can host the main site externally. Key Requirements: - De-link Firebird database from the existing web application. - Ensure the web application remains functional and accessible after separation. - Provide documentation on the new setup for future reference. Ideal Skills and Experience: - Strong experience with Firebird databases. - Proficiency in web application development and restructuring. - Familiarity with documentation and providing post-project support.

I have two parallel needs and would like to tackle them in one cohesive engagement. First, I need a job-posting platform built from scratch. The core flow should let employers register, create and manage vacancies, and let candidates build searchable profiles, apply, and receive status updates. A clean, mobile-responsive interface, secure authentication, and an admin dashboard for moderation and analytics are all essential. Feel free to suggest the best tech stack; I’m open to anything from a classic LAMP setup to a modern React + Node or Laravel solution as long as it remains scalable and easy to maintain. Second, I have a catalogue of product images that require professional Photoshop retouching. Consistent backgrounds, balanced lighting, dust removal, and colour accuracy are k...