Geospatial Database Administrator

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

Overview

The Geospatial Database Administrator (GDBA) specializes in PostgreSQL and Oracle database management to support geospatial data systems critical to Air Force missions. The GDBA is responsible for maintaining the integrity, performance, and security of geospatial databases, with a focus on implementing Security Technical Implementation Guides (STIGs) quarterly. The role also includes leading efforts to migrate Oracle databases to PostgreSQL, ensuring compliance with Department of Defense (DoD) standards.

Work Environment:

• Location: Scott Air Force Base - Belleville, IL (This is not a remote position)
• Security Clearance: Must hold or be eligible to obtain a Secret or higher-level security clearance.
• Travel < 20% of the time

Location: US-MO-Saint Louis

Contract type: Regular Full-Time

NV5 is a global technology solutions and consulting services company with a workforce of over 4,500 professionals in more than 100 offices worldwide. NV5's continued growth has been spurred through strategic investments in firms with unique capabilities to help current and future customers solve the world's toughest problems. The NV5 family brings together talent across a wide range of markets and fields, including Professional Engineers, Professional Land Surveyors, Architects, Photogrammetrists, GIS Professionals, Software Developers, IT, Project Management Professionals, and more.

At NV5 Geospatial, We are a collaboration of intelligent, innovative thinkers who care for each other, our communities, and the environment. We value both heart and head, the diversity of our people, and their experiences because that is how we continue to grow as a leader in our industry and expand our individual and collective potential.

Responsibilities

Database Management:

• Design, develop, and maintain PostgreSQL databases with PostGIS extensions for geospatial data.
• Administer Oracle databases and ensure compatibility and interoperability with existing systems.
• Manage database configurations, indexing, and optimization for performance and scalability.
• Lead migration efforts from Oracle to PostgreSQL, including planning, execution, and post-migration support.

Geospatial Data Administration:

• Work with Data Manager to develop and execute complex spatial queries and scripts to support mission needs.
• Ensure geospatial databases comply with metadata standards, such as FGDC or ISO 19115.

Migration Expertise:

• Conduct assessments of existing Oracle databases and develop migration strategies.
• Create tools and scripts to automate data migration processes between Oracle and PostgreSQL.
• Troubleshoot and resolve data compatibility and performance issues during migrations.

System and Security Administration:

• Ensure compliance with Air Force cybersecurity and data security standards.
• Perform database backups, disaster recovery planning, and regular system updates.
• Work closely with analysts, engineers, and IT teams to align geospatial systems with operational goals.

STIG Implementation and Security Compliance:

• Apply, configure, and validate Security Technical Implementation Guides (STIGs) quarterly to ensure database systems meet DoD cybersecurity requirements.
• Conduct regular vulnerability assessments, risk analysis, and mitigation for PostgreSQL and Oracle databases.
• Document and report compliance statuses and remediation efforts.
• Collaborate with security teams to address findings from security audits and inspections.

Qualifications

Requirements:

• Bachelor's degree in GIS, Geography, Computer Science, or a related field.
• Equivalent experience in lieu of a degree may be considered.
• Advanced knowledge of PostgreSQL with experience in database design and performance tuning.
• Proficiency in Oracle database administration, with experience supporting geospatial data.
• Demonstrated experience migrating Oracle databases to PostgreSQL, including resolving compatibility issues.
• Experience implementing and maintaining STIG compliance for databases.
• Familiarity with scripting languages (e.g., Python, SQL, PL/pgSQL, or PL/SQL) for data processing.

Preferred (in addition to requirements):

• Advanced knowledge of PostGIS, with experience in database design and performance tuning.
• Active DoD Secret clearance.
• Relevant certifications such as PostgreSQL Certified Developer or Oracle Certified Professional are a plus.
• Understanding of Air Force operations and geospatial requirements is preferred.
• Security certifications like CompTIA Security+ or CISSP are advantageous.

Competencies & Skills:

• Expertise in geospatial data standards, formats, and models.
• Proven ability to manage large-scale database migrations and optimize geospatial data workflows.
• Strong problem-solving skills and the ability to troubleshoot database issues effectively.
• Excellent communication and collaboration skills for cross-team efforts.

Employment is contingent upon successful completion of a background check and drug screening.

NV5 offers a competitive compensation and benefits package including medical, dental, life insurance, PTO, 401(k) and professional development/advancement opportunities.

NV5 provides equal employment opportunities (EEO) to all applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. NV5 complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

#LI-Onsite

#LI-JG1

#PostGIS

#PostgreSQL