We are seeking a Junior Database Engineer with solid experience in PostgreSQL, particularly with PostGIS. The primary responsibility is to manage and optimise spatial databases for performance, scalability, and reliability. Experience with Python, GIS tools, or FME is a bonus but not required.
Key Responsibilities:
Manage, maintain, and optimise PostgreSQL/PostGIS databases.
Write and improve SQL queries, views, and stored procedures.
Implement and monitor indexing, query performance, and data integrity.
Troubleshoot database issues and ensure uptime and consistency.
Assist in developing scripts for data migration and transformation.
Collaborate with developers and analysts on database-driven features.
Document database structure, logic, and optimisation practices.