Database Systems Web Developer at The School of St Jude

To design, develop, test, and deploy a secure, scalable, and user-friendly Alumni Portal that serves over 1,000 graduates. The system must also be structured to support seamless extension into Android and iOS mobile applications and integrate with other digital platforms used by the school.

Key Responsibilities

• Lead the end-to-end development of the Alumni Portal
• Collaborate with the CA Team and stakeholders for requirement gathering and planning
• Develop secure and scalable backend and frontend systems
• Design modern, responsive, and accessible user interfaces
• Conduct regular fortnightly/monthly knowledge transfer sessions with the internal CA Team developers
• Ensure thorough testing, documentation, and technical training for future maintenance
• Suggest and implement additional features to enhance functionality, upon mutual agreement

Deliverables

Platform Architecture & Accessibility

• Fully responsive web-based Alumni Portal accessible via desktops, tablets, and smartphones, based on the School of St Jude colour themes and logos.
• Backend designed with scalable architecture and shared APIs to support seamless development of future Android and iOS mobile applications as well as integration with other platforms.

Multi Tenant User Account & Profile Management

• Role-based access control (Alumni, Admins, Moderators, Staff)
• Secure account provisioning via admin-imported verified emails (no self-registration)
• Custom profile fields (academic, professional, interests)
• Alumni can edit and update profiles with admin review workflow

Dashboards & Analytics

• Visual dashboards for user engagement, login trends, content interactions
• Real-time analytics using best standard tools and features (e.g., Graphs, Google Analytics)
• Admin tracking by role, location, activity type, and growth metrics

Interactive Opportunity Board

• Jobs, internships, and scholarships posting with expiry countdowns and status badges
• Features: like, comment, share, document attachments
• Alumni-contributed listings subject to admin moderation

Events Management System

• Calendar/list views of alumni reunions, webinars, and workshops
• Features: RSVP, join events, like, comment, discussion threads, automated reminders

Alumni Service & Business Board

• “Alumni Marketplace” where alumni showcase goods/services for staff, alumni, and community
• Listings include descriptions, attachments, contact info, post expiry, etc.
• Interactive features: like, comment, share
• Admin approval required

Alumni Contribution & Support Section

• Forms for volunteering, donating, and contributing to alumni-administered initiatives
• Support categories (Donation, Mentorship, Sponsorship, Skill Sharing)
• Submissions routed to admins with email notifications

Community Groups & Interest Circles

• Interest- or profession-based alumni groups
• Group creation with admin approval
• Group-level news feeds, documents, discussion threads
• Interactive features: like, comment

Alumni Connect – Learning Resource Centre

• Career development repository: courses, guides, articles, videos, PDFs, DOCX, links, etc.
• Users can like, rate, comment, and bookmark materials
• Content managed by admins and moderated alumni contributions

Feedback & Survey System

• Form-based tools to collect user experience, feature requests, and engagement data
• Optional anonymous submissions
• Results visualized in the access given users’ dashboard

Communication Tools & Notifications

• Real-time messaging between users: Alumni, Admins, etc.
• Support Chat with category-based routing
• Multi-channel notifications: email, in-portal alerts, and SMS
• Admin-controlled communication templates

Secure API Integration Framework

• RESTful API with access control for external service integration
• Token-based authentication (OAuth2/API Keys)
• Developer documentation for internal/external use

Social Media Interaction & Sharing

• Ability for users to share posts, events, and opportunities directly to and from social media platforms
• Integration of social sign-in and profile linking (e.g., LinkedIn, Facebook)
• Real-time display of alumni social mentions, highlights, or achievements

Security & Privacy Enhancements

• General Data Protection Regulation (GDPR)-style privacy settings
• Consent-based data usage and session management
• Audit logs, encrypted sessions, login alerts, and secure file storage
• Comprehensive system logs capturing all user activities and admin operations for audit purposes

Hosting, Launch & Technical Documentation

• Virtual Private Server (VPS)-based deployment with staging and production
• Secure Socket Layer (SSL) configuration, performance optimization, automated backups
• Source code and documentation on the School of St Jude GitHub Account
• Admin and developer handover, training sessions, and user manuals

Data Export & Reporting Capabilities

• All user-generated data (profiles, posts, submissions, etc.) and analytics can be exported in multiple formats including XLS, CSV, and PDF
• Role-based access to reporting tools for data visualization and download

Interactive Capabilities Summary

All applicable content types (opportunities, events, resources, groups, service listings, posts, comments, attachments, etc.) will support:

• Like
• Comment
• Share
• User edits (own content), while giving the selected admins access to historical edits
• Admin moderation
• Etcetera

Required Qualifications & Experience

• 5+ years in full-stack web application development
• Bachelor Degree in Computer Science, IT, Software Engineering, Computer Engineering or any other related field.
• Proficiency in:
  • Backend: PHP (Core + Frameworks)
  • Frontend: Bootstrap, HTML5, CSS3, JavaScript, jQuery, AJAX
  • Database: MySQL/MariaDB
  • Web servers: Apache, Nginx, IIS
  • Version control: GitHub
• Strong grasp of web security and RESTful API development
• Experience with remote consulting and international projects
• Proven a minimum of three previously delivered projects actively in use using the mentioned technologies (provide proof from the clients)

Preferred:

• Mobile app development experience (Android/iOS)

Working Conditions

• Work Mode: Hybrid / On-site (at the School of St Jude, Arusha)