Lead modernization of a legacy Oracle system into a single-schema PostgreSQL platform. Design repeatable migration pipelines, implement automated reconciliation and data-quality checks, extract business rules from PL/SQL, build CDC workflows and analytics stores, and develop full-stack features (TypeScript/Node.js/React) while overseeing AI-agent-generated code and ensuring federal financial audit-grade integrity.
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 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).
We encourage all candidates who meet the basic requirements to apply, even if you do not have any of the following experience:
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.
Similar Jobs
.png)
Greentech • Hardware • Internet of Things • Machine Learning • Software • Business Intelligence • Agriculture
Manage and grow a portfolio of enterprise ranching customers from pilot to full-scale adoption. Own account success, retention, expansion, executive engagement, forecasting, and cross-functional coordination. Build industry relationships and scalable account strategies while frequently traveling to support customers and drive commercial outcomes.
Greentech • Hardware • Internet of Things • Machine Learning • Software • Business Intelligence • Agriculture
Drive new business and manage customer success across NW Wyoming by prospecting, conducting in-field sales and demos, onboarding customers, expanding accounts, and providing field feedback to internal teams while frequently traveling across the territory.
Top Skills:
Precision AgricultureSaaSVirtual Fencing
Greentech • Hardware • Internet of Things • Machine Learning • Software • Business Intelligence • Agriculture
Drive new business and ensure customer success across Utah South by prospecting, conducting in-field sales and onboarding, expanding existing accounts, meeting sales targets, gathering field feedback, collaborating with support teams, and representing Halter at industry events. Own full territory operations and support customers through deployment and adoption of Halter's virtual fencing solutions.
Top Skills:
Precision AgricultureSaaSVirtual Fencing
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
