Database Engineer

About the role

About the Organization

Now is a great time to join Redhorse Corporation. We are a solution-driven company delivering data insights and technology solutions to customers with missions critical to U.S. national interests. We’re looking for thoughtful, skilled professionals who thrive as trusted partners building technology-agnostic solutions and want to apply their talents supporting customers with difficult and important mission sets.

About the Role

Redhorse is transforming how the government utilizes data and technology. We are looking for an experienced Database Engineer to join the team designing, building, and maintaining a new AWS-hosted, web-based internal tool used by non-technical end users to submit, review, approve, and track sensitive, highly regulated data requests on classified systems. The tool replaces a legacy web application and manual email- and spreadsheet-driven review with automated workflows, structured data capture, and AI-assisted review.

As the Database Engineer, you will own the data layer of the application: modeling the request, review, and audit data; designing the relational and NoSQL stores that back the application; migrating data out of the legacy system; and making sure the database is secure, performant, auditable, and compliant with data-handling policies. You will work closely with application developers, cloud engineers, systems engineers, and policy experts across a multi-company team, and with stakeholders, to translate data-access policy into enforceable database design. This role works under general direction and is expected to independently determine the approach to difficult data problems.

Key Responsibilities - Design, build, and maintain the application's database management systems in the AWS environment, including logical and physical data modeling, relational database architecture, and metadata/repository design.

- Model the request lifecycle (submission, revision, review, approval, fulfillment, dissemination) so that workflow state, justifications, and reviewer decisions are captured as structured, queryable data rather than free text, email, or spreadsheets.

- Implement database-level security controls for sensitive request data, including role- and attribute-based access control, row/column-level security, encryption at rest and in transit, and least-privilege service accounts.

- Design and implement data retention periods, purge workflows, and immutable audit trails that satisfy policy and compliance requirements.

- Analyze the legacy application's data and processes; perform source analysis, data mapping, and data transformation to plan and execute migration into the target environment.

- Determine data storage requirements and evaluate, size, and select database technology components (e.g., Amazon RDS/Aurora PostgreSQL, DynamoDB, S3) for the application.

- Write, review, and tune SQL queries, stored procedures, and indexes for performance and scalability; support developers with efficient data access patterns and APIs.