|
Description: |
Expected duration: 3 - 4 weeks
We need a C# developer to build a Windows console-based “On-Premise Agent” that will:
• Authenticate to our central API (POST /api/login) via username/password and obtain a Bearer token
• Fetch SQL query, field mappings & endpoint URL (GET /api/fetch-query)
• Query an on-premises SQL Server and retrieve data
• Map SQL fields to the API payload schema
• Send data in batches of 1,000 records to POST /api/receive-data
• Retry up to 5x on login, fetch-query, SQL execution, and data-send failures
• Log every step (timestamped, daily rolling files) and report errors to POST /api/receive-error-data
• Be schedulable via Windows Task Scheduler and runnable manually
Deliverables:
1. C# console app targeting your chosen .NET runtime (.NET 6 or .NET 4.8)
2. Config file template (appsettings.json) with placeholders
3. Packaged installer (self-contained EXE or MSI with silent-install support)
4. Git repo with clear commits & branching
5. Unit/integration tests (≥70% coverage)
6. README (build, deploy, troubleshoot)
To apply, please include:
• Links to similar projects or GitHub samples
• Your preferred .NET runtime & logging framework
• Estimated hours (or fixed price) and hourly rate
We’ll share the full API spec and sample SQL schema once you’re shortlisted. |
