Data Engineer | ETL & Oracle on AWS | Flexible Hours

Theradex Oncology; Princeton (NJ); On-site; USD 130,000 - 160,000; Full time

Benefits offered by this job

Medical, dental and vision coverage

401(k) with company match

Tuition reimbursement

Flexible work schedules

Job summary

Theradex Oncology, a CRO focused on oncology trials, seeks a Data Engineer/Oracle DBA to manage databases and build robust ETL data integrations for cancer research.

Responsibilities include designing ETL pipelines, migrating databases to AWS RDS, ensuring data quality and governance in a regulated setting. Base salary ranges from $130,000–$160,000, with limited travel and Princeton office access.

Qualifications

• 7–10 years of Oracle DBA or Data Engineer experience with ETL tools.
• Deep knowledge of Oracle architecture, administration, and performance tuning.
• Proficiency in SQL and PL/SQL.
• Experience with scripting languages (Shell, Python).
• Experience with cloud database technologies (AWS RDS).
• Experience with cloud migration and legacy modernization.
• Strong data warehousing understanding.
• Experience in CRO/pharma or regulated industry preferred.

Responsibilities

• Install, configure, and maintain database instances across environments.
• Perform upgrades, patching, migrations, and backups.
• Monitor performance, ensure security, and implement recovery strategies.
• Automate DBA tasks using SQL, PL/SQL, and shell scripts.
• Plan migrations to AWS RDS for Oracle.
• Design, develop, and maintain ETL processes for data integration.
• Develop data pipelines with Talend, SQL Scripts, and Power Automate.
• Ensure SDLC, validation, governance, and audit documentation.
• Identify data quality improvements and reduce technical debt.
• Create architecture and data lineage artifacts.

Skills

Oracle DBA

Data Engineer

SQL

PL/SQL

Python

Shell scripting

ETL methodologies

Data warehousing

AWS RDS

Cloud migration

Education

Bachelor’s degree in Computer Science/Information Systems

AWS certification preferred

Tools

Talend

Power Automate

SQL Scripts

Job description

Theradex Oncology, a CRO focused on oncology trials, seeks a Data Engineer/Oracle DBA to manage databases and build robust ETL data integrations for cancer research.

Responsibilities include designing ETL pipelines, migrating databases to AWS RDS, ensuring data quality and governance in a regulated setting. Base salary ranges from $130,000–$160,000, with limited travel and Princeton office access.