Senior Pharmacovigilance Data Migration Consultant

• Configure, maintain, and optimize Oracle Argus Safety for pharmacovigilance operations and regulatory reporting
• Lead end-to-end pharmacovigilance data migration projects from legacy safety systems into target safety systems
• Perform source system assessment, data profiling, gap analysis, and migration impact assessments
• Analyze and convert PostgreSQL databases and database objects into Oracle Database/Oracle Autonomous Database
• Design and maintain source-to-target mapping documents, transformation rules, migration specifications, and data conversion documentation
• Develop SQL and PL/SQL scripts for extraction, transformation, loading, reconciliation, validation, and migration reporting
• Perform data extraction, cleansing, standardization, transformation, and loading
• Execute schema conversion and optimize migrated database objects
• Conduct data validation and reconciliation between source and target systems
• Support migration of Cases, Products, Events, Licenses, Studies, Regulatory Reports, Literature, Users, Workflow Data, Attachments, and Configuration Data
• Develop and execute migration validation plans, reconciliation reports, exception reports, and post-migration verification
• Support SIT, UAT, Performance Testing, Regression Testing, and Production Validation
• Troubleshoot migration issues involving data quality, database conversion, mapping, configurations, and integrations
• Develop and maintain Oracle BI Publisher reports and validation reports
• Collaborate with Pharmacovigilance, Regulatory Affairs, Business Analysts, Database Administrators, Validation Teams, and Oracle Support
• Support integrations between Oracle Argus Safety and external applications using APIs and web services
• Ensure compliance with GxP, FDA 21 CFR Part 11, EMA, ICH E2B(R3), GAMP 5, and validation standards
• Prepare migration plans, data mapping specifications, validation documents, technical design documents, SOPs, and migration summary reports
• Support Oracle Argus upgrades, cloud migrations, OCI, and ADB modernization initiatives
• Mentor junior consultants and provide technical guidance
• Recommend automation opportunities and continuous improvements

• Strong expertise in PostgreSQL database administration and development
• Hands-on experience converting PostgreSQL databases to Oracle Database and Oracle Autonomous Database (ADB)
• Experience with PostgreSQL-to-Oracle schema conversion, including tables, indexes, constraints, sequences, views, triggers, stored procedures, and functions
• Strong SQL and PL/SQL programming skills
• Experience developing migration scripts, stored procedures, packages, and automation utilities
• Experience using Oracle SQL Developer Migration Workbench or equivalent schema conversion tools
• Strong understanding of Oracle Database architecture, Oracle Autonomous Database (ADB), and performance tuning
• Experience with ETL processes, data transformation, and migration automation
• Ability to optimize SQL queries and improve migration performance for high-volume datasets
• Experience performing data assessment, profiling, cleansing, transformation, validation, reconciliation, and migration activities
• Ability to develop and maintain source-to-target mapping documents and migration specifications
• Experience executing complex SQL-based reconciliation and data validation activities
• Ability to identify and resolve migration defects, mapping inconsistencies, and data quality issues
• Experience conducting pre-migration, mock migration, production migration, and post-migration verification
• Experience supporting SIT, UAT, Regression Testing, and Production Validation
• Ability to perform record-level reconciliation
• Bachelor’s degree/Masters Degree in IT Stream preferred
• 7+ years of relevant experience in safety IT Systems

• Great Place to Work certification
• Equal Opportunity Employer
• Diversity, Equity & Inclusion commitment
• Inclusive culture
• Employee development and talent investment