Databasedesign Jobs

Strong Microsoft SQL Server DBA background (8+ years) but last ~5 years on build/installation. Goal: intensive, hands‑on refresh of day‑to‑day DBA tasks, plus Azure SQL and migrations from SQL Server to Azure SQL. Schedule: 1 hour per day, Monday to Friday, 7–8 pm CST, starting March 9. Duration: ~7 weeks total (about 4 weeks SQL Server, 3 weeks Azure SQL/migration), adjustable based on progress. Emphasize that you want practical labs, troubleshooting, and real‑world scenarios. Explicitly state: “No blockchain, crypto, Web3 or related topics involved.

I have an Airtable account, I need an Airtable pro who can turn my draft template into a fully functioning workspace to replace a google spreadsheet I have been using. The final base has to feel as familiar as a spreadsheet, yet still take advantage of Airtable’s relational power for contacts and their interactions. What I’ll hand over: • My existing spreadsheet/template in .csv / Airtable format • A short outline of the data I’m already tracking What I need from you: • Import and refine the template into a clear, spreadsheet-style Airtable base • Set up tables, linked records, key fields and filtered views so I can find customers in seconds • Light automation—think simple formulas, look-ups or single-step triggers—only wher...

I'm seeking an expert to develop SQL document templates specifically for Comarch Optima. The templates will be used to generate essential business documents such as: - Order Confirmations - Invoices - Packing Lists Ideal Skills and Experience: - Proficiency in SQL and Comarch Optima - Experience in creating SQL templates for business document generation - Familiarity with handling financial, inventory, and customer data Please provide examples of similar work done. Looking forward to your bids!

I have a set of records that must be keyed directly into our Microsoft SQL Server database. Everything needs to be done by hand—no automated import tools—so each field is checked for accuracy as it goes in. Here is how the work will flow: • I supply the table schema, any lookup lists, and clear formatting rules. • You receive the source files and a secure connection to the database. • As you enter each record, you verify mandatory fields, follow the naming conventions, and flag anything that does not align with the guidelines. • When the batch is complete, you run a quick count against my control totals so we know everything landed where it should. The goal is simple: a clean, fully populated SQL Server table with zero duplicates and no missing...

(Solo perfiles con experiencia demostrable en diseño de esquemas PostgreSQL en producción. No busco desarrollo web, sino arquitectura y consistencia relacional.) Tengo una base de datos PostgreSQL alojada en Supabase que recoge partidos, goles, tarjetas, convocatorias, sustituciones y más. Ya está conectada a Power BI y funciona, pero quiero garantizar su integridad antes de seguir creciendo. Lo que necesito • Revisar el esquema actual y unificar los tipos de clave (codigo_equipo, codigo_jugador, codigo_acta). • Definir y aplicar PK, UK, FK e índices que mejoren consistencia y tiempos de consulta. • Detectar registros duplicados y proponer claves naturales para cada tipo de evento. • Renombrar o re-codificar columnas problem&aa...

I need to bring several Visual FoxPro databases up to modern standards while also building a fresh one from scratch. On the legacy side, the structure needs a careful redesign so tables, indexes, and relations make sense for today’s workflows. As part of that redesign, stale and duplicate records have to be cleansed, and performance tuned so queries return instantly rather than in minutes. Once the data is sound, I want clear, professional-looking reports and analytics dashboards that management can run with a single click. The new database should follow the same architecture and optimisation principles so it integrates cleanly with our existing codebase. Everything must stay native to Visual FoxPro; however, if a lightweight helper tool (e.g., SQL Server Express or Power BI for t...

Necesito diseñar e implementar una base de datos que centralice la información de producción, clientes e inventario de mi negocio. Todavía no he decidido si conviene un modelo relacional (SQL) o no relacional (NoSQL), así que valoro tu recomendación según escalabilidad, costo y facilidad de mantenimiento. Alcance que tengo en mente: • Modelado del esquema para datos de producción, clientes e inventarios, asegurando integridad y relaciones claras. • Funciones básicas de consulta y reporte: totales de producción por periodo, niveles de stock en tiempo real y resumen de clientes activos. • Documentación breve que detalle la estructura, credenciales genéricas, instrucciones de respaldo y c&oa...

I need a production-ready, web-based HR Management System that unifies three core areas: • Time & Attendance – real-time clock-in/out, leave management, overtime tracking, and the ability to record salary advances. • Payroll Processing – automated calculations tied to the attendance data, statutory deductions, and downloadable payslips. • Employee Management – smooth onboarding/offboarding workflows, performance reviews, and secure document storage for contracts, IDs, and policies. Security, role-based access, audit logs, and a responsive interface are must-haves. I’m open on the tech stack as long as it is modern, scalable, and well documented; propose what you do best and outline any frameworks or cloud services you plan to use. Deliver...

I’m building an internal security tool and need a solid PostgreSQL foundation that starts as a single, multi-tenant database yet can be cleanly split into separate databases—and separate servers—later on. The first release will concentrate on storing architectural components (a very well defined structure) alongside threat-intelligence data (mapped to the components metadata), so the schema must keep cross-tenant isolation strict while still allowing swift relational join matching across those two domains. What I need from you • A full relational schema (ERD and DDL) optimised for multi-tenant operation—think shared-table with isolated tenant-id or schema-per-tenant, whichever you can justify—and documented so the eventual extraction path is clear. &...

Create one instance of CRM Software in HTML and using Ruby Rails. Import data from CSV file into predetermined fields

I have a Google AI Studio frontend built with Vite that is already running perfectly in the browser; what it lacks is a solid, secure connection to a MySQL database on Hostinger and a smooth path to go live. I need you to come in, design the database schema from scratch, build the API layer in either Node.js or PHP (I’m open to whichever you are strongest with), wire everything together for full CRUD capability, and then deploy the whole stack to my Hostinger account. The hosting account exists but is still in its default state, so you will also handle the basic domain + hosting setup on Hostinger before pushing the code. Security best-practices for credentials and connections are a must, as I plan to take real user data immediately after launch. Key deliverables • Database ...

I need a full‑stack developer or small dev team to integrate the Roku Ads / Demand API and build a white‑labeled advertising dashboard for my broadcasting business. The goal is to have a self‑serve style interface where we can manage campaigns, view performance, and provide reporting to clients. Key requirements: Strong experience with REST APIs and OAuth Experience integrating advertising or analytics APIs (Roku Ads, Google Ads, Meta Ads, or similar) Backend in Node.js, Python, or similar modern stack Frontend dashboard with authentication, user management, and role‑based access Reporting views for impressions, spend, conversions, and other key metrics Ability to pull and aggregate data from Roku and potentially other ad platforms into a single UI Nice to have: Experience with Ro...

I need a lean, working web application that lets teachers publish courses and students immediately start learning. The priority is speed to a usable MVP rather than polish, so clean, well-structured code and a straightforward interface matter more than pixel-perfect design. Scope of the first release • Authentication: only email + password, securely hashed, with clear separation between teacher and student privileges. • Course workflow: – Teachers create, edit and delete courses, then add lessons that can contain plain text or embedded video. – Students browse the catalogue, enroll, and view each lesson. • Homework loop: teachers post an assignment; enrolled students submit their work; the teacher can review it inside the platform. • Notifi...

The goal is to design a future-proof relational backbone for a multi-channel retail platform, built natively on PostgreSQL. I already run an operational system, and its live transactional records will have to be migrated into the new structure without downtime. Everything else—users, inventory, orders—will start fresh. Core design expectations The operational schema should be fully normalised to 3NF and optimised from day one for high concurrency. Think table partitioning (range and list), well-chosen GIN and B-Tree indexes, plus JSONB columns where semi-structured flexibility makes sense. Triggers, constraints and stored procedures must enforce business logic consistently, so the application tier can stay lightweight. Analytics layer Alongside the OLTP schema I need a se...

I need a senior Delphi mind to craft a clear-cut strategy for moving an existing application from the Borland Database Engine to FireDAC with SQL Server as the back end. The objective is full modernization: cleaner code, easier maintenance, and freedom from legacy BDE constraints. I will spin up a dedicated testing environment first, so your plan must assume zero changes touch production until every issue is ironed out. Please lean on practical experience—show me similar projects you have already steered; past work is my main filter when choosing who to collaborate with. Deliverables • A written migration roadmap outlining phases, timelines, and required tooling • A checklist for preparing the test instance (drivers, FireDAC components, SQL Server settings, connec...

A responsive frontend web application built for a photography business to showcase services, portfolios, and client information. The platform focuses on clean UI design, smooth navigation, and optimized performance. It is deployed on cloud infrastructure and structured for scalability and future backend integration. Link:

I’ve put together the entire front-end of my React Native app and now I’m ready to connect it to a real backend. During a live Zoom or Microsoft Teams session I want to screen-share and work side-by-side while you guide me through each step. Supabase is the database service I’d like to use (or firebase), though I’m open to brief comparisons with Firebase if a decision point comes up. I have no prior backend experience, so you’ll need to walk me through project structure, environment variables, and deployment best practices. Whether the supporting server logic ends up in Node.js or another lightweight option, keep everything clear and beginner-friendly so I can maintain it afterward. We must cover: • Authentication setup – phone OTP authentication....

I need a cloud database setup using either AWS, GCP, or Azure. The database should support both SQL and NoSQL. Requirements: - Experience with at least one major cloud provider (AWS, GCP, or Azure) - Proficiency in both SQL and NoSQL databases - Ability to design and implement secure, scalable, and efficient cloud databases - Knowledge of best practices for cloud database management and maintenance Ideal Skills: - Cloud architecture design - Database administration - Security compliance in cloud environments - Performance tuning and optimization Please provide examples of similar work done.

Busco a un desarrollador con experiencia en aplicaciones web y móviles para crear una plataforma de Control Preventivo dirigida al sector HVAC. Alcance clave • Usuarios previstos: Técnicos y Gerentes podrán iniciar sesión con distintos niveles de acceso y permisos. • Funcionalidades imprescindibles: – Seguimiento de mantenimiento para programar y registrar tareas preventivas. – Informes y análisis que consoliden datos de equipos y muestren métricas de desempeño. – Notificaciones y alertas automáticas por correo, push o SMS cuando se acerquen fechas críticas o se detecten anomalías. • Acceso multiplataforma: la interfaz debe adaptarse correctamente a computadoras de es...

I need a robust asset management database designed to track the location of physical assets like equipment and machines. Essential Features: - Real-time tracking of asset location - Maintenance history logging - Asset condition reports - Detailed asset movement logs - Current asset status updates - Tracking for both serialized and non-serialized assets - End-of-life tracking - Fault reporting - Comprehensive logs of actions taken (who did what and when) - Asset location data The ideal candidate should have experience in database design and management, particularly with real-time tracking systems. Familiarity with asset management protocols and strong attention to detail is essential.

Hi! I’m building an AppSheet project tracker for an engineering firm and I’m looking to hire an experienced AppSheet consultant for ongoing advisory help as I build the app myself. What I’m building Project tracker for an engineering firm * ~300 projects per year * Google Sheets backend (for now) * Intermediate complexity app (multiple related tables, workflows, status tracking, etc.) The kind of help I want I’m NOT looking for someone to build the whole app for me. I want someone who can support me with: * Architecture and best-practice guidance * Expression and slice troubleshooting * Automation design and reliability * Performance and scaling tips for Sheets + AppSheet * Security/filtering strategy (if needed) Key feature / challenge A major requirement is a...

i want to create MS Access database sheet requirement database not to big or hard Database Requirement Explanation I belong to the Indian Army. My unit has a strength of approximately 445 personnel. Every year, individuals remain embodied (on service) and disembodied (service break) for varying periods, usually ranging from 1 to 4 months at a time. I want to create a database (preferably in MS Access) where each individual has a separate profile, and all service periods are calculated automatically. ⸻ Individual Profile Requirements Each individual profile should contain: • Army Number • Rank • Name • Date of Enrollment Example: Army No: 1245 Rank: Sepoy Name: Pankaj Date of Enrollment: 01 Dec 2015 ⸻ Embodiment / Disembodiment Logic For each individual, there can be m...

I want a purpose-built Airtable base that lets my project managers track every $ that flows through a job while giving me, as the owner, a clear tick-off control for supplier payments. What the base must do • Cost management and calculations – an input for estimated cost, an input for actual cost, and an automatic profit-margin field that updates in real time. • Supplier quote storage and attachments – each cost line needs an upload field (PDF, image, email printout) so the original quote is always one click away. • Payment tracking – a simple checkbox or single-select that I can toggle when a quote has been paid; when selected, it should stamp the payment date automatically. Financial insight I rely on profit-margin reports, so the system sho...

I have a Computer Science systems-design assignment due in three days that focuses specifically on database design. I need a clear, well-structured submission that demonstrates solid theoretical understanding and practical application. Scope – Analyse the problem statement I will share and extract data requirements. – Produce an ER diagram, explain entity choices, relationships, cardinalities, and constraints. – Normalise the model up to 3NF, documenting each step and the rationale. – Provide the final relational schema with primary and foreign keys clearly indicated. – Supply brief written explanations (2–3 pages) that justify design decisions and reference best practices. Acceptance Criteria • Diagram delivered in a common format (PDF or...

I’m rolling out the first release of a job-searching platform that already sits on top of a community of 87 million professionals. The entire focus of this build is to let candidates search and discover employer-posted opportunities quickly and intuitively. Core scope • Job listings are the single feature we need live for launch. Employers must be able to create, edit, publish, and archive their openings through a straightforward dashboard, while seekers browse, filter, and save roles. • Only direct employers will post ads in this phase. The workflow has to reflect that—no agency fields, fees, or approval steps. • Clean, responsive UI that feels inviting to a global audience and scales to the size of our network. • Solid search & filter logic (k...

I need an Elasticsearch cluster set up to store and manage log data. On premises Requirements: - Install and configure a new Elasticsearch cluster from scratch. - Ensure the setup is optimized for log data ingestion and querying. - Provide basic documentation for accessing and managing the cluster. Ideal Skills and Experience: - Proven experience with Elasticsearch installation and configuration. - Strong understanding of log data and its requirements. - Good documentation skills. Install on premises on windows servers

I’m looking for a senior systems architect to design the technical foundation for a payment-gated booking network that controls access to real-time, high-demand service slots. From the user’s perspective, the flow is simple: select a slot → pay → receive instant confirmation. Behind the scenes, the platform must reliably handle concurrency spikes, subscription validation, atomic booking, and fast payment settlement, while guaranteeing zero double-booking. This is an architecture-first engagement. No UI or app build is required at this stage. Core Objectives Model the end-to-end flow for payment-gated real-time bookings for high-demand services. Design a subscription layer that wraps booking access. At launch we will offer a single monthly plan; the architecture m...

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.