Role Overview

We're seeking a Senior Fullstack Engineer whose gravitational centre is database architecture, data modelling, query performance, and system reliability — but who builds the applications that sit on top of those foundations and the interfaces that make the data useful. You are the person who makes sure the foundation holds: the schema designs that survive three years of feature growth, the query patterns that scale with the client portfolio, and the multi-tenant data models that enforce isolation without sacrificing performance. You will work across our APEX Suite — a unified enterprise intelligence platform serving agriculture, mining, retail, banking, and international cooperatives.

At Reisiger, every engineer operates with extreme ownership: you do not design a schema and hand it to someone else to build around. You build the full feature — database, API, interface — and you own its performance in production. We are architecture-agnostic — PostgreSQL is our backbone today, but you evaluate vector stores, document databases, time-series engines, and caching layers on their merits for each workload. And we are AI-native — Claude Code generates migration scripts, analyses query plans, audits schema drift, and automates data governance checks as part of our daily workflow.

Key Responsibilities

• Design and implement database architectures across multiple paradigms — relational (PostgreSQL), vector (pgvector), document, time-series, and caching — choosing the right engine for each workload

• Build multi-tenant data models that enforce strict client isolation, support entitlement-based access tiers, and scale horizontally as the client portfolio grows

• Own query performance across the platform — indexing strategies, query plan analysis, materialised views, partitioning, and connection pooling

• Architect data replication, backup, point-in-time recovery, and disaster recovery strategies that meet ISO 27001 requirements

• Design and implement vector search and embedding storage patterns for verification engines and retrieval-augmented generation systems

• Build database migration strategies — schema evolution, zero-downtime migrations, data backfills — using Prisma, Flyway, or custom tooling

• Build fullstack features end-to-end — particularly where the data model is the hard part and the UI is the expression of a well-designed query

• Design cross-service data access patterns — how billing reads usage data, how reporting queries aggregates, how real-time systems write event streams

• Leverage Claude Code to generate migration scripts, analyse slow query logs, audit schema drift, validate data integrity constraints, and automate compliance checks

• Ensure data compliance — POPIA, encryption at rest and in transit, data residency requirements, audit logging for all data access

Required Skills & Qualifications

• 5+ years of software engineering experience with at least 3 years focused on database architecture and data-intensive application development

• Expert PostgreSQL proficiency — schema design, advanced indexing (B-tree, GIN, GiST, BRIN), query plan analysis, partitioning, logical replication, row-level security

• Experience with multiple database paradigms — document stores (DynamoDB or MongoDB), vector databases (pgvector or Pinecone), caching layers (Redis), and understanding when each is the right choice

• Strong understanding of multi-tenant data architecture — shared schema with RLS, schema-per-tenant, database-per-tenant, and hybrid approaches with clear trade-off reasoning

• Proficiency in at least one fullstack framework (Next.js with Prisma, .NET with Entity Framework, or equivalent) to build complete features around your data models

• Experience with ORM and migration tooling — Prisma, Flyway, Alembic, Knex, or similar — including zero-downtime migration strategies

• Backend API proficiency — you design APIs that expose your data models efficiently, with proper pagination, filtering, and access control

• Understanding of data compliance — encryption, access logging, anonymisation, data residency, and regulatory requirements (POPIA)

• Active daily use of AI-assisted development tools — prompt engineering, code generation, agent orchestration

• Ability to explain performance implications and architectural trade-offs in business terms to non-technical stakeholders

Preferred Qualifications

• Experience with vector search and RAG (retrieval-augmented generation) patterns — embedding generation, similarity search, hybrid keyword-vector queries

• Knowledge of time-series data handling for IoT, sensor, or financial data workloads

• Experience with PostGIS and geospatial query optimisation for agricultural or mining data

• Familiarity with data lake and lakehouse patterns — S3-based storage with Athena, Glue, or Iceberg for analytical workloads

• Experience with database connection pooling at scale (PgBouncer, RDS Proxy) and connection management in serverless environments

• Knowledge of event sourcing or CQRS patterns for audit-critical data domains

• Understanding of graph database concepts (Neo4j, Neptune) for relationship-heavy data models

• Experience with database observability — slow query logging, pg_stat_statements, query plan regression detection

• Background in building data platforms that serve multiple business domains with different access patterns and SLA requirements

• AWS database certifications or equivalent demonstrated expertise

Visit our website at reisiger.co.za