Public Works and Government Services Canada
Symbol of the Government of Canada

Common menu bar links

Stream 3: Information Management (IM)/Information Technology (IT) Service

3.1 Data Conversion Specialist

Experience Levels

  • Junior: < 5 years of experience
  • Intermediate: 5- < 10 years of experience
  • Senior: 10+ years of experience

Responsibilities could include but are not limited to:

  • Oversee all facilities of the conversion process.
  • Complete mapping, interfaces, mock conversion work, enhancements, actual conversion, and verify completeness and accuracy of converted data.
  • Establish a strong working relationship with all clients, interact effectively with all levels of client personnel, and provide conversion support.
  • Analyze and coordinate data file conversions.
  • Work with importing files from heterogeneous platforms.

3.2 Database Administrator

Experience Levels

  • Junior: < 5 years of experience
  • Intermediate: 5- < 10 years of experience
  • Senior: 10+ years of experience

Responsibilities could include but are not limited to:

  • Customize database conversion routines.
  • Finalize Conversion Strategy.
  • Generate new database with the client.
  • Maintain data dictionaries.
  • Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database.
  • Develop and implement security procedures for the database, including access and user account management.
  • Advise programmers, analysts, and users about the efficient use of data.
  • Maintain configuration control of the database.
  • Perform and/or coordinate updates to the database design.
  • Control and coordinate changes to the database, including the deletion of records, changes to the existing records, additions to the database.
  • Develop and coordinate back-up, disaster recovery and virus protection procedures.

Specialties could include but are not limited to:

  • ERwin Data Modeler (BPWin)
  • ERWin
  • IBM DB2
  • Integrated Database Management System (IDMS)
  • Informix
  • Ingres
  • Microsoft (MS) Access
  • MS Structured Query Language (SQL)
  • Oracle
  • Oracle CASE
  • Oracle Financials
  • Silverrun
  • SQL Server
  • SQL*Database Administrator (DBA)
  • SQL*Forms
  • SQL*Menu
  • SQL*Net
  • SQL*Plus
  • SQL*Report
  • Sybase
  • Unisys DBII

3.3 Database Analyst / IM Administrator

Experience Levels

  • Junior: < 5 years of experience
  • Intermediate: 5- < 10 years of experience
  • Senior: 10+ years of experience

Responsibilities could include but are not limited to:

  • Define new database structures.
  • Define data conversion strategy.
  • Define database conversion specifications.
  • Finalize Conversion Strategy.
  • Work very closely with the users in order to maintain and safeguard the database.
  • Identify requirements for improvements to existing databases by determining users' information requirements and system performance and functional requirements.
  • Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database.
  • Mediates and resolves conflicts among users' needs for data.
  • Advise programmers, analysts, and users about the efficient use of data.

Specialties could include but are not limited to:

  • BPWin
  • ERWin
  • IBM DB2
  • IDMS
  • Informix
  • Ingres
  • MS Access
  • MS SQL
  • Oracle
  • Oracle CASE
  • Oracle Financials
  • Silverrun
  • SQL Server
  • SQL*DBA
  • SQL*Forms
  • SQL*Menu
  • SQL*Net
  • SQL*Plus
  • SQL*Report
  • Sybase
  • Unisys DBII

3.4 Database Modeller / IM Modeller

Experience Levels

  • Junior: < 5 years of experience
  • Intermediate: 5- < 10 years of experience
  • Senior: 10+ years of experience

Responsibilities could include but are not limited to:

  • The Data Architect has both strategic and tactical responsibility for developing and maintaining the Architecture and Data Models for corporate and project specific initiatives. This responsibility includes the identification of data most valuable to the department, the integration of this data, and the development of core relating data models. The resulting data models will be based on data architecture and modeling design principles and tenets.
  • Design, develop and maintain Logical Data Models.
  • Analyze proposed changes to databases from the context of the Logical Data Model.
  • Provide technical expertise in the use and optimization of data modeling techniques to team members.
  • Provide technical assistance, guidance and direction in terms of data analysis and modeling to team members.
  • Provide assistance to project team and business users relating to data issues and data analysis concepts.
  • Participate in the development of data modeling and metadata policies and procedures.
  • Participate in data analysis as a result of new/updated requirements.
  • Apply approved changes to logical data models.
  • Comply with corporate data architectures, strategies and frameworks, including enterprise data warehouse activities.
  • Analyze and evaluate alternative data architecture solutions to meet business problems/requirements to be incorporated into the corporate data architecture.
  • Review corporate architecture strategies and directions, data requirements, and business information needs and devise data structures to support them.
  • Improve modeling efficiency through recommendations on how to better utilize current metadata repositories.
  • Comply with corporate repository metadata directions.
  • Provide input to refinement of data architectures.
  • Participate in data architecture refinement.
  • Define access strategies.
  • Construct, monitor and report on work plans and schedules.

Specialties could include but are not limited to:

  • BPWin
  • ERWin
  • IBM DB2
  • IDMS
  • Informix
  • Ingres
  • MS Access
  • MS SQL
  • Oracle
  • Oracle CASE
  • Oracle Financials
  • Silverrun
  • SQL Server
  • SQL*DBA
  • SQL*Forms
  • SQL*Menu
  • SQL*Net
  • SQL*Plus
  • SQL*Report
  • Sybase
  • Unisys DBII

3.5 IM Architect

Experience Levels

  • Junior: < 5 years of experience
  • Intermediate: 5- < 10 years of experience
  • Senior: 10+ years of experience

Responsibilities could include but are not limited to:

  • Analyse existing capabilities and requirements, develop redesigned frameworks and recommend areas for improved capability and integration. Develop and document detailed statements of requirements.
  • Evaluate existing procedures and methods, identify and document database content, structure, and application subsystems, and develop data dictionary.
  • Define and document interfaces of manual to automated operations within application subsystems, to external systems, and between new and existing systems.
  • Prototype potential solutions, provide tradeoff information and suggest recommended courses of action.
  • Perform information modelling in support of BPR implementation.
  • Perform cost/benefit analysis of implementing new processes and solutions.
  • Provide advice in developing and integrating process and information models between business processes to eliminate information and process redundancies.
  • Provide advice in defining new requirements and opportunities for applying efficient and effective solutions; identify and provide preliminary costs of potential options.

Specialties could include but are not limited to:

  • BPWin
  • ERWin
  • IBM DB2
  • IDMS
  • Informix
  • Ingres
  • MS Access
  • MS SQL
  • Oracle
  • Oracle CASE
  • Oracle Financials
  • Silverrun
  • SQL Server
  • SQL*DBA
  • SQL*Forms
  • SQL*Menu
  • SQL*Net
  • SQL*Plus
  • SQL*Report
  • Sybase
  • Unisys DBII

3.6 Network Analyst

Experience Levels

  • Junior: < 5 years of experience
  • Intermediate: 5- < 10 years of experience
  • Senior: 10+ years of experience

Responsibilities could include but are not limited to:

  • Prepare implementation plans for particular technologies.
  • Installs and monitors particular facets of technology.
  • Configures and optimizes technical installations.
  • Troubleshoots, and responds to user problems.
  • Maintain up to date knowledge of particular technologies and products supporting that technology.

3.7 Platform Analyst

Experience Levels

  • Junior: < 5 years of experience
  • Intermediate: 5- < 10 years of experience
  • Senior: 10+ years of experience

Responsibilities could include but are not limited to:

  • Develop and document detailed statement of requirements for the proposed platform.
  • Analyze functional requirements to identify information, procedures and decision flows.
  • Evaluate existing procedures and methods, identify and documents database content, structure, and application sub-systems, and develop data dictionary.
  • Define and document interfaces of manual to automated operations within sub-systems, to external systems and between new and existing systems.
  • Define input/output sources, including detailed plan for technical design phase, and obtain approval for system proposals.
  • Design and document in detail all system components, interfaces and operational environment.
  • Design data structures and files, sub-systems and modules, programs, batch, on line, and production monitoring procedures, testing strategy and systems.
  • Document system design, concepts and facilities, present and obtain approval of detailed system designs.
  • Produce operational systems including all forms, manuals, programs, data files and procedures.

3.8 Storage Architect

Experience Levels

  • Junior: < 5 years of experience
  • Intermediate: 5- < 10 years of experience
  • Senior: 10+ years of experience

Responsibilities could include but are not limited to:

  • Develop, analyze, design, and implement the organization's storage infrastructure/architecture to ensure high levels of data quality and availability.
  • Develop capacity planning, backup and restore procedures for storage capabilities.
  • Develop or assist in development of data disaster recovery plans, as they relate to storage capabilities and continuity.
  • Develop, implement, and oversee policies and procedures to ensure consistent and seamless storage continuity and capabilities.

3.9 System Administrator

Experience Levels

  • Junior: < 5 years of experience
  • Intermediate: 5- < 10 years of experience
  • Senior: 10+ years of experience

Responsibilities could include but are not limited to:

  • Install, monitor, upgrade and maintain operating systems.
  • Install, monitor, upgrade and maintain hardware and software.
  • Work with Business Analysts, Project Managers, Developers, and clients/stakeholders to maintain and improve software performance.
  • Apply problem solving skills to troubleshoot and resolve technical problems.
  • Ensure timely and reliable system administration procedures, such as backup and/or recovery.
  • Analyze system performance and recommend improvements.

3.10 Technical Architect

Experience Levels

  • Junior: < 5 years of experience
  • Intermediate: 5- < 10 years of experience
  • Senior: 10+ years of experience

Responsibilities could include but are not limited to:

  • Develop technical architectures, frameworks and strategies, either for an organization or for a major application area, to meet the business and application requirements.
  • Identify policies and requirements that drive out a particular solution.
  • Analyze and evaluate alternative technology solutions to meet business problems.
  • Ensure the integration of all aspects of technology solutions.
  • Evaluate hardware and software relative to their ability to support specified requirements and, by determining potential and actual bottlenecks, and improve system performance through recommended hardware changes.
  • Review computer software systems and data requirements as well as communication and response needs and determine operating systems and languages needed to support them.

3.11 Technology Architect

Experience Levels

  • Junior: < 5 years of experience
  • Intermediate: 5- < 10 years of experience
  • Senior: 10+ years of experience

Responsibilities could include but are not limited to:

  • Develop technical architectures, frameworks and strategies, either for an organization or for a major application area, to meet the business and application requirements.
  • Identify the policies and requirements that drive out a particular solution.
  • Analyze and evaluate alternative technology solutions to meet business problems.
  • Ensures the integration of all aspects of technology solutions.
  • Monitor industry trends to ensure that solutions fit with government and industry directions for technology.
  • Provide information, direction and support for emerging technologies.
  • Perform impact analysis of technology changes.
  • Provide support to applications and/or technical support teams in the proper application of existing infrastructure.
  • Review application and program design or technical infrastructure design to ensure adherence to standards and to recommend performance improvements.

Specialties could include but are not limited to:

  • Hardware
  • Host System Software
  • Software
  • Storage
  • Network