SQL Jobs

Buscamos profesional en Ingeniería de Sistemas, Ingeniería Industrial, Ingeniería de Software o áreas afines, con experiencia en proyectos de Business Intelligence y análisis de datos. Requisitos principales: Experiencia comprobable en MicroStrategy. Manejo de SQL y bases de datos. Experiencia en creación de dashboards, reportes e indicadores KPI. Conocimientos en análisis, transformación y visualización de datos. Experiencia en herramientas de Business Intelligence y Business Analytics. Capacidad para analizar grandes volúmenes de información y generar reportes para la toma de decisiones. Deseable experiencia con Power BI, Microsoft BI, IBM InfoSphere u otras herramientas de analítica. Funciones princip...

Administro un servidor SA-MP que corre 24/7 en un panel Pterodactyl totalmente configurado y quiero llevarlo al siguiente nivel con un nuevo modo Roleplay. Necesito a alguien con experiencia comprobable en Pawn que pueda diseñar y programar el sistema de viviendas —pilar clave del proyecto— y, a la par, esté dispuesto a optimizar o depurar cuando sea necesario. Qué espero de ti • Construir desde cero el sistema de Housing: compra, alquiler, llaves, interiores, garajes y almacenamiento ligados a la economía del servidor. • Integrarlo con el registro de usuarios, comandos administrativos y la base de datos MySQL ya operativa. • Mantener el código claro, comentado y eficiente para facilitar futuras expansiones. Entregables m&...

# Sistema de Gestión para Clínica Veterinaria ## Descripción del proyecto Desarrollo de un sistema de gestión para una clínica veterinaria, diseñado para organizar y administrar de manera eficiente la información de pacientes, propietarios, consultas, vacunas, tratamientos y medicamentos. El proyecto contará con una base de datos desarrollada en **MySQL**, permitiendo almacenar y consultar la información de forma organizada y segura. ## Funcionalidades principales * Registro de propietarios y sus datos de contacto. * Registro de pacientes (perros, gatos y otras especies). * Historia clínica de cada animal. * Registro de consultas veterinarias. * Diagnósticos y tratamientos. * Control de vacunas y fechas de pr...

هل لديك قاعدة بيانات وتحتاج إلى كتابة استعلامات SQL لاستخراج أو تحليل البيانات؟ سأقوم بكتابة استعلامات SQL باستخدام SQL Server حسب احتياجك، مع الاهتمام بأن تكون الاستعلامات منظمة وواضحة وسهلة الفهم. تشمل الخدمة: • كتابة SELECT و WHERE و ORDER BY • استخدام GROUP BY و HAVING • استخدام JOIN لربط الجداول • استخدام الدوال التجميعية مثل COUNT و SUM و AVG • كتابة Subqueries • استخراج البيانات وتحليلها حسب المطلوب • تعديل وتصحيح استعلامات SQL الموجودة ما ستحصل عليه: استعلام SQL جاهز للاستخدام كود منظم وواضح شرح مختصر للاستعلام عند الحاجة لإتمام الخدمة، يرجى إرسال المطلوب بالتفصيل مع الجداول والأعمدة المستخدمة، ويفضل إرسال عينة من البيانات إذا كانت متاحة. نطاق العمل مقابل سعر الخدمة الأساسي: كتابة أو تعديل حتى 3 استعلامات بسيطة (مثل: Selection, Filtering, Basic Jo...

(apply only collage students) Full time Intern Technical SaaS Marketing / Growth – Remote – ₹10K–₹25K/month I'm building ****, an AI-powered database development and optimization tool available as a VS Code extension. Looking for a **part-time technical marketer / growth person** to help acquire our first users. **What you'll do:** * LinkedIn/X content * YouTube Shorts & product demos * Technical SEO/blogs * Developer-community engagement * Developer/CTO outreach * Product Hunt launches * User acquisition & conversion tracking **Technical knowledge preferred:** * SQL * MySQL/PostgreSQL * VS Code * AI/LLMs * SaaS/developer tools **Budget:** ₹10K–₹20K/month **Time:** 2–4 hours/day **Location:** Remote / India Developers moving into mar...

500 PleskExceptionDatabase Unable to access Plesk: DB query failed: (1146) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.smb_apsPackages' doesn't exist, query was: DESCRIBE `smb_apsPackages

I’m setting up a weekday mentoring program for aspiring Business / Data Analysts and need an experienced professional who can teach fluently in both Tamil and English. The core of the syllabus covers Excel, SQL, and Power BI + Tableau from absolute basics right through to advanced, so you must be comfortable demonstrating formulas one day and performance-tuning queries or DAX calculations the next. In addition, the cohort will expect: • Python at an intermediate, practical level (writing clean scripts for data prep and simple automation). • A walkthrough of AI & GenAI concepts and hands-on examples that sit between basic and intermediate complexity. • Touchpoints on Google Looker Studio, fundamental statistics, and—most importantly—how to turn raw ...

I need clear, decision-ready visual insights built from our business data. My focus is squarely on data visualization, and I’d like you to work in the two tools my team already knows—Tableau and Power BI—so we can keep everything aligned with our current workflows. Here’s what I have in mind: • Connect to the raw sales and operations data I’ll provide (CSV and SQL sources). • Design interactive dashboards that highlight trends, outliers, and key performance drivers for management review. • Incorporate filters, drill-downs, and concise narrative elements so anyone in the company can understand the story behind the numbers. Acceptance criteria • At least one Tableau workbook and one Power BI report, each fully functional and shareable...

I created a local SQLite database that holds stock and options information, but I’m still figuring out the best way to store and pull the numbers I need, fast. The tables already capture historical prices and my own trade transactions; what I’m missing is a solid grasp of the SQL required to store and retrieve that data efficiently and in formats I can feed straight into my analytics scripts. Here’s what I want from our collaboration: • A review of my current schema to be sure the historical-price and trade-transaction tables support the queries I intend to run. • Step-by-step examples (with clear explanations) of SELECT statements, joins, window functions, and indexing strategies that work well in SQLite when dealing with time-series market data. • ...

I’m building a fully-featured government site that not only informs the public but also houses a secure, integrated data management system. At the front end the public should be able to find key information quickly—news, notices, and any documents we choose to publish—while registered users access their own portal for personalised services. Behind the scenes I need a powerful yet intuitive administrative console that lets staff organise, track, and retrieve data without touching code. The core dataset is government documents, so the document module must support: • Document upload and secure storage • Fast, granular search and retrieval (metadata and full-text) • Version control with a complete audit trail Security, scalability, and accessibility a...

Data Management Course Notes (Complete Beginner Guide) Unit 1: Introduction to Data Management What is Data? Data is a collection of raw facts, numbers, text, images, or symbols that can be processed to produce meaningful information. Examples: Student name Age Roll number Marks Mobile number Information Information is processed and organized data that has meaning. Example: Marks = 85, 90, 88 (Data) Average = 87.67% (Information) Importance of Data Management Improves decision-making Reduces errors Saves time Increases security Supports business growth Helps in reporting and analysis Unit 2: Types of Data 1. Structured Data Organized in rows and columns Stored in databases Easy to search Example: Student database 2. Semi-Structured Data Not completely organized Uses tags or labels...

I need an interactive dashboard built directly inside Databricks that turns my existing operational data into clear, actionable insights. The focus is on two KPI groups—productivity metrics and error rates—so the layout should make it easy to compare trends, spot anomalies, and drill down to the underlying records. Preferred visuals are straightforward bar and line charts that auto-refresh and respond quickly to date-range or categorical filters. The data already sits in Delta tables; you can query it with Databricks SQL or notebooks, but the final deliverable must be a Databricks SQL Dashboard (or equivalent Databricks-native artifact) that I can share with colleagues without extra setup. Please include: • A clean, responsive dashboard with bar and line views for each K...

I need reliable help keeping our spreadsheet-based data accurate, tidy, and constantly up to date. The work is 100 % data entry, focused on spreadsheet management rather than a formal SQL or NoSQL database, so you will live inside Google Sheets or Excel every day. Here’s what I am looking for: • Take raw records I provide (CSV, emails, scanned forms) and place them into the correct worksheets. • Maintain consistent formatting, naming conventions, and column order. • Run basic formulas, filters, and conditional formatting to surface duplicates or incomplete rows, then correct them. • Produce a daily “changes” tab so I can quickly review what was added or edited. Accuracy is everything—before a file comes back to me I should be able to sp...

We are looking for an experienced **Software Engineer** to join our project and help build, improve, and maintain modern software applications. The ideal candidate has strong experience with **JavaScript/TypeScript and Python**, understands backend and frontend development, and is comfortable working with APIs, databases, and third-party integrations. ### Responsibilities * Develop and maintain software applications using **JavaScript/TypeScript and Python** * Build and integrate REST APIs and third-party services * Develop backend services and application logic * Work with databases and optimize queries when needed * Debug, troubleshoot, and resolve technical issues * Write clean, maintainable, and well-structured code * Review existing code and improve performance and reliability * Co...

I need all live data from our Jamison Woopsa ERP moved seamlessly into NECS entrée. The scope covers customer records, full inventory catalogs, and complete sales history. Every field has to land in the exact entrée-native structure so our team can switch over with no manual cleanup. During the move, I want every single record validated—no missing IDs, misplaced decimals, or date mismatches. If something fails a check, the process should flag it and give me a clear resolution path before final import. Deliverables I expect: • Exported Jamison Woopsa datasets • Transformation scripts or mapping documentation showing how each field aligns to entrée • Fully formatted entrée-ready files (or direct database load) • Comprehensiv...

I run a knitted-garment unit in Tirupur and I want a straightforward desktop application that lets me enter production data each week, have it instantly calculate the corresponding wages for every operation we perform, and then keep those records safely for an entire 53-week cycle. Core workflow • I select an operation—Cutting, Powertable, Singer, Ironing & Packing, Housekeeping, Helper, Checking, Kaja buttoning or Fusing—type in the pieces produced , and the app shows the wage for that contractor right away. • Once I confirm, the week’s data is written to a rolling database so I can pull any figure or summary for up to weekly status( 12months) • With one click I generate a neat PDF “payment slip” (screenshot style) and send it direct...

I need a Microsoft SQL Server specialist who can take stacks of paper‐based records, design the appropriate tables, and manually key every field into a clean, well-structured database. Once the information is in place, I want meaningful statistical insight extracted—basic descriptive stats, variance and correlation figures, and any notable outliers that should be flagged. To succeed you will be comfortable with SQL Server Management Studio and T-SQL for schema design, indexing and data validation rules that prevent transcription errors. After entry, apply your preferred statistics toolkit (native SQL functions or an external package you connect to the database) to run the agreed analyses and return concise results. Deliverables • Normalised SQL Server database with all paper...

We are launching a new web application. It is to help hosts manage events. It is a small application (first release) with a form for host to create, share the link, allowing guests to respond. Also there are email notifications. The requirements are not explicitly specified. Tester will have to understand the functionality and test. There is a SQL server backend application, hosted on Godaddy. Tester must test for security risks, vulnerability, unauthorised access, encryption, confidentiality, leakages, cyber security / penetration. Tester will also have to find out issues with coding standards, cookies, encryption in data exchange to ensure that plain data is not saved or transferred. The application is mobile/desktop/devices compatible. And needs to be tested on those. Tester will ...

I have a live MySQL database waiting for a batch of new customer contact records—names, emails, phone numbers and postal addresses. The raw data will reach you through a secure online form; every submission lands in an exportable CSV that you can pull at any time. Your job is to review each line for obvious typos or missing fields, flag anything suspect, then insert the clean records into the designated table. You may work directly in phpMyAdmin, MySQL Workbench, or via your own scripted INSERTs; the only requirement is that the final table structure, indexes and auto-increment keys stay untouched. Deliverables • All supplied records accurately entered into the database • A brief log noting any duplicates or corrections you had to make • SQL dump or confirm...

Python AI CRM Automation MVP — API Integration & AI Workflow I am building an AI-powered CRM automation system for a business and are looking for a strong Python developer to help develop the initial technical MVP. The system will connect a CRM/API with a Python backend and an AI layer to automate selected customer and lead-management workflows. This is intended to become a longer-term project, but we want to begin with a focused technical milestone before expanding the scope. The proper developer will help with: * Python backend development * CRM API integration * REST API development * Database design and queries * CRM data retrieval and updating * AI/LLM API integration * Structured data processing * Automation workflow implementation * Error handling and logging * Basic a...

I have a collection of text-based records that need to be inserted directly into an existing MySQL database. The tables are already created; what’s missing is the accurate, timely population of each field. Your task is straightforward: take the source files I’ll provide (plain text and a few CSVs), clean any obvious formatting issues, and upload the data through phpMyAdmin or a command-line import—whichever you’re most comfortable with—as long as referential integrity is maintained. I will supply: • The database schema with field definitions and constraints • Source files organised by table • Clear mapping notes showing which column each text element belongs to What I expect back: • All rows entered without duplication • Primar...

Διαθέτω ήδη ένα δυστυχώς μη λειτουργικό πρωτότυπο σε Glide χωρίς στημένο backend διότι δεν έχω τις απαιτούμενες γνώσεις και τον χρόνο. ​Θέλω μια πλατφόρμα που ΔΕΝ βασίζεται ...

I need an experienced Oracle database administrator to migrate an Oracle-based database management program from Windows 2000 to a current on-premises Windows platform. Requirements: - Migrate existing database without data loss. - Ensure compatibility with current Windows OS. - Optimize for performance on new platform. - Provide documentation for setup and maintenance. Ideal Skills: - Expertise in Oracle database management. - Experience with Windows server environments. - Strong troubleshooting and optimization skills. - Prior experience with legacy system migrations. Looking for a freelancer who can deliver this project efficiently and effectively.

I have several datasets coming in from different systems where the numeric fields are stored as plain ASCII files in some cases and UTF-8 exports in others. My goal is to run solid, reproducible data analysis on them, but first they need to be cleaned and standardised. Here is what I need from you: • Build a repeatable cleaning pipeline in Python (Pandas, NumPy) that detects the file encoding, converts everything to UTF-8 where necessary, and validates that all numeric columns are truly numeric—no stray characters, misplaced separators, or locale-specific quirks. • Where the raw files already sit in SQL Server, create T-SQL or Python-based routines that achieve the same checks and corrections in-database so I can schedule them in an Agent job. • Document each s...

Category tags: Intuit QuickBooks · Accounting · Python · API Integration · Financial Analysis · Data Management · SQL Budget: Fixed price, milestone-based. Bid the full scope. Timeline: 3–4 weeks from kickoff. What I need A reproducible synthetic dataset for a fictitious solid-waste hauling company, covering 24 consecutive months of operations. This is for internal staff training, reporting/BI sandbox testing, and month-end close practice. No real company, customer, vendor, or employee data will be used or accepted. The scope has two linked layers: Financial layer — a populated QuickBooks company file (GL, AR, AP, payroll, fixed assets). Operational layer — the underlying service, tonnage, container, and route data that the f...

I need a proven strategy to move more than 10 TB of mixed-type data—media assets, databases (primarily MSSQL dumps) and a variety of project files—across our WAN as quickly and safely as possible. The current link struggles with long round-trip times and occasional packet loss, so every transfer drags on for days and sometimes fails outright. My aim is threefold: slash the overall transfer window, eliminate checksum mismatches or corrupt segments, and lighten the ongoing load on the network while these moves are in progress. I am open to any combination of protocol tuning, compression, data deduplication, forward-error correction, WAN acceleration appliances, or cloud relay services—as long as the end result delivers measurable improvements. Deliverables • D...

Hi Everyone, We have urgent requirements for Senior Oracle EBS Functional Consultants. Experience: 10–12 Years Location: Remote (Indian Candidates only) Working Hours: US CST 1. Principal Consultant – EBS HRMS Functional Strong experience in Oracle EBS HCM, Core HR, Payroll, Benefits, Talent Management, and Self-Service, with hands-on experience in R12.2.x, production support, configuration, and implementation. Strong client-facing and communication skills are required. 2. Principal Consultant – EBS Prospect to Report Functional Strong experience in Oracle Projects, Projects Foundation, Planning & Control, Project Billing, Project Costing, Receivables, and Payables, along with hands-on experience in production support, implementation, configuration, and troubleshoo...

I have an active SolarWinds Observability Self-Hosted Essentials for Enterprise licence (EE1500, covering up to 1 500 nodes) and now need Network Performance Monitor installed and fully configured in a brand-new environment. Nothing from SolarWinds is running yet, so the engagement starts with clean servers and blank databases. What I need is complete, production-ready deployment: sizing and architecture guidance, Windows Server and SQL prerequisites, installation of the NPM engine, web console, additional polling engines or HA pairs if your design shows we need them, followed by initial discovery and onboarding of devices. Once the platform is stable I also want core alerting rules, reports and dashboards set up so my team can see value on day one. Deliverables • Design document ...