Database Engineer (PostgreSQL)

Database Engineer – PostgreSQL £50,000 | Fully Remote, UK | Permanent We’re working with a growing data and technology business looking for a Database Engineer to take ownership of improving the PostgreSQL databases behind its live, data-intensive platforms. This is not a traditional DBA position. You’ll work closely with software developers and DevOps engineers to improve database performance, optimise the way applications access data and help shape better database solutions as the platform continues to scale. The business processes large volumes of time-sensitive, high-throughput data, so performance, efficient retrieval and latency really matter. There is also a substantial archive of historical data that needs to become easier and more efficient to organise, search and retrieve. This would be a great opportunity for someone who enjoys finding database problems, understanding why they are happening and implementing practical solutions. What you’ll be doing * Reviewing and improving PostgreSQL schemas, indexes, constraints and SQL queries * Investigating slow queries using execution plans, database statistics, logs and monitoring * Optimising joins, repeated lookups and application data-access patterns * Working closely with developers to improve database design before new features are released * Improving how large volumes of historical data are organised, archived, indexed and retrieved * Designing views, materialised views and reporting structures where appropriate *…