SQL Jobs

Freelance BlueYonder WMS Developer (MOCA, SQL, Java) — End-to-End Ownership We’re looking for an experienced freelance or contract BlueYonder WMS Developer to take full ownership of customizing and enhancing warehouse transaction workflows. This is a hands-on role requiring someone who can independently design, implement, test, and support WMS logic in a live operational environment. This is not an integration-only role — the work is focused on modifying behavior inside WMS transactions, including allocation, picking, receiving, and putaway logic. Key Responsibilities Design and implement custom business logic directly within BlueYonder WMS using MOCA commands Extend and enhance existing transaction flows such as allocation, picking, receiving, and putaway Develop wrap...

### Project: Enterprise Data Warehouse & Analytics Optimization **Role:** Data Analyst **Project Overview:** Led the design and optimization of a scalable enterprise data warehouse and automated ETL workflows to enhance data accessibility and analytical efficiency for high-volume business datasets. **Key Contributions:** - Engineered **PLX-based ETL pipelines** to streamline ingestion and reduce turnaround time. - Automated query scripts, cutting data processing time by **50%** and accelerating insight delivery. - Unified multiple monthly data tables into integrated workflows, improving system efficiency. - Implemented **data quality frameworks**, reducing reporting errors by **90%**. - Collaborated cross-functionally to ensure data accuracy and actionable insights. ...

I need help to finish an Access database I've started for my dog boarding business. I will provide the database file and detailed written instructions. Key tasks include: - Data input forms - Reports generation - Query optimization Ideal skills and experience: - Proficiency in MS Access - Experience with database design and modification - Strong attention to detail - Ability to follow detailed written instructions

I’m putting together a comprehensive backtest that focuses exclusively on stock market data from the NYSE and NASDAQ, spanning the last 10 years. To do this effectively I need a well-structured historical dataset that I can drop straight into my models without hours of manual cleanup. Here’s what I’m after: • Daily (or finer) OHLCV prices, fully adjusted for corporate actions, splits, and dividends. • Consistent symbol mapping so delistings, mergers, and ticker changes don’t break the series. • A single, tidy delivery format—CSV files are fine, but a lightweight SQL or Parquet database also works if you prefer. • A short README that explains field definitions, adjustment methodology, and any known data caveats. If you already have a...

Both of my access-control platforms—System A (Suprema's Biostar X) and System B (dormakaba's Matrix Professional)—sit on the same Windows server and share a local MS SQL instance. Each exposes a REST API, yet today they operate in silos. I need a seamless, bi-directional integration so that any change to a person or employee record in one system is reflected in the other almost instantly. Scope of the sync • Core identity fields: name and unique ID • Credential data: RFID card number and state • Biometric assets: fingerprint templates • Media: profile picture • Security attributes: access-level permissions Key requirements 1. Real-time operation (sub-second latency acceptable). 2. Conflict-resolution logic—latest change...

We need an experienced Azure Data Engineer to design and implement robust data solutions on the Azure platform. You'll work on ETL processes, data analytics, and collaborate with cross-functional teams to deliver scalable data engineering solutions. Requirements: • Strong experience with Azure Data Factory (ADF) for ETL processes • Proficiency in Azure Databricks for advanced analytics • Hands-on experience with Azure Data Lake Storage (ADLS) • Experience with Azure Synapse Analytics for real-time analytics • Strong SQL skills for querying and database optimization • Python programming for scripting and automation • Experience with data modeling and data warehousing concepts • Excellent communication skills to work with stakeholders • Bach...

My PHP application is already online and fully connected to MySQL; it just needs a couple of light touches. In total I expect two-to-three quick updates, the most notable being the addition of a small feature that slots straight into the existing codebase. The other tweaks are straightforward logic or display adjustments—nothing structural, no schema changes, and certainly no rebuild. The code is plain PHP with direct SQL (no frameworks). A solid grasp of PHP, MySQL, and rapid debugging will let you dive in, trace the current flow, and wrap things up fast. Once we’ve talked through the exact lines to touch, I’ll share the repository and a database dump so you can run it locally. Deliverables • Updated PHP files with the new feature and minor fixes implemented &...

I need a centralized storage solution for structured data with defined access controls. The data should be accessible via direct database access. Requirements: - Design and implement a centralized database solution - Ensure secure, defined access to the data - Provide direct database access for querying Ideal Skills and Experience: - Expertise in database design and management - Experience with data access security - Proficiency in SQL and database querying

I need a seasoned Power BI developer to turn a very large, highly-granular data set into a single, dynamic dashboard focused on monitoring key operational-efficiency KPIs. Here’s the landscape you will step into: our raw information sits in both SQL databases and a series of regularly exported Excel/CSV files. I want a model that connects to each source, transforms the data so that it’s truly analysis-ready, and then visualises the metrics that matter—cycle times, throughput, bottleneck alerts, utilisation rates and any supporting drill-downs we decide to add. Scope of work • Build or optimise the data model, including merge logic between SQL and CSV tables, DAX measures, and relationships that guarantee a fast, responsive user experience even when the data vol...

I need a full-stack, self-hosted .NET solution that runs a 2 × 2 matrix MLM system. The site must let new members register under a sponsor, automatically position them in the chain, and reflect spill-over earnings in real time. Core roles are Standard user, Sponsor and Admin. A registered user should see a clean dashboard that shows an earnings overview, live balance details and a searchable transaction history. From that same panel they must be able to deposit, withdraw or transfer BEP20-based USDT, with each on-chain action recorded to the ledger and mirrored instantly in the database. The admin control panel must allow me to browse every account, approve or reject any pending deposit/withdraw request, modify wallet addresses if needed, and trigger manual payouts. Every sensitive...

Automated JIT POs Tracking System Development Our goal is for all last mile sites to achieve 95% receiving compliance, and to reach that target as quickly as possible. As an L4 on the GPCS-AMER team you are being assigned a task to create a tracking process for all unreceived JIT PO's 4 days past the need by date so they can be blind received in alignment with the AMZL_RACI_Final 3.0 task22. Goal: Create a mechanism/tool to alert our team on Monday-Wednesday of all overdue unreceived PO’s. This mechanism/tool should gather the unreceived PO’s, creating a list for the GPCS NIR team to receive. Objective Build a repeatable, automated mechanism (Mon–Wed) that: Identifies JIT POs ≥4 days past Need-By Date ...

Road Accident Analysis Dashboard | Power BI | DAX • Engineered an interactive Power BI dashboard tracking 5+ accident KPIs (severity, fatality rate, peak hours, high-risk zones) using DAX measures across a 12-month dataset. • Reduced insight discovery time by ~40% for stakeholders by replacing static reports with drill-down filters by location, vehicle type, and accident cause. • Applied DAX-based time intelligence to compare YoY fatality trends, revealing a 15% increase in night-time accidents that guided policy recommendations. AI-Enabled Multi-Disease Detection System | Machine Learning | Python • Built a multi-label ML classifier detecting Diabetes and Heart Disease with 87%+ accuracy using Logistic Regression and Random Forest on a 1,000+ patient d...

I’m building a new travel portal that should feel and flow almost exactly like Onetravel (about 90% of its current UX), but written end-to-end in .NET with Bootstrap so the layout stays fully responsive on every page. Core flow From Search → Listing → Detail → Add-On → Contact → Payment → Confirmation each module has to work seamlessly. For demo I need the Flight booking piece up and running before we expand to Hotel, Car, Bus and Holiday packages+ an Android app for the same Flight module must include • Search flights • Flight details page • Add-on services (bags, seats, meals, etc.) • Contact • Payment • Confimation page with Email to user • Data Saved on Google Sheets as Tables Under the hood • Mo...

Key Responsibilities Metrics Ownership Own end-to-end product metrics, including defining, tracking, and reporting. Set clear, measurable goals for product performance and monitor progress regularly. Build and maintain dashboards to ensure visibility of key metrics across stakeholders. Ensure consistency and accuracy in metric definitions and reporting standards. Understanding of User Behaviour & Journey Analyze user behavior across the product lifecycle to identify trends, patterns, and drop-offs. Map user journeys to uncover friction points and opportunities for improvement. Leverage both quantitative and qualitative data to derive actionable insights. Segment users to better understand different cohorts and their engagement patterns. Metrics Framework (North Star, L1, L2 Metrics) D...

My in-house ERP, built with PHP 8, Alpine JS, and htmx, has a data-processing fault: new or edited records are failing to persist to the database. The problem shows up only in two modules—Inventory Management and Financial Transactions—while all other areas work as expected. The core workflow: a user edits a record, htmx issues an async POST, the PHP controller validates and writes through an ORM to MySQL. The front-end confirms success, yet the row never appears (or reverts on refresh). No errors are thrown in the browser console, but MySQL slow-query logs stay clean, so I suspect a logic or transaction issue in the controller or model layer. I will grant repository access (Git) and a staging URL. The schema and seed data are documented in README. Deliverables • Di...

**Project Title:** Urgent Database Tutor Needed – Must Help Me Finish Everything in 2 Days **Project Description:** This project is **very urgent**. I need a highly qualified **database tutor** who can help me finish and understand **everything within 2 days**. I have a university Database course and I will provide the lecture files. I need someone who can work with me intensively and help me cover all the material quickly, clearly, and efficiently. **Topics included:** * ER diagrams and data modeling * business rules * entities, attributes, relationships * cardinality and constraints * strong and weak entities * associative entities * relational model and database constraints * keys, superkeys, candidate keys, primary keys, foreign keys * entity integrity and referential integr...

There is an extension for open card 2x, you need to convert it to open card 3.0.5.0. This is an extension for filtering auto parts by car model. It will also be necessary to link products by categories so that it works correctly

I need a full-stack, self-hosted .NET solution that runs a 2 × 2 matrix MLM system. The site must let new members register under a sponsor, automatically position them in the chain, and reflect spill-over earnings in real time. Core roles are Standard user, Sponsor and Admin. A registered user should see a clean dashboard that shows an earnings overview, live balance details and a searchable transaction history. From that same panel they must be able to deposit, withdraw or transfer BEP20-based USDT, with each on-chain action recorded to the ledger and mirrored instantly in the database. The admin control panel must allow me to browse every account, approve or reject any pending deposit/withdraw request, modify wallet addresses if needed, and trigger manual payouts. Every sensitive...

I’m looking for a reliable computer operator who can keep our day-to-day information flowing smoothly. Your core focus will be entering new database records with speed and accuracy, watching over system dashboards to catch issues before they turn into problems, and turning raw activity logs into clear, well-structured reports for management. You’ll work directly inside our database interface for record entry, using Notepad whenever you need a quick scratch-pad or to clean up text before pasting it into the system. While the data itself is structured, attention to detail is critical because any typo can ripple through multiple departments. On the monitoring side, I’ll count on you to keep an eye on resource usage, job queues, and error alerts, then note anything unusual s...

I’m in the start of a performance-focused data-migration effort that moves our current datasets into Snowflake, with Geneva and straight SQL powering the pipelines. To keep momentum, I need someone who can help on the hands-on analyst work while thinking like a Business Data Analyst. What I still have to finish centres on two areas: • Data extraction and transformation – mapping existing schemas, writing efficient SQL, and using Geneva/Snowflake utilities to cleanse and reshape data so downstream analytics run faster. • Data loading and validation – building repeatable load jobs into Snowflake, designing row-level and aggregate checks, and documenting reconciliation so stakeholders can trust the numbers. Acceptance criteria • Clean, reusable ETL scripts ...

look, this panel must be connected to zunga poker from fBk, this zunga poker texas holdem is on fb, I need a panel with whom when I enter the panel with my token or fBk password or user id, when I go to the panel and sit on the board the panel generates ds chips for me it takes from others or I don't know what, the panel must have options so that I can enter with 5-7-10 profiles if zslim, or if possible ds mi panel me generates chips, achieves a big level on profiles, takes all the rewards that zunga gives, it's even better, but I need a panel because there are people, you can see when you play that fo exist and people work with it, I need a panel to generate chips for any peofil on a saw who has an account, 10-20-30 profiles a day, I need a panel that generates chips for me, the...

We are looking for an experienced QGIS developer to implement a custom solution for QGIS Server. The goal is to make a custom WMS request parameter available inside the QGIS data provider layer (e.g. PostGIS) so that it can be directly used in SQL queries. Background: We are using QGIS Server to serve WMS layers backed by a PostGIS database. We need to dynamically filter or modify data at the database level based on parameters passed in the WMS request. Example: Incoming WMS request: ...&SERVICE=WMS&REQUEST=GetMap&MY_PARAM=123 Required functionality: Extract custom parameter (e.g. MY_PARAM) from the WMS request in QGIS Server Make this parameter available within the QGIS execution context Ensure the parameter can be used inside the data provider (PostgreSQL/PostGIS) Pass t...

I need a clear, data-driven report that lets me monitor how satisfied end users are with our IT help desk. The ticketing system already stores all the raw data; what I’m missing is a concise view that translates that data into actionable insights. The report must zero in on three satisfaction drivers: • Response time • Resolution quality • Agent professionalism I’m happy for you to work in the environment you’re most comfortable with—Excel, Power BI, Tableau or a direct SQL‐based dashboard are all acceptable—so long as the final output is easy for non-technical managers to read and refresh on demand. Trend charts, scorecards, and a short narrative summary will help leadership see at a glance where we’re excelling and where we n...

Senior Software Developer (Python, C++, SQL, AI Tasks) – Remote Access Work We are looking for an experienced Senior Software Developer with over 10 years of experience in Python, C++, and SQL, along with exposure to AI-related evaluation and coding tasks. Key Requirements: Strong expertise in Python, C++, and SQL Minimum 10+ years of professional experience Experience with AI/ML-related tasks or model evaluation workflows Ability to work on AI training, evaluation, and code refinement tasks Strong understanding of code refactoring and optimization Experience with GitHub and version control Familiarity with Docker and environment setup Experience with JSON and data parsing Strong debugging and problem-solving skills Comfortable working via remote access tools (TeamViewer / AnyDesk...

**Project Title:** Build or Source Comprehensive DVD / Blu-ray / CD / VHS Media Database (with API or Bulk Data) **Project Description:** I am building a private web-based media reference system (DVDs, Blu-rays, CDs, VHS) for use in my warehouse and purchasing workflow. The goal is to access or build a **comprehensive media database** that contains detailed information about physical media titles, ideally including and not limited to: * Movie / album title * Format (DVD, Blu-ray, CD, VHS) * Barcode (EAN/UPC) — very important * Release year * Genre * Region code (for DVDs/Blu-rays) * Video format (PAL / NTSC, etc.) * Country * Disc count (where applicable) --- **What I am looking for:** I am looking for someone who can help me with **one of the following (or a combination):** 1...

We are hiring an experienced Databricks Developer for support our data platform initiatives. This is a remote role aligned with US working hours. Location: Remote (Offshore – US Timings) Experience Required: 5+ Years (Data Engineering), 3+ Years (Databricks) Note: Budget is fixed. Please do not apply if you are looking to negotiate. Key Responsibilities Develop and optimize data pipelines using Databricks, PySpark, and Spark SQL Design and implement Delta Lake architecture (Bronze / Silver / Gold layers) Work on Lakehouse architecture and manage Unity Catalog Apply DataOps practices for scalable and reliable data workflows Optimize Spark jobs for performance and cost efficiency Required Skills Strong hands-on experience with Databricks Proficiency in PySpark and Spark SQL Experie...

I need a search facility integrated with a database. I'm open to recommendations on database type (SQL or NoSQL). Key Requirements: - Setting up a database (SQL/NoSQL) - Incorporating a search function - Ensuring efficient data retrieval Ideal Skills: - Database management expertise - Experience with search functionality implementation - Knowledge of both SQL and NoSQL databases Please provide your experience and any relevant projects. The database should be linked from our existing web site , be user friendly and linked to the current payment method that already exists. Must have at least 15 different fields as s earch facility.

I need a clean, fast-loading website for my automobile company built solely with HTML, CSS and vanilla JavaScript. The site’s main purpose is to turn visitors into qualified leads, so every page should guide users toward the contact form and telephone call-to-action without clutter. Overall look and feel I’m after an elegant, minimalistic layout: plenty of white space, concise copy blocks, subtle animations and a colour palette that keeps attention on the vehicles, not on decorative elements. Page structure & key content • Home – above-the-fold company introduction followed by a featured-products strip (image, brief spec, “Enquire” button) and a prominent lead form. • About – our story, values, team photo. • Product – g...

Necesito que diseñes y construyas una base de datos que me permita generar reportes de costos claros y rápidos. El foco está en tres componentes clave: • Costos fijos • Costos variables • Costos de producción Quiero que, con un par de clics, pueda descargar estos informes directamente en Excel con el formato listo para presentar. La solución debe: – Incluir un modelo de datos bien estructurado, fácil de mantener y de escalar. – Permitir la carga y actualización periódica de la información (idealmente mediante plantillas o importación masiva). – Automatizar la generación de reportes de costos en Excel, con filtros por periodo y centro de costos. – Venir acom...

I have an existing Microsoft SQL Server database and need clean, reliable queries that feed straight into polished paginated reports. Your focus will be data querying and reporting only—no schema redesign—using the two tools I already have in place: Power BI and SSRS. Here’s the flow I picture: you write or refine T-SQL to pull the right slices of data, build the dataset in SSRS, and then lay out the paginated report so it exports perfectly to PDF and Excel. Where interactive exploration is useful, a companion view in Power BI would be great, but the output I absolutely must have is a set of pixel-perfect paginated reports. Deliverables • Efficient T-SQL queries (stored procedures or views) that return the required fields • At least one SSRS .rdl file per ...

We’re seeking a skilled Laravel developer with strong SQL expertise to enhance our existing eVisa website. The site is fully built (source code provided), not from scratch—focus on development improvements for better UX, new features, and automation. Design tweaks (layout, images, fonts) are secondary but welcome if you’re skilled. Key Tasks (Priority: Development): • Add new country-specific forms. • Build beta AI chatbot for client form-filling via prompts and document uploads. • Enable adding admin users in the current dashboard. • Suggest and implement automation opportunities. • Integrate AI tools for automatic visa requirement updates (e.g., monitor country gov sites, no manual checks). Add chatbot that handles atleast 10 predefined user jou...

Descripción del Proyecto: Necesito un experto en Odoo para realizar un proceso de "limpieza profunda" y normalización en una base de datos Odoo Enterprise v17 alojada en Odoo.sh. El objetivo es eliminar las dependencias de código personalizado para migrar la base de datos al entorno SaaS (Odoo Online). Alcance del Trabajo: Extracción de Datos (Prioridad): Tarea: Identificar los campos personalizados creados por estos dos módulos. Exportar toda la información contenida en ellos (vía CSV/Excel) asegurando la trazabilidad con el ID externo de los registros originales (Pedidos de Venta y Tareas de FSM). Desinstalación de Módulos (Sin migrar lógica): Se deben desinstalar y eliminar por completo los siguientes m&oacu...

I need a fully dynamic tour-and-travel website coded in PHP (no WordPress or other CMS). Core pages and content include Home, About Us, Blog, Contact Us, plus dedicated sections for sightseeing tours, watersports activities, and the complete catalogue of tour packages. Each package should show details, images, pricing and allow a direct booking. Travellers must also be able to leave public reviews that appear under the relevant package. Behind the scenes I want a secure admin panel where I can: • add, edit or remove packages, activities and blog posts • confirm, cancel or export bookings • approve or delete customer reviews • update static page text and images without touching code Clean responsive design, modern UI, and well-structured code are essential. ...

Build a cross-platform desktop bot that uses computer vision (template matching) to automate web form filling and data scraping — controlled through a web-based dashboard, with no Selenium or browser drivers. We need a vision-based UI automation bot capable of navigating real browsers (Chrome, Firefox, Brave, Opera) installed on the user's machine. The bot will fill web forms and scrape report data using image-based template matching — no browser drivers or Selenium. A local web UI will serve as the control dashboard for operators to input data, monitor progress, and handle errors manually when needed. Core requirements 1. Cross-platform support Must run natively on Windows, Linux, and macOS without platform-specific hacks. 2. Native browser control Open and control the...

I’m looking to have a Python-based web application built that cleanly separates three user roles—admins, registered users, and guests—and persists all critical data in a relational database. Core requirements • Role logic: each role must see only the pages, actions, and navigation appropriate to it. Admins manage content and users, registered users access their personal dashboards, and guests can browse a limited public area. • Database integration: the app should read from and write to a robust SQL back-end (PostgreSQL or MySQL are both fine). All authentication, session data, and domain objects need to live there. • Clean, modern framework: Django is my first choice because of its built-in auth system and admin panel, but I’m open to Flask ...

I’m looking for someone who can turn our raw internal database records into forward-looking insights. The data is already well-structured in SQL tables; what I need now is a predictive layer that helps us forecast key metrics and identify the drivers behind them. You’ll have direct read-only access to the relevant tables along with a short data dictionary. From there, please choose the techniques and tools you’re most comfortable with—whether that’s Python (pandas, scikit-learn), R, or another established machine-learning framework—so long as the final model is reproducible and the code is clearly documented. The deliverable I expect is a concise notebook or script that: • cleans and preps the data, • trains and validates at least one...

Job Post: E-commerce Financial Systems Architect We are looking for an experienced professional to help design and implement a complete financial tracking and profit analysis system for our marketplace business. Key Responsibilities: Map all financial touchpoints (charges & credits) across the order lifecycle Develop a system to link supplier invoices with marketplace order IDs Calculate net profit per unit accurately Create a clear “Data Entry Guide” for non-technical staff Design a clean, scalable data schema (single-line item structure) Set up alerts for critical events (e.g., high return costs) Train team members on the new system and processes Ideal Candidate: Experience in e-commerce operations / marketplace accounting Strong skills in data structuring, Excel/Googl...

I need a clean, well-structured RESTful API that talks directly to a SQL backend (MySQL or PostgreSQL—happy to choose whichever fits your stack best). The job is straightforward: design and build the endpoints, wire them up to the database, and return predictable JSON responses. The API must cover CRUD operations, include basic token-based authentication, and come with concise Swagger/OpenAPI documentation so I can hand it to front-end devs without extra explanation. Please pay attention to performance (proper indexing, pagination, sensible error handling) and keep the codebase organized for easy future extension. Deliverables • Source code with clear project structure • SQL migration/seed scripts • Postman or curl examples for every endpoint • Swagger/O...

Description: I am building a research-based job market analytics system (US market) and need an experienced Python/NLP developer to help complete it end-to-end. Scope of Work: The project includes: • Data processing of large job datasets (10k-50k+ rows) • Extracting technical skills (Python, SQL, AWS, etc.) from job descriptions • Salary analysis and estimation (with validation using official BLS data) • Job demand trend analysis and forecasting • Building an interactive dashboard (Streamlit preferred) • Supporting research experiments and evaluation Research Requirements (Very Important): You must work on all 3: 1. Skill Extraction Reliability • Extract skills from job descriptions • Compare multiple methods • Evaluate (precision, recal...

Project Overview We are building an analytics module for an industrial tracking system (SINTRA). The system tracks assets (e.g. pallets) using smartphone-based 3D positioning (X, Y, Z). We already collect high-frequency data (time-series in InfluxDB). Goal: Build a Stability Analysis Dashboard to evaluate: data quality tracking stability device & zone performance detection issues ⚠️ Important Architecture (Must Follow) This project has a strict split: Backend / ETL (YOU BUILD) all calculations (jitter, jumps, gaps) scoring (0–100) classification (GREEN / YELLOW / RED) aggregations (1 min, 5 min, etc.) Grafana (YOU BUILD) dashboards charts tables filters alerts ❗ No business logic in Grafana ScopeETL / Backend process time-series data (x, y, z, timestamp) calculate: jitt...