CGH Technologies, Inc. · 4 months ago
Geospatial Database Engineer
Herndon, VA
Full-time
Onsite
Mid Level
$60K/yr - $65K/yr
3+ years expCGH Technologies, Inc. is a business solutions firm specializing in Data Management, Software Engineering, and Business Intelligence solutions. They are seeking a highly skilled PostgreSQL and PostGIS Database Engineer to support critical systems in cloud and on-premise environments, focusing on geospatial data management and database administration.
Information ServicesManagement Consulting
No H1B
U.S. Citizen Only
Responsibilities
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
Qualification
Required
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
U.S. Citizen or person with valid U.S. Work Visa who has lived in the U.S. for 3 or more years
Demonstrated ability to communicate and interface with the customer and interpret requirements
Ability to communicate 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
While performing the duties of this job, the individual is regularly required to sit, stand, talk, hear and use a computer/keyboard/mouse for several hours on a daily basis
May require occasional light lifting of up to 10 pounds
Benefits
Medical
Dental
Vision
Short- and long-term disability insurance
Life insurance
Commuter benefit
Flexible spending account
401K
Paid holidays
Paid Time Off (PTO)
Company
CGH Technologies, Inc.
CGH Technologies Inc, delivers information engineering solutions and management support services to United States and international government and private sector organizations.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase