Apply on Employer Site

NV5 · 11 hours ago

Geospatial Database Administrator

St Louis, MO

Full-time

Onsite

Mid Level

NV5 is a global technology solutions and consulting services company specializing in various fields, including geospatial data systems. The Geospatial Database Administrator will manage PostgreSQL and Oracle databases, ensuring their integrity, performance, and security while leading migration efforts and compliance with DoD standards.

ConsultingIndustrial Engineering

No H1B

Security Clearance Required

U.S. Citizen Only

Hiring Manager

Jamie Garrett

Responsibilities

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

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

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

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

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

Qualification

PostgreSQLOracle Database AdministrationSTIG CompliancePostGISDatabase MigrationScripting LanguagesProblem-SolvingCommunication SkillsCollaboration Skills

Required

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 and PostGIS, 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

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

Benefits

Medical

Dental

Life insurance

PTO

401(k)

Professional development/advancement opportunities

Company

NV5

Glassdoor3.5

NV5 is a provider of technology, conformity assessment, and consulting solutions for public and private sector clients supporting infrastructure, utility, and building assets and systems.

Founded in 1947