Geospatial DB Admin (PostGIS/Oracle) with Secret Clearance

Geospatial Consulting Group International (geocgi); St. Louis (MO); On-site; USD 68,000 - 82,000; Full time

Benefits offered by this job

Competitive salaries

401(k) plan with vesting

Medical, Dental, Vision

Training and certifications

Flexible work hours

Professional growth

Job summary

Geo cgi seeks an experienced GIS Database Administrator to manage PostgreSQL/PostGIS databases and oversee Oracle-to-PostgreSQL migrations for DoD missions. The role emphasizes STIG compliance, data security, and performance tuning at a Scott AFB-based site in Illinois.

Responsibilities include designing geospatial schemas, implementing metadata standards, and coordinating with security teams to meet DoD cybersecurity requirements. A Secret clearance or ability to obtain is required.

Qualifications

• Bachelor's degree in GIS, Geography, Computer Science, or related field.
• Advanced knowledge of PostgreSQL with experience in design and performance tuning.
• Proficiency in Oracle database administration for geospatial data.
• Experience migrating Oracle databases to PostgreSQL and resolving compatibility issues.
• Experience implementing and maintaining STIG compliance for databases.
• Familiarity with scripting languages (Python, SQL, PL/pgSQL, PL/SQL).
• 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 ability to troubleshoot database issues.
• Excellent communication and collaboration skills for cross-team efforts.

Responsibilities

• Design, develop, and maintain PostgreSQL databases with PostGIS for geospatial data.
• Administer Oracle databases and ensure interoperability with existing systems.
• Manage configurations, indexing, and performance tuning for scalability.
• Lead Oracle-to-PostgreSQL migrations including planning, execution, and post-migration support.
• Work with Data Manager to run complex spatial queries and scripts for mission needs.
• Ensure geospatial databases comply with FGDC or ISO 19115 metadata standards.
• Conduct migration assessments and develop migration strategies.
• Create tools to automate data migrations and resolve data compatibility issues.
• Ensure DoD cybersecurity and DoD data security standards are met.
• Perform backups, disaster recovery planning, and regular system updates.
• Apply STIGs quarterly and coordinate with security teams on audits.

Skills

PostgreSQL

PostGIS

Oracle DB

STIGs

Python

PL/pgSQL

PL/SQL

Geospatial data standards

Migration from Oracle to PostgreSQL

Database troubleshooting

Security/compliance

Team collaboration

Education

Bachelor's degree in GIS/Geography/Computer Science

Tools

PostgreSQL

Oracle DB

PostGIS

Python

Job description

Geo cgi seeks an experienced GIS Database Administrator to manage PostgreSQL/PostGIS databases and oversee Oracle-to-PostgreSQL migrations for DoD missions. The role emphasizes STIG compliance, data security, and performance tuning at a Scott AFB-based site in Illinois.

Responsibilities include designing geospatial schemas, implementing metadata standards, and coordinating with security teams to meet DoD cybersecurity requirements. A Secret clearance or ability to obtain is required.