Geospatial Database Administrator

Description

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.

• Collaborate with security teams to address findings from security audits and inspections.
• Design, develop, and maintain PostgreSQL databases with PostGIS extensions for geospatial data.
• Manage database configurations, indexing, and optimization for performance and scalability.
• Apply, configure, and validate Security Technical Implementation Guides (STIGs) quarterly to ensure database systems meet DoD cybersecurity requirements.
• Work with Data Manager to develop and execute complex spatial queries and scripts to support mission needs.
• Ensure compliance with Air Force cybersecurity and data security standards.
• Work closely with analysts, engineers, and IT teams to align geospatial systems with operational goals.
• Ensure geospatial databases comply with metadata standards, such as FGDC or ISO 19115.
• Administer Oracle databases and ensure compatibility and interoperability with existing systems.
• Troubleshoot and resolve data compatibility and performance issues during migrations.
• Document and report compliance statuses and remediation efforts.
• Perform database backups, disaster recovery planning, and regular system updates.
• Conduct regular vulnerability assessments, risk analysis, and mitigation for PostgreSQL and Oracle databases.
• Conduct assessments of existing Oracle databases and develop migration strategies.
• Create tools and scripts to automate data migration processes between Oracle and PostgreSQL.
• Lead migration efforts from Oracle to PostgreSQL, including planning, execution, and post-migration support.

Requirements

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

• Advanced knowledge of PostgreSQL and PostGIS, with experience in database design and performance tuning.
• Demonstrated experience migrating Oracle databases to PostgreSQL, including resolving compatibility issues.
• Experience implementing and maintaining STIG compliance for databases.
• Equivalent experience in lieu of a degree may be considered.
• Bachelor’s degree in GIS, Geography, Computer Science, or a related field.
• Proficiency in Oracle database administration, with experience supporting geospatial data.
• Strong problem-solving skills and the ability to troubleshoot database issues effectively.
• Relevant certifications such as PostgreSQL Certified Developer or Oracle Certified Professional are a plus.
• Proven ability to manage large-scale database migrations and optimize geospatial data workflows.
• Travel <20%
• Security Clearance: Must hold or be eligible to obtain a Secret or higher-level security clearance.
• Security certifications like CompTIA Security+ or CISSP are advantageous.
• Excellent communication and collaboration skills for cross-team efforts.
• Expertise in geospatial data standards, formats, and models.
• Familiarity with scripting languages (e.g., Python, SQL, PL/pgSQL, or PL/SQL) for data processing.
• Understanding of Air Force operations and geospatial requirements is preferred.

Benefits

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

Training + Development

Interview process

Visa Sponsorship

Security clearance