Software Engineer – Geospatial Data & Databases (PostgresPostGIS)

Candidates must be willing to work in SCIF daily or as needed. The anticipated end for this work is the end of July with expectation of mod/additional funding through 2027.

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

Requirements

• TS/SCI CI Poly Clearance with VA Customer eligibility and SBU/SECNet/COE accounts
• DoD 8140 Compliance
• 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
• 5 years of advanced Python development experience
• 4 years of data engineering experience
• 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
• 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
• ETL/ELT pipeline development using AWS services
• Experience with data lakes data warehousing and analytics platforms
  • Real-time data processing and streaming architectures
• Strong problem-solving abilities with proven track record of resolving complex technical challenges

Desired Skills

• 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

About Us
For more than 20 years NewGen Technologies has solved our clients toughest IT challenges with integrity security and outstanding service by delivering both technology and talent. We have helped secure borders have used artificial intelligence (AI) to fight terror aided the identification of criminals and have helped to prevent crime through the introduction of team of Highly Cleared Specialists have hard-to-find skills and expertise in a wide spectrum of technologies to provide solutions that transform business processes and solve problems of national significance. #CJ