The Air Force is looking to solve geospatial data systems critical to their missions by maintaining the integrity, performance, and security of geospatial databases, with a focus on implementing Security Technical Implementation Guides (STIGs) quarterly and migrating Oracle databases to PostgreSQL.
Requirements
- 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.
- Relevant certifications such as PostgreSQL Certified Developer or Oracle Certified Professional are a plus.
- Security certifications like CompTIA Security+ or CISSP are advantageous.
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.
- Apply, configure, and validate Security Technical Implementation Guides (STIGs) quarterly to ensure database systems meet DoD cybersecurity requirements.
Other
- Bachelor’s degree in GIS, Geography, Computer Science, or a related field.
- Equivalent experience in lieu of a degree may be considered.
- Must hold or be eligible to obtain a Secret or higher-level security clearance.
- Travel < 20% of the time
- Employment is contingent upon successful completion of a background check and drug screening.
