SQL Jobs

I have a dataset that is growing quickly and a business case ready for machine-learning insights. What I need now is someone who can take the project from raw data all the way to a production-ready model: that means designing the data pipeline, choosing and training the model, fine-tuning for accuracy and latency, then packaging everything for a reliable, scalable deployment. Here is what success looks like for me: • A repeatable pipeline (Python, SQL, Airflow or equivalent) that ingests the source data, performs cleaning / feature engineering, and stores curated tables. • Well-documented training notebooks or scripts using standard frameworks (scikit-learn, TensorFlow or PyTorch) together with clear evaluation reports. • Fine-tuning that pushes performance to an agr...

I want to streamline the way we handle data entry and ongoing data management within Embark Insurance Brokers Pvt Ltd by introducing a robust robotic process automation (RPA) solution. Right now, large volumes of policy information reach us in mixed formats, and too much of our team’s time is spent on repetitive copy-paste, validation, and database updates. Your mandate is to analyse these operational processes, design an automated workflow, and deploy an RPA bot that performs the data capture, cleansing, and upload steps with minimal human intervention. If you prefer UiPath, Power Automate, Blue Prism, or another enterprise-grade toolset, let me know—what matters most is accuracy, auditability, and ease of maintenance for our in-house IT staff. Key deliverables • Pr...

StepWise / .NET Job Support Expert (REST/SOAP APIs | SQL | Excel) We are looking for an experienced professional to provide **real-time job support** for a StepWise Developer role (Optum platform / .NET ecosystem). Role Type: * Remote job support (1–2 hours daily) * Live sessions via Google Meet * Long-term engagement Required Skills: * Microsoft .NET / ASP.NET * StepWise platform (or similar workflow/rating systems) * REST & SOAP APIs * SQL Server (queries, database handling) * Advanced Excel (formulas, data handling) * Experience with enterprise application support Responsibilities: * Provide live troubleshooting support * Assist in debugging real-time issues * Help with workflow automation and integrations * Guide through complex logic and system behavior Engagement...

I have an existing Oracle Forms 4.5 application running in a legacy environment, but the code that previously opened a session against our Oracle 8 instance no longer works on the current machines. All objects—tables, views, and stored procedures—are already in place; I only need a clean, reliable way for the form to open a connection and read data from those objects. What I need from you • A PL/SQL or built-in Forms code snippet (PRE-FORM trigger, WHEN-NEW-FORM-INSTANCE block, or another appropriate hook) that establishes the session with Oracle 8. • A brief example SELECT that proves the connection by returning a row to the form. • Short notes explaining any environment variables, entries, or FORMS45_PATH settings required so I can replicate the setup o...

We brought in this developer to debug a production RAG pipeline that had quietly degraded after a dependency bump. The pipeline — built on LangChain, FastAPI, and Supabase pgvector — was still returning results, but retrieval quality had clearly dropped: wrong chunks, wrong document sections, irrelevant context making it into answers. The scope was well-defined: audit our chunking config, confirm embedding model consistency between ingestion and query time, check our pgvector distance/index setup, and run live test queries to surface exactly where retrieval was going wrong. He delivered on every point. The root cause turned out to be a silent embedding model mismatch introduced during a langchain-openai upgrade — something easy to miss and painful to debug without knowin...

We are looking for an experienced ERP Functional Tester to test our cloud-based ERP system (CloudBizERP), covering Inventory, Procurement, Sales/CRM, HR & Payroll, and Finance integrations. The ERP Functional Tester is responsible for validating end-to-end business processes within the ERP system to ensure that all functional requirements are met. The role involves working closely with business stakeholders, developers, and project teams to ensure high-quality delivery of ERP modules. Key Responsibilities Analyze business requirements and functional specifications Design and execute test cases for ERP modules (Accounts, Inventory, Procurement, Sales, HR) Perform functional, integration, and regression testing Validate end-to-end business processes (Procure-to-Pay (P2P), Order-to-Cash ...

We are looking for an experienced Palantir Foundry Developer to support data and AI use cases. Scope of Work: * Build and maintain Foundry data pipelines (Pipeline Builder, Transforms) * Work with Ontology (object types, link types, data modeling) * Develop Workshop applications for business users * Implement AIP Logic workflows and basic agent integrations * Write production-quality Python, SQL, and PySpark code Requirements: * Hands-on experience with Palantir Foundry (mandatory) * Strong skills in Python, SQL, and PySpark * Experience with Ontology, Pipelines, and Workshop * Basic understanding of AIP (preferred) Project Details: * Budget: ₹45,000+(Negotiable) * Location: India

We are a liquor retail business based in Goa, looking to implement ERPNext with POS (Sunmi T2s device). We are hiring a hands-on freelancer with strong functional + technical expertise to work closely with us (remote + occasional on-site) and execute a complete ERPNext implementation. Scope of Work: • Understand current billing, inventory, and taxation workflows (including Goa liquor VAT/excise) • Setup ERPNext (Company, COA, Items, Warehouse, POS) • Configure GST + VAT/excise correctly for liquor sales • Setup POS (Sunmi device + ERPNext POS / TailPOS if required) • Import sample/test data • End-to-end testing (billing, returns, stock, reports) • Staff training for daily operations • Go-live support + stabilization Approach: Keep system simple at...

I have a working-but-fragile Chrome extension that crawls pages and “dorks” (niche search queries) looking for HTTP API tokens that match a specific regex. The job is twofold: 1. Repair and streamline the current codebase so the scanner reliably captures and locally stores every hit. Right now it sporadically misses matches and sometimes stops writing to storage. 2. Enrich the detection logic with fresh, private dorks and widen the sweep to cover the full set of indicators I care about: Keywords, Phrases, API endpoints, HTTP API strings and any related variations you can dream up. The flow I picture: • Content script injects, scans DOM + network responses in real time. • Regex engine identifies tokens, deduplicates them and saves to local storage / optional we...

I’m looking for ongoing help keeping my Espo CRM instance running smoothly on a Windows server. The main things I need handled are: • Performing regular software updates and full-system backups so I always have a reliable restore point • Troubleshooting and resolving any technical issues that crop up, whether they’re performance slow-downs, error messages, or connectivity problems • Customizing server settings—tuning IIS, PHP, database parameters, and security configurations—to match Espo CRM best practices and my team’s workflow Maintenance can be scheduled anytime; I’m flexible as long as downtime is kept to a minimum and communicated in advance. Familiarity with Windows Server administration, SQL databases, and Espo CRM internals ...

I’m sitting on a sizeable pool of customer data and need clear, actionable insight into why clients stay—or slip away—so I can sharpen our overall experience. The single metric I care about right now is retention rate; every query, chart, and model should trace back to that outcome. Here’s how I picture the engagement: • Clean and consolidate the raw customer datasets I’ll supply (CSV and database exports). • Run the exploratory analysis and segmentation needed to surface churn-related patterns. • Build predictive or descriptive models—whichever proves most reliable—to highlight the moments of greatest attrition risk. • Present findings in a concise slide deck plus an interactive dashboard (Python, SQL, Tableau or Power ...

I have a set of raw transactional records sitting in several CSV files. I need them imported into Power BI, cleaned, and reshaped into a star-style model. The core relationships I must see are Customer → Orders and Region → Revenue; anything else you add for best practice is welcome provided it remains documented. Once the model is in place, create DAX measures for: • Total revenue • Number of orders • Distinct customers • Return rate With those measures, build visuals that show: • Revenue distribution by region • Seasonal revenue patterns (month and quarter) • Any revenue-concentration risk—e.g., regions or customers that contribute a disproportionate share • Key performance trends over time I will consider the job c...

Project brief We need an experienced database migration specialist to migrate a standalone Microsoft SQL Server database to a standalone PostgreSQL database on Linux. The database is approximately 4 GB, and the scope includes schema, data, indexes, constraints, views, and any required compatibility fixes. Scope of work Assess the source standalone SQL Server database and identify dependencies. Migrate tables and data to standalone PostgreSQL. Convert indexes, primary keys, foreign keys, and constraints. Convert views and other supported database objects. Identify and rewrite incompatible SQL Server-specific logic where required. Test data integrity, row counts, and key queries. Support final handover with scripts and documentation. Deliverables Migration assessment and approach document....

I need a compact module that connects to my SQL Server database, fetches raw attendance data, and delivers a clean report that mirrors the sample layout I will share. Two filters must work flawlessly and in combination: date-wise and employee-wise—both hold equal weight for daily use. Any duplicate rows you encounter should be excluded before the data reaches the final grid or export. My preference is an ASP.NET / C# backend, though you’re free to craft the stored procedures as you see fit. Once the dataset is shaped, the user should be able to export the report to both Excel and PDF with a single click, keeping the exact formatting intact (headers, column order, totals, page breaks). Deliverables I expect: • A ready-to-run report with source code • Brief setup no...

Sempre quis ter meu próprio servidor de San Andreas Multiplayer e agora finalmente tenho tempo para dedicar a isso. Procuro alguém que desenvolva do zero (em Pawn) um gamemode Roleplay bem estruturado, pronto para rodar em hosting comum e fácil de manter. O que preciso ver no pacote: • Sistema de empregos robusto (alta prioridade) • Sistema de famílias/clãs integrado (alta prioridade) • Sistema de polícias e ladrões separado dos empregos (alta prioridade) • Sistema de casas com compra, venda e cofre • Sistema de veículos com garagem e combustível • Sistema de fome e necessidades básicas • Hierarquia de staff: moderador, supervisor e níveis acima • Comandos de ...

I have a comprehensive export of our task data and individual performance logs that need to be turned into clear, actionable insight. The core of the job is to examine task completion rates and highlight how closely we stick to the original schedule—
specifically a side-by-side comparison of planned versus actual completion dates. I also want to see how each employee’s performance influences those results so we can recognise top contributors and spot recurring bottlenecks. You’ll receive: • CSV exports from our project-management tool (tasks with planned and actual dates, assignee, status) • A simple employee-performance file with monthly ratings and role details What I need back: • Cleaned, well-structured datasets (ready for future reuse) &bul...

Opis projektu: Poszukuję doświadczonego freelancera do przeprowadzenia pełnej migracji sklepu internetowego z platformy RedCart na platformę PrestaShop. Zakres prac: Migracja ma być przeprowadzona najpierw w środowisku testowym. Przeniesienie całej bazy danych z zachowaniem struktury Przeniesienie dostawców, producentów, magazynów, stron informacyjnych, szablonów produktów Przeniesienie wszystkich produktów: Wszystkich danych takich jak nazwa produktu, waga, producent, dostawca, kod kreskowy, kod u dostawcy, ceny netto, brutto zakupu, ceny netto brutto sprzedaży, zdjęcia oraz opis zdjęć, przypisanie do kategorii jaka w sklepie, krótki opis produktu, długi opis produktu, opcje do produktu, magazyn stany, słowa kluczowe do wyszukiwarki, seo :...

I’m looking for an experienced ethical hacker who can also roll up their sleeves and work directly on the codebase. Your first priority will be to probe our existing applications and utilities for security weaknesses, then patch or refactor the vulnerable components yourself. You will work from user stories and specs that I provide, translating them into secure, efficient software. Day-to-day you’ll be analysing requirements, recommending upgrades, collaborating with the rest of the dev team, and documenting everything—from flowcharts and user guides to the exact remediation steps you take. Routine maintenance and performance tuning are part of the remit as well. A solid command of Java and Python is essential, and you should feel at home in relational databases lik...

This is a structured research and data entry project involving the review of established medical guidelines and the construction of standardized content entries based on those sources. Work will be completed using a detailed instruction manual, predefined formats, and example outputs to ensure consistency and accuracy. The role requires strong attention to detail, the ability to follow exact instructions, and comfort working with structured information. Modern tools may be used to support research and organization, but all final content must be carefully reviewed and aligned with source material. • Strong attention to detail • Experience with research and information synthesis • Ability to follow precise written instructions • Comfort working with structured data and te...

Looking for SQL expert who has experience with the stored procedures to debug and fix the errors

Sou profissional sênior de Tecnologia da Informação com mais de 14 anos de experiência, especializado em Engenharia e Arquitetura de Dados. Ao longo da minha carreira, atuei na estruturação e modernização de ambientes de dados, sempre com foco em performance, escalabilidade e geração de valor para o negócio. Tenho forte experiência com SQL Server, Oracle e MySQL, além de atuação sólida em processos de ETL/ELT com Pentaho e desenvolvimento de dashboards estratégicos em Power BI. Também possuo conhecimentos em Azure e venho evoluindo em tecnologias modernas como Databricks e arquitetura de dados em nuvem. Na Accenture, liderei iniciativas de otimização de p...

Thousands of lines of T-SQL that once worked are now returning incorrect results. I need a fresh set of expert eyes to comb through the entire script, pinpoint exactly where the logic breaks down, and fix it. The code lives in SQL Server. While you work through the main script, I also need you to cascade several hundred new parameters into a series of dependent stored procedures. These procedures already compile; they simply require the additional parameters to be wired through correctly so downstream calculations stay consistent. What I expect from you: • A clean, corrected version of the original query and any touched procedures • A concise change log explaining the root cause of the logical error and how you resolved it • Updated stored procedures with the new param...

I have been running my numbers in spreadsheets for far too long and now need a properly structured Microsoft Access solution. The goal is to design and optimise a database whose sole focus is managing financial data—specifically our invoices and billing records. Here is what I need from you: • A relational schema that keeps the tables normalised, eliminates duplicate data, and supports growth. • Intuitive forms for entering new invoices, applying payments, and updating client details without exposing raw tables. • Parameter-driven queries and summary reports that let me filter by client, date range, paid / outstanding status, and export cleanly to Excel or PDF. • Thoughtful use of indexes, validation rules, and VBA where necessary so the system stays fast ...

We are looking for an experienced data analyst / developer to help us build a visual dashboard for inventory and sales performance, based on data from Loyverse POS (Back Office + API). Our company operates multiple retail stores (costume jewelry), and we need a reliable system to monitor stock, sales trends, and optimize purchasing decisions. Current Situation (Manual Process): At the moment, we rely on manual exports from Loyverse: • Export of current stock data (with unique SKU per product) • Export of sales data over a selected period (e.g., 30 days) • Calculation of average sales per product: Average Daily Sales = Quantity Sold / Number of Days Limitation: This method does not account for out-of-stock periods, which leads to inaccurate sales averages and poor resto...

I need a production-floor MIS dashboard built in Power BI that lets our garment-manufacturing managers see every line’s output and efficiency at a glance. The single most important view is line-wise production and performance tracking, but the same report must also surface quality indicators so we can spot defect trends early. Here is the flow I picture: • A landing page that shows yesterday’s pieces produced per line, the corresponding efficiency %, and an overall quality score. • Time-based slicers (day, week, month) that instantly recalc every visual. • Drill-through or drill-down so a supervisor can jump from a plant summary into an individual sewing line, then right into an operator if the data exists. • Clean, executive-level visuals that someo...

I need a Python script to analyze tachograph data stored in a database. The focus is on rest period analysis using standard regulations. Key requirements: - Analyze rest periods/shifts based on standard regulations - Output results in a readable format - Create infrigments Ideal skills: - Proficiency in Python - Experience with database handling (SQL) - Knowledge of tachograph regulations and analysis Please share relevant experience and approach.

I’m building a data-driven application that delivers complete game-level and player-level analytics for four sports: Football, Cricket, Formula One, and Tennis. The goal is to merge historical and live feeds into a unified warehouse, run advanced modelling on top of it, and expose the results through interactive dashboards and an API other products can tap into. Scope of work • Set up or connect to reliable data sources, normalise them, and design an extensible schema that copes with multiple sports and rule sets. • Develop the ETL pipeline (Python, SQL, Spark or a comparable stack) to ingest, clean, and enrich the data in near-real-time. • Build an analytics layer capable of producing player performance metrics, match summaries, and cross-sport comparisons. Pre...

Urgent requirement: Oracle EBS Techno-Functional Consultant Need an Oracle EBS Techno-Functional Consultant who can join immediately after one interview round. Project must start from next day after selection and be completed within 15 calendar days, including Saturday and Sunday. Scope: * Oracle EBS integration for Vendor Onboarding and GRN process * Frontend forms and workflow are already built in React by our team * Consultant needs to handle Oracle EBS API/integration side Work details: * Vendor onboarding payload from React app to create vendor in Oracle EBS * GRN process where approved data from React workflow needs to be posted/updated in Oracle EBS * 8 to 10 APIs approximately * 4 POST * 1 UPDATE * 3 GET * GET APIs required for vendor info, vendor list, and DC code/desc...

The registration form at crashes with an HTTP 500 the moment it is submitted, and the submission never reaches the MySQL table. phpMyAdmin also throws the same 500 page right after the failure. I have not touched the PHP or MySQL configuration, and there have been no recent updates or installs on the server. I do, however, have full access to the error logs—I’m just not sure how to interpret them—so you are free to dig into those. What I need is straightforward: locate the underlying cause of the 500, repair it, and confirm that every new form entry is successfully written to the database without breaking anything else on the site. Deliverables • Identify and fix the code / server issue causing the HTTP 500 • Verify data is inserting correctly into MySQ...

I’m looking for an experienced developer to build a complete hospital application in CodeIgniter 4 that covers operations from the front office to the back office. User roles to support • Admin – User management, Report generation, System configuration • Doctor – Patient management, Appointment scheduling, Prescription management • Patient – access to personal records, appointments, and billing Key modules – Front office: patient registration, queue handling, outpatient/inpatient admission – Clinical records: SOAP notes, lab and radiology results upload – Pharmacy & prescription fulfilment linked to the doctor’s module – Billing with payment-gateway integration – Back office: inventory, account...

I have a SQL Server view that already aggregates every validation script we run on raw_valid and model_valid. What I now need is the front-end: an interactive Power BI dashboard built in a tabbed interface that surfaces those scripts, lets users explore them, and provides both basic text search and advanced filtering. Connection & data model • Connect directly to the existing view (read-only). • Expose the script name, object type, target table, last run date, status, and the full script body or a hyperlink to it. • Optimise the model so the dashboard opens quickly even when the view grows. Visual & navigation requirements • Two main tabs—one for raw_valid scripts, one for model_valid—each mirroring the same layout for consistency. ...

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...