SQL Jobs

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

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

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

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