Job Requirements
Herndon, VA Springfield, VA
Top Secret/SCI Polygraph not specified
Career Level not specified
Salary not specified
Join Premium to unlock estimated salaries 
Job Description
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
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
group id: 91136741