Description:

We are looking for a Database Migration Engineer with strong skills in Oracle and PostgreSQL internals, database development, performance optimization, and migration automation. The candidate will be responsible for converting Oracle-based applications and databases to PostgreSQL while ensuring accuracy, performance, and reliability.

Key Responsibilities:

- Oracle DB internals: Understanding Oracle-specific features like PL/SQL, packages, triggers, sequences, and data types.

- PostgreSQL internals: Knowledge of PostgreSQL architecture, SQL syntax, and capabilities.

- Translate Oracle SQL and PL/SQL code to PostgreSQL SQL and PL/pgSQL.

- Handle differences in syntax, functions, and stored procedure logic.

- Understanding how to convert Data types Constraints, indexes, sequences, Users, roles, and privileges

- Performance Tuning

- Backup & Recovery

- Ensure rollback plans are in place in case of issues.

- Basic Linux/Unix system administration

- Database deployment and configuration

- Ora2Pg (most commonly used open-source tool) and pgloader

- Write ETL scripts in Python, Shell, or SQL for data transformation and movement.

- Automate migration workflows using scripting.

InterraIT, a Ferfier group company, is a leader in Digital Engineering services focused on the Mobility and Manufacturing space.

With over two decades of experience, we help customers in their Digital Transformation and Modernization journey with cutting-edge technology, enabling them to transform, grow, and thrive in a dynamic digital era.

With a global presence and a diverse team of skilled professionals, we specialize in areas like AI powered SaaS product cloud-native applications development, Application Modernization and Development, Digital Transformation, Mobility Digital Retail Solutions, Data Platform and Monetization, MobileApps, Digital Twin and Managed services.