Senior Data Migration+ Argus Safety+ Orcale PL/SQL consultant
Core
Lead end-to-end pharmacovigilance data migration projects, converting PostgreSQL databases to Oracle/Oracle Autonomous Database (ADB) for Argus Safety System.
Role type
Senior Data Migration Consultant (Pharmacovigilance)
Builds
Migrated safety data (Cases, Products, Events, Regulatory Reports) into Oracle Argus Safety and OCI/ADB environments
Domain
Life Sciences / Pharmacovigilance / Database Engineering
Required skills
PostgreSQL database administration, Oracle Database/ADB architecture, PL/SQL programming, ETL processes, data profiling and gap analysis, schema conversion, data validation and reconciliation, GxP compliance, SQL query optimization
Preferred skills
Oracle SQL Developer Migration Workbench, Oracle BI Publisher, API/web service integration, automation development, mentoring
Technologies
PostgreSQL, Oracle Database, Oracle Autonomous Database (ADB), Oracle Cloud Infrastructure (OCI), Oracle Argus Safety, Oracle BI Publisher, SQL Developer
Responsibilities
Lead end-to-end pharmacovigilance data migration projects; Convert PostgreSQL schemas, tables, views, triggers, and stored procedures to Oracle/ADB; Develop SQL/PL/SQL scripts for ETL, extraction, and validation; Perform data profiling, gap analysis, and migration impact assessments; Execute data cleansing, transformation, and loading ensuring regulatory compliance; Conduct comprehensive data validation and reconciliation between source and target systems; Support migration testing (SIT, UAT, Production Validation); Mentor junior consultants on migration methodologies and best practices
Seniority
Senior, hands-on IC with leadership responsibilities
