Mid-Level Full-Stack Software Engineer (Data & Migrations)

Redhorse Corporation
United States
about 1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours

Tech stack

Legacy Database Application Programming Interfaces (APIs) Artificial Intelligence Amazon Web Services Data Analysis Cloud Computing Data Integrity Relational Databases Programming Tools IBM Cognos Business Intelligence PostgreSQL Node.Js
+13 more
Operational Databases Oracle (Applications) Performance Tuning PL-SQL TypeScript ReactJS Change Data Capture SC Clearance Containerization Virtual Agents Legacy Systems Web Api Data Generation

Job description

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)., * 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.

Requirements

  • 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

We encourage all candidates who meet the basic requirements to apply, even if you do not have any of the following 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).

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., 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 Talent.Acquisition@redhorsecorp.com

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.clearancejobs.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:21 min

Exploring the target application for front end tests

Anna Mcdougall Ā· JS Congress

9:56 min

Expanding browser capabilities with modern web APIs

Ire Aderinokun Ā· JS Congress

4:36 min

Hiring passionate software engineers to tackle unprecedented scaling challenges

Dana Lawson Dana Lawson +1 Ā· WWC Europe 2026

2:59 min

Introduction and transitioning into the tech industry

Anna Mcdougall Ā· JS Congress

7:44 min

Bootstrapping a test-driven asp.net web api

Alex Banul Ā· LIVE

2:52 min

Addressing junior hiring bottlenecks and mitigating widespread employee burnout

Hung Lee Hung Lee +3 Ā· WWC Europe 2026

Videos

See all

Related articles

See all