Database Design Jobs

I have a MySQL database that needs a set of well-structured, performant SELECT statements built with precise Boolean logic. The goal is to retrieve complex, multi-condition result sets in a single call rather than piecing data together in application code. You will be working only on read operations—no inserts or updates—so efficiency and clarity of each query are critical. The tables are already indexed, but I welcome recommendations if you spot obvious improvements that would speed up AND / OR combinations, NOT clauses, nested conditions, or full-text searches. Once the queries are finished, I need a short explanation of the logic behind each one so future maintenance is straightforward. Deliverables I expect: • SQL files (or a single file) containing the final SELEC...

Software Developer Required – Vehicle Movement & Loading Management System We require an experienced software developer/team to develop a centralized vehicle movement and loading management application operating across three locations. Basic Workflow Vehicle Entry → Loading Point → Vehicle Exit At each location, an operator will use a device to enter/update the vehicle status. All data must be centralized and visible to an authorized controlling user. Information to be Captured At Entry: * Vehicle Registration Number * Vehicle Type * Driver Name/ID * Driver Contact/identification details, if required * Entry Date & Time (automatic) * Purpose/Load details, if required * Unique Vehicle/Transaction ID At Loading Point: * Vehicle identification * Loading status...

Our main database is already running on PostgreSQL 13 (anything in the “12.x or higher” family), and I need an experienced DBA to step in and tighten two things: First, Database optimization. The work includes reviewing current configuration parameters, checking execution plans, tuning indexes, and suggesting any schema changes that will noticeably reduce latency under peak load. If extensions (pg_stat_statements, auto_explain, etc.) should be enabled or configuration values (shared_buffers, work_mem, effective_cache_size and friends) adjusted, please make those recommendations backed by data. Second, Backup and recovery. I want a clear, scripted process—preferably with pg_dump and/or a modern tool such as pgBackRest or Barman—that covers daily backups, point-in-t...

I have several bank statements saved as PDFs where each transaction is presented line-by-line. I need a small utility that can read those files, pull out every transaction, and insert the information into an SQLite database. The essential fields are the date, description and amount shown on each line; if a running balance is available it would be great to capture that as well. Accurate numeric handling is critical—please strip currency symbols, recognise minus signs or debit/credit markers, and make sure amounts are stored as real numbers rather than text. I use macOS but a cross-platform command-line solution is ideal. Python with pdfplumber / PyPDF2, pandas and the built-in sqlite3 module would suit me perfectly, though I’m open to another stack if you clearly outline the a...

I need a comprehensive reporting sheet with an integrated database for our engineering team. The tool should capture the following data: - Performance metrics - Maintenance history - Incident reports Functionality requirements include: - Data entry and updates - Data analysis and reporting - Automated alerts and notifications Ideal skills and experience: - Database development - Data analysis - Experience in creating automated alerts and notifications systems Your solution should streamline our reporting process and enhance data accessibility.

I need a full-cycle build of a School Management System delivered as a dedicated mobile app for both iOS and Android. The solution must include a solid back-end, restful APIs, and a well-structured database so that the Admin, Teacher, and Student roles each see only what they should. A classic username-and-password flow is enough for the first release, but it must be implemented securely with proper session handling and encryption in place. Core modules I expect from day one are fee tracking, attendance, timetable, examination results, push notifications, and printable reports. Everything should be responsive to different screen sizes, optimised for low-bandwidth scenarios, and ready for future additions such as two-factor login or parent access without major refactoring. Deliverables ...

I am looking for a Senior Backend Software Engineer to help design and build a scalable, production-grade Agentic Data Platform. The project focuses on building backend infrastructure for LLM-enabled data ingestion, enrichment, processing, and discovery across large and complex datasets. The platform should be designed from the beginning to support AI agents, automated workflows, and intelligent data retrieval. What you will work on - Design and implement scalable backend services and microservices - Build APIs using REST and gRPC - Design reliable data ingestion and processing pipelines - Build low-latency streaming and event-driven systems - Work with large-scale PostgreSQL / MySQL databases - Integrate LLMs and AI agents into backend workflows - Build data enrichment and discovery se...

I’m looking for a complete marketplace listing solution built with PHP (latest stable version) and MySQL on the back-end, paired with a native Android app. The web portal should let me manage three distinct roles—Admin, Seller, and Buyer—each with the appropriate dashboards and permissions. Attached Pdf Flie Please Review & Share Your Work Link Listing Market Place link Android App ink Key points I need covered: • Web portal: clean UI for adding, editing, and browsing listings, plus the usual order flow and reports an admin would expect. • Role management: separate logins and capabilities for Admin, Seller, and Buyer, all controllable from the admin panel. • Android app: native code (Java or Kotlin) that mirrors the core buyer experience, supp...

I need a focused staff-management module for our hospital administration team that handles one thing exceptionally well: shift scheduling. The application should let me build, edit, and publish rosters, catch double-bookings instantly, and highlight coverage gaps across wards. Each staff member must have a personal login so they can check their timetable on any device and receive a prompt email or SMS when something changes. Please architect the tool so it can slot into our wider hospital information system later—clean REST endpoints and a clear database schema are important. I’m comfortable with any modern web stack (for example, React or Vue paired with Node, Django, or a comparable back-end) as long as the code is well-documented and easy for our in-house IT team to pick up...

Issue is coming with my Ecommerce Website that again and again Hostinger is Activating query Blocking due to huge request from website. Have to Check the Root Cause of this and make website lighter and bug free.

I’m ready to have our new corporate site built entirely in PHP so we can keep full control of the codebase without relying on a hosted platform. The build should feel clean and modern on the front-end while giving us straightforward admin screens to manage content. Core features I need implemented: • Contact form that validates input and emails the right department • Searchable, profile-style employee directory pulled from a MySQL database • Dynamic news feed I can publish, edit, and archive in seconds • A listings section for our services that I can expand or reorder at any time Please code the back-end in PHP (a lightweight framework such as Laravel or CodeIgniter is fine if it speeds things up) and use standard tools like HTML5, CSS3, JavaScript, and ...

I have an advanced Excel workbook—between two and five sheets—filled with customer data that must live in Microsoft SQL Server. The columns include typical customer fields (name, contact details, account numbers, dates, notes), but a few calculated columns and drop-down validations make the file slightly more complex than a flat table. What I need from you is a repeatable, fool-proof process that moves every row from the workbook into SQL Server while preserving data types, relationships and any necessary transformations (e.g., date formats, trimming extra spaces, converting text “NULL” to actual NULL). I’m open to whatever tool you prefer—T-SQL scripts, SSIS package, Python + pandas, or a lightweight C# utility—as long as it runs on Windows and I...

DESCRIPCIÓN DEL PROYECTO: TOP GEAR & AUTOMOCIÓN OS Buscamos un Arquitecto Full-Stack / Desarrollador Senior experto en Inteligencia Artificial y E-commerce automotriz para desarrollar la plataforma web y sistema operativo Automoción OS / Top Gear. La plataforma es un motor financiero, logístico y aduanero de extremo a extremo que integra catálogos internacionales de vehículos, cotización en tiempo real de importación a Colombia (vía Zona Franca Buenaventura), pasarela de upselling de servicios en destino, automatización de marketing en redes sociales e integraciones omnicanal con portales de clasificados. 1. Motor Paramétrico de Liquidación Financiera (Backend Core) Módulo de Divisas (TRM): Int...

I’m ready to turn a new content-management concept into a fully-functioning web application and need a product engineer who can own the software side from first sketch to production launch. The core goal is to let non-technical users create, edit, organise and publish content through an intuitive browser interface, backed by a solid, scalable architecture. You would guide the technical vision, select the most appropriate stack, set up the database schema, craft the front-end experience and stitch everything together with clean, well-documented code. Secure authentication, role-based permissions, media handling, version control and a straightforward editorial workflow all have to feel seamless for the end user. An API layer for future integrations and basic analytics would be a big p...

I need an e-commerce website built from the ground up that lets visitors locate items quickly through a fast, accurate product-search feature. Everything from the storefront layout to the backend catalogue management should revolve around that smooth search experience so customers can reach any product in only a few keystrokes. Core requirements • Modern, responsive design that works on mobile and desktop • A well-structured product database and search algorithm (live suggestions, filters, typo tolerance) • Easy dashboard where I can add or update products without touching code While user reviews and a full shopping-cart flow could be added later, the initial milestone focuses on putting the catalogue online and making search flawless. Tech stack is flexible—S...