Sql jobs

...users. Secure the bot (rate limiting, validation, protection against common mistakes). Help with deployment and configuration on my server (or recommend best option). Tech stack Node.js Telegraf (Telegram Bot API) PostgreSQL Experience with crypto / USDT flows is a big plus. What I’m looking for Someone who has built Telegram bots with real users before. Strong experience with Node.js and SQL databases. Can write clean, well-commented code and suggest better architecture if needed. Good communication in English and able to give regular updates. When you apply, please mention Examples or links to Telegram bots you have built. Briefly what you would check first when you see the existing code. Your estimate (rough) for time and cost to take this bot from curren...

The trip-planning site at is already well underway, and I hold the full source code. Unfortunately, the previous developer left...After that we will tackle the functional and UI pieces one by one until the product is finished. Speed matters—I’d like to move ASAP—but clarity and security come first. If you are comfortable with ASP.NET MVC, C#, Entity Framework, Bootstrap/HTML/CSS, and disciplined version control practices, let’s start by agreeing on the initial audit and go from there. Back end is SQL Server 2008 R2, but could possibly switch to SQL lite. It is a booking and trip management system for my charter bus company. Lots done but lots still missing, First task is to make every there working flawless less, good UI, no bugs. No beginner...

I need a full-stack website that lets visitors request our “Cloud” home service and gives me a robust admin panel to run everything behind the scenes. The site has to be deployed on Microsoft Azure, so please structure the code and infrastructure (App Service, SQL/NoSQL, storage, CI/CD if you prefer) accordingly. Front-end • Modern, responsive landing page that explains the service and captures leads or direct bookings. • Clean contact/booking form with validation and confirmation emails. Admin panel requirements • User management (create, edit, suspend customers and staff). • Service booking management with status updates, filters, and search. • Analytics & reporting—at minimum daily/weekly booking counts and user stats, ...

...More specifically, I need insight on: • Page views and navigation paths — where users enter, where they drop, and the common journeys in between • Interactions with elements (clicks, scrolls) — which buttons, links, or sections grab attention and which are ignored Raw data can be delivered in GA4, server logs, or CSV form; you pick the environment you feel most comfortable in (Python, R, SQL, BigQuery, or a BI tool such as Tableau, Power BI, or Looker Studio). I expect you to handle cleaning and modeling, run the exploratory analysis, and wrap up with a concise report or dashboard that highlights the key findings along with action-oriented recommendations. Acceptance criteria • Reproducible code/notebook or documented query set • Visual...

...strategy for moving an existing application from the Borland Database Engine to FireDAC with SQL Server as the back end. The objective is full modernization: cleaner code, easier maintenance, and freedom from legacy BDE constraints. I will spin up a dedicated testing environment first, so your plan must assume zero changes touch production until every issue is ironed out. Please lean on practical experience—show me similar projects you have already steered; past work is my main filter when choosing who to collaborate with. Deliverables • A written migration roadmap outlining phases, timelines, and required tooling • A checklist for preparing the test instance (drivers, FireDAC components, SQL Server settings, connection pooling, etc.) • Co...

...Deliverables 1. Fully functional BigQuery data warehouse with all five Google platforms connected 2. Automated data pipeline documentation (schemas, flows, schedules) 3. AI interface configured with connection guide and sample queries 4. User guide for querying data through AI 5. One training session (1-2 hours) ## Required Skills **Must Have:** - 3+ years experience with Google BigQuery - Strong SQL and data modeling expertise - Experience integrating Google Marketing Platform tools - Google Cloud Platform (GCP) familiarity - Experience with data pipeline tools (Fivetran, Stitch, Airbyte, or custom ETL) - API integration knowledge (OAuth 2.0) **Nice to Have:** - Experience with AI/LLM integration layers - dbt (data build tool) knowledge - Google Analytics 4 or Google Ads cer...

...frontend is already in place, but the UI needs a visual and usability upgrade before we move forward. Beginning tomorrow, I’d like you to step in, take ownership of the codebase, and carry the project all the way to production. On the backend I’m leaning toward Node.js, yet I’m flexible on the stack if you can justify clear benefits. Our database is still open for discussion—feel free to propose SQL (MySQL, PostgreSQL) or NoSQL (MongoDB, etc.) solutions that best fit a live-service game. Whichever route we pick, clean schema design, migration strategy, and security best practices are essential. Core scope • Fix and polish the existing frontend, focusing specifically on user-interface design so it looks and feels like a modern game portal. • A...

...standard Wix CLI apps), managing the necessary infrastructure (hosting, networking, security, and external databases). Backend Development: Develop robust, scalable backend services in Node.js / TypeScript (REST endpoints, custom authentication, input validation, and structured logging). Data Strategy: Design clean data models and persistence layers, managing integrations between Wix Data, external SQL/NoSQL databases (Supabase/Firebase/Postgres), and caching strategies. Wix Ecosystem & Integrations Wix App Development: Build and maintain Wix apps using the Wix CLI, creating seamless dashboard extensions, admin UIs, and backend services. Deep Integrations: Utilize the Wix SDK and Platform APIs to interact with Wix Stores, Orders, Collections, and eCommerce domain objects. Fe...

...academic insights Homework reminders 4️⃣ Student AI Homework explanation Exam preparation tips Doubt solving Performance suggestions 5. Advanced AI Features (Must Have) Context memory (session-based + user-based) Multilingual (English + Hindi initially) Smart report generation (PDF export) Predictive analytics (attendance trends, performance risk) AI-based timetable optimization Natural language to SQL query conversion Fine-tuned prompt engineering Guardrails & hallucination control Secure data filtering per role...

Job Title: Oracle WAX & WAM Consultant – Job Support Engagement Type: Part-Time Job Support Support Duration: 2 Hours per Day Monthly... Provide documentation and knowledge transfer where required. Required Skills & Experience 7+ years of experience in Oracle Utilities domain. Strong hands-on experience with: Oracle WAX (Work & Asset eXchange) Oracle WAM (Work and Asset Management) Experience in: Work order management Preventive & corrective maintenance Asset lifecycle management System integrations Good knowledge of SQL for data validation and troubleshooting. Experience supporting live production environments. Strong communication skills. Engagement Details 2 Hours per Day (Flexible timing) Remote Support Monthly Budget: ₹22,000 – ₹24,...

I need a cloud database setup using either AWS, GCP, or Azure. The database should support both SQL and NoSQL. Requirements: - Experience with at least one major cloud provider (AWS, GCP, or Azure) - Proficiency in both SQL and NoSQL databases - Ability to design and implement secure, scalable, and efficient cloud databases - Knowledge of best practices for cloud database management and maintenance Ideal Skills: - Cloud architecture design - Database administration - Security compliance in cloud environments - Performance tuning and optimization Please provide examples of similar work done.

Job Description We need a disciplined SQL/data engineer to produce a deterministic, re-runnable script-based build (lean MVP, not enterprise infra). Goal Create a single canonical, one-row-per-company dataset anchored on UEI, then enrich it using exact UEI matches (no name guessing). Inputs (provided) USAspending extract / source tables (L24M window) DSBS export (CSV) with UEI + owner contact fields SAM Active Entity extract (CSV) with UEI + phone + officer names Written Segment B & C rules (explicit) Deliverables 1. USAspending segmentation + canonical vendor table >Filter to last 24 months >Vendor-level aggregation → one row per UEI >Apply Segment B & C logic exactly as written >Deterministic CSV output >Basic QA checks: a. no duplicate UEIs ...

...Gross Weight, Net Weight, Invoice Number, Vendor Name and Dispatch Date. Once captured, that data must flow straight into a master inventory database, stay synchronised, and drive all downstream reports. Key functions I expect: • Continuous PDF scraping from the local path I specify, with no manual trigger required. • Central master inventory that grows with each import; I’m open to whichever SQL back-end you feel best suits the job as long as it is industry-standard and easy for us to maintain. • Live stock dashboards that let me view balances by Micron and by Size at a glance. • Automatic quantity adjustment the moment a dispatch is marked, ensuring the figures on-screen always match the warehouse floor. • One-click packing list generat...

...knowledge of .NET Framework 4.8 or higher, with experience developing, maintaining, and improving applications in production environments - Experience with Entity Framework (Code First and/or Database First), including relationship handling, migrations, and query optimization - Strong command of LINQ for efficient querying, data transformation, and business logic - Database - Proven experience with SQL Server, including: - Development and maintenance of Stored Procedures - Creation and usage of Functions, Triggers, and Views - Query optimization and performance analysis - Data schema management in production environments - Integrations & Services - Experience consuming and integrating REST APIs / services, both internal and third-party - Knowledge of cloud services, preferabl...

Hi! I am looking to upgrade my current sales dashboard. I am looking for a Data Specialist who I can learn from and who can propose the best solution for my needs. Data will come from CSV files. I need a place where I can import that data to. I would like the dashboard to be as detailed as possible showing multiple KPIs, graphs, and correlations between the various data. Once setup, I would like it to be fairly simple to import new data, and modify the dashboard as needed over time. I would like this setup to be fully offline and local. My current thoughts are Metabase + SQLite. However I am open to other solutions and recommendations. I will be able to provide an example of the CSV during discussion to see how and what we can achieve with the data. I am looking for an individual who...

...data • Routes processed data into analytics and care coordination systems We are looking for a highly experienced senior full-stack developer to take ownership of our core backend platform. This is not a junior or mid-level role. You will be the primary engineer across two production services running on Google Cloud Platform. Tech Stack • Node.js (Express) • Python (Flask) • PostgreSQL (Cloud SQL) • BigQuery • GCP (Cloud Run, Pub/Sub, GCS, Cloud Build, Cloud KMS) • Terraform • Event-driven architecture • HIPAA-compliant infrastructure • AI-assisted development (Claude Code) Responsibilities • Own and extend our ingestion backend (Node.js) • Maintain and evolve our mapping/transformation service (Python) • Desi...

I need a complete n8n configuration that tie...3. A short README that explains each node, expected inputs / outputs, and how to extend or modify the logic. 4. Screenshots or a loom clip showing the workflow running end-to-end so I can verify everything before deploying. Acceptance criteria • API calls perform fetch, send, and update operations without hard-coded keys or values. • Database queries run with parameterized inputs to avoid SQL injection. • Cloud-storage credentials are read from environment variables only. • The workflow completes without unhandled errors and logs meaningful messages at each stage. If something in my outline can be improved, feel free to suggest refinements—just keep the core requirement of API, database, and cloud-s...

...team can understand how stock levels have moved over time and where the pressure points sit. Here’s what I have: several years of SKU-level records housed in a SQL database, plus a few CSV extracts. I need you to pull and clean the data, run robust trend analysis in Python (Pandas, NumPy, preferably some Matplotlib or Seaborn visuals), and package the insights so they are easy for our planners to act on. Time-series forecasting or demand planning frameworks aren’t required right now, but please structure the code so we could layer those in later if needed. Deliverables: • Well-documented Python notebook or script that connects to our SQL source, performs the trend analysis, and generates clear charts/tables. • A concise slide deck or PDF summary h...

...Django REST APIs, GraphQL, or gRPC Microservices architecture Machine Learning and AI TensorFlow, PyTorch, Scikit-Learn, or similar frameworks Experience working with LLMs and modern AI frameworks Prompt engineering, RAG, or vector databases is a plus Cloud and DevOps AWS, Azure, or Google Cloud Platform Docker and Kubernetes CI/CD pipelines and deployment practices Data and Systems SQL or NoSQL databases (PostgreSQL, MySQL, MongoDB, Redis) Data processing and scalable system design experience Security and Best Practices OAuth, JWT, RBAC authentication systems Secure API development and production standards Optional (Nice to Have) Blockchain or emerging technology experience Expectations Strong real-world development experience Good English communication skil...

I’m ready to bring in a security specialist to run a thorough, manual penetration test on my live e-commerce application. Automated scanners aren’t enough for this engagement—I need human-driven testing that uncovers real-world attack paths. Here’s what I’m looking for: • A full manual assessment covering all SQL Injection, Cross-site Scripting (XSS) and Cross-site Request Forgery (CSRF),Web Application Penetration Testing , Network Penetration Testing Services External or Internal, Web Services Testing, API Testing • Exploitation-level proof of concept for every confirmed issue, with clear, reproducible steps. • A concise risk-ranked report that separates critical, high, medium and low findings, followed by practical remediation advi...

I have a Hadoop cluster holding several large data sets, and I need a seasoned PySpark developer who also writes rock-solid SQL. The immediate aim is to connect to the cluster (YARN/HDFS with Hive metastore), develop or refine PySpark jobs, optimise the accompanying SQL, and make sure everything runs smoothly end-to-end. You’ll receive access to a staging namespace plus a sample of the data. Once the logic checks out we’ll promote the code to the full environment. Deliverables • A clean, well-commented PySpark notebook or .py job that executes successfully on the cluster • The corresponding SQL script or view definitions ready for Hive or spark-sql • A concise README detailing execution steps, parameters, and expected outputs ...

...can maintain it later • Save each record directly into a relational table (MySQL or PostgreSQL—let me know which you prefer) using prepared statements to prevent SQL injection • Provide a simple configuration file where I can switch credentials, database connection strings and add new profile URLs without touching the core logic Acceptance criteria • I point the tool at 10 test profiles; all mapped fields appear in the database exactly once with no missing characters • A command-line log or dashboard shows progress and any errors in real time • You hand over the source code, a README with setup steps, and a sample SQL schema Experience with Python (Selenium, Playwright or similar), LinkedIn APIs, and database integration will be...

...CSV so staff can pull quick counts. • Low-stock thresholds with email alerts (SMTP already configured in the system). • Clear install/merge instructions and brief user documentation. Acceptance The module must install without breaking existing ERP functions, display accurate stock counts after sample transactions, and meet simple code-review standards (PSR-12, parameterised queries, no raw SQL injections). I will provide a code snapshot, database schema and access to a staging server. If this initial stock-tracking phase goes smoothly, we can discuss adding supplier or order processing down the line....

...solutions fast Non-Negotiables * Design quality is paramount: clean, polished, modern UX/UI execution * Bug-free delivery is paramount: high attention to detail and strong QA habits * Mastery of AI workflows is paramount and will be evaluated in the hiring process Requirements * Strong hands-on experience with and Laravel * Proven experience building and consuming REST APIs * Strong SQL/database skills (MySQL or PostgreSQL) * Comfortable with Git-based workflows and high-quality PR reviews * Clear communication and ability to work independently Nice to Have * Experience with auth flows (Laravel Sanctum, NextAuth, etc.) * CI/CD and deployment experience (VPS, Docker, containerized infra) * Performance and security hardening experience * Experience integrating LLM tools and AI-...

...(should allow for multiple or "all"). ● <api_key> – Handled via __secrets.AIRTABLE_API_KEY or custom named key. Reference: Use the existing platform templates as a reference for coding standards and placeholder syntax. 2. Validation Scenarios You must demonstrate a successful flow execution for each of the following architectures: ● Scenario A: The Native Bridge (Airtable → SQL) ○ Flow: DLT-Code Node (Source) → SQL Database Node (Destination). ○ Test: Connect the Airtable template to your local Postgres or MySQL instance. ● Scenario B: Local Analytics (Airtable → DuckDB) ○ Flow: DLT-Code Node (Source) → DuckDB Node (Destination). ○ Test: Materialize Airtable data into a local .duckdb file. ● Scenario C: Universal Connector (Airta...

I currently manage a website built for display management. It runs on a Linux server with an SQL database. Over time, the system has slowed down and is struggling to handle the increasing volume of data efficiently. The goal is to redesign the website using modern technologies and update the overall architecture to improve performance and scalability. All page designs have already been completed in Figma. The platform synchronizes its main database with local databases on connected desktop workstations, and the new version must remain fully compatible with the existing desktop software to ensure seamless synchronization. There are three user roles: Super Admin, Admin, and User, each with specific permissions to manage or view different levels of content. In addition, the UI need...

I’m building an internal business tool and need an experienced .NET Core developer who can work during the India night shift (roughly 9 PM–5 AM IST). The project centers on a browser-based web application, so you’ll spend most of your time inside ASP.NET Core, Entity Framework, and SQL Server, wiring up clean MVC or Razor Pages, setting up dependency injection, and testing endpoints with Postman or Swagger. You’ll collaborate directly with me over Teams for quick stand-ups and code reviews, pushing updates to a Git repository each night. I already have wireframes, a partial domain model, and an Azure DevOps board with user stories ready for you; your first tasks will involve refining the data layer, implementing responsive views, and tightening up API endpoi...

...dashboards and retraining scripts Acceptance criteria A working API must return real-time predictions within agreed latency limits, integrate seamlessly with the current SMTP/ESP workflow, and include logging for compliance review. Final delivery is considered complete when the system runs in production and all documentation passes peer review. Tools & stack Python, scikit-learn or TensorFlow, SQL/NoSQL for data storage, and standard MLOps utilities (Docker, CI/CD) are anticipated, yet alternative libraries are welcome if they meet the same reliability and security standards. Timeline and milestones will be outlined together at project start, with code reviews scheduled at each major checkpoint....

...multiple mats and rounds, with clear matside displays. • Scores are entered live; individual results immediately roll into cumulative team standings. • At any point, I can print clean, ready-to-post brackets or final summaries. Everything must run in a browser so I can open it from any laptop in the gym. I’m flexible on the tech stack—React or Vue paired with Node.js, Django, or Laravel and a SQL database makes sense as long as the code is clean, documented, and easy to deploy. An exportable data format and concise installation guide are part of the final hand-off. I’ll share detailed rules, UI sketches, and workflow diagrams once we connect. We can break the build into milestones for architecture, core engine, interface, testing, and deployment,...

...polished Power BI report that pulls live data from my SQL Server instance, applies a handful of straightforward calculations (simple sums, averages, percentages—nothing too exotic), and then presents the results in an interactive set of bar charts, line graphs, and pie charts. You will start by configuring the data gateway or direct-query connection so the report can refresh without manual intervention. Once connected, build a clean data model with clear relationships, sensible field naming, and the calculated columns or measures we agree on. With that foundation in place, design the visuals so users can slice, filter, and drill down smoothly on the key metrics we track each week. Deliverables • A fully-functional .pbix file connected to my SQL Server da...

...clients—schools, companies, public bodies and similar organisations—can log in over the internet to view, upload and download their own estate-related and compliance documents such as surveys, inspection reports and certificates. Editing in the browser isn’t required; the goal is a “read, upload, download” portal that keeps every file in its original form. Here’s what I need built: • A relational database (SQL or comparable) that stores the file-metadata and user accounts. • A clean web interface that works on desktop and mobile, served from my own on-prem server. • Username-and-password authentication with session timeout and password-reset functions. • Role separation so each client only ever sees their own folder ...

I need a Python-based tool that can scan video files, detect Trees, Road, Infrastructure—and leave room for many more object classes as the project grows—then save ev...confirm accuracy. OpenCV for frame extraction and display is acceptable; YOLO, TensorFlow, or another modern model is fine so long as the code is clean, well-commented, and easy for me to retrain with additional classes. To keep the hand-off smooth, please include: • A self-contained Python 3 script (or module set) that performs detection, inserts frames into MySQL, and plays them back. • The SQL schema and sample data script. • A brief README explaining environment setup, model weights location, and how to add new classes. Show me past work on similar computer-vision or database-driv...

...knowledge of .NET Framework 4.8 or higher, with experience developing, maintaining, and improving applications in production environments - Experience with Entity Framework (Code First and/or Database First), including relationship handling, migrations, and query optimization - Strong command of LINQ for efficient querying, data transformation, and business logic - Database - Proven experience with SQL Server, including: - Development and maintenance of Stored Procedures - Creation and usage of Functions, Triggers, and Views - Query optimization and performance analysis - Data schema management in production environments - Integrations & Services - Experience consuming and integrating REST APIs / services, both internal and third-party - Knowledge of cloud services, preferabl...

...2. I can log in to the admin panel, create a coupon and see it apply correctly at checkout. 3. Orders, stock and coupons are stored and editable in the database. 4. Code is organised, commented and delivered with a short README on setup. Please keep the setup straightforward so I can host it on a standard LAMP stack. Source code should be delivered via Git (GitHub or Bitbucket) along with a SQL dump for initial data....

...solution including: ? Ignition Perspective Application Modern, responsive screens Recipe CRUD interface Color picker with Hex capture Matrix editor (437 rows) Recipe library and selection Product assignment dashboard Status indicators and interlocks ? Database (MySQL) Parent–child recipe structure Optimized foreign key design Active status tracking table Indexed queries for fast access Full SQL export provided ?Deliverables You will receive online demonstration of : Ignition Project Complete Perspective screens Named Queries & scripts MySQL schema PLC tag/DB mapping list As discussed the project is divided into phases, in this phase complete project will be demonstrated through video and online live support. Final files will be handed over in next phase. Loo...

...integration-tested. I’ll provide the mobile team’s contract-first API specs; you’ll wire them up, create the database schema, and deliver clear migration scripts. Acceptance criteria 1. Endpoints for sign-up, MFA login, password reset, profile update and session management return the exact request/response shapes supplied. 2. Onboarding flow persists all user milestones and is replayable for audit. 3. SQL scripts run cleanly on both MySQL 8 and PostgreSQL 15. 4. Postman or similar collection demonstrates every endpoint, including negative cases. 5. Code passes all tests via Maven and spins up with Docker-Compose in one command. If you’re experienced with Spring Security, JPA/Hibernate and containerised deployment, this should feel straightfor...

...who can move comfortably between Python scripting, SQL optimisation, PySpark transformations and Airflow orchestration. The immediate focus is end-to-end pipeline build-out: designing clean ingestion logic, transforming data in Spark, writing efficient queries and scheduling everything through well-structured Airflow DAGs. If you can demonstrate hands-on experience across all four technologies - Python, SQL, PySpark and Airflow—and enjoy owning a pipeline from raw source to curated output, I’d like to work together. Deliverables I’m expecting: • A working set of PySpark jobs that handle ingestion, transformation and output staging • Airflow DAGs that schedule, monitor and alert on each job’s success or failure • Parameteri...

Employment Type & Work Location: - Full-time position - Onsite work required - Candidates must be willing to work onsite in Thailand and/or Indonesia (depending on project assignment) Required Skills: - Strong proficiency in Python - Solid knowledge of SQL - Experience with Git version control system - Good English reading and writing skills Preferred Skills: - Experience with ERP systems and/or eCommerce platforms - Business knowledge such as Accounting or Supply Chain - Experience with Docker Additional Advantages: - Hands-on experience with ERP systems (development and/or functional usage) - Knowledge of JavaScript, HTML, CSS - Demonstrable work on GitHub repositories - Public GitHub repository with proven experience will be a strong advantage

I’m building a high-end real-estate lead engine that can capture, qualify, and route 150–200 fresh inquiries every week with a hard 99.5 % uptime target. Instead of a generic chatbot, the core of this MVP is a lightning-fast Custom Qualification UI written in React, backed by a Node.js API and a PostgreSQL (or comparable SQL) data store. What I need from you is end-to-end ownership of the stack: solution architecture, clean code, robust testing, and cloud deployment. The product must open the door for future add-ons such as a real-time analytics dashboard, but for this first milestone the focus is on: • Lead scoring system that assigns quality grades the moment data arrives • Automated lead routing that pushes hot prospects to the correct broker or CRM qu...

...marketing, UX, and technical teams to optimize website performance - Develop predictive models or advanced analytics to anticipate user behavior - Ensure data accuracy, consistency, and reliability Required Profile : - Bachelor’s degree (or equivalent) in Statistics, Mathematics, Computer Science, Data Science, or related field - 2–5 years of experience in data analysis - Strong proficiency in SQL, Advanced Excel, Google Analytics, Power BI or Tableau - Knowledge of Python or R for advanced analysis is a plus - Strong analytical mindset and ability to translate data into clear recommendations - Ability to work independently while collaborating with a multidisciplinary team - Interest in digital products, web platforms, and ideally the iGaming industry Project Detail...

I need my operational data—currently stored across several Excel workbooks—turned into interactive Power BI reports that make trend-spotting and drill-downs effortles...detailed project proposal outlining the steps you would take to: • connect and clean multiple Excel sources • model the data for accurate relationships and DAX measures • design intuitive visuals that highlight KPIs, variances, and historical trends • deliver a ready-to-share .pbix file plus a short hand-off guide Everything will be built on Excel inputs for now, though I may extend to SQL or cloud sources later, so keep future flexibility in mind. Proposals that anticipate potential pain points (e.g., refresh errors, file path changes) and suggest best-practice Power Query ...

Mores What functionality do you want the Telegram bot to have? bot que gestione una base de datos de usuarios y realice peticiones HTTP, Automaticas, API-based integration with external game servers (Unity/JSON). No standard SQL ¿Qué tipo de base de datos te gustaría usar? SQL ¿Qué tipo de peticiones HTTP debe realizar el bot automáticamente? The bot requires standard REST API methods (GET, POST, PUT) to interact, interact with JSON-based endpoints and handle authentication headers.

...APEX) Deliverables: • Requirements Document (SRS) • Data Model (ERD) • Flow Diagrams • Project Schedule Phase 2 – Database & Backend Design (Week 2) Duration: 5 days Tasks: • Design Oracle tables: o Students o Parents o Teachers o Classes o Attendance o security o Student Delivery Logs o Users & Roles • Create sequences & constraints • PL/SQL APIs & packages • REST APIs for mobile app • Security & authentication design Deliverables: • Database schema • PL/SQL packages • API documentation Phase 3 – Oracle APEX Backend Development (Weeks 3–4) Duration: 10 days Modules in APEX: Admin Module • Student management • Parent management • Teacher management • ...

Responsive Web application + Mobile App Technology: .NET core, SQL, Angular Feature 1. Vehicle Master Management Add and manage vehicle details including registration, insurance, permits, fitness, PUC, and ownership information. 2. Driver Management Maintain driver profiles, license details, expiry tracking, and vehicle assignment. 3. Trip Tracking Log trip start and end with odometer capture and maintain route/date-wise trip history. 4. Fuel Management Record fuel entries with bill upload, auto-calculate mileage, and monitor fuel efficiency. 5. Maintenance Management Schedule preventive maintenance, record service history, and track maintenance costs. 6. Compliance & Expiry Alerts Automated alerts for insurance, permit, PUC, fitness, and license expiry. 7. Gate Ent...

...figures that must be transferred accurately into working spreadsheets and then reflected in our existing SQL database. The spreadsheets will be the primary source, so precision in every cell—dates, currency formats, formulas, and cross-sheet references—is essential before the data is pushed to the database. You will receive scanned source documents, the current Excel template, and credentials to a staging schema in our SQL environment. Once each spreadsheet is complete and vetted for errors, the corresponding tables in SQL need to be updated so that our reporting dashboards stay in sync. Deliverables • Completed Excel workbook with all financial data correctly entered and formatted • SQL script (or direct upload) that mirrors the s...

...an experienced developer to support and enhance an existing enterprise application built using Visual Basic (VB / VB.NET) with a SQL database backend. The application is currently in active use, and we require a developer who can quickly understand the existing codebase, implement enhancements, optimize database performance, and resolve issues as they arise. This is not a greenfield project — the focus will be on improvement, stabilization, and incremental feature development. Scope of Work Includes: Understanding and working with an existing VB / VB.NET codebase Enhancing modules and implementing new business requirements Writing and optimizing complex SQL queries, stored procedures, views, and functions Debugging and resolving application and database-related...

I need an API layer that lets HikCentral Pro push employee attendance records directly into my SQL database. HikCentral will be the data source; the SQL instance will act as the system of record. At the moment I’m not completely sure of the payload format—HikCentral’s documentation mentions something that looks like “POSTSQL”, so I’ll need guidance on the exact structure (it could end up as JSON once we see the sample webhook). Core requirements • Accept incoming attendance records from HikCentral over HTTPS. • Route those records into a chosen table within my SQL environment (SQL Server is currently installed, but I can adjust if you suggest a better flavour). • Support three actions through separate, se...

...- Section for additional notes and comments. 2. Reporting Module Updates Reports are currently generated via SQL queries into HTML tables. - Adding new filters (Date, Status, Manager). - Adding new columns to two existing reports. - Performance optimization (fixing slow query execution). 3. Refactoring the Discount Mechanism The current "Discount Rules" module needs a logic overhaul: - Support for multiple discount types (Fixed amount, Percentage, and Combined). - Dynamic conditions (based on Client Type, Total Amount, Date range, and Service Category). - Bug fixing and edge-case handling. Requirements - Extensive experience with procedural PHP and vanilla codebases. - Strong SQL skills (optimization and complex joins). - Ability to maintain and patch legacy c...

...have an existing analytics initiative that now needs a dedicated Redshift-based warehouse. The core objective is to design and implement a robust schema in Amazon Redshift, then ingest data coming from three different sources—our operational SQL databases, a set of RESTful APIs, and periodic flat-file drops in CSV or JSON. Here is what I’m aiming for: • A well-structured Redshift warehouse (star or snowflake schema, whichever is most appropriate) built to scale and documented clearly. • Reliable, automated ingestion pipelines for each source type. For SQL we currently use PostgreSQL and MySQL; for APIs the payloads are mostly JSON; the flat files live in S3. • Transformations that standardise data types, handle slowly changing dimensions, ...

...instantly generate a finished PDF. The workflow is straightforward: • Users authenticate through a standard login screen (ASP.NET Identity is fine). • After login they see a dashboard listing the available templates. Payment Gateway required. • When a template is selected, questionairre is uploaded, the user completes the questionaire, the system pulls the relevant data automatically— from a SQL-based data source and from a simple form the user completes—and merges it into the template. • The completed document is rendered as a PDF, reviewed to the admin team, once approved, then offered for download and optionally emailed to the user. Type of users. Admin, Distributor and End User. Distributor may introduce end users. End User who is associ...