SQL Jobs

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

We are hiring a Senior AI Engineer to own and accelerate AI capabilities across the platform — from customer-facing features to internal agentic workflows and production-grade AIOps. This is a high-impact, hands-on role where you will shape the next generation of AI systems and directly influence customer experience, product velocity, and operational efficiency. The Opportunity You will lead development across three core pillars: - AI Product Engineering – Ship core AI-powered features — intake, scheduling, session notes, billing automation, and more. - AI Foundations / Enablement – Build reusable primitives, evaluation tooling, and golden paths. - Agentic Workflows & AIOps – Create AI agents that automate operational work and support internal operation...

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 ned to fix sign up and sign in fuction in website . Its issue is in backend function/database. need to do hosting. Few funnctions would need too see if other features of website if not working , do fix that too. its quick work, website is not complicated. Bid Fair price.

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

I need VBA script to execute stored procedure that I have in oracle SQL with some parameter input from excel

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 have a sizable set of customer data sitting in CSVs and I want it turned into clear, actionable insights. Right now I’m still deciding which angle will be most valuable—anything from simple descriptive trends through to predictive or even prescriptive models is on the table—so I’d like your input on what the data can realistically deliver. Here’s what you’ll be working with • Customer profiles (demographics, acquisition source) • Historical purchase records and spend patterns • Engagement logs from email and in-app activity What I need from you 1. A short plan outlining the analysis path you recommend once you’ve skimmed a sample of the data. Feel free to propose segmentation, churn risk scoring, lifetime value estima...

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

I need two focused Python utilities that help me keep both of my data platforms tidy by flagging objects that haven’t been touched in X days and suggesting safe-to-drop SQL. Program #1 – AWS Athena • Connect to my Athena catalog (I work from the AWS Management Console, but in code I’d like you to stay with boto3). • For every table and view in a specified database, look back over completed query executions for the chosen time window. • Views can nest CTEs or reference other views, so the script must walk the full dependency chain to decide whether a reference is direct or indirect. • Return one CSV with the following columns exactly: database , objectname, objecttype, last_reference_datetime, referencetype (direct/indirect) , referencedBy,...

Saya ingin menjalankan proyek pengembangan keterampilan dengan fokus khusus pada Analisis Data. Tujuan utama saya adalah membangun pondasi yang kokoh sekaligus memperdalam praktik terbaik sehingga produktivitas, profesionalisme, dan efisiensi kerja meningkat secara nyata. Ruang lingkup yang saya butuhkan: • Penyusunan kurikulum ringkas namun terstruktur mencakup statistik dasar, eksplorasi data, hingga visualisasi. • Materi pembelajaran yang mudah dipahami—slide, catatan singkat, serta contoh kode—menggunakan alat umum seperti Python (pandas, matplotlib) atau SQL, sesuai kebutuhan. • Sesi praktik berbasis studi kasus nyata agar saya dapat langsung menerapkan teknik cleansing, analisis, dan interpretasi hasil. • Penugasan singkat dengan umpan balik ter...

I am looking for an experienced MySQL database expert to recover my database from .ibd (InnoDB) files and convert them into a proper .sql dump file. Background My production server crashed unexpectedly. I took a backup while the server was running. The backup contains .ibd files only (no .sql dump). I do NOT have .frm files.

one product shop connect to mollie payment for ideal payments also connect stripe payment processor. - single product shop - payment sucessfull page and confirmation mail send to client - report new orders trough backend and mail - manage orders wich are paid they should be open status after press on this order we can put text field area with text and press process order then client gets second mail with details inserted inside the text area. - manage product add pictures picture gallary sort images by sliding them - seo things adsense tag things keywords and all needed options for site it should take all options from our old site tags. in a area called site settings. like smtp mailing things and tag handlings prefer fast clean oop php sql in minimal style - all things can be taken ...

I’m building a REST-based .NET API dedicated to policy management for an Indian insurance platform. The immediate scope is twofold: enabling seamless policy creation and automating renewals, all while exchanging customer data with our existing CRM system in real time. You’ll be working in C# on .NET 6/7, applying clean-architecture patterns, Entity Framework (SQL Server), and secure OAuth2/JWT authentication. Because this sits inside an IRDA-regulated environment, I expect production-ready logging, error handling, and audit trails that match standard compliance practices in the Indian market. A minimum of three years’ hands-on experience delivering insurance solutions in India is essential—you should already understand typical policy lifecycles, endorsement logic,...

Suporte Técnico Nível 1 e 2: Atendimento presencial e remoto, registro e acompanhamento de chamados, resolução de incidentes de hardware, software e redes. Sistemas Corporativos: Administração e suporte ao ERP TOTVS RM, incluindo parametrizações, geração de relatórios e atendimento a usuários. Realizo consultas no banco de dados, criação de queries em SQL, confecção de relatórios conforme demanda dos usuários e desenvolvimento de dashboards no Power BI. Infraestrutura: Gerenciamento de ambientes com Active Directory, Admin Center e Microsoft 365; criação de usuários, permissões e grupos. VoIP: Atuação com o sistema de telefo...

I am preparing to move a sizeable MySQL dataset—customer, product, and transaction records—to a new environment and need someone who has performed full-scale migrations before. The assignment runs for roughly one month, during which you will work from our Hyderabad office so we can iterate quickly with business owners and IT. The work covers the entire pipeline: extracting data from the current MySQL instance, scrubbing and de-duplicating it, mapping old structures to the target schema, and applying significant transformations to fit new business rules. Solid SQL is obviously essential, and you should already feel at home with large tables, indexes, constraints, and performance tuning. Experience scripting in Python or using ETL utilities (e.g., Talend, Pentaho, custom shell/P...

Job Title: Data Architect — Azure & Databricks Key Responsibilities Design and govern scalable data platforms using Azure and Databricks. Define end-to-end data architecture (ingestion, storage, processing, modeling, serving) based on Lakehouse and governance principles. Establish data modeling standards and architecture best practices. Architect and optimize data pipelines using Databricks, Delta Lake, and Azure Data Factory. Implement CI/CD and environment management using Databricks Asset Bundles and automation tools. Drive performance optimization across Spark, SQL, and Python workloads. Apply software engineering best practices (modular design, testing, CI/CD) to data solutions. Partner with business and analytics teams to translate requirements into scalable archit...

I need someone who can support me for following things: Provide technical expertise to evaluate, design, and strengthen institutional data infrastructure, including integration of Student Information Systems (SIS), Learning Management Systems (LMS), Customer Relationship Management (CRM)/early alert systems, and other student success technologies. Provide technical support in the creation, monitoring, and optimization of data pipelines, warehouses, and governance structures to ensure scalable, reliable, and secure access to data. Support data quality efforts through profiling, cleansing, deduplication, and validation of large datasets from multiple sources. Develop, or provide assistance in the development of, dashboards and reports that turn data into actionable insights, including d...

Analyzed 10,000 rows of raw retail sales data and built a complete analytics system with 11 professional charts and an automated PDF report that runs with a single click. The biggest challenge was identifying why profit margins were inconsistent across different product categories and regions despite strong overall sales numbers. Using Python and Pandas I cleaned and transformed the raw data, removed errors and inconsistencies and built a complete analysis pipeline from scratch. KEY FINDING: Discounts above 40% were generating negative profit across hundreds of transactions. Capping discounts at 20% identified a $50,000 annual profit recovery opportunity the business did not know existed. WHAT WAS DELIVERED: 1. Complete data cleaning and preparation 2. 11 professional char...