Systems Architect & Implementation Lead (SQL/Supabase)

Edgexec (Pty) Ltd; Pretoria; On-site; ZAR 558,000 - 837,000; Full time

Job summary

Edgexec (Pty) Ltd seeks a Systems Developer and Implementation Specialist in Pretoria for a 6-month fixed-term contract. You will modernise internal systems, replace Access with SQL/cloud solutions, and extend a Supabase-based platform, covering inventory, asset and technical job modules.

You will work with management to map requirements, design architecture, migrate data, implement security, and deliver production-ready solutions with training and documentation for users and admins.

Qualifications

• Practical experience with SQL, PostgreSQL and relational database design.
• Experience with Supabase or a comparable cloud backend platform.
• Web application development and API integration experience.
• Experience migrating data from Microsoft Access or similar legacy systems.
• Practical experience with AI-assisted development tools such as Lovable, Cursor, Claude Code, GitHub Copilot or ChatGPT.
• Experience with authentication, permissions, testing, deployment and reporting.
• Strong business-process analysis and solution-design capability.
• Ability to work directly with senior management and non-technical users.
• Strong communication and user-training skills.
• Experience developing inventory, warehouse, asset-management, field-service, job-management or ERP-related solutions will be advantageous.

Responsibilities

• Assess and replace an existing Microsoft Access system with a modern SQL-based or cloud-based solution.
• Review existing databases, forms, queries, reports, workflows and business logic.
• Design database and application architecture for replacement systems.
• Clean, map, migrate and validate historical data.
• Continue development of the company's Supabase-based operational platform.
• Develop inventory and warehouse functionality covering receiving, serialised stock, locations, transfers, picking, delivery, returns and barcodes.
• Develop asset-management functionality covering identifiers, serial numbers, locations, warranties, movements, repairs and lifecycle history.
• Develop technical job-management functionality covering allocation, scheduling, site attendance, work records, photographs, stock usage, configuration details, customer sign-off and reporting.
• Develop and maintain Supabase, PostgreSQL and SQL database structures.
• Build relationships, views, functions, validations and audit trails.
• Implement authentication, role-based permissions and row-level security.
• Develop or integrate APIs where required.
• Use Git or GitHub to manage source code and development changes.
• Apply appropriate architecture, security, testing and coding standards when using AI-assisted development tools.
• Work with management and operational users to understand requirements and map business processes.
• Build prototypes, gather feedback and refine functionality for production use.
• Conduct functional, data, workflow, permission, mobile and desktop testing.
• Coordinate user acceptance testing and resolve defects.
• Plan and execute system implementation and data migration.
• Configure users and permissions and roll out solutions across relevant departments.
• Monitor adoption and resolve issues following implementation.
• Prepare user guides, training material and technical documentation.
• Train employees, key users and system administrators.
• Document system architecture, databases, business rules, permissions, integrations, deployment and backup procedures.
• Maintain complete source-code repositories and administrator documentation.
• Support the retirement of the legacy system once the replacement is stable and approved.

Skills

SQL

PostgreSQL

Supabase

Web development

API integration

Data migration

AI tools

GitHub Copilot

Authentication

Permissions

Testing & deployment

Documentation

Stakeholder comms

Inventory/ERP

Tools

Lovable

Cursor

Claude Code

GitHub Copilot

ChatGPT

Job description

Edgexec (Pty) Ltd seeks a Systems Developer and Implementation Specialist in Pretoria for a 6-month fixed-term contract. You will modernise internal systems, replace Access with SQL/cloud solutions, and extend a Supabase-based platform, covering inventory, asset and technical job modules.

You will work with management to map requirements, design architecture, migrate data, implement security, and deliver production-ready solutions with training and documentation for users and admins.