Senior Pharmacovigilance Data Migration Consultant – Oracle Argus Safety
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Pharmacovigilance data migration consultant converting PostgreSQL safety systems to Oracle Argus for life sciences clients. Supporting validation, compliance, integrations, and database modernization.
Responsibilities:
- 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 assessment, data profiling, gap analysis, and migration impact assessments
- Convert PostgreSQL databases and schema objects into Oracle Database and Oracle Autonomous Database while ensuring integrity and performance
- Design and maintain source-to-target mappings, transformation rules, migration specifications, and conversion documentation
- Develop SQL and PL/SQL scripts for extraction, transformation, loading, reconciliation, validation, and reporting
- Perform data extraction, cleansing, standardization, transformation, and loading
- 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, Database Administrators, 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, 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 recommend automation and continuous improvements
Requirements:
- 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
- Ability to perform 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
- Bachelor’s degree/Masters Degree in IT Stream (preferred qualification)
- 7+ years of relevant experience in safety IT Systems
Benefits:
- Great Place to Work certification
- Equal Opportunity Employer
- Diversity, Equity & Inclusion commitment
- Cultural beliefs emphasizing patient-minded work, client delight, professional development, talent development, innovation, and inclusive collaboration
Similar Jobs
Data Engineer
Data Engineer building Snowflake, dbt, Airflow, and AWS pipelines for IDEXX’s medical data products. Enabling trusted clinical insights for analysts and veterinary health teams.
AWS Data Architect
AWS Data Architect designing S3 Data Lakes, ETL frameworks, and analytics platforms for Leighton’s cloud consultancy. Enabling governed, secure, scalable AWS data solutions.
Senior Golang Engineer, Data Processing
Senior Golang Engineer building high-throughput Go pipelines for Litmus, whose platform turns industrial machine data into usable real-time AI infrastructure. Owning streaming services across cloud and edge environments.
Senior Data Engineer
Senior Data Engineer scaling data pipelines and MLOps infrastructure for Keebo’s cloud warehouse optimization platform. Building reliable models, features, and AI-enabled engineering workflows.
Senior Data Engineer, Ads Data – AI Native
Senior Data Engineer owning Databricks pipelines, metrics, and governance for Life360’s advertising data. Improving performance, cost, reliability, and self-serve insights for teams supporting family safety products.
Senior Data Engineer
Senior Data Engineer building reliable data pipelines and models for LMI’s federal national security applications. Supporting AI, analytics, deployment, and mission-user workflows.
Staff Data Engineer, CBP
Staff Data Engineer building scalable data pipelines, models, and ontology for CBP operations. Supporting LMI’s mission-ready digital solutions in Google Cloud.
Senior Contract Software Engineer, Data & Platform
Senior contract engineer building scalable data pipelines and platform services for Nimble’s software that helps schools recruit educators. Designing reliable systems and data-intensive products for education leaders.
Senior Data Engineer, Network Platform
Senior Data Engineer building scalable, governed data platforms for Cisco’s cloud-managed networking solutions. Developing reliable pipelines, data context layers, and AI-enabled engineering workflows.
Snowflake Data Architect
Senior Snowflake Data Architect designing Snowflake healthcare data platforms for Datavail. Leading patient identity, dimensional modeling, quality controls, and engineering delivery.
Data Architect – VA OCDAO Data and Analytics
Data Architect designing enterprise data models, taxonomies, and metadata standards for the Department of Veterans Affairs. Leading business architecture content and aligning data governance structures.
Data Engineer – VA OCDAO Data and Analytics
Data Engineer building pipelines and integrations for the Department of Veterans Affairs OCDAO enterprise data catalog. Applying data quality and security controls remotely across the United States.
SQL Developer, Data Migration Specialist
SQL Developer and Data Migration Specialist configuring Momentive Software’s cloud platform for nonprofits and associations. Developing client solutions, supporting data conversion, testing deployments, and training users.
Junior Data Engineer – Snowflake, Oracle
Data Engineer Jr apoiando a migração de Data Warehouse Oracle para Snowflake na Keyrus, grupo internacional de dados e IA. Desenvolvendo pipelines, validando código e documentando processos.
Senior Data Architect – North America
Senior Data Architect shaping Snowflake architecture, financial data models, and integrations for a real estate investment firm. Improving governance, performance, quality, and reporting reliability.
Data Engineer, Pharmacy Data, SQL Server
Remote Data Engineer building SQL Server pharmacy data pipelines for Chiri’s AI operating platform. Ensuring reliable ingestion, quality, observability, and high availability.
Middle Data Engineer
Data Engineer owning analytics infrastructure for Boosters’ JustDone AI research assistant. Building reliable event, ETL/ELT, BigQuery, Airflow, and Milvus pipelines.
Senior Data Engineer – Square, APAC
Senior Data Engineer building scalable data pipelines and feature platforms for Binance’s global cryptocurrency ecosystem. Supporting machine learning and recommendation systems across APAC.
Senior FHIR Data Platform Engineer
Senior engineer optimizing HAPI FHIR and PostgreSQL platforms for federal healthcare modernization. Delivering quality reporting, MDM, performance, and reliable data exchange.
Data Engineer – Level III
Data Architect / Engineering Lead guiding AWS modernization, enterprise data platforms, and AI/ML enablement. Supporting AttainX’s federal NRCS technology programs under the USDA OMNI contract.