| Oracle Migration Lead at Oracle, Arizona, USA |
| Email: [email protected] |
| From: Benjamin Thomas, Concord it systems .INC [email protected] Reply to: [email protected] Oracle Migration Lead Melville NY Onsite Day 1 Long Term Contract Client : Virtusa/ Verint Job Description: Assess the existing Oracle databases and gauge the complexity and estimate the efforts required for a migration Ensure PostgreSQL will be the best migration target based on the nature of the application and the type of data and the business logic in the database and that it 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 Lead migration projects and work closely with the database migration teams so that the project is aligned with the standards set by client Train internal teams on the PostgreSQL and migration-related activities Perform migration of PL/SQL code that includes Packages, Procedures and Functions from Oracle to PostgreSQL At least 10 years of experience in performing Oracle to PostgreSQL migrations and in helping clients port applications from Oracle to PostgreSQL with alternate approaches that are open source At least 7 years of experience in writing PLpgSQL and migrating Packages and Procedures from Oracle to PostgreSQL Hands-on experience on AWS Services - RDS, Aurora, SCT, DMS Experience migrating Large databases across multiple database engines (e.g. PostgreSQL, Oracle etc.) At least 5 year of experience in writing Oracle PL SQL code Knowledgeable in various alternatives for syntax and features only applicable to Oracle e.g. Hierarchical queries in Oracle use CONNECT BY, Oracle uses rownum, etc., so you re able to find the best alternatives in PostgreSQL for various Oracle features Knowledgeable in the target data types in PostgreSQL that suit the corresponding Oracle data types while migrating objects from Oracle You ve used migration tools like Ora2PG or Schema Conversion toolkit from AWS You ve migrated data from Oracle to PostgreSQL using FDW s or custom tools or existing open source tools. Knowledge on tools that enable continuous replication of data from Oracle to PostgreSQL is a plus Experience with training development and delivery Experience in a variety of complex environments Keywords: |
| [email protected] View all |
| Wed Nov 23 00:24:00 UTC 2022 |