Database Engineer

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