We are seeking a skilled Database Engineer with deep expertise in PostgreSQL and PostGIS to design, develop, and optimize our spatial and relational data systems. The ideal candidate will have a strong foundation in SQL, database performance tuning, and spatial data management. You will play a critical role in ensuring data reliability, scalability, and accessibility for internal teams and applications.
Design, implement, and maintain PostgreSQL databases with a focus on performance, scalability, and security.
Manage and optimize PostGIS-enabled databases for spatial data processing.
Develop complex SQL queries, stored procedures, triggers, and views to support application and analytics needs.
Monitor database performance, troubleshoot issues, and implement optimizations.
Collaborate with data engineers, GIS analysts, and developers to integrate spatial and relational datasets.
Implement backup, recovery, and high-availability strategies for critical databases.
Maintain data quality, integrity, and consistency across multiple systems.
Stay updated with PostgreSQL and PostGIS best practices, new features, and industry trends.
Strong proficiency in SQL, including advanced querying, joins, window functions, and optimization techniques.
Hands-on experience with PostgreSQL administration, tuning, and replication.
Expertise in PostGIS for spatial data storage, indexing, and queries.
Familiarity with database design principles, normalization, and data modeling.
Experience with ETL processes, data pipelines, or GIS data workflows.
Knowledge of GIS concepts, spatial indexing, and coordinate systems.
Familiarity with version control (Git) and CI/CD practices for database deployments.
Strong analytical, problem-solving, and troubleshooting skills.
Experience with cloud database platforms (AWS RDS, GCP Cloud SQL, Azure Database for PostgreSQL).
Knowledge of performance monitoring tools like pgAdmin, pg_stat_statements, or similar.
Experience with Python or other scripting languages for automation.
Understanding of NoSQL databases or hybrid database architectures.