Jobs at Oracle in Germany

Salary Range : CA$90,000.00 To CA$110,000.00 Annually

Key Responsibilities and Accountabilities

The Database Migration Analyst / Programmer uses their knowledge of Data Model theory and practice, Postgres PL / pgSQL (or Oracle PL / SQL) and SQL to design, execute and confirm the migration from various origin databases into the Katalyst iGlass database (PPDM-based) data model. The Database Migration Analyst / Programmer works under the technical supervision of the Chief Database Architect on operational projects directed by operational Project and / or Account Managers to ensure that client origin data is accurately reflected in iGlass at the end of the migration process. Great organisational ability, a high level of attention to detail, the ability to multi-task, a natural curiosity and a desire to learn are also required for this role.

Key Responsibilities :

• Conduct in-depth analysis and profiling of source data from various systems (e.g., ProSource Seabed, Trango, Petrobank, eSearch, custom databases).
• Collaborate with Account / Project Management teams to develop comprehensive data migration plans, including mapping source data to the iGlass data model.
• Design, code / program, and implement robust data model migration processes using PL / pgSQL, SQL, and industry-standard ETL best practices.
• Create and maintain necessary database objects (tables, views, etc.) within the Postgres environment.
• Develop in-depth expertise in the iGlass data model and its intricacies.
• Perform thorough peer reviews and quality control on the work of colleagues.
• Contribute to research and development projects as needed.

Skills Required :

Required Education and Experience

Occasional regional and international travel may be required.

J-18808-Ljbffr