Redhorse

Government consulting with AI-driven digital transformation

Database Engineer

Database AdministrationConfirmed live in the last 24 hours

Full-timeChantilly, VA, USAIn-person

About the Job

Requirements

Active Top Secret/Sensitive Compartmented Information clearance with polygraph.
A bachelor's degree in Computer Science, Information Systems, Information Technology, Engineering, or a related field and 5+ years of relevant experience; or a master's degree and 3+ years of relevant experience. Equivalent experience may be considered in lieu of a degree.
5+ years of experience designing, building, and administering relational databases such as PostgreSQL, Oracle, Microsoft SQL Server, or MySQL.
Expert SQL skills, including query writing, performance tuning, indexing strategy, and stored procedures or functions.
Demonstrated experience with conceptual, logical, and physical data modeling and relational database design.
Hands-on experience with AWS database and storage services such as Amazon RDS, Aurora, DynamoDB, and S3, preferably on classified systems.
Experience implementing database security, including access control, encryption, and auditing.
Experience implementing backup, recovery, and replication solutions.
Experience with data migration, including source analysis, data mapping, and data transformation from legacy systems.
Scripting experience with Python, Bash, or PowerShell for automation and data processing.

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 or repository design.
Model the request lifecycle so 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- and 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 such as Amazon RDS or Aurora PostgreSQL, DynamoDB, and S3.
Write, review, and tune SQL queries, stored procedures, and indexes for performance and scalability; support developers with efficient data access patterns and APIs.
Implement comprehensive backup, recovery, and replication solutions; define and test recovery point objective and recovery time objective targets.
Establish database configuration management and schema change control, including migration scripts and versioning, integrated into the team's continuous integration and continuous delivery pipeline.
Structure and prepare data to support rules-based validation, AI-assisted detection of common request errors, reporting, and metrics for customer leadership.
Monitor database health, capacity, and performance; troubleshoot and resolve production data issues.
Prepare system requirements, data dictionaries, and design documentation throughout implementation.

Desired Qualifications

A master's degree in Computer Science, Information Systems, Information Technology, Engineering, or a related field.
Experience supporting application development on classified systems.
AWS certification, such as AWS Certified Database – Specialty or Solutions Architect – Associate, or equivalent.
Experience with NoSQL data stores such as DynamoDB and MongoDB and choosing between relational and NoSQL designs.
Experience with regulated or sensitive data, including retention schedules, purge or expungement, audit logging, privacy controls, and role- and attribute-based access control.
Experience with workflow- or case-management data models involving requests, approvals, and state transitions.
Experience with database schema-change tooling such as Flyway and Liquibase and continuous integration, continuous delivery, or SecDevOps practices.
Experience with Infrastructure as Code such as Terraform and CloudFormation and containers such as Docker and Kubernetes.
Experience with ETL or ELT tools and event-driven AWS services such as Lambda, SQS, and Glue.
Experience preparing data for machine learning or AI-assisted applications.
Experience with Agile methodologies and tools such as Jira and Confluence.

Salary Range: 150000 to 225000 (Currency: USD) (Pay period: per-year-salary)

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.

Implement comprehensive backup, recovery, and replication solutions; define and test RPO/RTO targets.

Establish database configuration management and schema change control (migration scripts, versioning) integrated into the team's CI/CD pipeline.

Structure and prepare data to support rules-based validation and AI-assisted detection of common request errors, and to support reporting and metrics for customer leadership.

Monitor database health, capacity, and performance; troubleshoot and resolve production data issues.

Prepare system requirements, data dictionaries, and design documentation throughout implementation.

Required Qualifications

Active TS/SCI with Polygraph.

Bachelor's degree in Computer Science, Information Systems, Information Technology, Engineering, or a related field and 5+ years of relevant experience; or a Master's degree and 3+ years of relevant experience. Equivalent experience may be considered in lieu of a degree.

5+ years of experience designing, building, and administering relational databases (e.g., PostgreSQL, Oracle, Microsoft SQL Server, MySQL).

Expert SQL skills, including query writing, performance tuning, indexing strategy, and stored procedures/functions.

Demonstrated experience with data modeling (conceptual, logical, and physical) and relational database design.

Hands-on experience with AWS database and storage services (e.g., RDS, Aurora, DynamoDB, S3), preferably on classified systems.

Experience implementing database security, including access control, encryption, and auditing.

Experience implementing backup, recovery, and replication solutions.

Experience with data migration: source analysis, data mapping, and data transformation from legacy systems.

Scripting experience (e.g., Python, Bash, or PowerShell) for automation and data processing.

Desired Qualifications

Master's degree in any of the above fields.

Experience supporting application development on classified systems.

AWS certification (e.g., AWS Certified Database – Specialty, Solutions Architect – Associate) or equivalent.

Experience with NoSQL data stores (e.g., DynamoDB, MongoDB) and choosing between relational and NoSQL designs.

Experience with regulated or sensitive data: retention schedules, purge/expungement, audit logging, privacy controls, and RBAC/ABAC.

Experience with workflow- or case-management data models (requests, approvals, state transitions).

Experience with database schema-change tooling (e.g., Flyway, Liquibase) and CI/CD / SecDevOps practices.

Experience with Infrastructure as Code (e.g., Terraform, CloudFormation) and containers (Docker, Kubernetes).

Experience with ETL/ELT tools and event-driven AWS services (e.g., Lambda, SQS, Glue).

Experience preparing data for machine learning or AI-assisted applications.

Experience with Agile methodologies and tools such as Jira and Confluence.

The salary range provided for this position represents the anticipated base salary for successful candidates. Actual compensation will be determined based on a variety of factors, including relevant experience, education, certifications, skills, security clearance level, geographic location, market conditions, and internal equity. In addition to base salary, eligible employees may participate in Redhorse's comprehensive benefits programs and may be eligible for performance-based or other incentive compensation, where applicable.

Redhorse Corporation is an equal opportunity employer. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability, or any other protected class.

If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability. You can request reasonable accommodations by contacting Talent Acquisition at [email protected]

Redhorse Corporation shall, in its discretion, modify or adjust the position to meet Redhorse’s changing needs. This job description is not a contract and may be adjusted as deemed appropriate in Redhorse’s sole discretion.

About the Company

Redhorse

Government consulting with AI-driven digital transformation

Redhorse helps government agencies improve operations by providing consulting and hands-on delivery that combines digital transformation, artificial intelligence, and sector expertise in National Security, Networking Technology and Infrastructure, Energy, and the Environment. The company works with clients on mission-critical projects, analyzing data and systems and then designing architectures, implementing technology changes, and guiding long-term partnerships in regulated environments. Its differentiators are close, collaborative client work, sector-specific knowledge, and a focus on outcomes that align with public sector security and compliance needs. The goal is to help government agencies operate more efficiently, securely, and effectively through data-driven strategies and AI-enabled transformations.

Company size: 201-500
Company stage: Growth Equity (Venture Capital)
Total funding: Not listed
Headquarters: Arlington County, VA
Founded: 2008

Recently Posted Jobs

Explore more opportunities at Redhorse

See more jobs