Job Details

Your reply to daniyal.z@concorditsystems.com -

To

Subject
Message -

daniyal.z@concorditsystems.com wrote:
From:
                                   Daniyal Zane,
                                   Concord IT systems                                            
       daniyal.z@concorditsystems.com
       Reply to:   daniyal.z@concorditsystems.com

Oracle Migration Lead (PostgreSQL, AWS)

Remote engagement

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 opensource 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:

Your email id:

Captcha Image:

Captcha Code: