Programmation de bases de données Jobs

I'm seeking a consultant based in Johannesburg South Africa, with strong experience in Power BI, Power Automate, and knowledge of Syspro for a 6-month engagement. The goal is to build tables and dashboards and automate some of our internal workflows. Key Responsibilities: - Building tables and dashboards in Power BI - Automating internal workflows using Power Automate - Connecting to SQL databases and Excel spreadsheets as data sources - Ensuring that both management and operational teams can effectively use the outputs Ideal Skills and Experience: - Strong expertise in Power BI and Power Automate - Proficiency in SQL and Excel - Familiarity with Syspro - Experience in creating user-friendly dashboards for management and operational teams Please provide examples of similar projects...

Need existing database of European countries which u scrapped earlier

I’m a beginner looking for a 1-on-1 Databricks instructor for a very hands-on, fast-paced 2-week program. Requirements: - Strong real-world Databricks experience - Hands-on Apache Spark (PySpark), SQL, Delta Lake - Real use case / mini project (end-to-end pipeline) - Live screen sharing, coding together - Beginner-friendly but practical (no theory-only) Goal: By the end of 2 weeks, I want to confidently build and understand a real Databricks data pipeline. Availability: 5–6 sessions per week, 1–1.5 hours per session Please share: - Your Databricks experience - How you would structure these 2 weeks - Your hourly rate Thanks!

We are looking for a contract Data Engineer with hands-on experience in Microsoft Fabric to support pipeline development and data movement activities. You will help me: 1) Develop and manage data pipelines using Microsoft Fabric 2) Perform data loading and data migration activities 3) Ensure reliable and efficient data flow across systems Required Skills: 1) Strong experience with Microsoft Fabric 2) Proven experience in pipeline development 3) Hands-on exposure to data loading and data migration projects

I'm a longtime FileMaker user developing a simple tracking database. I need assistance with formatting time output in 24-hour format for reports. Ideal skills include: - Proficiency in FileMaker - Experience with time calculations and formatting - Ability to guide users effectively If you can help me resolve this issue or direct me to the proper resources, I would appreciate it.

I need about three hours of guided, screen-shared help moving product data that currently lives in several related Excel sheets straight into my PostgreSQL database. No transformations are required—just a clean import exactly as the data sits now. During the session we will • create or confirm the target tables and column types, • choose the quickest import method (COPY commands, pgAdmin’s import wizard, or any tool you prefer), • load every sheet accurately, and • finish by writing a few SQL queries to verify row counts, join related tables, and pull sample SKU-level results. Deliverables for me at the end of the call will be: • a working, repeatable import script or step-by-step notes; • the example SELECT queries we ran together; a...

I am looking for a developer to create a digital version i.e. an app of medical paper form for patients. The goal is to input data via a user-friendly interface (Web App or Windows App) and generate a PDF report at the end. The main goal is to make it user friendly but do not change the content. The next important step, is to make this app have a login feature to save the data entered for each patient into an exportable list of total patients.

I need a relational database system designed and implemented for a small restaurant using PostgreSQL. This database should efficiently manage orders and provide insightful analytics. Key Requirements: - DBMS: PostgreSQL - Track Orders - Store Details: Items ordered Ideal Skills and Experience: - Strong PostgreSQL expertise - Experience in database design and implementation - Knowledge of generating analytical insights from database data The database should help us understand popular menu items, track daily sales, and maintain a comprehensive order history.

We are looking at consultant who has deep understanding of Oracle Finance, PPM, SCM APIs and their linkages with the functional modules and front end functionality

I’m standing up a brand-new business-intelligence stack in Snowflake and need a reusable migration framework built with dbt and solid SQL. The framework has to pull from two kinds of sources—existing relational databases and the steady stream of CSV/Excel flat files our teams export—then land, cleanse, validate, and automate each load all the way into analytics-ready tables. Here’s what I’m after: • A dbt project structured for easy extension, complete with models, seeds, macros, and tests that enforce data-quality rules at every stage. • Parameterised SQL and Snowflake tasks/procedures that orchestrate fully automated loads, from raw landing zones through staging to final marts. • Built-in monitoring and reporting—leveraging dbt tes...

I need help moving structured information that currently sits inside a batch of Word files into my SQL database. Every document follows the same template—think headings like Name, Address, Reference ID, Dates, and a few numeric fields—so once you see one you’ll immediately understand the layout of the rest. The job is pure data extraction from documents. You’ll read each Word file, pull the fields exactly as they appear, and insert them into the SQL tables I’ll provide. I will supply: • a sample of the Word template • the SQL schema with column descriptions • a small set of completed rows so you can confirm formatting Accuracy is key; any typos or misplaced values will create reporting issues downstream. Please make sure each entry match...

I want to create a custom open AI like Claude, ChatGPT,Gemini etc so I can use for my internal use where I just need to upload customer documents and AI will give full 6-7 pages colurful report with our company logo with below mentioned details Loan eligibilty Details in Tabular Form in Tabular Form documents form Filling Details queries based on Past queried data

I want to create a custom open AI like Claude, ChatGPT,Gemini etc so I can use for my internal use where I just need to upload customer documents and AI will give full 6-7 pages colurful report with our company logo with below mentioned details Loan eligibilty Details in Tabular Form in Tabular Form documents form Filling Details queries based on Past queried data

I am setting up a streamlined system that records and stores personal data only—no financial or operational information is involved. The core deliverable is a lightweight, well-structured database (MySQL, PostgreSQL, or similar) paired with a clean interface where I can input, edit, and search individual records with ease. Key expectations: • Design the data model to capture standard personal fields (name, address, phone, email, ID number), leaving it flexible for future additions. • Build a simple, password-protected web form or desktop utility for CRUD operations. • Include basic reporting so I can export selected records to CSV or PDF and view simple statistics such as total entries and date-range counts. • Provide clear setup instructions and brief user...

Descripción Somos Bioluniel, una marca ecuatoriana de salud y bienestar. Vendemos mediante una red de médicos (prescripción o recomendación) y a través de puntos de venta (farmacias y distribuidores) en varias ciudades del país. Buscamos una persona en Ecuador con experiencia idealmente en clientes del sector salud (clínicas, consultorios, bienestar, farmacia, suplementos o productos terapéuticos). Muy importante: el trabajo de redes sociales debe realizarse de forma autónoma. Nosotros entregaremos el tema y el mensaje de cada publicación, pero la persona seleccionada deberá encargarse por completo de la creación, programación, publicación y seguimiento. Funciones principales (redes social...

I need a brand-new Microsoft Access file that lets our small church keep all giving information in one place. The database should open with a simple membership form where I can manually add or update each giver’s name, address and contact details. Every giver must have a unique ID so that offerings entered later will always link back to the correct person. A second form will record each offering. When I choose the member’s name, the form should automatically pull in their ID; I then select the fund from a drop-down list that starts with Tithe, Building Fund, Missions, Mercy Ministries and Other. I also need the option to add new fund names on the fly without touching the table design, plus a memo area for special notes. From these two tables I want to run three practical repo...

I need the full set of customer-related records lifted from my SQL database and dropped into a single worksheet that follows a template I’ll send you. The database holds tables for customers, payments, customer relations, sales and units. Your job is to write the necessary SQL (views, joins or stored procedures—whatever is most efficient), run it, and populate the template with: • each customer’s name and contact details • their complete purchase history and account status • the matching payment, sales and unit information Everything must end up in one sheet exactly where the template expects it, so column order and data types have to match. Once the file is filled, deliver it back together with the extraction script or query so I can repeat the proce...

Project Overview We have an existing Microsoft Access [Year2019/ 365] application currently split into a front-end and back-end. We need to migrate the back-end data to SQL Server Express to improve stability and multi-user performance. The front-end must remain in Access and be optimized to work efficiently with the new SQL back-end. Key Tasks & Responsibilities Database Migration: Upsize all tables from the Access .accdb/.mdb file to a SQL Server Express instance. Data Integrity: Ensure all primary keys, foreign keys, and relationships are correctly mapped and enforced in SQL Server. Table Linking: Use ODBC to link the Access front-end to the new SQL Server tables. Query Optimization: Identify and convert "heavy" Access queries into SQL Server Views or Stored Procedures...

I have an Access database for managing information about friends and relatives. I use this to automatically address snail mail for birthday cards & Christmas letters etc., generate monthly birthday lists, record gifts given, and various other things. It is not a particularly good design but it serves my purposes. I have developed a few queries to create address labels in various formats. The queries work fine for couples but it gets a bit tricky to NOT include a partner if they have passed on or separated etc. It is tricky because I want to keep the information about everybody even after they have passed, but I don't want to include their name when addressing a card or letter to the remaining partner. I would rather not re-write the database and am looking for someone to creat...

I need a comprehensive database project dedicated to the Beauceron dog breed. The goal is to provide the community with a reliable tool for pedigree tracking, health monitoring, and breeding management. Essential Requirements: - Integrated pedigree tracking and health monitoring - Automated Coefficient of Inbreeding (COI) calculations - Crowdsourced data input via online forms, with administrator validation Additional Features: - Lineage visualization - Genetic trait tracking - Historical pedigree reports Ideal Skills & Experience: - Database development and management - Experience with online form validation - Familiarity with canine genetics and pedigree systems - Strong UI/UX for community engagement

We have an MS Access application (connected to MS SQL Server) that has been developed over the last 8 years. We need an MS Access developer to add features and fix errors. It is used for reporting (predefined filters on tables), sending emails, generting printouts and recording data that our ERP is not flexible enough to accept. The application needs improvements in database design (table normalisation, indexes), bug fixes, removing dead code/reports/forms and adding new features.

Manejo diariamente grandes volúmenes de consultas de clientes; registro cada caso y luego lo sigo hasta su resolución. Para ello utilizo hojas de cálculo y una base de datos sencilla, pero el acceso se ha vuelto lento y está afectando mi productividad y la calidad del soporte que doy. Quiero que un especialista revise la estructura actual, identifique los cuellos de botella y diseñe una solución que acelere la búsqueda, carga y actualización de la información. No importa si la propuesta implica depurar las hojas de cálculo, normalizar tablas SQL, automatizar procesos con scripts o incluso migrar a otro motor: lo esencial es reducir drásticamente los tiempos de respuesta sin perder la trazabilidad de cada ticket d...

Saya membutuhkan pengembangan dashboard monitoring terpadu berbasis Apache Superset yang mencakup: • KPI Monitoring • Sales Reporting • Project Management Lingkup pekerjaan: 1. Melakukan URD (User Requirement Definition) singkat bersama saya untuk merumuskan skema data, alur kerja, serta estimasi durasi. 2. Menghubungkan Superset ke database existing dan, bila diperlukan, merancang database baru lengkap dengan aplikasi CRUD sederhana sebagai inputer. 3. Menyiapkan visualisasi prioritas berupa grafik batang, garis, dan pie, ditambah tabel ringkas serta tampilan dashboard interaktif agar data mudah dipantau real-time. 4. Menyusun permission, filter, dan slice sehingga setiap modul (KPI, Sales, Project) dapat diakses sesuai peran. 5. Menyerahkan dokumentasi s...

I need help moving structured information that currently sits inside a batch of Word files into my SQL database. Every document follows the same template—think headings like Name, Address, Reference ID, Dates, and a few numeric fields—so once you see one you’ll immediately understand the layout of the rest. The job is pure data extraction from documents. You’ll read each Word file, pull the fields exactly as they appear, and insert them into the SQL tables I’ll provide. I will supply: • a sample of the Word template • the SQL schema with column descriptions • a small set of completed rows so you can confirm formatting Accuracy is key; any typos or misplaced values will create reporting issues downstream. Please make sure each entry match...

I need an experienced Oracle-centric developer who is equally comfortable in Databricks SQL, MySQL, PostgreSQL, T-SQL and PL/SQL to move several production-grade data sets off Oracle 19c and make them run just as fast—if not faster—on each target platform. Here is what the engagement looks like in practical terms: • Data migration: extract with native Oracle utilities (Data Pump or equivalent), load into MySQL, PostgreSQL and Databricks SQL, and validate row-level parity. • Query optimization: review my current PL/SQL queries, reproduce them on each destination, then tune them until execution times meet or exceed the Oracle baseline. Please capture execution plans and explain any indexing or partitioning decisions. • Stored procedure development: rewrite ex...