SQL Jobs

Tengo una base de datos MySQL 5.7 (compatible con MariaDB) que alimenta una aplicación PHP / Laravel con tablas de millones de registros. El principal dolor que quiero resolver son las consultas lentas; necesito que el sistema responda con la agilidad que nuestros usuarios esperan. Busco a alguien con experiencia probada en entornos de alto volumen que analice a fondo la base, detecte cuellos de botella y me entregue soluciones listas para producción. Valoro el dominio de EXPLAIN, performance_schema y cualquier otra herramienta de análisis de consultas. Quiero trabajar específicamente en: • Optimización de consultas • Revisión de índices • Revisión y ajuste de la configuración de MySQL Entregables espera...

Actualmente gestiono un inventario de productos en una base de datos de Microsoft Access y la limitación de un solo usuario está frenando el crecimiento del negocio. Quiero trasladar toda la información a Microsoft SQL Server para que varias personas puedan leer y escribir datos simultáneamente y, de paso, incorporar algunas mejoras sobre la funcionalidad actual. Lo esencial del encargo: • Migrar por completo la estructura y los datos del inventario desde Access a SQL Server, manteniendo la integridad y las relaciones existentes. • Configurar roles y permisos que permitan a distintos usuarios leer y escribir datos de forma segura. • Replicar las funcionalidades que ya uso en Access (formularios, consultas clave, reportes básicos) y pr...

Necesito desarrollar un sistema de nómina capaz de manejar hasta 500 empleados de manera segura y confiable. El objetivo es centralizar todo el proceso de cálculo y generación de información salarial en una sola plataforma, reduciendo errores manuales y facilitando el cumplimiento legal. Funciones imprescindibles • Cálculo automático de salarios, incluidas horas extra y aguinaldos. • Gestión de deducciones e impuestos conforme a la normativa local. • Generación de recibos y reportes imprimibles en PDF. • Manejo de documentación de RRHH (contratos, licencias, cartas, etc.). • Soporte multimoneda para pagos en diferentes divisas. • Reportes mensuales y reportes personalizables (por centro ...

Necesitamos un programador .NET que pueda trabajar en la zona de Barcelona para colaborar en el desarrollo de una aplicación web orientada a empresa. Objetivo Colaborar en el desarrollo de una aplicación web empresarial centrada en la gestión administrativa. El proyecto debe cubrir los procesos internos habituales: formularios de datos, permisos, diferentes estados de expedientes, generación de reportes y paneles de control. Alcance del trabajo • Back-end en .NET (preferiblemente .NET 6 o superior) con arquitectura limpia y API REST. • Front-end con Razor Pages, Blazor o similar, manteniendo un diseño responsive. • Gestión de datos en Microsoft SQL Server. • Entorno de desarrollo Microsoft Visual Studio. &b...

Hola Somos una agencia española y nos encontramos en búsqueda activa de una pequeña agencia o freelancer de habla hispana para colaboración de forma recurrente (y también por bolsas de horas mensuales) con experto/a en Prestashop, en tareas de: - Desarrollo y diseño web Prestashop (obligatorio) - Programación a medida (Bootstrap, PHP, CSS, SQL, Ajax, JavaScript, HTML…) - Migración de datos (Clientes, Pedidos, Productos, etc...) - Instalación y configuración módulos. - Corrección de bugs. - Modificación a medida de módulos, core, theme, etc... - Actualización de versiones (1.6, 1.7, 8.X, etc...) Requisitos (imprescindibles) - Facturación: posibilidad de emitir fa...

I’m working with several spreadsheets that combine both text and numerical fields and need them ready for reliable analysis. Everything will be handled in Microsoft Excel—which is my preferred environment—though familiarity with Google Sheets is always a plus should a quick hand-off be required. The raw files arrive in varying shapes, so your job is to bring uniformity and accuracy before I run deeper analytics. Specifically, I need you to: • Remove duplicates • Correct any obvious or hidden data entry errors • Standardize formatting across columns and rows (dates, numeric precision, text casing, etc.) Along the way you’ll also re-enter or adjust individual records where information is missing or inconsistent, keep clear notes of any assumption...

I’m working with several spreadsheets that combine both text and numerical fields and need them ready for reliable analysis. Everything will be handled in Microsoft Excel—which is my preferred environment—though familiarity with Google Sheets is always a plus should a quick hand-off be required. The raw files arrive in varying shapes, so your job is to bring uniformity and accuracy before I run deeper analytics. Specifically, I need you to: • Remove duplicates • Correct any obvious or hidden data entry errors • Standardize formatting across columns and rows (dates, numeric precision, text casing, etc.) Along the way you’ll also re-enter or adjust individual records where information is missing or inconsistent, keep clear notes of any assumption...

I’m looking for a freelancer who can guide me in learning integration and configuration for Elite 3E, as well as Intapp, iManage, and Bhoomi along with database configuration and scheduling jobs/ task over databases. The ideal mentor can walk me through APIs in a live environment and help me understand how these applications work in practice, directly related to my day-to-day job responsibilities.

Sou cofundador da Fluxus One, startup catarinense dedicada a soluções de Inteligência Artificial, e preciso de um desenvolvedor N8N experiente para trabalhar 100 % remoto na evolução do nosso Agente de Vendas baseado em IA. Hoje o agente já conversa com clientes, processa pagamentos e alimenta o estoque de uma grande marca brasileira; queremos levá-lo ao próximo nível. Principais frentes de atuação • Aprimorar a funcionalidade do sistema de pagamento, o gerenciamento de estoque e a integração com outras plataformas já conectadas. • Adicionar novas camadas de automação de tarefas, relatórios personalizados e um assistente virtual que amplie a experiênc...

Retail cigar store database needed. I buy my cigars from several wholesale vendors. The cigars are not unique to the vendor. I buy cigar type A from Vendor #1 and Vendor #2 depending on the price at the time. Vendor Form Item Form Invoice Form All forms to include buttons to Save, Clear or Print form. Vendor Report: (Filtered by Vendor) Total spent for time period specified Invoice list Items purchased list Item Report: (Filtered by Brand) Item List showing Name, Barcode, SKU, Total purchased, Box Quantity, Total Unit Quantity (Box Quantity x Quantity Purchased), Last Purchased Date Item Report: (Filtered by Barcode) Item List showing from invoices: Top Section: Brand, Name, Barcode, SKU, Box Quantity Line Items: Date, Vendor, Invoice Number, Quantity Purchased, Box Cost, Sell Box ...

This project is a fully functional, custom-built web application designed to handle secure user registration, login routing, and backend data management. Built from scratch, it features a responsive user interface and a robust PHP/SQL backend, demonstrating a complete full-stack development workflow. Key Features: User Authentication System: Secure account creation and login portal for end-users. Dedicated Admin Panel: A restricted-access admin dashboard built to monitor, manage, and oversee user accounts and system data. Relational Database Integration: Fully connected to a MySQL database using PHP for real-time data storage, secure session management, and efficient data retrieval. Interactive Frontend: A clean, intuitive, and responsive user interface built with HTML, CSS, and JavaS...

This project is a fully functional, custom-built web application designed to handle secure user registration, login routing, and backend data management. Built from scratch, it features a responsive user interface and a robust PHP/SQL backend, demonstrating a complete full-stack development workflow. Key Features: User Authentication System: Secure account creation and login portal for end-users. Dedicated Admin Panel: A restricted-access admin dashboard built to monitor, manage, and oversee user accounts and system data. Relational Database Integration: Fully connected to a MySQL database using PHP for real-time data storage, secure session management, and efficient data retrieval. Interactive Frontend: A clean, intuitive, and responsive user interface built with HTML, CSS, and JavaS...

Project Prompt – Online Web Application for License & Document Management Project Description: We need a secure web-based application to manage all company licenses, their required documents, and related correspondences. The application should allow users to: Add, edit, and delete licenses and associated documents. Track expiration dates and send notifications/reminders for renewals. Store letters, approvals, and other correspondence related to each license. Search and filter licenses by type, status, or department. Generate reports of licenses, renewals, and document status. Technical Requirements: The application must be web-based (accessible via browser). Database-backed to securely store all data (SQL or NoSQL). User authentication and authorization to protect sensi...

Por favor, regístrate o inicia sesión para ver los detalles.

Je souhaite faire développer un logiciel de bureau capable de gérer l’ensemble de nos ordres de missions, qu’elles soient domestiques, internationales ou encore techniques spécialisées. Fonctionnalités attendues • Suivi des missions : création, planification, historique et état d’avancement en temps réel. • Gestion des dépenses : saisie des frais, règles de remboursement, génération de notes de frais. • Rapports de mission : export PDF/Excel, statistiques clés et tableau de bord pour le management. Environnement Le logiciel devra fonctionner en mode desktop (Windows de préférence). Une architecture modulaire est appréciée afin...

I need a production-ready backend that powers a multi-tenant School Management SaaS. The stack is fixed—ASP.NET Core 8 Web API with EF Core and SQL Server—so you should be completely comfortable designing clean, modular code in that environment. Core scope • Build the entire API layer only; no front-end work. • Architect true multi-tenancy from day one, separating data per school while keeping shared services efficient. • Implement rock-solid authentication and authorization, plus fine-grained role-based access control. Day-to-day users include Students, Teachers, Parents, School Admins, Platform Admins and other school-specific roles, so permissions must be both flexible and secure. • Model every major domain: school setup/configuration, student/pa...

I am a recent graduate and want a structured skill-development course that takes me from absolute beginner to confident practitioner in data analysis. The program should combine theory with plenty of hands-on practice so I can start applying what I learn right away. What I expect • A clear learning path that begins with fundamental concepts (data types, basic statistics, exploratory analysis) and steadily introduces more advanced topics. • Practical exercises and mini-projects using widely adopted tools such as Excel, SQL and Python (Pandas, NumPy, Matplotlib or similar), so I can build a small portfolio along the way. • Short quizzes or checkpoints after each module to confirm I have grasped the material. • Real-world datasets for practice plus guidance on where...

A new Siemens-based material-handling line is ready for commissioning and I need a clean, well-structured PLC project that focuses on data acquisition and logging. The controllers are Siemens S7 (TIA Portal) and the HMI layer will sit on WinCC (Unified or Classic—whichever you are most comfortable with). Core objective Capture and store real-time Operational status from drives, conveyors, and sensors so that maintenance and performance dashboards can draw from a reliable historical database. Inventory levels and movement tracking may be added later, so please structure tags and DBs with scalability in mind. Scope of work •⁠ ⁠Write the PLC logic that collects the required status bits, words, and alarms. •⁠ ⁠Build WinCC screens for live visualization, manual overrid...

I have a collection of digital Excel workbooks that must be imported into a live database. Each workbook contains structured records; your task is to move every field into the corresponding table and verify the integrity of the import so the data is immediately usable. The work is purely database entry—no text transcription and no spreadsheet cleanup. You will receive the Excel files exactly as they sit on my drive, and I will provide the database schema along with any lookup tables you might need. Please keep existing column names intact unless we agree on a mapping change in advance. Key deliverables • Populated database with all records from the supplied Excel files • A brief validation log noting any skipped, merged, or corrected rows • Confirmation that pr...

Sistema Inteligente de Monitoramento de Ambiente Este projeto consiste no desenvolvimento de um sistema inteligente de monitoramento de ambiente em tempo real, utilizando sensores conectados a microcontroladores e integrados a uma plataforma web. O sistema funciona da seguinte forma: sensores físicos (como o acelerômetro ADXL345 e outros dispositivos IoT) coletam dados do ambiente — por exemplo, posição de janelas, movimentação ou condições do ambiente. Esses dados são enviados por meio de um microcontrolador (ESP8266 ou ESP32) para o Node-RED, que atua como plataforma de integração e processamento dos fluxos de dados. O Node-RED recebe essas informações, realiza o tratamento inicial dos dados e...

I’m building a location-based social discovery platform focused on restaurant listings. The entire stack will rely on Supabase, so I need you to stand up and configure the Supabase backend—database schema, row-level security, authentication, storage, and REST/Realtime APIs—then hook it seamlessly to a clean, modern-minimalist interface. Core flow: a user signs up with email-and-password, grants location access, and instantly sees nearby restaurants. They can browse an infinite-scroll list, refine results through search and filters, and open a detail view with photos, description, and map pin. All pages must be fully responsive; the mobile web experience is the priority, and the desktop web view can surface a subset of features for simplicity. Deliverables • Supabas...

I need a polished, insight-rich Power BI dashboard that lets our leaders quickly understand three years of people data. The focus is on following KPI families: Employee headcount, Gender Diversity, Attrition and Training & Development. From project-level views to individual drill-downs, the visuals should reveal trends, outliers, and actionable patterns so managers can make decisions on coaching, promotions, and skill-building in seconds rather than hours. Scope of work • Connect to our raw HR data sources (excel files) and model them cleanly for year-over-year comparison. • Build interactive visuals—scorecards, slicers, heat maps, and time-series charts—that highlight performance and learning progress at department, team, and individual levels. • Opti...

I’m getting ready to launch FUNRUNNERS Baseball, a brand-new semi-pro, worldwide league built on the simple “Keep It Super Simple” mindset. To bring owners, managers, players and—most importantly—fans together, I need a membership platform that works seamlessly on both a website and a mobile app. Here’s the vision: The moment a visitor lands on our site or opens the app, they should be able to create a free fan profile, follow their favorite district team, and get real-time updates on drafts, games and league news. Paid upgrades will unlock deeper perks such as live-stream access, fantasy-style stat tracking, and exclusive merchandise offers. League mechanics also live inside the platform: fifteen charter franchises are being offered at auction. A pr...

I need a Power BI dashboard to track time, effort, and costs. This dashboard should effectively visualize: - Project timelines - Work hours - Expenses Ideal Skills and Experience: - Proficiency in Power BI - Experience in data visualization - Strong understanding of project management metrics

The PHP script is already sitting in my cPanel file manager; it just needs its database connection parameters adjusted so it can talk to my MySQL instance. I’ve got the host, username, password, and database name ready—what I’m missing is someone who can jump in, open the file, drop the credentials into the correct section, save, and confirm the script loads without errors. Because everything is already uploaded, I expect this to be a five-minute screen-share or direct edit. Once I see the page pulling data from the database without throwing connection errors, the task is done. The website is developed by a junior developer for the school, which is a non-profit project, and so I expect the developer to do it as a volunteer. Thanks in advance

Database Migration Specialist: MySQL to Supabase/PostgreSQL We're looking for a data migration expert who doesn't just move data — you ensure it arrives clean, complete, and production-ready. You have deep experience migrating large-scale databases and understand the nuances of moving from MySQL to PostgreSQL in Supabase environments. What You'll Do: - Plan and execute end-to-end migration of large MySQL databases to PostgreSQL on Supabase - Audit source data for inconsistencies, duplicates, and schema incompatibilities before migration - Design and implement migration scripts, transformation logic, and validation checks - Handle data type mapping, constraint differences, and stored procedure conversions between MySQL and PostgreSQL - Perform dry runs, staged migrati...

Requesting an existing software interface to Oracle software that will report sales from a hotel

I need a self-contained module added to our custom-built B2B portal that lets clients post their project requirements and makes those posts visible to all registered vendors in a clean list view. Core workflow • A logged-in client clicks “Post a Project,” fills out a project-description field, and submits. • The project instantly appears for vendors inside a paginated list view ordered by newest first. • Any logged-in vendor can open a listing, read the details, and click “Respond” to start a private thread with the client. Essential features • Project description field with rich-text support and a 1 000-character limit. • Server-side validation and XSS protection. • Real-time notifications (email and in-dashboard alerts) to v...

I need a new Cognos dashboard focused purely on data visualization. The dashboard will pull its figures from our existing SQL databases, so you’ll be working with relational data structures, writing efficient queries, and making sure refreshes stay fast even as record counts grow. The look and feel matter to me: clear charts, intuitive drill-downs, and a layout that lets managers grasp trends at a glance. If you have experience shaping Cognos visualizations with custom prompts, calculated fields, and conditional formatting, that’s exactly the skill set I’m after. Deliverables • A fully functional Cognos dashboard connected to the specified SQL sources • Reusable data modules and any query subjects you create • Brief setup notes so my internal admin ca...

I have an in-house VB.NET application backed by SQL Server 2008 R2 that currently schedules four 6-hour shifts per day. Operational changes now require three 8-hour shifts instead. The change touches two main areas: • Business logic – all routines that build the daily roster, assign staff and calculate shift boundaries work off the 4 × 6 model. • Database structure – several tables store fixed shift identifiers, start / end times, and downstream references that assume four records per day. Because the scheduling and allocation algorithms drive time-sensitive workflows, any adjustment must keep existing calculation accuracy intact. The user interface itself can stay as is; only back-end logic and schema need attention. What I need delivered 1. Updated ...

Add some features in back-end

I’m moving our freight-invoice workflow off a Windows-only desktop utility and into a fully SQL Server–driven pipeline. All business rules live in clear documentation, every data source has been mapped, and I have a year’s worth of validated invoices to prove the expected outputs. Here is the flow I need implemented: CSV files arrive from carriers, they are ingested into staging tables, T-SQL stored procedures match each line to the appropriate rate-card logic, the correct freight charges are calculated, and the results are surfaced through an API. The API’s main purpose is to let our client application migrate data and trigger the stored-procedure processing as needed. To keep us aligned, these are the concrete deliverables: • Schema for raw, staging, and ...

Knight Online PVP deneyimini ayakta tutan oyuncu sınıflarının yeteneklerini ince ayara getirmekte. Yalnızca mevcut skill’lerin güç, mana, gecikme ve etki değerlerini yeniden dengelemek, gerekirse birkaçını devre dışı bırakmak istiyorum. Yeni yetenek ekleme ya da harita düzenleme talebim yok; tamamen “mevcut yetenekleri modifiye etme” üzerine yoğunlaşacağız. Beklediğim çıktı – Güncellenmiş ve ilişkili veri dosyaları – Live ortamda çakışmasız çalıştığının kısa testi – Hangi değerleri değiştirdiğinizi ve nedenini anlatan küçük bir not dökümanı Knight Online sunucu dosyalarına, özellikle de SQL tabanlı skill tablolarına hâkim, daha önce en az bir PVP ...

We are looking to hire a software company that already has an existing Employee Transport / Cab Management Software for managing corporate employee pick-up and drop operations. The requirement is not to build a system from scratch, but to deploy an already developed solution and perform minor customizations based on our operational needs. The system should support key functionalities such as employee transport scheduling, cab allocation, route management, driver management, trip monitoring, and reporting through a centralized admin dashboard. Features like real-time tracking, trip monitoring, and operational reporting will be preferred. The selected vendor will be responsible for software deployment, configuration, minor customization, testing, and implementation, along with providing a ...

I have several raw datasets that need to be transformed into clear insights I can act on. Because the data spans different business areas, I’m open to whichever analytical approach—descriptive, predictive, or prescriptive—you believe will unlock the most value. Here’s what I’d like to walk away with: • A clean, well-structured dataset that documents every transformation step • An analysis that highlights key patterns, outliers, and actionable trends • Visualisations and a brief write-up summarising findings, assumptions, and recommended next steps Please outline the method you would apply, the software stack you’d choose, and any clarifying questions you have about the data’s shape or source. Once we agree on scope, we can bre...

I have a small GPS-tracker website that is already coded in PHP and MySQL; now I need it running smoothly on my Hostinger account. The priority is to get the hosting environment configured, make sure PHP and phpMyAdmin are accessible, then organise a clean routine for handling my database files. Here’s what I expect: • Move or recreate the current site on Hostinger, adjusting PHP versions or extensions if needed so every tracker feature works. • Set up a simple, reliable path in phpMyAdmin (or a tool you recommend) so I can manually upload and download my .sql backups whenever I want—no automated schedule is required, just a clear step-by-step flow I can repeat. • Confirm that each manual restore correctly repopulates the database and leaves the live site...

I need help streamlining my customer data so every record in our CRM is accurate, complete, and ready for rapid reporting. Your main goal will be to: • Import raw customer lists, remove duplicates, and fill in missing fields • Tag, segment, and organize contacts so sales and support teams can target campaigns easily • Generate a clean export plus a brief summary of key findings or data issues you spot You’ll be working directly inside our current CRM software—the tool I rely on every day—so proven experience with similar platforms is essential. While I prefer CRM-native workflows, knowledge of Excel or SQL is welcome if it speeds up bulk edits or advanced queries. I value quick learners who adapt fast, keep an eye on detail under pressure, and comm...

For the next round of hiring I want an accomplished Senior Data Engineer to sit in on our technical interviews for roughly two hours each day. The role is purely evaluative: you will craft probing questions, join live video calls, and quickly score each candidate’s depth of knowledge across Python, Scala and SQL. Our stack centres on Azure and Databricks, so practical insight into large-scale Spark/PySpark jobs, data-model design, ETL orchestration and cloud performance tuning is essential. Candidates frequently discuss streaming, optimisation strategies and modern AI/ML add-ons, so any hands-on exposure to libraries such as PyTorch, NumPy, SciPy or TensorFlow will help you challenge them at the right level, though it is not mandatory. Availability is limited to two focused hou...

I'm seeking an expert to help normalize my SQL database to the 2nd Normal Form (2NF). The primary goal is to reduce redundancy. Key Requirements: - Expertise in SQL databases - Strong understanding of 2NF principles - Experience in database normalization Ideal Skills: - SQL proficiency - Database design and architecture - Problem-solving skills for redundancy issues Please provide relevant experience with your bids.

I have an Excel workbook stored on OneDrive that needs a small yet useful enhancement—a form inside the file that can look up a project in our online database and instantly return both customer and project details. When a match is found, the form should auto-populate the relevant cells; when no match exists, every field must remain editable so I can type the information in myself from scratch. The workbook is already on OneDrive, so please design the solution to run smoothly there, whether you choose built-in Excel Forms, a bit of VBA, Power Query, or a lightweight Office Script—whichever you feel is most reliable for cloud use. Key fields will include project ID, customer name, address, phone, project description, and status. All lookups reference our SQL-based database via i...

Our historical sales data is signalling shifts that we don’t fully understand yet, so the priority is a diagnostic analysis that tells us not just what changed, but why it changed. The raw tables cover order details, customer attributes, product SKUs and daily revenue going back three years. Primary questions on the table: • How have sales trends evolved month-to-month and season-to-season? • Which customer segments are driving (or dragging) revenue, and how has their purchasing behaviour shifted? • Which products or product groups are over- or under-performing once promotions, returns and stock-outs are factored in? A clean, reproducible workflow in SQL, Python (Pandas, NumPy, Sci-Py) or R is essential so the team can rerun the analysis after future data drops...