Database Engineer

JOSEF GROUP INC

Annapolis Junction, MD, United States

2 days ago

Apply on www.careerbuilder.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.careerbuilder.com

Tech stack

Geographic Information Systems Cloud Database Configuration Management Databases Continuous Delivery Continuous Integration Data Files Data Integrity Extract Transform Load (ETL) Data Recovery Relational Databases Database Design

+25 more

Python (Programming Language) PostgreSQL SQL Azure NoSQL Performance Tuning PostGIS Server Administration Spatial Data Infrastructures SQL Stored Procedures SQL Databases Data Processing Scripting Freeform SQL System Availability Database Optimization Database Performance Indexer Git Amazon Relational Database Service Optimization Algorithms Performance Monitor Data Management Database Rules and Triggers Software Version Control Data Pipelines

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., * 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.

Requirements

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.

Skills: Continuous Deployment/Delivery, Continuous Integration, Data Management, Data Modeling, Data Processing, Data Quality, Data Recovery, Data Sets, Database Administration, Database Architecture, Database Design, Database Extract Transform and Load (ETL), Database Programming, Database Triggers, Geographic Information Systems (GIS), Geospatial Analysis, Git, High Availability, Identify Issues, NoSQL, Performance Analysis, Performance Tuning/Optimization, PostgreSQL, Quality Management, Replication and Remote Mirroring, SQL (Structured Query Language), SQL Databases, Software Administration, Source Code/Configuration Management (SCM), Spatial Data, Stored Procedures