Senior Pharmacovigilance Data Migration Consultant – Oracle Argus Safety

• 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 while ensuring integrity and performance
• Design and maintain source-to-target mappings, 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 Oracle 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 migration validation plans, reconciliation reports, exception reports, and post-migration verification activities
• Support SIT, UAT, Performance Testing, Regression Testing, and Production Validation
• Troubleshoot migration issues involving data quality, database conversion, mappings, configurations, and integrations
• Develop and maintain Oracle BI Publisher reports and validation reports
• Collaborate with Pharmacovigilance, Regulatory Affairs, Business Analysts, DBAs, Validation Teams, and Oracle Support
• Support integrations between Oracle Argus Safety and external applications using APIs, web services, and interface technologies
• Ensure compliance with GxP, FDA 21 CFR Part 11, EMA, ICH E2B(R3), GAMP 5, and validation standards
• Prepare migration plans, 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 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
• Ability to execute 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 for completeness, consistency, and accuracy
• Bachelor’s degree/Masters Degree in IT Stream (preferred qualifications)
• 7+ years of relevant experience in safety IT Systems (preferred qualifications)

• Employees can work remotely
• Great Place to Work certification
• Inclusive and diverse workplace culture
• Equal Opportunity Employer
• Employee referral opportunity