Stream 3: Information Management/Information Management Service
I.1 Data Conversion Specialist
Experience levels
Level 1: < 5 years of experience
Level 2: 5- < 10 years of experience
Level 3: 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
I.2 Database Administrator
Experience levels
Level 1: < 5 years of experience
Level 2: 5- < 10 years of experience
Level 3: 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
BPWin
ERwin Data Modeler (ERWin)
IBM DB2
Integrated Database Management System (IDMS)
Informix
Ingres
Microsoft Access
Microsoft Structured Query Language (SQL)
Oracle
Oracle CASE
Oracle Financials
Silverrun
SQL Server
SQL*DBA
SQL*Forms
SQL*Menu
SQL*Net
SQL*Plus
SQL*Report
Sybase
Unisys DBII
I.3 Database Analyst / Information Management Administrator
Experience levels
Level 1: < 5 years of experience
Level 2: 5- < 10 years of experience
Level 3: 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
I.4 Database Modeller / Information Management Modeller
Experience levels
Level 1: < 5 years of experience
Level 2: 5- < 10 years of experience
Level 3: 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
I.5 Information Management Architect
Experience levels
Level 1: < 5 years of experience
Level 2: 5- < 10 years of experience
Level 3: 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
I.6 Network Analyst
Experience levels
Level 1: < 5 years of experience
Level 2: 5- < 10 years of experience
Level 3: 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
I.7 Platform Analyst
Experience levels
Level 1: < 5 years of experience
Level 2: 5- < 10 years of experience
Level 3: 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
I.8 Storage Architect
Experience levels
Level 1: < 5 years of experience
Level 2: 5- < 10 years of experience
Level 3: 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
I.9 System Administrator
Experience levels
Level 1: < 5 years of experience
Level 2: 5- < 10 years of experience
Level 3: 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
I.10 Technical Architect
Experience levels
Level 1: < 5 years of experience
Level 2: 5- < 10 years of experience
Level 3: 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
I.11 Technology Architect
Experience levels
Level 1: < 5 years of experience
Level 2: 5- < 10 years of experience
Level 3: 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
