About the position
Design and maintain robust data models, including tables for users (auth tokens), integrations (flows/status), and logs (timestamps/errors), supporting JSONB for flexible API payloads.
Implement CRUD operations via indexed queries and enable real-time updates using LISTEN/NOTIFY.
Develop integration hooks such as triggers for audit logging and stored procedures for complex joins (e.g., integration patterns analysis).
Collaborate with backend teams to expose API endpoints (e.g., /API/integrations) using frameworks like Spring Boot or Node.js/Express.
Ensure performance targets (<100ms query latency) and support high throughput (1,000 TPS) with connection pooling.
Apply advanced security measures, including row-level security (RLS), TLS encryption, and OAuth/JWT validation at the application layer.
Implement scalability strategies such as horizontal sharding and read replicas for analytics.
Ensure compliance with GDPR and POPIA, including immutable audit logs and secure data handling.
Configure and manage PostgreSQL environments (version 16+), leveraging extensions like PostGIS or TimescaleDB where applicable.
Support managed services (AWS RDS or Azure Database for PostgreSQL) for automated backups and scaling.
Provide full-text search and JSON support for API responses.
Participate in disaster recovery and business continuity initiatives to ensure data availability and integrity.
Minimum Requirements:
Education & Experience
5–8 years of experience in database administration, data design, or ERP support.
Experience with Oracle Financials and ERP delivery.
Bachelor’s degree in IT, Computer Science, or equivalent (NQF 7 preferred).
Equivalent experience will also be considered.
Desired Skills:
- Database Administration
- Oracle Financials and ERP delivery
- Data Design
