Database Migration Analyst/Programmer

at  Katalyst Data Management

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

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.