SQL Jobs

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

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

We have Oracle and MS-SQL environments that need expert support, and for compliance purposes the work must be performed by someone who is physically located in Canada. Here is the immediate scope: Oracle upgrades – Plan and execute version upgrades on Development and Production databases, ensuring minimal downtime and a clean rollback path. – Review current backup, recovery and high-availability strategies and adjust them to suit the new versions. Ongoing operational support – Handle day-to-day administration, performance tuning, security patching and capacity planning. – Document every change clearly so our internal team can trace what was done and why. Integration assistance for active projects – Our developers are building Web and...

I have an existing Excel-based form that needs to run itself instead of relying on manual copy-and-paste. The form captures three kinds of input—free-text notes, numeric values (including dates or currency), and predefined multiple-choice selections—and all of them must be validated the moment a user types or picks an option. Once a user presses “Submit”, I want the sheet to carry out three things automatically: 1. Check every field against built-in validation rules (no missing mandatory items, correct number formats, valid choices). 2. Auto-populate any look-ups or calculated fields so the person filling the form never sees #N/A or has to open another tab. 3. Push a clean, single-row record straight into an external database table (SQL Server is preferred, ...

I need a lightweight vehicle-management tool focused squarely on load handling. The core requirement is accurate, real-time load weight tracking for every vehicle that passes through our facility. I’m interested in a clean interface where operators can enter a vehicle ID, capture the weight from a connected scale (or manual input when needed), and save that data to a searchable log. At this stage load management is the only must-have module; features such as entry/exit stamping or driver assignment may be added later, so please keep the architecture flexible for future expansion. Key deliverables • A web-based or desktop application (Windows preferred) that records vehicle ID, timestamp, and gross/net weight. • Simple dashboard to view, filter, and export weight records...

Our main database is already running on PostgreSQL 13 (anything in the “12.x or higher” family), and I need an experienced DBA to step in and tighten two things: First, Database optimization. The work includes reviewing current configuration parameters, checking execution plans, tuning indexes, and suggesting any schema changes that will noticeably reduce latency under peak load. If extensions (pg_stat_statements, auto_explain, etc.) should be enabled or configuration values (shared_buffers, work_mem, effective_cache_size and friends) adjusted, please make those recommendations backed by data. Second, Backup and recovery. I want a clear, scripted process—preferably with pg_dump and/or a modern tool such as pgBackRest or Barman—that covers daily backups, point-in-t...

I have a large set of customer information stored in a database, and I need it cleaned, structured, and exported into professional-looking spreadsheets so my team can work with it easily. All of the data is already digital—no paper scanning involved—but the current tables are messy, contain duplicates, and use inconsistent field names. You’ll connect to the database directly (whether it’s MySQL, PostgreSQL, or Microsoft SQL Server—the exact engine can be confirmed once we start) and pull every customer record. From there, I’m expecting: • One master Excel or CSV file with clear, human-readable headers • Removal of duplicates and obvious data entry errors • Consistent formatting for dates, phone numbers, and addresses • A brief...

I need an experienced Power BI specialist who can dive straight into an urgent KPI dashboard build for our Bedford-based business. The model must pull live and historical data from three different sources—Excel files stored in SharePoint, our on-premise SQL databases, and several Online APIs—and blend them into a single, well-structured data model. The core story the dashboard must tell is operational efficiency: utilisation rates, throughput times, downtime causes, cost per unit, and any other DAX measures you know will help management spot bottlenecks quickly. Alongside that operational narrative I also want space for two high-level sales indicators—total revenue and sales growth rate—so leadership can see in one view how internal performance is affecting topline...

Career Summary: Results-Driven Database Professional with over 19 years of Extensive Experience in Oracle Database Technologies, Providing 24x7 Production Support and Managing Mission-Critical Database Environments Across Diverse Industry Sectors, including Banking, Finance, Insurance, Telecommunications, Oil & Gas, Pharmaceuticals, Automotive, Airports, and Expertise in Oracle Database Administration, High Availability Solutions, Oracle RAC, Disaster Recovery (DR), Performance Tuning, Database Migrations, Backup and Recovery, and Production Support. Proven Track Record of Successfully Handling Large-Scale Enterprise Database Infrastructures While Ensuring Maximum Availability, Reliability, Security, and Operational Excellence. Progressively Advanced Through Key Leadership and Techni...

I have a sizeable set of sales transactions exported directly from my e-commerce platform and I need a clear, insight-driven analysis that helps me understand the market forces reflected in those numbers. Your task is to dive into this raw sales data, clean and structure it, then surface trends that answer key market research questions: What products or categories are gaining momentum, which customer segments are buying when and why, and how do seasonal or promotional events shift demand? I would like the final work delivered as: • A cleaned, well-documented dataset (CSV or database table) that I can reuse. • A concise written report highlighting the main findings, supported by visuals. • Interactive dashboards (Tableau, Power BI, or similar) so I can explore the trends...

We have existing AWS services that need to be migrated to Microsoft Azure and are looking for an experienced Azure professional to assist with the migration. The environment consists of one web application and one API, both of which receive a high volume of traffic and require a scalable, highly available Azure architecture.

For my company Awizohub, I need a streamlined, web-based tool that lets me generate and print QR-code stickers in multiple label sizes without fussing over which printer I am using. From a single Google Chrome tab I want to: • Type or bulk-paste the data that the QR code should hold (CSV upload is fine). • Pick a predefined label template or quickly enter custom width, height, gap, and margin. • Preview the sheet/roll so I can confirm alignment before wasting labels. • Hit “Print” and have the app push a perfect layout to any connected printer—desktop laser, ink-jet, or thermal label printer—leveraging the browser’s print dialog or a PDF download. Accuracy is critical: the printed code must stay within tolerance so every scanner rea...

Project Title Zoho + Supabase Developer / Team for Data Migration & Ongoing Backend Support Project Description We are looking for an experienced Zoho developer, backend developer, or small development team to help migrate data from our existing Zoho environment into a new Supabase/PostgreSQL backend. This project may also develop into ongoing backend development and maintenance work through Freelancer.com after the initial migration is completed. Our organization currently uses Zoho Recruit, Zoho CRM, Zoho Books, and other Zoho applications to manage recruitment, candidates, employers, clients, and operational data. We are developing a new recruitment and job platform with Supabase/PostgreSQL as the primary backend. The platform already has an initial backend and application ar...

I’m committing the next eight weeks to sharpening my SQL and Excel skills and I’d like you to steer the process. I already work comfortably at an intermediate level, but I’m still spending far too long turning raw data into clear, compelling visuals. My goal is to leave this programme able to move from question to insight quickly—writing tidy, well-structured SQL queries and translating the results into polished dashboards and charts inside Excel (and, where it makes sense, Power BI). Here’s how I picture our collaboration: • A structured learning path that steadily raises the bar each week, mixing short theory explanations with hands-on exercises drawn from real business scenarios. • Screen-sharing or paired-coding sessions where you watch me wo...

I need a seasoned Oracle Cloud HCM professional to run candidate interviews on Zoom or Microsoft Teams and provide a clear, written assessment of whether each applicant truly matches the technical job description I will supply. Along with Must have Fast formula experience, must have In-depth knowledge in at least two of HCM Cloud Modules: Core HR Absences Benefits Payroll Workforce Compensation OTL Taleo OLC Oracle recruit. Cloud -certification will be an advantage What I expect from you • Conduct a 45- to 60-minute live interview per candidate, covering technical depth, problem-solving approach and real-world project exposure. • Test for 5–14 years of hands-on Oracle Cloud HCM experience, especially around Fast Formula in at least two cloud modules (for example Core ...

I’m a complete beginner to data engineering and want a structured, guided path that quickly gets me comfortable with real-world workflows. My first priority is solid data modeling, but I’d like each concept tied directly to hands-on practice as well as the “why” behind it, so theory and application move together. The stack I need to master is SQL, dbt, Snowflake, and Fivetran. A typical session might start with designing a dimensional model, move into building that model in Snowflake, automate the ELT with Fivetran, and finish by transforming the data with dbt—all committed to Git so best practices stick from day one. I learn fastest by doing, so please be ready to: • Walk through short, focused explanations, then immediately switch to screen-sha...

I’m looking for a data-savvy partner who can jump in a few hours each week to keep our datasets tidy and turn them into clear, actionable visuals in Power BI. The work is squarely focused on visualization and cleaning rather than heavy statistical modeling. Here’s what I need you to handle regularly: • Remove duplicate records across several CSV and SQL sources • Identify and fill (or flag) missing values in a way that keeps our reporting reliable • Spot and correct inconsistencies in field naming, formats, and codes • Build or update interactive Power BI dashboards so stakeholders can explore trends without digging into raw tables Typical deliverables • A cleaned dataset (or SQL view) ready for downstream use • A PBIX file with refre...

Data Analyst Tutor Needed — Intensive 2-Month Program (Python, SQL, Excel, Power BI) Overview I'm looking for an experienced data analyst or data scientist to tutor me through a structured, self-directed curriculum over the next 2 months, with the goal of being fully job-ready and actively applying for Data Analyst roles by the end of the program. I already have a Master's degree in Data Science and have built out a complete week-by-week study plan — I need a tutor to guide me through it, review my work, unblock me when I get stuck, and run mock interviews at the end. This is not a "teach me from scratch with your own materials" role — I have the curriculum already mapped out day by day. I need someone who can teach to that curriculum, adapt it if ne...

I’m looking for a sharp analyst to turn my raw sales exports into clear, decision-ready insight focused on revenue growth. The data covers online and in-store transactions plus basic customer attributes; it just hasn’t been cleaned or modeled yet. Your mission: • Prepare and cleanse the files so every sale is accurately timestamped and attributed to product, channel and customer segment. • Build the model that lets us track revenue growth and uncover its drivers—product mix, regions, marketing channels, returning vs. new buyers, average order value, and seasonality. • Visualise the trends in an interactive dashboard (Tableau, Power BI, or similar) and supply a short slide deck that highlights the biggest growth levers and red flags. I’m flexible...

I have an existing Excel workbook that currently relies on manual submissions. All the figures we need already live in a SQL Server database; they simply have to appear in the correct cells of the form and then trigger the usual calculations and formatting the sheet already performs. Here is what I need from you: connect Excel to SQL Server, pull the required numeric fields, map them to the form’s input range, and set the process to refresh on demand (button or scheduled refresh—whichever is cleaner). The workbook must stay fully functional for colleagues who are not technical, so the solution should run with a single click and require no additional installs beyond standard Office components. VBA, Power Query, or a lightweight Add-in are all acceptable, provided they are rel...

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