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