Systems Engineer TS/SCI | Lead Data Migration & Modeling

Zohorecruit; Columbia (MD); On-site; USD 175,000 - 210,000; Full time

Benefits offered by this job

Health, Dental, Vision Insurance

PTO and Holidays

401(k) with company match

Tuition reimbursement

Job summary

Zohorecruit is seeking a senior Systems Engineer 3 in Columbia, MD. The role requires an active TS/SCI with Polygraph and focuses on reverse engineering ~40 legacy databases into a unified data model for migration to a modern platform.

The ideal candidate will design and implement comprehensive database models, write and optimize SQL across Oracle and PostgreSQL, and ensure data security throughout the process.

Qualifications

• Bachelor’s degree in CS/Systems Engineering with 20+ years of relevant experience, or 25+ years without a degree.
• Database design, data modeling, and schema normalization.
• SQL across Oracle and PostgreSQL.
• Reverse engineering complex software systems.
• Data analysis, normalization, cleansing, and data security governance.

Responsibilities

• Reverse engineer legacy systems across front-end and back-end to map data structures.
• Design unified database models to consolidate ~40 databases into a single system.
• Author and optimize SQL queries within Oracle and PostgreSQL environments.
• Perform data analysis, normalization, cleansing, and validation for migration integrity.
• Implement data security best practices during modeling, extraction, and migration.
• Support data visualization and prototyping for analytic tools.

Skills

Database design

Data modeling

Schema normalization

SQL

RDBMS

Reverse engineering

Data analysis

Data security

Education

Bachelor’s degree in CS/Systems Eng

Tools

Oracle

PostgreSQL

BM&A systems

Job description

Zohorecruit is seeking a senior Systems Engineer 3 in Columbia, MD. The role requires an active TS/SCI with Polygraph and focuses on reverse engineering ~40 legacy databases into a unified data model for migration to a modern platform.

The ideal candidate will design and implement comprehensive database models, write and optimize SQL across Oracle and PostgreSQL, and ensure data security throughout the process.