Full-Time Database Conversion Developer (Oracle to PostgreSQL)
Apexon is hiring a remote Full-Time Database Conversion Developer (Oracle to PostgreSQL). The career level for this job opening is Experienced and is accepting USA based applicants remotely. Read complete job description before applying.
Apexon
Job Title
Posted
Career Level
Career Level
Locations Accepted
Share
Job Details
Required:
Hands on Conversion experience
Build Data Model
Build Pipeline
Hands on Cloud (Azure)
AWS knowledge is preferred
Responsibilities:
Primary responsibility is the successful conversion of large datasets from an Oracle database system to a comparable PostgreSQL RDBMS.
Comfortable using the various PostgreSQL tools and extensions such as foreign data wrappers, and the ora2pg extension.
Assess the existing Oracle databases, gauge the complexity, and estimate the efforts required for a migration
Determine the best migration target based on the nature of the application and the type of data and the business logic in the database, and if PostgreSQL or MySQL or any other Open source database suits better as a target database technology for migration
Prepare data migration strategies and designs for each project, including plans to avoid downtime when required
Perform migration of PL/SQL code that includes Packages, Procedures and Functions from Oracle to PostgreSQL