A well established company is modernising its internal operational systems and requires a hands-on specialist to develop, implement and roll out the new solutions across the business.The successful candidate will replace an existing Microsoft Access system, continue development of thecompany's Supabase-based operational platform, migrate data, test and deploy the solutions, and trainemployees to use them effectively. This is an implementation-focused role. Success will be measured by working systems that are adopted by users, supported by reliable data and properly documented.
Key Responsibilities
Legacy System ReplacementAssess the existing Microsoft Access system and replace it with a modern SQL-based or cloud-basedsolution. This will include:
Reviewing the current databases, forms, queries, reports and business logic.
Documenting existing workflows and identifying processes that should be improved.
Designing the replacement database and application architecture.
Cleaning, mapping, migrating and validating historical data.
Rebuilding the required workflows, forms, reports and dashboards.
Implementing suitable security, access control, backup and recovery measures.
Operational Platform DevelopmentContinue development of the company's operational platform using Supabase and modern AI-assisted orVibe Coding tools. Priority modules include:
Inventory and warehouse management, including receiving, serialised stock, locations, transfers, picking,
delivery, returns and barcode functionality.
Asset management, including customer asset identifiers, serial numbers, locations, warranties, movements, swap-outs, repairs and lifecycle history.
Technical job management, including allocation, scheduling, site attendance, work records, photos, stock
usage, configuration details, customer sign-off and reporting.
Additional operational modules and workflows agreed during the contract period.
Database and Application Development
Develop and maintain Supabase, PostgreSQL and SQL database structures.
Create appropriate 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 changes.
Apply sound architecture, security, testing and coding standards when using AI-assisted development tools.
Business Process and Solution DesignWork directly with management and operational staff to understand requirements and convert them intopractical system functionality. The candidate will map workflows, identify opportunities for automation, buildprototypes, obtain user feedback and refine the solution into production-ready functionality.
Testing Implementation and Rollout
Complete functional, data, workflow, permission, mobile and desktop testing.
Coordinate user acceptance testing and resolve defects before deployment.
Prepare implementation plans and migrate the required operational data.
Set up users and permissions and roll out modules to the relevant departments.
Monitor adoption, resolve initial issues and improve the system from user feedback.
Retire the old system when the replacement is stable and approved.
A module will only be regarded as delivered once it has been tested, accepted, deployed and adopted bythe business.
Training and Documentation
Prepare user guides, quick-reference material and training content.
Train employees, key users and system administrators.
Provide initial support after implementation.
Document the system architecture, database structure, business rules, permissions, integrations,
deployment process and backup procedures.
Maintain complete and current source-code repositories and administrator documentation.
All source code, database structures, documentation and related intellectual property developed as part of the employment relationship will belong to the company, subject to the employment agreement.
Required Experience and Skills
Practical SQL, PostgreSQL and relational database design experience.
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 or Vibe Coding tools such as Lovable, Cursor, Claude Code, GitHub
Copilot or ChatGPT.
Experience with authentication, permissions, testing, deployment and reporting.
Strong business-process analysis, communication and user-training skills
Experience developing inventory, warehouse, asset-management, field-service, job-management or ERP-related solutions will be highly advantageous.
Desired Skills:
System Specialist
About The Employer:
Join a well established company in Pretoria