Long-Term Architect – Time-Series Platform with GIS & API Ingestion (Phase 1 Scouting)

*** IMPORTANT: FUTURE PROJECT SCOUTING - NO IMMEDIATE HIRE *** We are currently in the corporate restructuring and financial planning phase for this time-series technology suite. This job post is strictly for scouting, interviewing, and shortlisting the right long-term Senior Full-Stack Architect for future collaboration. The contract will be funded, activated, and executed in clear, independent stages over the coming months and years. Phase 1 milestone budget (50,000 - 60,000 NOK) will be locked in escrow when the project is officially launched. If you want to be interviewed and shortlisted for a premium, long-term tech collaboration, please read the criteria below and apply. #### 🏛️ The Complete 6-Phase Roadmap (For Long-Term Architecture Context): * **Phase 1 (Initial Launch Milestone):** Deploy core TimescaleDB (PostgreSQL) containerized inside a DigitalOcean Droplet, integrate Grafana Frontend interface, pull dynamic blast parameters from third-party Blastmanager REST APIs, and overlay NGU (Norges geologiske undersøkelse) geological vector map channels onto the Grafana Geomap panel. * **Phase 2 (Future Staged Milestone) – Fleet Automation & Multi-Platform ESG Reporting:** Build a flexible, multi-platform REST API data broker layer. While our primary integration framework target is SmartDok, the architecture must be abstract enough to ingest fleet logs, operator hours, machinery data, and fuel metrics from other major industry systems (e.g., Infobric, Ditio, Procore, or direct telematics/OEM APIs). Convert these combined multi-source metrics into carbon equivalents (tCO₂e) based on official Norwegian emission factors, and ensure database records are stored immutably using a SHA-256 validation hash string for compliance auditing. * **Phase 3 (Future Staged Milestone):** Integrate wireless MQTT/LoRaWAN gateway inputs from White-Label VibCon Sensors (Teltonika EYE hardware) and PIR sensors for active industrial perimeter security, cross-referencing triggers against construction/blasting timelines to automatically fire external 230V Shelly BLE relays linked to physical site floodlights. * **Phase 4 (Future Staged Milestone):** Automate the Norwegian Standard (NS 8141) calculation formula, seed explosives product matrix arrays, and build a secure, standalone internal portal for high-resolution pre-construction photo surveys using cryptographic SHA-256 hashes to eliminate ongoing cloud storage expenses. * **Phase 5 (Future Staged Milestone):** Develop a WebGL/Three.js 4D time-freeze rendering workspace combining multiple synchronized drone footage streams with Sandvik MWD rig data (MPa drill profiles). * **Phase 6 (Future Staged Milestone):** Integrate two-way voice-to-text functionality (OpenAI Whisper APIs) with biometric Voice ID logic restricted strictly to company management. #### 📐 Strict Requirements for Phase 1 Infrastructure Architecture: 1. Configure containerized TimescaleDB partitioned properly to handle extreme, concurrent time-series ingestion strings without truncation or performance lag. 2. Build the database schema to handle device IDs, battery levels, microsecond timestamps, 3-axis orientation metrics, and the 5 core telemetry compliance channels: mm/s, m/s², Hz, full Fast Fourier Transform arrays, and peak amplitudes, including raw time-series waveform files. 3. Program background synchronization protocols connecting to Blastmanager APIs and plotting vector transmission corridors dynamically on Grafana Geomaps. 4. Set up an internal accounting calendar routine tracking cumulative sensor operational days per selected date frame to generate seamless customer invoicing files. #### ⏱️ Specific Perimeter Automation Requirements (Sought for Phase 3 Core Logic): * **Automated Scheduling & Trigger Pause:** Implement a time-based scheduling array for all perimeter sensors. By default, sensors must enter a trigger-pause between 06:30 and 18:00 local time (no alerts or relay triggers allowed). The system must automatically arm itself between 18:00 and 06:30. * **Grafana Overrides:** Build a secure, interactive admin toggle switch inside the Grafana project view. Project administrators must be able to manually deactivate or override the security triggers at any time to allow scheduled overtime work or late-night logistics without setting off floodlights or alarms. #### 💰 Project Terms & Intellectual Property Ownership: * This post initiates a Shortlisting Process. No contract is signed or funded tonight. * Future execution will be run strictly on a Fixed-Price Milestone Contract locked in Upwork Escrow stage-by-stage. * 100% repository, configuration, and source code ownership belongs exclusively to our parent firm (VibCon Holding AS / Thomas Holding AS) at every single step. All code is hosted inside our own isolated architecture environment. #### 💬 How to Apply: To completely filter out automated AI spam bots and verification scrapers, you must start your application text with the exact word "HARESTUA". Proposals failing to include this word in the very first line will be automatically rejected without review.