Get familiar with our database structures and document how they are modelled.
Analyse table and column usage and prepare migrations where structures are no longer needed.
Improve our data models : reduce duplicated values and work with references and views.
Optimise data access so that more work happens in the database and less in the application.
Measure query performance and add indexes where they make a difference.
Review our database access policies.
You are studying computer science, data engineering or something similar.
Comfortable in SQL : joins, aggregates, indexes, and reading a query plan.
You are happy to spend time reading existing code before changing it.
PostgreSQL specifics (indexing strategies, EXPLAIN, constraints, triggers) and experience with Supabase or a similar API-over-Postgres layer are a plus.
Coursework or a project in data modelling and normalisation .
Experience with AI-assisted development tools .
Humble, low eg