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 biometrics. Our 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

Apply to Software Engineer – Geospatial Data & Databases (Postgres/PostGIS)