Technical Lead – Oracle to PostgreSQL Jobs at Virtusa in Colombo, Sri Lanka.

Job Overview

Technical Lead – Oracle to PostgreSQL

About the job

Requirements

• 7-9 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
• Assess the existing Oracle databases and gauge the complexity and estimate the efforts required for a migration
• Lead migration projects and work closely with the database migration teams so that the project is aligned with the standards set by client
• Perform migration of PL/SQL code that includes packages, procedures, and functions from Oracle to PostgreSQL
• At least 5 years of experience in writing PLpgSQL and migrating packages and procedures from Oracle to PostgreSQL
• At least 2 years of experience in writing Oracle PL/SQL code
• Knowledgeable in various alternatives for syntax and features only applicable to Oracle
• Knowledgeable in the target data types in PostgreSQL that suit the corresponding Oracle data types while migrating objects from Oracle
• Hands-on experience on AWS Services – RDS, Aurora, SCT, DMS
• Experience migrating large databases across multiple database engines
• Experience in migration tools like Ora2PG or Schema Conversion toolkit from AWS
• Experience in 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

Apply on LinkedIn