Geospatial DBA-Scott Air Force Base, Illinois (St. Louis area)

At geocgi we pride ourselves on not losing our focus. We started out and remain GIS experts (or geeks. . . depending on your perspective). Since 2006, we’ve evolved into a world-class and world-wide service provider of multiple disciplines. We are a talented, hardworking group that share values and characteristics that drive client, professional, and personal success. geocgi is seeking a skilled Geospatial Database Administrator to provide database management support for geospatial systems for the United States Air Force Program at Scott Air Force Base, Illinois (St. Louis area). The Geospatial Database Administrator will manage PostgreSQL and Oracle databases to support geospatial systems for Air Force missions, ensuring database integrity, performance, security, and compliance with DoD standards, while leading migration efforts from Oracle to PostgreSQL. The Geospatial Database Administrator will also focus on implementing Security Technical Implementation Guides (STIGs) quarterly. This position’s location is at Scott Air Force Base in Illinois (St. Louis area). 

Key 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 the 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 and document 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 U.S 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. 

As an employee of geocgi, the Geospatial Database Administrator will have access to a generous benefits package, in addition to a corporate culture and community of GIS geeks. Our benefits include but are not limited to: 

• Competitive salaries, commensurate with experience and leading Federal Contractors in the geospatial industry. 
• Opportunities for upward mobility in a dynamic fast paced environment within a small company. 
• Merit-based spot and end of year bonuses. 
• Safe Harbor 401(k) plan with immediate vesting. 
• Flexible work hours and PTO. 
• Complete Medical, Dental, and Vision coverage for individuals. 
• Company paid training, certifications, and professional growth and development. 

The following are requirements of the Geospatial Database Administrator: 

• US Citizen with a DoD Secret Clearance or ability to obtain and maintain. 
• Ability to obtain and maintain CompTIA Security+ Certification. 
• 4 years of experience with a Bachelor’s degree in Geography, GIS, Computer Science, Engineering, or related field; or 2 years of experience with a Master’s degree; or 2 years of experience with a PhD. 
• 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. 
• Understanding of Air Force operations and geospatial requirements is preferred. 
• 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.  
• Skilled in communicating effectively with military command staff, contractors, and civilians, ensuring clear and concise information exchange across diverse groups and stakeholders. 
• Ability to manage multiple projects, meet deadlines, and work both independently and collaboratively, with a passion for location-based problem-solving to support business and mission-critical challenges. 
• Proficient with Microsoft Office Suite (Word, Excel, PowerPoint, Outlook). 

The following are preferred or be willing to obtain and maintain of the Geospatial Database Administrator: 

• CompTIA Security+ Certification. 
• CISSP Certification 
• PostgreSQL Certified Developer or Oracle Certified Professional. 

Please visit our website and careers page at: www.geocgi.com to apply. Geocgi provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. As a U.S. Federal Contractor, geocgi complies with COVID-19 vaccine mandates for all personnel as outlined by Executive Order 14042.