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 8 days ago

Sr Pharmacovigilance Data Migration Consultant – Oracle Argus Safety

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

Leads the team this role joins

Recruiter

In-house, owns the opening

Head of the team

Director or head of the group

Power Apply

From your own Gmail and LinkedIn.

About the role

This is a senior, full-time remote role in Pune, India, for a consultant who migrates pharmacovigilance safety data into Oracle Argus Safety, with at least seven years of safety IT experience expected. The work covers the full migration lifecycle, from source assessment and mapping through to testing, reconciliation and post-migration checks, including conversion of PostgreSQL databases to Oracle. EVERSANA operates in the healthcare industry and lists this role within its safety and data team.

What you’ll do

  • Lead end-to-end pharmacovigilance data migrations from legacy safety databases into target systems.
  • Assess source systems, profile data and run gap analysis to set the migration strategy.
  • Convert PostgreSQL schemas and objects, including tables, triggers and stored procedures, into Oracle Database and Oracle Autonomous Database.
  • Write source-to-target mapping documents, transformation rules and conversion specifications.
  • Build SQL and PL/SQL scripts for extraction, transformation, loading, reconciliation and validation.
  • Run data validation and record-level reconciliation to confirm migrated safety data is complete and accurate.
  • Support SIT, UAT, performance testing and production validation.
  • Troubleshoot data quality, mapping and configuration issues during migration.
  • Build Oracle BI Publisher reports that verify migrations.
  • Support integrations between Argus Safety and other systems through APIs and web services.
  • Keep migrated data compliant with GxP, FDA 21 CFR Part 11, EMA requirements, ICH E2B(R3) and GAMP 5.
  • Mentor junior consultants and recommend automation that improves migration efficiency.

What they’re looking for

  • At least seven years of relevant experience in safety IT systems.
  • Strong PostgreSQL database administration and development skills.
  • Hands-on experience converting PostgreSQL databases to Oracle Database and Oracle Autonomous Database.
  • Experience converting schemas, including tables, indexes, constraints, sequences, views, triggers, procedures and functions.
  • Strong SQL and PL/SQL programming skills.
  • Experience with ETL, data transformation and migration automation.
  • Experience with Oracle SQL Developer Migration Workbench or similar schema conversion tools.
  • Understanding of Oracle Database architecture and performance tuning.
  • Ability to optimize SQL for high-volume datasets.
  • Experience with pre-migration, mock migration, production migration and post-migration verification.

Nice to have

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

What’s on offer

  • Remote, full-time working arrangement, as listed

Skills

Oracle Argus SafetyPostgreSQLOracle DatabaseOracle Autonomous DatabaseSQLPL/SQLETLData migrationData reconciliationOracle BI PublisherOracle SQL DeveloperData mappingSchema conversionPerformance tuningPharmacovigilanceGxP21 CFR Part 11ICH E2B(R3)

Questions about this role

Is this job remote?

Yes. The listing is remote and based in Pune, India.

How many years of experience are needed?

At least seven years of relevant safety IT systems experience.

Is a degree required?

The posting lists a bachelor's or master's degree in an IT stream as preferred, not mandatory.

Is pay listed?

No, the posting does not state pay.