Database Engineer

Database Engineer

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.