SQL/MX Release 2.0 Best Practices

Project Planning 7
Project Planning
HP Roles and Responsibilities
This list of suggested roles and responsibilities is intended to move a typical database project toward a
successful conclusion. One person can assume more than one role, although where a conflict exists
between roles and the project timeline, separate individuals should take the separate roles.
For example, the roles of Database Consultant and Extract/Load/Transform (ETL) Specialist require
complementary skills and could be interchangeable, but the nature and sequence of these tasks might
cause difficulties if the same person attempts to perform both functions. The Technical Lead also could
act as the Performance Specialist, since the major responsibility for most performance aspects of the
system is on the Database Consultant with input from the Performance and Communication consultants.
Each person who fills these roles should be experienced with the NonStop operating system and OSS
(Open System Services), and should have prior database experience. While third-party consultants might
assist in these roles, it is strongly advised that the Technical Lead be an HP employee or approved person.
Roles
Technical Lead
• Acts as lead architect and technical specialist
• Participates in all activities defined for other consultants and specialists
• Thoroughly understands the NonStop operating system environment, and has a working knowledge
of all selected products
• Acts as liaison within the project team and as primary point of contact with project management
Database Consultant
Database-management tasks
Managing an SQL/MX database involves the tasks required to create the database, ensure its availability
to users, and perform required changes. Because the database is an integral part of the application,
measuring application performance and tuning the database configuration to enhance performance
are also database-management tasks.
The database consultant does these tasks:
• Migrates to newer releases of SQL/MX software or falls back to earlier releases
• Determines database layouts and data dictionary plans
• Plans for database security, integrity, and recovery
• Creates and loads databases
• Queries catalog tables for information about databases
• Alters databases
• Manages databases and programs
• Reorganizes and moves databases
• Manages database applications
• Performs recovery operations
• Manages distributed databases
• Assembles and optimizes queries
• Measures and enhances performance
• Does TACL/OSS scripting for job management
• Sets up and installs any database-management tools