Geospatial Data & Database Engineer

AQUA IT
Herndon, United States of America
12 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Herndon, United States of America

Tech stack

Query Performance
Geographic Information Systems
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Business Analytics Applications
Computer Programming
Databases
Data as a Services
Information Engineering
Data Integrity
ETL
Data Warehousing
Database Security
Disaster Recovery
Amazon DynamoDB
Spatial Databases
Monitoring of Systems
PostgreSQL
Performance Tuning
PostGIS
Amazon Web Services (AWS)
Software Engineering
Management of Software Versions
System Availability
Database Optimization
Servicebus
Amazon Web Services (AWS)
Data Lake
Kubernetes
Infrastructure Automation Frameworks
Deployment Automation
Performance Monitor
Amazon Web Services (AWS)
Api Gateway
Amazon Web Services (AWS)
Stream Processing
Data Pipelines
Redshift

Job description

  • Manage and maintain Aurora Postgres databases with PostGIS extensions, ensuring high availability, performance, and data integrity
  • Design and implement Row Level Security (RLS) policies to enforce fine-grained access controls and data isolation across multi-tenant environments
  • Architect and optimize spatial databases, including schema design, spatial indexing strategies, and query performance tuning for geospatial workloads
  • Oversee database operations including backup and recovery procedures, version upgrades, horizontal and vertical scaling, performance monitoring, and troubleshooting of production issues

Requirements

  • TS/SCI with CI Poly required

  • Must be willing to work in SCIF daily or as needed

  • 5+ years of professional software engineering experience with cloud-first development approach

  • 5+ years of hands-on experience with AWS CDK for Infrastructure as Code

  • 3+ years building complex, reusable CDK constructs and stacks

  • Proficiency in async programming and performance optimization* 3+ years implementing multi-environment deployment strategies using CDK

  • 5+ years of advanced Python development experience

  • 4+ years of data engineering experience

  • ETL/ELT pipeline development using AWS services

  • Experience with data lakes, data warehousing, and analytics platforms o Real-time data processing and streaming architectures

  • 3+ years with AWS cloud-native services o Advanced knowledge of Lambda, API Gateway, EventBridge, SQS, SNS o Experience with data services: RDS, DynamoDB, Redshift, S3, Athena o Container orchestration with ECS, Fargate, or EKS

  • Strong problem-solving abilities with proven track record of resolving complex technical challenges Preferred Qualifications:

  • 3+ years of hands-on experience managing and optimizing PostgreSQL or Aurora Postgres databases in production environments, with demonstrated expertise in PostGIS for geospatial workloads

  • Strong understanding of database security best practices, including Row Level Security (RLS) implementation and multi-tenant access control strategies

  • Proven experience designing and optimizing spatial database schemas, implementing spatial indexing strategies, and tuning complex geospatial queries for performance at scale

  • Solid operational experience with database administration tasks including backup/recovery, version upgrades, scaling strategies, monitoring tools, and troubleshooting production incidents

  • *Familiarity with cloud-native database services (AWS RDS/Aurora preferred) and infrastructure-as-code practices

Apply for this position