Database Engineer – 4D, Oracle, PostgreSQL Migration

🔥 8 minutes ago

🌵 Arizona, California, +18 more states – Remote

🌵 Arizona – Remote 🏄 California – Remote 🏛️ District of Columbia – Remote 🐊 Florida – Remote 🥔 Idaho – Remote 🌽 Illinois – Remote 🦬 Montana – Remote 🎰 Nevada – Remote 🏖️ New Jersey – Remote 🗽 New York – Remote 🌲 North Carolina – Remote 🌲 Oregon – Remote 🦀 Maryland – Remote 🍂 Massachusetts – Remote 🌴 South Carolina – Remote 🎸 Tennessee – Remote 🤠 Texas – Remote ⚔️ Virginia – Remote ☕ Washington – Remote 🧀 Wisconsin – Remote

💵 $119.8k - $149.2k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

🔙 Backend Engineer

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Coforma

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2017

🏛️ Government

Government • Healthcare • Public Interest

Coforma is a mission-driven digital product and design firm that partners with government and public-sector organizations to design and build ethical, accessible, human-centered technology services. They provide research, product design, engineering, and strategy focused on healthcare, veterans services, and public-interest programs, helping modernize government services and improve outcomes for communities.

📋 Description

• Own the migration strategy (from design and build to execution) for moving a proprietary 4D application database and an Oracle database into a consolidated, normalized PostgreSQL platform with no data loss and a verifiable cutover. • Reverse-engineer the source schemas, including a proprietary 4D structure with incomplete documentation, and design the target Postgres data model. • Build repeatable, automated, idempotent ETL/migration pipelines (extract from 4D and Oracle, transform, load into Postgres) that can be run, validated, and safely re-run. • Design and implement data validation and reconciliation to prove source-to-target parity: row counts, checksums, and business-rule spot checks. • Translate vendor-specific logic and constructs (Oracle PL/SQL, sequences, triggers, data types; 4D structures and exports) into Postgres equivalents. • Plan and execute cutover: sequencing, downtime minimization, and a tested rollback plan. • Document the target schema, the migration process, and operational runbooks so the work is maintainable after you. • Solve problems across the stack alongside other engineers including building new systems and improving existing ones, consistently applying best practices with a focus on accessibility. • Collaborate with teammates and government/client stakeholders, and work within agile/scrum: planning, breaking down requirements, refinement, and estimation.

🎯 Requirements

• Proven experience migrating production relational databases end to end, including at least one migration from a legacy or proprietary source system with incomplete documentation. • Strong PostgreSQL experience: schema design, normalization, data types, constraints, indexing, and efficient bulk loading of large datasets (e.g. COPY). • Strong SQL, including the ability to read and translate vendor-specific SQL and procedural code into a different engine's equivalents. • Working Oracle knowledge: extracting schema and data, and understanding Oracle data types, sequences, and PL/SQL well enough to translate them. • Demonstrated ability to build automated, idempotent ETL / data pipelines and to validate data integrity across systems through reconciliation, not assumption. • The engineering judgment and persistence to reverse-engineer an unfamiliar, poorly documented system. You do not need prior 4D experience, but you do need to be the kind of engineer who can figure out a proprietary system you've never seen. • Proficiency with the command line and shell scripting, and the ability to script migration logic in a general-purpose language (Python, Ruby, or similar). • Discipline around version control and testing of migration logic, and experience collaborating in a remote/distributed environment using agile and scrum. • The ability to communicate complex technical concepts to non-technical audiences, including client and government stakeholders. • Strongly Preferred, But Not Required: • Direct 4D experience (the 4D SQL engine, ODBC connectivity to/from 4D, or 4D data export). This is rare and a significant plus, but it is not a requirement, and we will train the right migration engineer on the 4D specifics. • Experience with Oracle-to-Postgres migration tooling such as ora2pg, AWS DMS, or equivalents. • Familiarity with the failure modes of cross-engine migration: character encoding, NULL handling, date/timestamp semantics, and numeric precision. • Infrastructure-as-Code (Terraform, AWS CDK, or similar) for provisioning the target Postgres environment. • 3+ years of experience working with APIs and databases of various types. • 3+ years of experience building applications with open-source programming languages. • Prior experience working in digital services, government, or federal consulting.

🏖️ Benefits

• Internet: Will prioritize and maintain access to strong, reliable internet for the remote nature of our work, except when on vacation or holiday. • Security: Will keep the highest security practices to ensure privacy and security of Coforma and client information, given the nature of our work, even when on vacation. • Travel Flexibility: On request and with advanced notice, will attend in-person events such as meetings, workshops, and trainings as assigned for projects that require it. • Brand Representation: Will represent Coforma professionally and sincerely, modeling our Company Values in all interactions.