Geospatial Data & Database Engineer Security Clearance

Position: Geospatial Data & Database Engineer with Security Clearance
Software Engineer – Geospatial Data & Database (Postgres/PostGIS)
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
o Real-time data processing and streaming architectures

• 3+ years with AWS cloud-native services
o Advanced knowledge of Lambda, API Gateway, Event Bridge, SQS, SNS
o

Experience with data services: RDS, Dynamo

DB, 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 Postgre

SQL 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