Senior Pharmacovigilance Data Migration Consultant – Oracle Argus Safety

🔥 16 minutes ago

🇮🇳 India – Remote

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 10%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.Why this score:

• Just posted.
• Jobs at this company usually fill in 29 days.
• No salary listed.

Apply Now

Find Similar Remote Jobs

EVERSANA

WebsiteLinkedInAll Job Openings

5001 - 10000 employees

💼 Consulting

🏥 Healthcare

⚕️ Healthcare Insurance

Consulting • Healthcare • Healthcare Insurance

EVERSANA is a comprehensive service provider focused on integrated commercial solutions for the life sciences industry. The company offers a wide range of services including advisory and management consulting, regulatory consulting, patient services, market access strategies, pricing and revenue management, medical affairs, and digital transformation. EVERSANA is known for its expertise in drug commercialization, enabling companies to effectively launch and manage pharmaceutical products. With a platform powered by data and analytics, EVERSANA addresses challenges related to drug pricing, market access, patient adherence, and product delivery, helping companies optimize their commercial strategies and enhance patient outcomes. The company emphasizes innovation and has been recognized for its use of AI and data analytics within the life sciences sector.

📋 Description

• 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

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume