SQL Jobs

I need to organise all of my customer information in a structured SQL database and give my team a simple way to add or update those records directly from their phones. The core of the job is two-fold: first, design and deploy a clean relational schema that captures names, contacts, addresses, notes and whatever other standard customer fields you would normally expect; second, build a mobile interface that lets users create, read, update and delete those records through straightforward forms. The mobile side can be cross-platform in Flutter or React Native, or native Android if that is faster for you—what matters most is that it connects securely to the database, validates input, and presents a searchable list of existing customers. No CSV imports or external APIs this time; everythi...

Build a single Power BI dashboard that pulls data live from my Excel workbooks and our SQL database, then turns that information into clear insights about customer demographics and customer satisfaction. The data model should merge both sources seamlessly, handle refresh schedules, and expose relationships that let me slice results by date, region, product line, and any other key fields you uncover. Inside the report, I want bar charts for quick comparisons, pie charts for proportional breakdowns, and line graphs that reveal trends over time—each fully interactive with tooltips, drill-through, and cross-filtering. Supply the finished .pbix file, document any custom DAX logic, and publish a ready-to-share version to Power BI Service (or show me how in a brief hand-off call). Whe...

I need to turn two raw datasets—sales and customer records—into a clean, insight-packed dashboard. Start by profiling the data in Excel or SQL, removing duplicates, filling or flagging missing values, and standardising every date, currency and categorical field so the tables can join cleanly. With trustworthy data in place, build an end-to-end Power BI model: set relationships, create calculated columns and DAX measures, and surface the KPIs that drive our decisions (revenue trends, customer lifetime value, churn, product mix, regional performance). The visuals should be interactive, with slicers that let managers move from an executive overview down to line-item detail. Quick exploratory charts in Excel are welcome, but the final, shareable report must live in Power BI. Deli...

AWS Data Engineer Needed — 1:1 Mentor/Tutor to Teach AWS Data Engineering Category: Data Engineering / Cloud Computing / Tutoring & Mentoring Description: I'm looking to build strong AWS Data Engineering skills from the ground up and want an experienced AWS Data Engineer to act as a personal tutor/mentor — covering core concepts, tools, and hands-on skills needed to work as a data engineer on AWS. What I'm looking for: 1:1 sessions (video call) covering AWS data engineering fundamentals and hands-on labs Coverage of core services: S3, Glue, Redshift, Athena, Kinesis, Lambda, EMR, Step Functions, RDS/DynamoDB ETL/ELT pipeline design, data lake vs. data warehouse concepts Python/PySpark for data engineering, SQL for analytics Guidance on real-world project work...

I need a concise descriptive analysis of the data currently stored in my relational database. The tables are already structured and populated; what I lack is a clear, statistics-driven snapshot that highlights key totals, averages, distributions, and any obvious trends or anomalies. You’ll connect directly to the database (credentials supplied after award) and: • explore table relationships and data quality, • run summary statistics and frequency counts, • create straightforward visualizations—think bar plots, histograms, heat-maps—that quickly communicate the story behind the numbers, • package everything into a short, well-commented Jupyter Notebook (or SQL script plus slides, if you prefer) so I can reproduce the results at any time. Plea...

I want to extend my Dolibarr installation with a small module that lets me attach JPEG product images directly from the product card and enter one or more manual tags at the moment of upload. The goal is to make daily catalogue maintenance quicker: staff should be able to drag-and-drop a .jpg, type the tags, save, and instantly see the image in the gallery section of the product together with its tags. Key points • Only JPEG files have to be accepted, with basic size validation and automatic thumbnail generation. • Tags are plain-text keywords entered by the user; they need to be stored in the database and displayed under each image, with the ability to filter/search products by those tags later on. • The solution must respect Dolibarr’s module guidelines so I...

I run a finance operation that relies on up-to-the-minute market data. What I need now is a streamlined MIS process that turns those feeds into clear, insightful reports and dashboards. You’ll work with market data exclusively, shaping it end-to-end: extracting with SQL, modelling in Excel for quick ad-hoc views, and visualising in Tableau for daily management reporting. Everything must refresh automatically so my team can focus on decisions, not data wrangling. Deliverables • SQL scripts that pull and aggregate the required market data on a schedule • An Excel model with clean, pivot-ready tables and scenario analysis sheets • Interactive Tableau dashboards (published to our server) featuring drill-downs, KPIs, and one-click PDF exports • A concise hand...

I have an existing SQL database that needs regular, accurate data entry and ongoing management. The core of the work is keeping every record current, validating each new entry against our existing tables, and running simple queries to confirm that key fields stay consistent over time. You will receive raw data files (mostly CSV) on a scheduled basis. I’ll expect you to import them, reconcile any duplicates, flag inconsistencies, and confirm successful inserts. Familiarity with basic normalization rules, foreign-key constraints, and indexing is important because I want the tables to remain fast and reliable as they grow. Deliverables: • Cleaned, imported data sets fully integrated into the SQL database • A brief log of changes, issues found, and resolutions for each ba...

I want a sleek, self-refreshing Power BI dashboard that pulls customer counts from two sources—an Excel file and our Databricks environment—and visualises the 12-month trend for each line of business across Brand A, Brand B and Brand C. The core visual should be clean line charts with a rolling monthly view, allowing users to toggle brands or drill down by product line without losing the last-year perspective. You will work with my existing Databricks SQL endpoint (I’ll share the cluster URL and credentials) and a locally stored Excel workbook. I need the model set up so both sources refresh automatically through the Power BI gateway and any new month appended to either source rolls straight into the visuals. Deliverables • A .pbix file containing the data model, r...

Our in-house document management platform has been running smoothly on a C#/.NET stack, MS SQL Server, and AWS for several years, but the developer who built and nurtured it is leaving. I need someone who can step in right away, understand the codebase, and keep the application stable and performant. The immediate focus is routine maintenance—diagnosing and fixing any bugs that surface and squeezing better performance out of the code, database, and AWS resources. I don’t have a current list of issues, yet I suspect the usual mix of edge-case errors and slow queries will emerge once you start profiling the system. You’ll get full access to the Git repository, SQL scripts, and our AWS environment (EC2, RDS, S3). A thorough walkthrough with the departing developer can be a...

Power BI – Talent Acquisition Control Tower & Executive Dashboard We are looking for an experienced Power BI Developer / HR Analytics Specialist to build a comprehensive Talent Acquisition Control Tower & Executive Dashboard. This is not a basic visualization project. We need a scalable recruitment analytics solution covering the full recruitment lifecycle: Requisition → Sourcing → Screening → HM Review → Interview → Selection → Offer → Acceptance → Joining → Closure The solution must support both daily recruitment operations and executive-level reporting. 1. Recruitment Overview & Demand vs Delivery Track: * Total Requisitions * Total Openings/Vacancies * Open / Closed / Hold / Cancelled * Sourcing / Interview / Offer /...

I have a production oracle instance that has grown beyond 100 GB and it now needs to live on SQL ,Server postgres sql . The task covers everything from preparing the source, mapping the schema, transferring the data, and validating that every object—tables, views, functions, and constraints—behaves exactly the same once it lands in SQL Server. Here is what I expect to walk away with: • A fully migrated SQL Server database, ready for cut-over • A repeatable migration script or SSIS/ADF/DMS pipeline so I can re-run the process for future refreshes • A concise migration report highlighting any datatype conversions, performance tweaks, and objects that required special handling • Verification scripts or queries that prove row counts, checksums, and refe...

I’m putting together a lightweight ERP foundation and need a clean, well-structured VB.Net solution that I can grow over time. The stack is fixed—VB.Net with DevExpress WinForms controls on the front end and PostgreSQL on the back. Core scope The project centres on three building blocks: a secure login screen, a ribbon-style main menu, and one fully functional CRUD form that will serve as the model for future modules. Authentication must recognise three separate roles—Administrator, Manager, and Employee—and enforce granular permissions once the user is inside the application. Main menu expectations After a successful login the user should land on a DevExpress-based menu that exposes the Reporting Module, Settings & Preferences, and User Management. Menu...

I need an Oracle APEX application that streamlines one of our internal business processes from start to finish. The focus is a clean, permission-based workflow that automatically routes each new record through a multistep approval cycle. At a minimum the app must: • Capture data through responsive APEX forms • Trigger an approval workflow the moment a record is submitted • Update status, log every decision, and prevent users from skipping steps When an approver acts, the system should move the item to the next stage, send the correct email or in-app notification, and maintain an audit trail we can export to CSV or view in a dashboard. I will provide table definitions and sample data; you’ll translate that into APEX pages, processes, and any PL/SQL packages req...

I’m kicking off a new healthcare patient-management system and the first critical piece is a rock-solid, compliant data layer. The entire scope at this stage revolves around database management—designing, building, and documenting a schema that can safely house patient records, appointments, clinical notes, and billing details while meeting HIPAA-level security expectations. Here’s what I need from you: • Analyse typical patient-care workflows and translate them into an efficient relational model. • Deliver an ER diagram, a fully normalised schema, and an indexing strategy suitable for high-volume queries. • Implement the model in the SQL engine you recommend (PostgreSQL, MySQL, or MS-SQL are all fine if they cover encryption-at-rest, robust backup, a...

I need a purpose-built IoT inventory platform that keeps every tool in my auto shop accounted for and instantly searchable from a tablet on the workshop floor. The interface has to feel at home on an iPad or similar device—large touch targets, quick loading times, and an offline-tolerant design so my technicians can still work if Wi-Fi drops for a moment. Core workflow Technicians will scan or tap a tagged tool, confirm where it is going, and the system updates our stock level and location log. When a tool hasn’t been returned or its quantity falls below a preset threshold, the platform should flag it on the dashboard and optionally push a notification. I’m open to common tag technologies such as BLE or passive RFID; the software just needs a clean way to map tag IDs to ...

I have a collection of well-formatted CSV files and a live SQL database that I need to turn into clear, insightful visuals. The core of this engagement is data visualization—using Python to translate rows and columns into plots, dashboards, or interactive charts that quickly communicate trends and outliers to non-technical stakeholders. You will have direct access to the structured data; most of it is already clean, so the emphasis is on choosing the right libraries (Pandas, Matplotlib, Seaborn, or Plotly—whatever suits the story best), crafting reusable code, and presenting the results in a concise, easy-to-update format. If you are comfortable adding light data-cleaning steps or basic statistical summaries along the way, that flexibility is welcome, but not required. De...

I have a growing file of U-S customer email records that first need to be keyed in accurately and then grouped into meaningful customer segments. The work starts with straightforward data entry—importing every record exactly as provided into a master spreadsheet or my HubSpot CRM—before moving on to customer segmentation that relies on one critical attribute: each contact’s Medical code. Once every line is in place, I’d like you to segment the list so I can target campaigns with precision. Feel free to use Excel, Google Sheets, or an SQL-friendly tool for the entry phase; for the segmentation itself, you can stay in the same environment or switch to Python / R if that speeds things up. Consistency and zero typos are essential because these addresses feed directly...

Developer Brief Build a secure, cloud-based sports performance data platform that consolidates data from multiple technology providers into one dashboard. This is an example dashboard I have built The initial scope is to integrate Catapult Sports, VALD, and Teamworks. The platform must support both API-based data ingestion and manual or automated uploads of Excel/CSV files. API connections should retrieve approved data on a scheduled basis, while spreadsheet imports should validate, map, and standardise fields before storage. Create a central database with a consistent athlete profile and identifiers, enabling data to be matched across systems. Athlete matching should prioritise unique IDs and verified email addresses, with an administrator review process for unmatched or duplicate rec...

I want to commission a full-featured hospital management system that natively integrates with the Ayushman Bharat Digital Mission (ABDM) stack. The application must streamline day-to-day operations for Out-Patient, In-Patient and Emergency departments while guaranteeing smooth data exchange with ABDM services such as Health ID creation, HIP/HIE-CM consent flows and e-prescriptions. Core modules I need: • Patient management covering registration, OPD/IPD admissions, discharge summaries and encounter history that can be shared via ABDM. • Inventory management for pharmacy and medical supplies with real-time stock, expiry and reorder alerts. • Billing & accounting that supports cashless, insurance and government scheme workflows, generates GST-compliant invoices and ...

En lo técnico necesito nivel sólido de React con TypeScript y buen manejo de SQL (consultas, esquemas, optimización básica). El punto clave es Claude Code: buena parte del código existente fue generado con esa herramienta, así que necesito a alguien que sepa leer y entender esas estructuras sin perderse, y que además trabaje con ella de forma eficaz — gestionando bien el contexto, iterando y revisando el output. No busco ni a quien la use a ciegas ni a quien la evite. Más allá del stack, valoro la autonomía: te doy el objetivo y lo resuelves. Entregas completas, sin dejar cosas a medias. Comunicación directa y rápida. Y criterio para decirme que algo está mal planteado antes de construirlo, no...

I’m rebuilding a web application from scratch and need a seasoned JavaScript developer who is equally comfortable on the browser and in Node.js. On the front-end I want clean, intuitive screens, a fully responsive layout, and smooth API integration. I’ll rely on you not only to code those pieces but also to show me the best way to push user-generated data up to a database. Server-side, you’ll wire everything together in Node.js and expose the endpoints the UI depends on. Part of the work involves calling Claude AI, so familiarity with its SDK, streaming responses, and prompt design will save us a lot of trial and error. I haven’t settled on a data store yet—SQL or NoSQL are both on the table—so I’d value your guidance on choosing and provisio...

Senior Data / AI Engineer - Marine Data, APIs, Web Scraping & Machine Learning We are building a new AI-powered technology platform that works with large amounts of marine, oceanographic, weather, environmental, geographic and destination data. We are looking for a strong Data / AI / Machine Learning Engineer to help build the data and intelligence infrastructure behind the platform. This is not primarily a frontend or UI development role. We need someone who is very comfortable working with large datasets, APIs, web scraping, automated data pipelines, geospatial data, historical and forecast data, oceanographic datasets, and scoring/recommendation models. Experience working with marine weather, oceanographic, coastal or environmental data is a major advantage. What you will work...

We are looking for an experienced Software / System Architect to design and review the architecture of a closed-loop financial platform. The platform includes user accounts, balances, transactions, deposits/withdrawals, trading, payments, wallet functionality, and administration. We already have a development team and an existing system. We need an architect who can review the current setup, identify gaps, design the overall system architecture and flows, and provide clear technical guidance and architecture documentation for our developers. Experience with FinTech, payment systems, trading platforms, digital assets, banking, or other transaction-heavy financial systems is highly preferred. Please share relevant architecture experience and examples of similar systems you have worked on...

I am building an end-to-end Python solution that automatically ingests, processes, and reports on financial data pulled from CSV files, SQL databases, and live APIs. Clean, well-structured, and easily maintainable code is essential because the system will be extended over time. Scope of work You will take the project from initial design through deployment. That includes setting up the data-collection pipeline, writing transformation and analysis modules, implementing robust error handling and logging, building unit / integration tests, and preparing a production-ready deployment script or container. The stack is entirely Python, so I expect idiomatic use of tools such as pandas, SQLAlchemy, asyncio, and, where it adds value, lightweight AI/ML components for anomaly detection or forecast...

Cloud Pricing Validation & Test Automation Framework Designed and developed an end-to-end Python automation framework to scrape and validate cloud pricing data from AWS and Azure platforms. Built Selenium-based UI automation using the Page Object Model (POM) and PyTest framework to validate pricing calculators, search functionality, filters, and region selection. Implemented API validation using the requests library to compare pricing data with scraped UI data. Automated data storage in SQLite and performed SQL-based validation for duplicates, missing values, and historical price comparison. Generated HTML execution reports, detailed logs, CSV/Excel summaries, and dashboards to monitor pricing changes and regression results. Integrated modular architecture with reusable utilities, con...

SAP S/4HANA Greenfield Implementation for Procure-to-Pay (P2P) Description Implemented end-to-end SAP S/4HANA solution using SAP MM for procurement and inventory processes, ensuring seamless system transition with high data accuracy. Roles &Responsibilities ? Configured end-to-end Procure-to-Pay (PR, PO, GR, LIV) in SAP S/4HANA, improving procurement efficiency by 20%. ? Designed and configured pricing procedures and account determination (OBYC), reducing invoice mismatches by 25%. ? Set up enterprise structure and master data (Material Master & Business Partner) for procurement processes. ? Executed data migration using LSMW/Migration Cockpit with 99% data accuracy. ? Implemented subcontracting and consignment processes for complex procurement scenarios. ? Ensured seamless cross-m...

CORE-103 Data & SQL Foundations. 10 topics. Almost every system these students build or support will store its data in a relational database, and almost every serious production incident involves one. From what a database is for through querying, joins and aggregation to schema design, transactions and indexing. Real time goes to reconciliation - checking that a query returned the RIGHT answer rather than a plausible one - because a wrong number delivered confidently is worse than no number at all. Note: this course shares ground with DB-101, the Databases track foundation, at a much shallower depth. You will be asked to coordinate with that trainer so the two reinforce rather than repeat each other. THE 10 TOPICS — FIXED 1. What a database is for (6 h) - persistence, con...

I have a dataset that must be loaded into our online database without errors and, at the same time, I want the source text that accompanies each record rendered in both Spanish and simplified Chinese. All source material is in English and arrives as clean text files; your job is to: • Populate every field in the database exactly as specified in the schema I will share (SQL-based back-end with a web form for input). • Translate the English content into Spanish and Chinese before the final save, keeping sentence structure natural and industry terminology consistent. I will give you step-by-step screencasts on how to access the system, a glossary of preferred terms, and a small test batch so we can confirm quality. I expect native-level accuracy in both languages, correct char...

I’m looking for onsite training in Oracle Fusion Cloud Procurement who is located in Bangalore near by electronic city. I'll be coming to your location to learn any project you have done on below mentioned modules. My immediate focus spans the following functional areas: • Supplier Management • Sourcing • Procurement Contracts • Self Service Procurement . integrations Day to day, I may ask you to review or adjust existing configurations, troubleshoot workflow or approval issues, walk me through best-practice setups, and document any changes so I can maintain them moving forward. Clear explanations, quick turnaround on questions, and the ability to share screens while we work through solutions will be essential. If you have proven experience guidi...

Analyzed sales data using Excel, SQL and Power BI to identify sales trends, top-performing products, revenue insights and business performance. Created an interactive Power BI dashboard with KPIs and visualizations to help users understand the data and make better business decisions.

I have a two-part project that blends data science with creative rendering. First, I need to mine our operational data to uncover clear, actionable insights that will streamline internal workflows. You’ll have direct access to our raw logs and performance metrics; from there, I’m expecting clean data pipelines, exploratory analysis, and models or dashboards that highlight where we can cut cycle time, reduce error rates, and better allocate resources. Python (Pandas, scikit-learn), SQL, or a similar stack is ideal, but I’m open to the tools you find most efficient as long as the findings are reproducible and clearly documented. Second, I want a series of polished 2D and 3D character renders that visualize key personas involved in those optimized processes. Think engagin...

I have several enterprise-scale integration and data-migration initiatives kicking off right now and need an Azure Data Factory specialist who can jump in immediately for at least the next two months. The work centres on building, troubleshooting and optimising ADF pipelines that: • extract data from SQL Server and other database engines, plus a range of APIs (including Salesforce and S3 endpoints), • apply complex, rule-driven transformations, and • load cleansed results into a variety of target systems. You will own the whole lifecycle—from designing linked services and parameterised datasets, to writing highly-tuned SQL, to setting up monitoring and alerting so everything runs reliably at scale. I’ll look to you to surface and solve performance issues ...

We are seeking an experienced Full Stack Developer to support the development and enhancement of modern web applications. The ideal candidate will have strong experience building scalable front-end and back-end solutions, developing APIs, working with databases, and collaborating with engineering teams to deliver high-quality software. The role involves developing and maintaining user-facing applications using technologies such as React, Angular, Node.js, .NET, or Java. Responsibilities include building and integrating REST APIs, working with SQL and NoSQL databases, troubleshooting application issues, improving existing features, participating in code reviews, and supporting continuous improvement of development practices. Experience with Git workflows and cloud deployment environments...