Senior Systems Engineer: Unified DB & Legacy Migration

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

Benefits offered by this job

Health, Dental, and Vision Insurance

Life and Disability Insurance

PTO and Holidays

401(k) with Company Match

Tuition Reimbursement

Job summary

J T in Columbia, MD is seeking a senior Systems Engineer 3 to support a mission-critical initiative delivering advanced visualization and presentation services for analytic tool prototyping, development, and production. You will reverse engineer ~40 legacy databases into a unified, universal data model to enable efficient data analysis and migration to a modern platform.

The role requires active TS/SCI with Polygraph clearance and deep expertise in database design, SQL, and data security

Qualifications

• Bachelor’s degree in Computer Science, Systems Engineering, or related discipline plus 20+ years of experience, OR 25 years of relevant experience without a degree.
• Proven expertise in database design, data modeling, and schema normalization.
• Extensive hands-on experience with SQL in Oracle and PostgreSQL.
• Demonstrated reverse engineering of complex software systems across front-end and back-end layers.
• Proven track record in data analysis, cleansing, normalization, and data security governance.

Responsibilities

• Reverse engineer legacy systems across front-end and back-end to map data structures and workflows.
• Design, architect, and develop unified database models to consolidate ~40 databases.
• Author and optimize complex SQL queries in Oracle and PostgreSQL.
• Perform data analysis, normalization, cleansing, and validation to ensure data integrity during migration.
• Implement robust data security practices throughout modeling, extraction, and migration phases.
• Support data visualization and prototyping for downstream analytic tools.

Skills

Database design

Data modeling

Schema normalization

SQL

RDBMS

Reverse engineering

Data processing

Data security governance

Security clearance

Education

Bachelor’s degree in Computer Science, Systems Engineering, or related

25 years of relevant experience without a degree

Tools

Oracle

PostgreSQL

Job description

J T in Columbia, MD is seeking a senior Systems Engineer 3 to support a mission-critical initiative delivering advanced visualization and presentation services for analytic tool prototyping, development, and production. You will reverse engineer ~40 legacy databases into a unified, universal data model to enable efficient data analysis and migration to a modern platform.

The role requires active TS/SCI with Polygraph clearance and deep expertise in database design, SQL, and data security