Database Migration Analyst / Programmer

Katalyst Data Management; Calgary; On-site; CAD 90,000 - 110,000; Full time

Job summary

A leading company in data management is seeking a Database Migration Analyst / Programmer to facilitate data migration processes and ensure the accuracy of client data in their iGlass database system. The ideal candidate should have strong skills in SQL and PL/pgSQL, along with a background in data modelling principles. This role demands attention to detail and offers an opportunity to work on operational projects alongside experienced professionals, contributing your knowledge to enhance data quality and migration methodologies.

Qualifications

• Bachelor's degree in computer science or equivalent experience.
• 5+ years of experience in data model analysis and migration using SQL and PL/pgSQL.
• Knowledge of PPDM data model highly valued.

Responsibilities

• Conduct in-depth analysis of source data from various systems.
• Design, code, and implement data migration processes using SQL.
• Collaborate with teams to develop comprehensive data migration plans.

Skills

Postgres PL / pgSQL

Oracle PL / SQL

SQL (DML & DDL)

Data modelling principles

Analytical skills

Problem-solving skills

Strong communication

Interpersonal skills

Attention to detail

Database change control

Education

Bachelor's degree in computer science

Tools

Database utilities (e.g., Postgres copy)

Job description

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 :

Strong proficiency in Postgres PL / pgSQL (Oracle PL / SQL considered equivalent).

Solid understanding of data modelling principles and best practices.

Expert-level knowledge of SQL (DML & DDL).

Excellent analytical and problem-solving skills.

Strong communication and interpersonal skills.

Experience with database utilities (e.g., Postgres copy, Oracle SQLLoader / import).

Familiarity with industry-standard data models for the Oil & Gas domain, such as PPDM.

Attention to detail and a commitment to data quality.

Ability to work independently and as part of a team.

Experience with database change control and promotion processes.

Required Education and Experience

A bachelor’s degree in computer science or equivalent experience.

5+ years of experience in data model analysis, data profiling, data mapping, and data model migration execution using Postgres PL / pgSQL (or Oracle PL / SQL) and SQL.

Knowledge of PPDM data model highly valued.

Occasional regional and international travel may be required.

J-18808-Ljbffr