Geospatial Database Engineer

CGH Technologies-posted 3 months ago
$60,000 - $65,000/Yr
Mid Level
Herndon, VA
101-250 employees
Professional, Scientific, and Technical Services
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

CGH Technologies, Inc. (CGH) is a business solutions firm, specializing in Data Management, Software Engineering, and Business Intelligence solutions. Located within the Washington corridor, CGH has worked successfully with Government, Commercial and International sectors, providing management consulting, software development and facilities/infrastructure design, maintenance and program management support of large, complex operational environments and facilities security maintenance. CGH has an exciting opportunity for a Geospatial Database Engineer to join the CGH Team. We are seeking a highly skilled PostgreSQL and PostGIS Database Engineer to join our team. This role combines database development, administration, and operational responsibilities to support critical systems in the cloud and on-premise environments. The ideal candidate has extensive experience with geospatial data, PostGIS integration, and the automation of database operations.

  • Design, implement, and maintain PostgreSQL and PostGIS databases supporting spatial and non-spatial workloads.
  • Administer databases, including installation, configuration, patching, upgrades, backups, disaster recovery, and high-availability solutions.
  • Develop, manage, and optimize database schemas, geospatial queries, spatial indexing, and GIS data models.
  • Create, test, and deploy stored procedures, triggers, and functions for applications leveraging geospatial datasets.
  • Aggregate, transform, and analyze large-scale geospatial data from various sources.
  • Monitor and resolve database performance issues, focusing on both relational and spatial query optimization.
  • Automate system operations with shell scripts, SQL scripts, and infrastructure-as-code tools.
  • Ensure database security, auditing, and compliance across all environments.
  • Document operational standards, geospatial procedures, and best practices.
  • 3-5+ years of professional experience with PostgreSQL, including 2+ years of PostGIS in production.
  • Demonstrated record of supporting enterprise-scale geospatial data workflows.
  • Bachelor's degree in Computer Science, GIS, Information Systems, or equivalent experience.
  • Significant hands-on experience with PostgreSQL and PostGIS administration and development.
  • Strong background in geospatial data management, including spatial data formats, projections, indexing, and advanced GIS processing.
  • Ability to develop and optimize complex spatial queries, leveraging PostGIS functions and extensions.
  • Solid understanding of Linux/Unix operating systems and strong scripting skills in Bash, Shell, or similar.
  • Demonstrated experience in cloud and on-premise environments.
  • Good SQL performance tuning experience, including optimizer insights for spatial datasets.
  • Microsoft Office 365 proficiency.
  • Demonstrated ability to communicate and interface with the customer and interpret requirements.
  • Strong interpersonal and communication skills, capable of both collaborative and independent work.
  • Effectively manages a high volume of work while maintaining focus on critical tasks.
  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Short- and long-term disability insurance
  • Life insurance
  • Commuter benefit
  • Flexible spending account
  • 401K
  • Paid holidays
  • Paid Time Off (PTO)
Track Jobs with Teal

Job Search Resources

•
AI Resume Builder
•
Geospatial Engineer Resume Examples
•
Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service