Geospatial DB Architect: PostgreSQL + PostGIS Migrations

NV5; St. Louis (MO); On-site; USD 110,000 - 150,000; Full time

Job summary

NV5 Geospatial seeks a Geospatial Database Administrator to maintain PostgreSQL/PostGIS and Oracle databases for DoD-related geospatial systems. The role emphasizes migration from Oracle to PostgreSQL, STIG-based security, and rigorous data integrity.

Responsibilities include performance tuning, backups, and collaboration with cross-functional teams to meet mission goals. Requires DoD-related experience, security clearance eligibility, and strong scripting skills.

Qualifications

• Bachelor’s degree in GIS, Geography, Computer Science, or related field.
• Equivalent experience may be considered.
• Advanced knowledge of PostgreSQL with database design and performance tuning.
• Proficiency in Oracle database administration with geospatial data experience.
• Experience migrating Oracle to PostgreSQL and resolving compatibility issues.
• Experience implementing and maintaining STIG compliance for databases.
• Familiarity with scripting languages such as Python, SQL, PL/pgSQL, or PL/SQL.

Responsibilities

• Design, develop, and maintain PostgreSQL databases with PostGIS extensions for geospatial data.
• Administer Oracle databases and ensure interoperability with existing systems.
• Manage configurations, indexing, and performance tuning for scalability.
• Lead migration efforts from Oracle to PostgreSQL including planning and post-migration support.
• Work with Data Manager to run complex spatial queries and scripts for mission needs.
• Ensure metadata standards compliance (FGDC/ISO 19115).
• Assess existing Oracle databases and develop migration strategies.
• Create tools/scripts to automate data migration between Oracle and PostgreSQL.
• Troubleshoot data compatibility and performance during migrations.
• Ensure compliance with Air Force cybersecurity and data security standards.
• Perform backups, disaster recovery planning, and system updates.
• Collaborate with analysts, engineers, and IT to align systems with goals.
• Apply and validate STIGs quarterly to meet DoD requirements.
• Conduct vulnerability assessments and document remediation efforts.

Skills

PostgreSQL

PostGIS

Oracle

Security STIGs

Scripting (Python/SQL/PL/pgSQL/PL/SQL)

Data migrations (Oracle to PostgreSQL)

Geospatial data standards

Team collaboration

Education

Bachelor’s degree in GIS, Geography, CS or related field

Tools

PostgreSQL

Oracle

PostGIS

Python

SQL

Job description

NV5 Geospatial seeks a Geospatial Database Administrator to maintain PostgreSQL/PostGIS and Oracle databases for DoD-related geospatial systems. The role emphasizes migration from Oracle to PostgreSQL, STIG-based security, and rigorous data integrity.

Responsibilities include performance tuning, backups, and collaboration with cross-functional teams to meet mission goals. Requires DoD-related experience, security clearance eligibility, and strong scripting skills.