SQL Jobs

Our cloud-based HRIS serves us well for day-to-day data, yet it offers no space to document formal investigations. Right now each case is typed into a Word template and saved manually—a process that makes version control, trend analysis, and quick retrieval a chore. I need this entire workflow moved into Microsoft Access so every investigation sits in one secure, searchable place. The database must capture everything we currently record: employee details, an overall investigation summary, every witness statement or piece of evidence we collect, and the final resolution or outcome. On top of that core structure, I want automated notifications (for example, reminders when a case nears its deadline), robust reporting tools that let us pull both individual case summaries and aggregated ...

I’m building a lightweight telehealth web app and need an experienced backend developer to set up the core services. The stack is fixed at Node.js for the server layer and PostgreSQL as the data store, so deep familiarity with Express (or a comparable framework), query builders/ORMs, and SQL optimisation is essential. Scope of this first phase is intentionally narrow—two key modules only: 1. Secure user authentication (email / password, bcrypt hashing, JWT sessions) 2. Payment workflow wired to either Stripe or Razorpay—single-charge flow with webhooks for confirmation and refunds The REST API should expose clean endpoints the front-end team can consume for sign-up/login, patient profiles, appointment booking, and payment intent creation. Please containerise the ...

Project Title: Development of a Desktop Audit Application with Online Access (Based on Existing Excel Lead File) Project Overview: We are an accounting and audit firm currently using an Excel-based lead file as a core working tool for audit assignments. As part of our internal development strategy, we want to transform this Excel file into a structured, professional desktop application with secure online access. Objective: Build a robust application that allows audit team members to perform lead work digitally, with workflow management, hierarchical validation, and centralized data control. Scope of Work: 1. Core Transformation * Convert the existing Excel file into a functional application while preserving all logic, structure, and calculations. * Ensure high data integrity and consi...

I need a robust, high-performance automation tool to verify and categorize approximately 300,000 user accounts from two databases. The tool will check login validity on a specific portal and classify accounts by type. Key Technical Challenges: Large Scale Processing: The tool must handle 300,000+ entries efficiently. I need a developer who understands multi-threading and asynchronous processing to ensure the task doesn't take weeks. Smart De-duplication: There are many duplicates across the databases. The tool must include a pre-processing step to clean and de-duplicate the list before starting the verification process to save time and resources. Account Classification: For every successful login, the tool must scrape the account dashboard to identify if it is a Corporate (Enterpri...

Looking for training on your setup environment for following points Daily 2-3 hrs per day. 1)Creating cluster node based dynatrace kit and creating Ui install or join with another cluster node. 2) uninstall active gate and uninstall cluster node on windows and linux environment. 3)Configuration of Monitors and Alert handling. Observability and Davis AI 4)Handling the Dynatrace OneAgent andActive Gate Installations. 5)App Onboarded more than 10+ Application both infra and full stack. (Docker Node ) 6)Created own custom extension for Database based on the client requirement SQL queries. 7)Monitoring Servers, Network , VMware infa , Cloud and application Performance of onboarded apps. 8)Creating host group and Management zone and alerting profile. 9)Creating dashboard both infra and services...

I’m a recent graduate preparing to apply for Data Analyst positions and I need a professionally written résumé that will help me stand out. I have basic academic and project experience but no full-time employment history, so the document has to frame my coursework, internships, and relevant skills in a way that passes ATS filters and appeals to hiring managers in analytics teams. Here’s what I’m looking for: • One- to two-page résumé in both editable Word/Google Docs and PDF formats • Clear, impact-oriented wording with data-driven achievements where possible • Section order and styling that follow current best practices for entry-level analytics roles • Optimised keywords for SQL, Python, Excel, Tableau, statistics a...

I’m offering a fully-functional Laravel e-commerce site, purpose-built for selling digital products. The application already includes a reliable shopping-cart flow, user authentication, product upload/management screens and a streamlined checkout that can be wired to any popular payment gateway with minimal effort. What you receive • Complete, well-structured Laravel 10 codebase with Blade templates and RESTful controllers • SQL dump of the database plus seeders for demo products • Installation guide and environment file sample for quick deployment on shared hosting or VPS • One session of post-handover support to help you get it running smoothly on your own server The site was developed with scalability in mind—clean separation of services, modern...

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

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

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

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

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

Actualmente tengo tres tableros alojados en que debo mover a un entorno totalmente integrado con BigQuery. Cada uno combina métricas mostradas mediante gráficos de barras, gráficos de líneas y paneles de KPI / scoreboard, por lo que necesito que la nueva versión en Looker refleje exactamente esa misma lógica, estética y granularidad de datos. El trabajo incluye: • Conectar Looker a mi proyecto de BigQuery y crear las vistas o tablas derivadas necesarias. • Escribir y optimizar las consultas en BigQuery que alimentarán los informes, asegurando tiempos de respuesta ágiles. • Reproducir los tres tableros con las mismas visualizaciones, filtros y cálculos, validando que cada cifra coincida con la versi&o...

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

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

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