Database Administrator

Experience and Requirements

• :
• • Designing and maintaining advanced PostgreSQL data models with JSONB, indexed queries, and real-time updates (LISTEN/NOTIFY).
  • Building triggers, audit logs, and stored procedures for complex integrations.
  • Working with backend teams to expose APIs using Spring Boot or Node.js/Express.
  • Meeting high-performance targets (<100ms latency, ±1,000 TPS) and applying strong security measures (RLS, TLS, OAuth/JWT).
  • Configuring and managing PostgreSQL 16+ and cloud-managed services (AWS RDS/Azure PostgreSQL).
  • Supporting full-text search, JSON-based responses, and disaster recovery planning.

Responsibilities

• 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.

Develop and implement integration processes and interfaces, including third-party
and perimeter/boundary integrations, focusing on secure API gateways, OAuth
2.0 authentication, and JWT token management, aligned with PMO standards