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

Sr Pharmacovigilance Data Migration Consultant – Oracle Argus Safety

Clinical & MedicalSeniorFull-time
Who we'd reach at EVERSANAFound and reached by Power Apply
Best leadHiring manager

Leads the team this role joins

Founder

Decides on early hires

Head of talent

Runs hiring at the company

Power Apply

From your own Gmail and LinkedIn.

About the role

This is a senior, full-time technical consulting role leading pharmacovigilance data migrations into Oracle Argus Safety, suited to a consultant with deep database and migration experience. The consultant plans and runs migrations of safety data from legacy systems, converting PostgreSQL databases into Oracle Database or Oracle Autonomous Database and validating the results. EVERSANA serves life sciences and pharmaceutical clients, and this role also covers regulatory compliance, documentation, and mentoring junior consultants.

What you’ll do

  • Lead end-to-end pharmacovigilance data migrations from legacy safety systems into target systems.
  • Assess source systems, profile data, run gap analyses, and define migration strategies.
  • Convert PostgreSQL schemas and database objects into Oracle Database and Oracle Autonomous Database.
  • Write SQL and PL/SQL for extraction, transformation, loading, reconciliation, and validation.
  • Build source-to-target mapping documents, transformation rules, and migration specifications.
  • Configure and optimize Oracle Argus Safety for pharmacovigilance operations and regulatory reporting.
  • Support testing including SIT, UAT, performance testing, and production validation.
  • Resolve migration defects, mapping issues, and data quality problems.
  • Maintain migration plans, validation reports, and technical design documents, with GxP and FDA 21 CFR Part 11 compliance in mind.
  • Support Oracle Argus upgrades, cloud moves to Oracle Cloud Infrastructure, and system integrations via APIs.
  • Mentor junior consultants and recommend automation to speed up migrations.

What they’re looking for

  • At least seven years of experience in safety IT systems.
  • Strong PostgreSQL database administration and development skills.
  • Hands-on experience converting PostgreSQL databases to Oracle Database or Oracle Autonomous Database, including tables, indexes, views, triggers, and stored procedures.
  • Strong SQL and PL/SQL programming, and experience writing migration scripts and automation utilities.
  • Experience with Oracle SQL Developer Migration Workbench or an equivalent conversion tool.
  • Understanding of Oracle Database architecture and performance tuning, plus ETL and high-volume data migration experience.
  • Ability to perform record-level reconciliation and complex validation between source and target systems.

Nice to have

  • A bachelor's or master's degree in an IT stream.

Skills

Oracle Argus SafetyPostgreSQLOracle DatabaseOracle Autonomous DatabasePL/SQLSQLETLData MigrationData ValidationSchema ConversionPerformance TuningOracle BI PublisherOracle Cloud InfrastructureGxP ComplianceMigration Testing

Questions about this role

How many years of experience do I need?

The posting asks for at least seven years of experience in safety IT systems.

Do I need a degree?

A bachelor's or master's degree in an IT stream is preferred, though the posting does not make it a requirement.

Which databases does the role involve?

PostgreSQL and Oracle Database, including Oracle Autonomous Database, are central to the role.