Database Engineer

Role Overview

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 Postgre
  
  SQL 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 Postgre
  
  SQL 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 Postgre
  
  SQL 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 Postgre
  
  SQL).

• Knowledge of performance monitoring tools like pg Admin, _statements, or similar.

• Experience with
  Python or other scripting languages for automation.

• Understanding of No
  
  SQL databases or hybrid database architectures.