Geospatial Database Administrator

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

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

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

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