Principal Database Developer; Onsite

Overview

Date Posted:

Country:
United States of America

Location:

CO106: 16470 East Hughes Drive, Aurora, CO 80011 USA

Position Type:
Onsite

U.S. Citizenship or Immigration Status Requirements:
Active and transferable U.S. government issued security clearance is required prior to start date. U.S. citizenship is required, as only U.S. citizens are eligible for a security clearance

Security Clearance: TS/SCI without Polygraph

This position is eligible for a Sign-On Bonus

At Raytheon, the foundation of everything we do is rooted in our values and a higher calling – to help our nation and allies defend freedoms and deter aggression. We bring the strength of more than 100 years of experience and renowned engineering expertise to meet the needs of today’s mission and stay ahead of tomorrow’s threat. Our team solves tough, meaningful problems that create a safer, more secure world.

We are seeking a Principal Database Developer with Postgre

SQL experience to lead the development, optimization, and management of mission-critical databases supporting Satellite Ground Systems for the intelligence community. This role blends hands-on development with database architecture and administration, ensuring fast, secure, and scalable data solutions in a high-stakes, classified environment. This is an onsite position located in Aurora CO.

• Work closely with software engineers and systems engineers to design relational schemas, build secure and performant queries, implement PostGIS features, and drive improvements that support real-time operations.
• Design, develop, and maintain relational databases using AWS Aurora Postgre
  
  SQL.
• Create and optimize PostGIS-enabled schemas and geo-temporal queries for high-speed data retrieval.
• Define and implement complex security protocols for data filtering and redaction
• Translate data models into normalized, relational schemas aligned with application requirements.
• Collaborate with developers to integrate and optimize database access via JPA/Hibernate and other persistence frameworks.
• Tune performance through advanced indexing, partitioning, and query optimization techniques.
• Set up and manage database environments, including schema version control and migration support.
• Establish secure, efficient structures to support evolving development needs and future scalability.

• Typically requires Bachelor’s degree in Science, Technology, Engineering or Mathematics (STEM) and a minimum of 8 years of prior relevant experience.
• At least five (5) years of experience in Database Administration, including installation, configuration, and maintenance of a Relational Database Management System (e.g., Oracle, Postgre
  
  SQL, or MySQL).
• SQL scripting experience.
• CompTIA Security+ certification (required for privileged access).

• Experience setting up and optimizing AWS Aurora Postgre
  
  SQL environments.
• Experience of relational data modeling and schema versioning in support of software development.
• Experience with security, setting up RLS, session and permissions management, experience with column or cell level security a plus
• Experience with query optimization, mapping tables to blocks and partitions, sub-table structure and keying/indexing for efficiency
• Experience with PostGIS, ability to optimize geo temporal queries and indexes
• Java Persistence (JPA) experience and an understanding of the coupling between JPA structure and the Database.
• Architecture experience: the ability to design schemas (and migrate schemas in place).
• Experience managing an operationally fielded Database while simultaneously being under further development
• Experience with JPA/Hibernate structures and how they interact with the underlying database.
• Experience supporting classified or government systems with strict security requirements.
• Exposure to Dev Ops practices related to database deployment and automation.
• Experience as the sole or lead database expert on a development team.
• Familiarity with source control systems (e.g., Git/Bitbucket) and CI/CD integration.
• Familiarity with Java-based software ecosystems and schema integration in microservice architecture.

• Whether you’re just…