SQL Jobs

There was a compromised file uploaded to my fivem server accidentally by one of my devs. After some careful digging we believe we've identified the source of the infection, and removed any signs of the spread it caused. (It had been appending code to files automatically. said code and js files were removed.) However now the server itself almost fully launches, but at the very end experiences some sort of sigsev crash error, creates a dump file, and then starts over ad infinitum. We've already tried updating to current artifacts, and reverting to older ones, nothing seems to work for that. We're seeking a developer who can come in, identify the issues with the crash, and maintain the root server files to the best of their ability to save us the hassle of needing to reasse...

# Data Engineer / Web Scraping Specialist — Luxury Asset Price Index (Watches, Handbags, Prints) — 10-Year Historical Dataset + Ongoing Pipeline ## Overview I run a luxury-asset price index project. I need help sourcing **transaction-level historical price data** across **three independent categories**: Few exemples : 1. **Watches** — Rolex, Patek Philippe, Audemars Piguet, Omega, Cartier, Vacheron Constantin, Richard Mille, etc. 2. **Handbags** — Hermès (Birkin / Kelly), Chanel (Classic Flap), Louis Vuitton, Dior, etc. 3. **Prints / editions** — Picasso, Warhol, Chagall, Miró, Basquiat, Hockney, Banksy, etc. Each category is a **separate dataset** feeding a separate database table. I also need a **system that keeps pulling new completed sales...

I need an end-to-end software solution built around a robust SQL datastore that can scale as our records grow. The application should streamline the way we collect, process, and act on information so my team no longer wastes hours on repetitive work. At a minimum the system must: • Automate data entry from multiple sources (CSV uploads, web forms, and future API feeds) while validating formats and catching duplicates in real time. • Generate scheduled and on-demand reports—both summary dashboards and exportable PDFs/Excel—so stakeholders always have up-to-date metrics. • Trigger notifications by email, SMS, or in-app alerts when configurable thresholds or events occur. • Remain flexible for “more” automation tasks we will define together ...

Need an SAP & AI consultant to build a Pharma Process Intelligence PoC. Details We're looking for an experienced freelancer to build an AI-powered Process Intelligence PoC for pharmaceutical manufacturing. The project involves analyzing SAP manufacturing and quality data to identify process bottlenecks, delays, rework, and KPI gaps. The solution should include process analytics, KPI dashboards, conversational AI/Copilot, and actionable improvement recommendations. Preferred skills: SAP PP/QM * Process Mining (Celonis or similar) * Python, SQL * Power BI * AI/LLMs (Azure OpenAI, LangChain, RAG) * Pharma Manufacturing, GMP, ICH Q9/Q10 * Dashboard & analytics development This is an hourly remote engagement with the potential for a longer-term collaboration. Deliverables ...

I already have a fully-populated Oracle database and need a graph model built on top of it so I can run trend analysis directly inside Oracle. The job involves identifying the right tables and relationships, turning them into graph nodes and edges (using Oracle PGX/Spatial & Graph or a comparable built-in graph option), and delivering a working graph schema that lets me query trends with Cypher-like or SQL/PGQL syntax. What I expect from you: • An initial review of the existing schema to decide which entities should become vertices and which links should become edges. • Creation of the graph inside my Oracle instance, including any necessary property calculations or aggregations to support time-series trend queries. • A short set of sample queries that demonstrate...

Our in-house safety management platform—built with ASP.NET MVC, C#, SQL Server, JavaScript, jQuery, HTML, and CSS—needs a focused update across three core modules: Hazard, Incident, and Risk Management. I have several clear goals for this round of work: streamline navigation, cut page load times, and refresh the UI so day-to-day users can move through tasks without friction. Beyond the usability lift, I also want to expand functionality: • Reporting tools that turn stored data into exportable, filterable dashboards. • A real-time notification system that pushes email and in-app alerts as events occur. • Granular user-role management so access rights map neatly to each site, region, and job title. Under the hood, you’ll likely touch existing CRUD oper...

Our manufacturing arm captures plenty of shop-floor and ERP data, yet most of it sits unused. I want that information converted into a clear story focused on operational efficiency. The core of the assignment is to analyse our manufacturing data and surface three critical metrics—production yield, machine downtime, and inventory levels—within an intuitive management dashboard. Here is how I see the flow of work: • Data preparation: connect to and clean raw production logs, maintenance records, and stock files (SQL, Excel, or CSV). • Modelling & analysis: calculate run-rate KPIs, variance against targets, and trend lines that highlight bottlenecks. • Visual delivery: build an interactive dashboard (Power BI, Tableau, or a similarly robust tool) that ex...

I need an end-to-end software solution built around a robust SQL datastore that can scale as our records grow. The application should streamline the way we collect, process, and act on information so my team no longer wastes hours on repetitive work. At a minimum the system must: • Automate data entry from multiple sources (CSV uploads, web forms, and future API feeds) while validating formats and catching duplicates in real time. • Generate scheduled and on-demand reports—both summary dashboards and exportable PDFs/Excel—so stakeholders always have up-to-date metrics. • Trigger notifications by email, SMS, or in-app alerts when configurable thresholds or events occur. • Remain flexible for “more” automation tasks we will define together ...

We are looking for an experienced Java Full Stack Developer to build a modern, scalable, and secure e-commerce website from scratch. The ideal candidate should have strong experience in Java-based web application development and be capable of handling both frontend and backend development. Project Scope The website should include: User registration and login with secure authentication Product catalog with categories and search functionality Product details pages Shopping cart and wishlist Secure checkout process Payment gateway integration Order management and order history Admin dashboard to manage products, inventory, orders, customers, and promotions Responsive design for desktop, tablet, and mobile SEO-friendly architecture Email notifications for orders and account activities Tech...

Necesito llevar mi base de datos histórica en SQL Server al siguiente nivel: quiero que cualquier usuario pueda escribir preguntas en español (p. ej. “¿Cuántas órdenes se enviaron ayer a México?”) y que ChatGPT o Gemini traduzca esa solicitud a SQL de forma segura y eficiente. El objetivo final es eliminar los reportes manuales en Excel y sustituirlos por un panel interactivo que muestre la información en tiempo real. Por eso busco a alguien con experiencia comprobable en: • Integrar LLMs (ChatGPT 4 o Gemini) con SQL Server mediante text-to-SQL, cuidando performance y exactitud de las consultas. • Desarrollar un backend robusto en Python, .NET o la tecnología que mejor garantice seguridad, cifrado en tr&aac...

Executive Power BI Project Report

I have outlined a complete concept for a lightweight handyman-management plugin aimed at hotels and similar properties. Everything—flows, fields, and screen mock-ups—is documented here: Core objectives • Build the solution as a WordPress plugin that relies on Advanced Custom Fields Pro for flexible data entry. • Optimise every screen for mobile so hotel staff can open it on a phone or small tablet and act quickly. Key features to implement • Task scheduling: create, assign, and calendar jobs directly from the dashboard. • Real-time worker tracking: each maintenance crew member can update status (“in progress”, “waiting parts”, “done”) and clock time spent. • Task categories limited to maintenance reque...

I need a well-structured SQL database that turns raw sales transactions into clear insight for our monthly analytics and reporting. The core job is to design the schema, import existing sales data, and build the queries (or stored procedures) that generate our standard monthly sales report with totals, trends, and key breakdowns. Right now the data lives in CSV exports from our point-of-sale system. I want it migrated into a relational database—engine choice is open (PostgreSQL, MySQL, MS SQL, or another you recommend) as long as it handles growth and lets me run additional ad-hoc reports later. Good indexing and normalization are essential because report runs must stay quick when the dataset scales. Deliverables: • SQL scripts for creating all tables, constraints, and index...

I’m upgrading my accounting workflow and want to push Tally to its full potential. Your job is three-fold: build custom reports that give me the exact business insights I need, hook Tally up to at least one external platform, and migrate our historical data without a hitch. Here’s what success looks like for me: • Custom report generation – user-friendly layouts, drill-downs, and the option to export to standard formats. • Integration with other software – I’m open to linking a CRM, e-commerce, or full ERP system; we’ll choose the most valuable connection together and make data flow in real time. • Data migration – every transaction, ledger, and master record comes across intact, validated, and ready for day-to-day use. I&rsq...

I'm looking for a skilled Python data engineer to help with several data processing tasks. The data is primarily sourced from procurement websites. Key Responsibilities: - Data cleaning and transformation - Integration of data from multiple sources - Building robust data pipelines Specific transformations required: - Data formatting - Data enrichment - Data aggregation Ideal Skills and Experience: - Proficiency in Python and data engineering tools - Experience with SQL databases, APIs, and CSV/Excel files - Strong background in data cleaning, transformation, and pipeline construction - Familiarity with procurement data is a plus Looking for someone who can efficiently handle complex data tasks and deliver clean, integrated datasets. In-house job in Kolkata preferred

# Inventory Management System Development of a complete web-based Inventory Management System designed to simplify stock control and improve business operations. The application enables users to manage products, suppliers, and categories while tracking stock movements in real time, ensuring accurate inventory records. The system includes secure user authentication, role-based access control, advanced search and filtering, an interactive dashboard with key performance indicators, detailed reports, and a complete history of inventory transactions. Its responsive and user-friendly interface provides a seamless experience across desktop and mobile devices. **Key Features:** * Product, category, and supplier management * Stock entry, withdrawal, and real-time inventory tracking * Advanced s...

Our job portal’s search results page is being dragged down by slow data retrieval, and it’s directly affecting the overall speed and load time of the site. I need someone who can dive in, pinpoint the bottlenecks, and deliver measurable gains without disrupting existing features. Here’s how I see the engagement: • Analyse current queries, API calls, and any middleware that sits between the database and the front-end to uncover why the data feed to the search results is sluggish. • Optimise what you find—whether that means rewriting SQL, adding smart indexing, implementing server-side caching, or fine-tuning backend code. • Validate improvements with before-and-after metrics: Time To First Byte, total page load, and server response time for typic...

Access-to-SQL-Server Migration — Experienced Developer Needed (Paid Assessment First) We run a business ERP built in Microsoft Access (front-end / back-end split, ~40 users). We are looking for an experienced developer to move the data (the Access back-end tables) onto Microsoft SQL Server, while keeping our Access forms as the user interface. The database is small (~300 MB of tables). This project is a short PAID ASSESSMENT — not the full migration. Before committing, we want you to review our system and tell us whether the migration is worthwhile, what it involves, and how many hours it would take. The full migration would be a separate engagement afterwards, only if we decide to proceed. Requirement — proven migration experience We will only consider developers who hav...

Excited to share my latest Starbucks Sales Dashboard built using Power BI, Excel, SQL, and DAX. This interactive dashboard provides valuable business insights into sales performance, product trends, customer behavior, and store profitability. It enables decision-makers to monitor KPIs, identify top-performing products, analyze monthly revenue, and optimize business strategies with real-time visual analytics. The Starbucks Sales Dashboard is a professional Business Intelligence solution designed to analyze and visualize Starbucks sales data. It transforms raw business data into meaningful insights through interactive charts, KPI cards, filters, and dynamic reports. The dashboard helps stakeholders understand sales trends, customer purchasing patterns, product performance, regional sales, a...

I run several production workloads on Oracle 19c and need an expert DBA who can handle three core activities for me around the clock: building new databases from scratch, tuning performance on existing instances, and carrying out version or patch upgrades without downtime to the business. Here is what I expect from you: • Database creation – end-to-end installation and configuration of fresh Oracle 19c environments, including listener setup, tablespaces, and all basic security hardening. • Performance tuning – proactive monitoring and remediation using AWR/ASH reports, SQL Tuning Advisor, indexing strategies, and statistics management to keep response times low. • Upgrade & patching – planning and executing PSU/RU installs or full-version upgrades...

I need an end-to-end AI solution that lets a runway-patrol drone spot even the tiniest foreign object debris (FOD) in real time. The airframe already carries LiDAR, an infrared sensor and an electro-optical (EO) camera; what is missing is the software that fuses those feeds, classifies debris and reports exact GPS position so ground crews can clear it fast. Scope of detection • Metallic pieces, plastic fragments and loose stones—down to roughly 1 mm in size. • Operation must be reliable in both daylight and nighttime conditions. • Accuracy target is set to a high threshold; false positives have to stay low while recall stays near perfect. Key tasks 1. Build or adapt a multi-sensor fusion pipeline that consumes LiDAR point clouds, IR imagery and EO frames. 2...

Looking for an Experienced Data Engineer Project Description I am looking for a skilled Data Engineer to help design, build, and maintain reliable data pipelines and infrastructure. The work may include collecting data from different sources, cleaning and transforming it, and storing it in a database or data warehouse. You may also work with APIs, cloud services, ETL workflows, and large datasets. The ideal candidate should have strong experience with Python, SQL, data modeling, and ETL/ELT pipelines. Experience with AWS, GCP, or Azure is preferred. Knowledge of tools such as Airflow, Spark, Kafka, Snowflake, BigQuery, or Databricks would be a plus. Please include the following in your proposal: A short introduction about your Data Engineering experience Examples of similar projects ...

Overview: We are looking for an experienced Backend Developer / Systems Integrator to set up and configure a local MCP (Model Context Protocol) Server on a dedicated Windows PC. The goal is to bridge our local, on-premise SQL Database with AI tools (such as Microsoft Copilot, Claude Desktop, or Cursor) so we can query our database securely using natural language. Remote Access & Working Method (Important): Full Remote PC Access Provided: You will be given direct remote desktop access to our dedicated Windows PC using AnyDesk, TeamViewer, or UltraViewer to perform the entire installation and configuration. Database Access: We will provide you with a secure, Read-Only SQL credential strictly for testing the database connectivity from the MCP server. Technical Environment: Host OS: D...

I’m looking for a seasoned database administrator to take charge of our SQL Server environment for a Bank of India–related platform. The immediate focus is on keeping the core banking data layer fast, resilient, and secure. Here’s what the assignment covers: • Database optimisation – analyse slow queries, tune indexes, and improve overall throughput without disrupting live operations. • Backup & recovery – design and automate point-in-time backups, test restores regularly, and document the full recovery strategy. • Security management – harden user roles, apply the latest patches, set up auditing, and make sure compliance standards are met. You’ll be handed full access to a staging instance first, followed by production onc...

Swiggy Sales Data Analysis Analyzed a large Swiggy orders dataset (196K+ records) using SQL and Python. Performed data cleaning, handled missing values and outliers, and conducted exploratory data analysis to identify sales trends, customer behavior, restaurant performance, and order patterns. Created visualizations and generated actionable business insights to support data-driven decision-making. Blinkit Sales Dashboard (Power BI) Designed an interactive Power BI dashboard to analyze sales performance, product categories, outlet performance, and customer purchasing trends. Used Power Query for data transformation and DAX measures to calculate KPIs, enabling stakeholders to monitor business performance effectively. Used Car Price Prediction Built a machine learning regression model in Pyth...