Software Engineer – Geospatial Data & Database
aqua IT
1 day ago
Full-time
On-site
Herndon OR Springfield, Virginia, United States
LiDar, Mapping & GIS
Responsibilities:
- 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
Qualifications/Skills Required:
- 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
- Real-time data processing and streaming architectures
- 3+ years with AWS cloud-native services
- Advanced knowledge of Lambda, API Gateway, EventBridge, SQS, SNS
- Experience with data services: RDS, DynamoDB, Redshift, S3, Athena
- 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