Get Started
Hunting for you, 24x7Get the iPhone app

Your hunt runs in your pocket, and tells you the moment a strong match opens.

Download on theApp Store
EVERSANAPosted 11 days ago

Oracle Argus Safety

Who we'd reach at EVERSANAFound and reached by Power Apply
Best leadHiring manager

Leads the team this role joins

Team lead

Runs the team day to day

Founder

Decides on early hires

Power Apply

From your own Gmail and LinkedIn.

About the role

This is a full-time, onsite senior consultant role in EVERSANA's information systems area, for someone who migrates pharmacovigilance safety data into Oracle Argus Safety. The work involves converting PostgreSQL safety databases to Oracle and validating the results for regulated use. EVERSANA provides commercialization services to life sciences clients, and this role sits within its clinical and medical department.

What you’ll do

  • Lead end-to-end pharmacovigilance data migrations from legacy safety databases
  • Assess source systems, profile data and evaluate migration impact
  • Convert PostgreSQL schemas, tables, procedures and triggers into Oracle Database and Oracle Autonomous Database
  • Write source-to-target mappings, transformation rules and migration documentation
  • Build SQL and PL/SQL for extraction, transformation, loading and reconciliation
  • Run validation, reconciliation and exception reports across cases, products, events and other safety entities
  • Support SIT, UAT, performance testing and production validation
  • Diagnose and fix defects in data quality, mapping and configuration
  • Create Oracle BI Publisher reports for migration verification
  • Support Oracle Argus upgrades and cloud and database modernization on OCI and ADB
  • Mentor junior consultants and recommend automation

What they’re looking for

  • Strong PostgreSQL administration and development experience
  • Hands-on experience converting PostgreSQL to Oracle, including Oracle Autonomous Database
  • Strong SQL and PL/SQL programming skills
  • Experience writing migration scripts, stored procedures, packages and automation utilities
  • Experience with Oracle SQL Developer Migration Workbench or similar conversion tools
  • Understanding of Oracle architecture and performance tuning
  • Experience with ETL and optimizing queries for high-volume data
  • Familiarity with GxP, 21 CFR Part 11, EMA, ICH E2B(R3) and GAMP 5 expectations
  • Seven or more years of relevant experience in safety IT systems

Nice to have

  • Bachelor's or Master's degree in an IT discipline

Skills

PostgreSQLOracle DatabaseOracle Autonomous DatabasePL/SQLSQLOracle Argus SafetyETLData MigrationData ValidationData ReconciliationOracle SQL DeveloperOracle BI PublisherOCIGxP21 CFR Part 11GAMP 5

Questions about this role

Is this role onsite?

Yes, the listed work arrangement is onsite.

How many years of experience are needed?

Seven or more years of relevant safety IT experience.

Do I need Oracle Argus experience?

The role centers on Oracle Argus Safety, so familiarity with the system and its upgrades is central to the work.

Is a degree required?

A degree in an IT discipline is preferred, not stated as mandatory.