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.