Leads the team this role joins
In-house, owns the opening
Director or head of the group
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
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.