Leads the team this role joins
Runs the team day to day
Decides on early hires
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
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.