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 ( 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 ( 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

Job & Company Description: I am currently building a pipeline of Database Administrators with proven experience and expertise working with cloud-based data platforms. If youre looking to advance your DBA career this is your chance to work on impactful, data-driven projects. Key Responsibilities: Manage and maintain cloud-based and on-premises databases. Perform database installations, upgrades, monitoring, and optimisation. Implement database security, backups, disaster recovery, and high availability. Troubleshoot database issues, ensuring performance, reliability, and scalability. Optimise SQL queries, stored procedures, and database structures. Maintain documentation, policies, and best practices for database environments. Job Experience and Skills Required: Education: Relevant Degree or Diploma in Information Technology, Computer Science, or relevant field. Experience: Must have 3 years experience as a Database Administrator. Strong experience working with cloud platforms (Azure SQL, AWS RDS, Aurora, DynamoDB, or GCP Cloud SQL). Proficient in SQL Server, MySQL, PostgreSQL, or Oracle environments. Hands-on experience with database performance tuning and optimisation. Strong understanding of backups, restores, monitoring, and disaster recovery. Familiarity with automation and scripting (PowerShell, Bash, Python, etc.). Nice to Have: Cloud certifications (Azure / AWS / GCP). Exposure to Infrastructure-as-Code (Terraform, ARM, CloudFormation). Apply now!