Leads the team this role joins
Decides on early hires
Runs hiring at the company
From your own Gmail and LinkedIn.
About the role
This is a senior, full-time technical consulting role leading pharmacovigilance data migrations into Oracle Argus Safety, suited to a consultant with deep database and migration experience. The consultant plans and runs migrations of safety data from legacy systems, converting PostgreSQL databases into Oracle Database or Oracle Autonomous Database and validating the results. EVERSANA serves life sciences and pharmaceutical clients, and this role also covers regulatory compliance, documentation, and mentoring junior consultants.
What you’ll do
- Lead end-to-end pharmacovigilance data migrations from legacy safety systems into target systems.
- Assess source systems, profile data, run gap analyses, and define migration strategies.
- Convert PostgreSQL schemas and database objects into Oracle Database and Oracle Autonomous Database.
- Write SQL and PL/SQL for extraction, transformation, loading, reconciliation, and validation.
- Build source-to-target mapping documents, transformation rules, and migration specifications.
- Configure and optimize Oracle Argus Safety for pharmacovigilance operations and regulatory reporting.
- Support testing including SIT, UAT, performance testing, and production validation.
- Resolve migration defects, mapping issues, and data quality problems.
- Maintain migration plans, validation reports, and technical design documents, with GxP and FDA 21 CFR Part 11 compliance in mind.
- Support Oracle Argus upgrades, cloud moves to Oracle Cloud Infrastructure, and system integrations via APIs.
- Mentor junior consultants and recommend automation to speed up migrations.
What they’re looking for
- At least seven years of experience in safety IT systems.
- Strong PostgreSQL database administration and development skills.
- Hands-on experience converting PostgreSQL databases to Oracle Database or Oracle Autonomous Database, including tables, indexes, views, triggers, and stored procedures.
- Strong SQL and PL/SQL programming, and experience writing migration scripts and automation utilities.
- Experience with Oracle SQL Developer Migration Workbench or an equivalent conversion tool.
- Understanding of Oracle Database architecture and performance tuning, plus ETL and high-volume data migration experience.
- Ability to perform record-level reconciliation and complex validation between source and target systems.
Nice to have
- A bachelor's or master's degree in an IT stream.
Skills
Questions about this role
How many years of experience do I need?
The posting asks for at least seven years of experience in safety IT systems.
Do I need a degree?
A bachelor's or master's degree in an IT stream is preferred, though the posting does not make it a requirement.
Which databases does the role involve?
PostgreSQL and Oracle Database, including Oracle Autonomous Database, are central to the role.