Database Migration Analyst/Programmer
Apply NowCompany: Katalyst Data Management
Location: Calgary, AB T1Y 7M8
Description:
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:
Skills Required:
Required Education and Experience
Occasional regional and international travel may be required.
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:
- Proven experience in data model analysis
- Proven experience in coding/programming custom data model migration processes.
- 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.
- Unix scripting experience (a plus).
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.