Sql jobs

We are seeking a skilled data analyst to assist with the following tasks: - Data cleaning and preprocessing, including handling ...following tasks: - Data cleaning and preprocessing, including handling missing values and duplicates. - Conducting Exploratory Data Analysis (EDA) to identify trends and actionable insights. - Building interactive dashboards and reports using Power BI. - Generating actionable business insights to support decision-making. Preferred Tools/Software: - Excel (advanced formulas, pivot tables) - SQL (data extraction and querying) - Python (Pandas, NumPy, Matplotlib) - Power BI The project is expected to be completed within 2 to 3 weeks, depending on complexity. The fixed budget for this project is ₹20,000, with slight flexibility based on scope and ...

This is a structured research and data entry project involving the review of established medical guidelines and the construction of standardized content entries based on those sources. Work will be completed using a detailed instruction manual, predefined formats, and example outputs to ensure consistency and accuracy. The role requires strong attention t...attention to detail • Experience with research and information synthesis • Ability to follow precise written instructions • Comfort working with structured data and templates • Familiarity with evidence-based professional sources/guidelines • Basic data entry experience • Organizational and analytical skills • Comfort using modern digital tools for research and workflow support • Familiarity with ...

Looking for SQL expert who has experience with the stored procedures to debug and fix the errors

I’m building a self-hosted, fully offline education portal that brings career development and personal well-being under one roof. The site will house technical courses—SQL, Excel, Python, Java, Power BI, AI, LLMs, and other trending skills—alongside sections dedicated to aptitude training, gym routines, yoga, and meditation. Visual direction • Overall look: relaxed and friendly so newcomers feel welcome, yet clean enough for seasoned professionals to navigate quickly. • Home page must spotlight Course categories first; everything else can flow beneath or be reached from secondary navigation. Brand identity Alongside the site, I need a logo that communicates professionalism and expertise while still echoing our vision of continuous learning and...

...have a collection of fully structured datasets already living in a Databricks workspace and now need a clean, scalable schema that takes advantage of Databricks SQL in a cloud-based environment. The work involves analysing the existing tables, proposing an optimal relational model, and then producing the physical DDL so I can deploy everything straight into Databricks. Key goals • Normalise the data where it makes sense, but stay pragmatic for query performance. • Define primary and foreign keys, partitioning and clustering strategy suited to Spark execution. • Provide clear, version-controlled DDL (Databricks notebooks or .sql files) plus an ER diagram so future teammates can understand the design quickly. Acceptance criteria – All tables ...

My Access split database has grown past the 2 GB limit; once that happened it slowed to a craw...Reduce the file size or otherwise restructure the data so we stay safely under 2 GB. • Re-link the front-end and confirm forms, queries, and reports run at normal speed over the network. • Provide a concise summary of the steps taken so I can maintain the solution. I can supply the front-end file, the problem back-end, and remote access to the network share. If you think migrating tables to SQL Server Express, archiving old data, or another approach would be cleaner, I’m open to your recommendations. Let me know how long you’ll need and which tools you prefer (VBA, Jet Compact Utility, ACE OLEDB, etc.). I’m eager to get this database stable and responsiv...

I need help recovering data from an SQL database that has been corrupted. The specific issue is metadata corruption. Ideal candidates should have: - Extensive experience with SQL databases. - Proven track record of resolving metadata corruption issues. - Strong problem-solving skills and attention to detail. - Ability to work within budget and provide timely updates. Please provide relevant experience in your bids.

Thousands of lines of T-SQL that once worked are now returning incorrect results. I need a fresh set of expert eyes to comb through the entire script, pinpoint exactly where the logic breaks down, and fix it. The code lives in SQL Server. While you work through the main script, I also need you to cascade several hundred new parameters into a series of dependent stored procedures. These procedures already compile; they simply require the additional parameters to be wired through correctly so downstream calculations stay consistent. What I expect from you: • A clean, corrected version of the original query and any touched procedures • A concise change log explaining the root cause of the logical error and how you resolved it • Updated stored procedures with...

From Pakistan or India. My team is extending an existing ASP.NET Core web application and I’d like a junior-level developer to handle a stream of bite-sized tasks. Typical work will include: • Twea...request with a concise summary • Proof that the change meets the ticket’s acceptance criteria • No new warnings or test regressions Acceptance is based on my code review, automated test pass, and adherence to the provided guide. We’ll collaborate via Slack, and I’ll be available for questions and mentorship, but I expect you to know the ASP.NET MVC/Core pipeline, basic HTML/CSS/JavaScript, SQL Server, and Git. If you’re eager to build real-world skills, communicate clearly, and turn around small features promptly, I’m ready to...

...through your architecture, toolchain, and deployment process so I can replicate or extend the project later. Core expectations • Native Android build (Kotlin or Java with Android Studio). • Standard social features—user registration/login, profile editing, posts with images/video, likes/comments, and real-time notifications. • Secure back-end (Firebase, Supabase, or a lightweight REST API with SQL) and cloud storage for media. • Clear documentation: project setup, key code sections, and build/submit steps for Google Play. • A live demonstration on an emulator or device and a Q&A session so I can ask “how did you build this?” and get practical, hands-on guidance. Please outline your proposed tech stack, any reusable librar...

...every visual. • Drill-through or drill-down so a supervisor can jump from a plant summary into an individual sewing line, then right into an operator if the data exists. • Clean, executive-level visuals that someone can read on a shop-floor screen or in a board meeting without extra explanation. Data will come from our existing production sheets; I can supply CSV exports or connect you to our SQL server—whatever you prefer. Once the model is in place, I’ll look for simple ways to refresh it (Gateway, scheduled refresh, or other). Acceptance criteria – Line-wise pieces produced, efficiency %, and quality rate in one interactive view – Daily snapshot plus week-to-date and month-to-date filters that perform quickly – Responsive lay...

...but the payment step can stop at a confirmation screen—no real gateway hookup for now. • Basic database layer to store products and capture mock orders so I can review them in an admin view or via simple SQL queries. • Clean code structure that I can later extend into a full production build. Tech is flexible—React, Vue, or a templated PHP/Node stack all work for me as long as the final site loads quickly and is easy to maintain. I’m open to your preferred framework and any boilerplate you’ve proven on past jobs. Deliverables 1. Source code with clear README for local setup. 2. SQL export or migration scripts for sample data. 3. Deployed demo link (Heroku, Vercel, shared cPanel, etc.) I can click through. 4. Short hand-off call...

I need a Python script to analyze tachograph data stored in a database. The focus is on rest period analysis using standard regulations. Key requirements: - Analyze rest periods/shifts based on standard regulations - Output results in a readable format - Create infrigments Ideal skills: - Proficiency in Python - Experience with database handling (SQL) - Knowledge of tachograph regulations and analysis Please share relevant experience and approach.

...The goal is to merge historical and live feeds into a unified warehouse, run advanced modelling on top of it, and expose the results through interactive dashboards and an API other products can tap into. Scope of work • Set up or connect to reliable data sources, normalise them, and design an extensible schema that copes with multiple sports and rule sets. • Develop the ETL pipeline (Python, SQL, Spark or a comparable stack) to ingest, clean, and enrich the data in near-real-time. • Build an analytics layer capable of producing player performance metrics, match summaries, and cross-sport comparisons. Predictive models for injuries, form slumps, or race outcomes are a plus. • Create a lightweight front end or embed visualisations (Tableau, Power BI, Pl...

...approximately * 4 POST * 1 UPDATE * 3 GET * GET APIs required for vendor info, vendor list, and DC code/description lookups Required skills: * Oracle EBS R12 / R12.2/ R14, Fusion * Strong techno-functional knowledge * Strong P2P cycle knowledge * Hands-on in vendor onboarding / supplier creation * Hands-on in GRN / receiving / purchasing integrations * Experience in Oracle EBS APIs, interfaces, PL/SQL, custom packages * Able to understand external payload mapping and deliver quickly Expected responsibility: * Requirement study and field mapping * Create Oracle EBS APIs/services * Handle validations, error logging, and response structure * Support testing and deployment * Work closely with our React/application team Timeline: * Immediate interview * Start from next d...

We’re on the lookout for a Nintex Developer / Workflow Automation Specialist to join our dynamic team! If you’re passionate about workflow automation, process efficiency, and smart solutions – this role is for you! Apply today and help us build smarter business processes! Role Summary: We’re looking for a Nintex-focuse...notifications, data routing, and integrations • Basic understanding of JavaScript, APIs, or expressions (for advanced workflow logic) • Good communication skills (you’ll work closely with non-technical users) Nice to Have (Bonus) • Experience with Power Automate / Power Platform • Experience with SharePoint administration or customization • Experience integrating with external systems (REST APIs, SQL, etc.) &...

We need a developer experienced in database analysis and data migration to help extract and restructure data from an existing question bank dataset. Our platform already has a defined hierarchi...extracted content into our existing hierarchical schema. 4. Ensure the following elements are preserved: • Question IDs • Answer options • Correct answers • Explanations • Tables • Images/media references 5. Export the processed data into a format compatible with our platform (JSON or SQL). Requirements Please include in your proposal: • Experience with database analysis or data extraction • Experience with data transformation / migration • Familiarity with structured formats such as JSON / SQL • The tools or approach you ...

...a robust preprocessing pipeline that feeds seamlessly into our future predictive models. The end-goal for this phase is clear: extract insights that help us validate product hypotheses and impress early pilot partners. We move fast—ASAP delivery is non-negotiable—so I’m looking for someone who can jump in, spin up notebooks, and iterate daily. Expect to work with Python (Pandas, NumPy, SciPy), SQL, and ideally Spark for the heavier ETL steps; experience deploying workflows on AWS or GCP is a plus because we’ll be productionising soon. Deliverables • Cleaned, well-documented datasets ready for downstream modelling • A reproducible preprocessing pipeline (scripts or notebooks + environment files) • An insights report highlighting key t...

...would be: “Show me the growth in March vs February” or “Which categories were above average last quarter?” The bot should reply with concise text explanations plus optional charts or tables, ready for copying into reports or dashboards. Data will arrive in CSV or through a direct connection to our existing store platform; the solution should comfortably handle either method. Python with pandas, SQL, or a similar stack is fine as long as the response time stays near real-time. Feel free to integrate an LLM or retrieval-augmented generation layer so the conversation feels natural and follow-up questions are understood in context. Deliverables • A working chatbot deployed to a simple web interface or Slack channel • Source code and environment...

I’m building a self-hosted, fully offline education portal that brings career development and personal well-being under one roof. The site will house technical courses—SQL, Excel, Python, Java, Power BI, AI, LLMs, and other trending skills—alongside sections dedicated to aptitude training, gym routines, yoga, and meditation. Visual direction • Overall look: relaxed and friendly so newcomers feel welcome, yet clean enough for seasoned professionals to navigate quickly. • Home page must spotlight Course categories first; everything else can flow beneath or be reached from secondary navigation. Brand identity Alongside the site, I need a logo that communicates professionalism and expertise while still echoing our vision of continuous learning and...

...layer designed around a hybrid model—relational tables for structured, transactional data alongside a NoSQL store for high-volume or schemaless collections—so familiarity with both SQL (PostgreSQL or MySQL) and something like MongoDB, DynamoDB, or Firestore is essential. I already have product requirements mapped out; what I need from you is: • A scalable architecture diagram showing tenancy isolation, shared services, and CI/CD flow • Implementation of the core multi-tenant framework (user provisioning, tenant onboarding, permission engine, billing hooks) • Database schemas and migration scripts for the SQL side, plus collections and indexing strategy for the NoSQL side • Containerised deployment (Docker / Kubernetes or similar) wit...

The page at suddenly refuses to reach my MySQL database. Instead of a clear SQL error, it simply “does not connect,” leaving the form unusable. I have not touched the username, password, host, or database name, and I have yet to test other scripts on the same server. I need you to: • Inspect the existing PHP connection logic on (and any included config files) • Identify why the connection fails and correct it so the page inserts data again • Document the exact fix you apply so I can replicate it elsewhere if needed Please be comfortable troubleshooting classic PHP-MySQLi (or PDO) code, checking server logs, and confirming that the final page loads without warnings or notices. Once your fix is in place, I’ll verify the form submits successfu...

...management - Job alerts Subscription & Payment - Subscription plans for employers and employees - Payment gateway integration (Razorpay / Stripe / PayU or similar) - Payment history and subscription status Admin Panel - Manage users - Manage jobs - Manage subscriptions and payments - Reports and analytics Technical Requirements: - Backend: ASP.NET Core Web API - Frontend: - Database: SQL Server / PostgreSQL - Authentication: JWT + OTP verification - Payment Gateway Integration - Clean architecture and scalable code Preferred Skills: - Experience developing Job Portal or Marketplace platforms - Knowledge of REST APIs, security, and scalable architecture - Experience integrating payment gateways and OTP services - Good UI/UX understanding Deliverables: - Complete sou...

...a project-style gallery or dashboard that showcases trading instruments in real time, and a Contact form so users can reach support without leaving the page. The front end has to be modern, fast and responsive—React, Vue, Svelte or a similar framework is fine as long as it renders smoothly on desktop and mobile browsers. For the back end, I lean toward Node.js/Express or Python/Django with a SQL or NoSQL database to store user profiles, order history and configuration data. Real-time market quotes should stream through WebSockets from a third-party API, and every sensitive request must pass through HTTPS with the usual encryption, rate-limiting and input validation in place. I will consider the job complete when the source code is delivered, runs error-free on my VPS ...

...betting platform and want a qualified ethical hacker to run a full-scale penetration test against the public-facing web application. The priority is website & application-level weaknesses, so I expect you to probe everything users can touch: signup, log-in, wallets, odds display, live bets, admin panels behind authentication—every feature that might be exploited. Please include the usual suspects—SQL injection, XSS, CSRF, IDOR, authentication bypass, file upload issues, business-logic flaws—essentially the OWASP Top 10 and anything else you uncover during your manual and automated reconnaissance. Black-box testing is preferred at first; if you later need limited credentials for deeper inspection we can arrange that. Deliverables I need: • A concise ex...

...handling, outpatient/inpatient admission – Clinical records: SOAP notes, lab and radiology results upload – Pharmacy & prescription fulfilment linked to the doctor’s module – Billing with payment-gateway integration – Back office: inventory, accounting interface, and management information reports Deliverables 1. Fully functional CI4 source code with clean MVC structure and comments 2. SQL scripts for database schema and seed data 3. Installation guide plus a concise user manual Acceptance criteria • Role-based access control enforced for Admin, Doctor, and Patient • Responsive interface (Bootstrap 5 or similar) • All CRUD operations implemented through CI4 models and controllers • Reports exportable to...

...certificate pinning issues. Client-Side Injection: Test for vulnerabilities like SQL Injection in local databases or Cross-Site Scripting (XSS) in WebViews. Broken Authentication & Session Management: Test for weaknesses in login, logout, session handling, and credential management on the client side. Code Obfuscation & Reverse Engineering Resistance: Assess the difficulty of reverse-engineering the application. 2. API / Server-Side Testing: API Endpoint Discovery and Mapping: Identify all API endpoints used by the mobile application. Authentication & Authorization Flaws: Test for broken object-level authorization (BOLA/IDOR), broken function-level authorization, and other access control issues. Injection Attacks: Test for SQL Injection, NoSQL Injection, Comma...

I have a SQL Server view that already aggregates every validation script we run on raw_valid and model_valid. What I now need is the front-end: an interactive Power BI dashboard built in a tabbed interface that surfaces those scripts, lets users explore them, and provides both basic text search and advanced filtering. Connection & data model • Connect directly to the existing view (read-only). • Expose the script name, object type, target table, last run date, status, and the full script body or a hyperlink to it. • Optimise the model so the dashboard opens quickly even when the view grows. Visual & navigation requirements • Two main tabs—one for raw_valid scripts, one for model_valid—each mirroring the same layout for consis...

Freelance BlueYonder WMS Developer (MOCA, SQL, Java) — End-to-End Ownership We’re looking for an experienced freelance or contract BlueYonder WMS Developer to take full ownership of customizing and enhancing warehouse transaction workflows. This is a hands-on role requiring someone who can independently design, implement, test, and support WMS logic in a live operational environment. This is not an integration-only role — the work is focused on modifying behavior inside WMS transactions, including allocation, picking, receiving, and putaway logic. Key Responsibilities Design and implement custom business logic directly within BlueYonder WMS using MOCA commands Extend and enhance existing transaction flows such as allocation, picking, receiving, and putaway Devel...

...login: the platform must enforce Multi-Factor Authentication (MFA) out of the box. • Multi-tenant control panel: I should be able to onboard a new school in minutes, assign a custom sub-domain/logo/theme and manage licence limits without touching code. • Clean UI built on Bootstrap (or similar) and responsive for mobile. Mobile App in React native Deliverables 1. Source code and SQL scripts (MS SQL preferred) with clear layer separation (DAL, BLL, UI). 2. Database schema capable of true multi-tenancy. 3. Installation guide plus step-by-step video walkthrough. 4. Post-deployment support for initial bug fixes (30 days). Acceptance will be based on: – All listed modules working end-to-end for at least two demo schools on the same server. &...

My production web application needs a quick but thorough round of bug fixing and performance tuning. I am seeing issues on both the frontend and the backend, so I need someone who can dive into each layer...database response time (before-and-after metrics) 3. Polished layout with fully responsive behavior 4. A concise report summarizing the changes, tests performed, and recommended next steps I’d like to wrap this up within the next day or two. When you reply, please include a brief note on similar projects you have handled, the tools or approaches you used (e.g., Chrome DevTools, Lighthouse, SQL profiling, caching strategies), and any quick observations you have based on the description above. Clear, timely communication is essential—let’s get this app r...

...customize). TECH STACK REQUIREMENTS - Backend language: Python 3.10+ - Backend framework: FastAPI - Database: PostgreSQL (via asyncpg, raw SQL — no ORM) - AI/LLM: OpenAI API (GPT-4.1 or later) - Embeddings: OpenAI text-embedding-3-small - Vector DB: Pinecone - Encryption: AES-256-GCM (Python cryptography library) - Frontend framework: React (Create React App) - Graph editor: React Flow - Styling: Plain CSS (no Tailwind, no CSS-in-JS) - Language: JavaScript (no TypeScript) - Primary accent color: #5616ea DELIVERABLES 1. Backend module — A self-contained Python package/directory with: - All route handlers (FastAPI routers) - Database models and migration SQL scripts (CREATE TABLE statements) - Execution engine - AI generation pipeline - MCP cli...

We are seeking an expert Full-Stack Developer to design and build a complex SaaS platform similar to PassKit. This platform will allow our clients (merchants) to create, manage, and distribute digital loyalty cards directly to their customers' Apple Wallet and Google Wallet. This is not a simple website project. It requires deep knowledge of mobile wallet APIs, cryptogra...Preference: Backend: PHP 8.x (with PDO) or Node.js. Database: MySQL. Frontend: Clean HTML/CSS/JavaScript (or a framework like React/Vue). Required Qualifications: Proven Experience with Apple PassKit (server-side pass generation) and Google Wallet API. Deep experience with Stripe API (specifically Subscriptions/Billing). Solid understanding of security best practices (SSL, data encryption, SQL injecti...

...for location, domain and date posted. • Study Resources: simple area where PDFs, slides or links can be attached and displayed. • Interview Preparation: page that outlines what a good interview looks like and shows pricing tiers for mock-interview services (static content is fine). Technical notes • Clean, commented code so I can explain it during my presentation. • Database schema in .sql file plus sample data for at least five internships, one admin and two companies. • Session-based login; password hashing is a must. • A short README that walks me through setup and how to add more internships or resources later. Deliverables 1. Full source code (HTML, Java, PHP), MySQL dump and README. 2. Quick video or screenshots showing the sy...

I need a small, clean script that connects to my MySQL instance, pulls the user-related tables I specify, and runs a concise analysis on that data. Typical insights I care about include daily sign-up trends, active-versus-inactive ratios, cohort retention, and any outliers worth flagging. The w...then return or print the results in a readable format (JSON or a simple report is fine). Please keep the code modular so I can extend it later. Deliverables • Source script with clear connection parameters abstracted for security • Brief setup/readme so I can run it locally or on a server • Sample output file showing the analysis results I’m flexible on language—Python with pandas or SQL-native procedures both work—as long as the solution is l...

I need to add a few new capabilities to an existing PHP script so it ha...a step-by-step brief for each enhancement. At a glance, the expansion involves: secure database interactions using PDO, a lightweight REST-API call, and a small HTML form whose data is validated, stored, and echoed back to the user. Please keep the code PSR-12 compliant, well commented, and organised in clearly named classes or functions. Deliver the updated files, a concise changelog, and any SQL needed for new tables. Acceptance criteria • Script installs cleanly on my staging server. • All new features behave exactly as documented and pass my test cases. • No breaking changes to existing functionality. Let me know your estimated turnaround and links to any similar PHP extension work ...

I need to add a few new capabilities to an existing PHP script so it ha...a step-by-step brief for each enhancement. At a glance, the expansion involves: secure database interactions using PDO, a lightweight REST-API call, and a small HTML form whose data is validated, stored, and echoed back to the user. Please keep the code PSR-12 compliant, well commented, and organised in clearly named classes or functions. Deliver the updated files, a concise changelog, and any SQL needed for new tables. Acceptance criteria • Script installs cleanly on my staging server. • All new features behave exactly as documented and pass my test cases. • No breaking changes to existing functionality. Let me know your estimated turnaround and links to any similar PHP extension work ...

Please Sign Up or Login to see details.

...a well-structured historical dataset that I can drop straight into my models without hours of manual cleanup. Here’s what I’m after: • Daily (or finer) OHLCV prices, fully adjusted for corporate actions, splits, and dividends. • Consistent symbol mapping so delistings, mergers, and ticker changes don’t break the series. • A single, tidy delivery format—CSV files are fine, but a lightweight SQL or Parquet database also works if you prefer. • A short README that explains field definitions, adjustment methodology, and any known data caveats. If you already have a reliable data pipeline in Python, R, or another language, feel free to leverage it; just make sure the final output is easy for me to import into pandas. Accuracy and comp...

Both of my access-control platforms—System A (Suprema's Biostar X) and System B (dormakaba's Matrix Professional)—sit on the same Windows server and share a local MS SQL instance. Each exposes a REST API, yet today they operate in silos. I need a seamless, bi-directional integration so that any change to a person or employee record in one system is reflected in the other almost instantly. Scope of the sync • Core identity fields: name and unique ID • Credential data: RFID card number and state • Biometric assets: fingerprint templates • Media: profile picture • Security attributes: access-level permissions Key requirements 1. Real-time operation (sub-second latency acceptable). 2. Conflict-resolution logic—latest...

...fixing issues. Michigan Technological University Michigan Technological University +4 2. Key Technical Responsibilities Writing Efficient Code: Creating clean, maintainable, and well-documented code. Debugging: Identifying and fixing errors in existing software. Version Control: Using tools like Git and GitHub to manage code changes. Database Management: Designing and managing data structures using SQL or NoSQL databases. System Optimization: Ensuring high performance, scalability, and security. Cloud Computing: Developing services delivered via platforms like AWS, Azure, or GCP. Michigan Technological University Michigan Technological University +4 3. Specialized Roles Frontend Development: Focusing on the user-facing side, building interfaces using HTML, CSS, React, or Vue....

...experience in SQL programming and Python scripting • Experience with ETL processes, data modeling, and data warehousing concepts • Familiarity with version control systems (Git) and DevOps practices • Strong communication skills to collaborate with cross-functional teams • Bachelor's degree in Computer Science, Information Technology, or related field Deliverables: • Design and implement scalable data solutions on Azure platform • Develop ETL processes using Azure Data Factory for data ingestion and transformation • Create data processing solutions using Azure Synapse Analytics • Utilize Azure Databricks for advanced analytics and large dataset processing • Provide regular project updates and collaborate with stakeholders • ...

...on ETL processes, data analytics, and collaborate with cross-functional teams to deliver scalable data engineering solutions. Requirements: • Strong experience with Azure Data Factory (ADF) for ETL processes • Proficiency in Azure Databricks for advanced analytics • Hands-on experience with Azure Data Lake Storage (ADLS) • Experience with Azure Synapse Analytics for real-time analytics • Strong SQL skills for querying and database optimization • Python programming for scripting and automation • Experience with data modeling and data warehousing concepts • Excellent communication skills to work with stakeholders • Bachelor's degree in Computer Science or related field Preferred: • Microsoft Certified: Azure Data Engineer Ass...

...to join our team for full-time contract work supporting data engineering and ETL development projects. Requirements: • 7+ years of experience with Informatica Data Engineering, DIS and MAS • Strong expertise in Databricks and Hadoop ecosystems • Proficiency with relational SQL and NoSQL databases (Azure Synapse, SQL Server, Oracle) • Experience with major cloud platforms (Azure, AWS, or Google Cloud) • Knowledge of Agile methodologies and tools like SCRUM, TFS, and JIRA • Advanced SQL skills including T-SQL and PL/SQL • Experience building and optimizing big data pipeline architectures • Hands-on experience developing both batch and real-time workloads • Knowledge of Data Lake and dimensional data modeling ...

We need an experienced MuleSoft developer to work on integration solutions connecting various systems and databases. Requirements: • 4+ years of experience with MuleSoft Anypoint Platform/Studio • Strong experience connecting MuleSoft APIs with Azure SQL, Azure Blob, and Snowflake • Proficiency with REST and SOAP web services • Strong working knowledge of JSON and XML data formats • Experience with Agile and waterfall project management methodologies • Excellent problem-solving and analytical skills • Strong communication and presentation abilities • Must be available to work 12pm - 9pm IST, Monday through Friday • Immediate availability or maximum 15-20 days notice period Deliverables: • Design and develop MuleSoft integration sol...

...trail verification Non-Functional Testing • Load testing • Performance testing • Stress testing • Scalability testing • Concurrency testing • Stability and reliability testing Security Testing • Vulnerability assessment • Penetration testing • Authentication and authorization validation • Role-based access control testing • Session management testing • Input validation checks • Protection against SQL Injection, XSS, CSRF Integration & Data Testing • Data consistency and reconciliation • Error handling and retry mechanisms ERP-Specific Controls • Financial data integrity • Transaction consistency • Approval workflows • Multi-user / multi-company scenarios • Compliance and audit ...

...feature that slots straight into the existing codebase. The other tweaks are straightforward logic or display adjustments—nothing structural, no schema changes, and certainly no rebuild. The code is plain PHP with direct SQL (no frameworks). A solid grasp of PHP, MySQL, and rapid debugging will let you dive in, trace the current flow, and wrap things up fast. Once we’ve talked through the exact lines to touch, I’ll share the repository and a database dump so you can run it locally. Deliverables • Updated PHP files with the new feature and minor fixes implemented • Any revised SQL queries or scripts • A concise change log confirming that every existing function still performs without errors The ideal turnaround is within a day or tw...

I need a centralized storage solution for structured data with defined access controls. The data should be accessible via direct database access. Requirements: - Design and implement a centralized database solution - Ensure secure, defined access to the data - Provide direct database access for querying Ideal Skills and Experience: - Expertise in database design and mana...for structured data with defined access controls. The data should be accessible via direct database access. Requirements: - Design and implement a centralized database solution - Ensure secure, defined access to the data - Provide direct database access for querying Ideal Skills and Experience: - Expertise in database design and management - Experience with data access security - Proficiency in SQL and databas...

...large, highly-granular data set into a single, dynamic dashboard focused on monitoring key operational-efficiency KPIs. Here’s the landscape you will step into: our raw information sits in both SQL databases and a series of regularly exported Excel/CSV files. I want a model that connects to each source, transforms the data so that it’s truly analysis-ready, and then visualises the metrics that matter—cycle times, throughput, bottleneck alerts, utilisation rates and any supporting drill-downs we decide to add. Scope of work • Build or optimise the data model, including merge logic between SQL and CSV tables, DAX measures, and relationships that guarantee a fast, responsive user experience even when the data volumes climb. • Design an intu...

...responsive layouts that work on desktop and tablet. I am open to any mainstream stack—React, Vue, Svelte or similar—as long as it stays JavaScript throughout and keeps load times low. Back-end & Data All existing tables and relationships should be migrated to MySQL. Any Access macros or VBA logic need to be rewritten in JavaScript (Node.js or serverless functions are both acceptable). Please keep the SQL portable so I can host on a standard cloud instance. Deliverables • Complete source code for front end and back end • MySQL schema and migration scripts • A one-click setup guide (Docker compose or similar is fine) • User manual covering the equivalent of each Access form/report • Final walk-through on Zoom to verify every fe...