Posted at: 7 July
Mid-Level Full-Stack Software Engineer (Data & Migrations)
Company
Redhorse Corporation is a Virginia-based B2B professional services firm specializing in management and technology consulting, engineering, and IT solutions for U.S. government agencies and Fortune 500 companies.
Remote Hiring Policy:
Redhorse Corporation offers remote, hybrid, and on-site work arrangements, with hiring limited to candidates based in the United States. Team members are supported in various U.S. locations, and remote roles are available depending on the position.
Job Type
Full-time
Allowed Applicant Locations
United States
Job Description
About the Role
Redhorse transforms the way government uses data and technology. We are seeking "Everything Engineers" with a Data Focus to lead the modernization of a mission-critical legacy system managing billions of dollars in international security cooperation.
This role is for the "Agent-native" engineer. On this team, AI-led development isn't a novelty—it’s how we build. You will work through agentic toolkits (Claude Code, Codex, etc.) every day to replace a decades-old Oracle-based platform with a modern, high-integrity PostgreSQL ecosystem. You will own the ground the modernization stands on, ensuring that years of complex production data are migrated with financial-grade proof while building across the full stack (UI, API, and Infrastructure).
Key Responsibilities
- Decompose complex data and business problems into specifications precise enough for AI agents to implement directly and concretely.
- Design and maintain a repeatable migration pipeline that consolidates legacy mirrored Oracle schemas into a modern, single-schema PostgreSQL environment.
- Implement rigorous automated reconciliation machinery (checksums, financial control totals, and row counts) to provide government acceptance evidence.
- Conduct "legacy archaeology" by interrogating hundreds of thousands of lines of PL/SQL packages and triggers to extract and document load-bearing business rules.
- Develop transactional schemas using Prisma and design Change Data Capture (CDC) workflows into dedicated analytics stores.
- Build complete vertical slices of capability, including React-based admin UIs for data quality reports and Node.js API endpoints.
- Set the technical bar for data integrity, utilizing golden-master behavioral checks to prove migrated cases still price and process identically to legacy systems.
- Maintain a rigorous human-review process for all agent-generated code to ensure compliance with federal financial standards.
Required Experience/Clearance
- Must be a U.S. Citizen and eligible for a U.S. SECRET clearance.
- 3+ years of experience building and operating production data systems.
- Hands-on experience with agentic AI development tools (Claude Code, Codex, or equivalent) on real-world codebases.
- Strong track record with relational data systems, including schema design, migration, and performance tuning.
- Ability to read and reason about PL/SQL and legacy database logic.
- Professional fluency in the modern web stack: TypeScript, Node.js, and React.
- Demonstrated experience with cloud infrastructure (AWS) and CI/CD fundamentals.
Desired Experience
- Experience with heterogeneous migrations, specifically moving from Oracle to PostgreSQL.
- Familiarity with data modeling for analytics and replacing legacy reporting estates like Cognos.
- Background in financial data systems or environments subject to strict federal audit standards.
- Experience with AWS GovCloud, CDK, and containerized deployments (EKS/ECS).
- Experience with data-quality tooling and synthetic data generation.
- Prior work in a regulated government environment (FedRAMP, RMF, or IL-specific programs).