Software Engineer – Geospatial Data & Database
About The Position
This role focuses on managing and maintaining Aurora Postgres databases with PostGIS extensions, ensuring high availability, performance, and data integrity. The engineer will design and implement Row Level Security (RLS) policies for fine-grained access controls in multi-tenant environments. Key responsibilities include architecting and optimizing spatial databases, schema design, spatial indexing, and query performance tuning. The role also involves overseeing database operations such as backup and recovery, version upgrades, scaling, performance monitoring, and troubleshooting 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
- 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
Nice To Haves
- 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
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
