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.

Key Responsibilities:

• 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.

Required Skills & Qualifications:

• 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.

Preferred 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.