Database Engineer

The Josef Group; Maryland; On-site; USD 90,000 - 150,000; Full time

Job summary

The Josef Group in Maryland is seeking a Database Engineer with deep PostgreSQL and PostGIS expertise to design, develop, and optimize spatial and relational data systems for internal applications. You will design and maintain PostgreSQL databases, optimize PostGIS-enabled datasets, develop complex SQL, and ensure data reliability, scalability, and security.

Collaboration with data engineers and GIS analysts is essential.

Qualifications

• Strong proficiency in SQL, advanced querying and optimization.
• Hands-on PostgreSQL administration, tuning, and replication.
• Expertise with PostGIS for spatial data storage and indexing.
• Experience with ETL processes, data pipelines, or GIS workflows.
• Knowledge of GIS concepts, spatial indexing and coordinate systems.
• Familiarity with Git and CI/CD practices for deployments.
• Strong analytical and problem-solving abilities.

Responsibilities

• Design, implement, and maintain PostgreSQL databases with 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.
• Monitor database performance and troubleshoot issues.
• Collaborate with data engineers, GIS analysts, and developers.
• Implement backup, recovery, and high-availability strategies.
• Maintain data quality, integrity, and consistency.
• Stay updated with PostgreSQL and PostGIS best practices.

Skills

Strong proficiency in SQL

Analytical and troubleshooting skills

Data modeling principles

Tools

PostgreSQL

PostGIS

pgAdmin

Git

CI/CD

Job description

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.