Analyzes system performance and addresses performance problems. Evaluates costs, specifications, and organizational policies to recommend system performance tuning. Resolves resource competition issues. The typical environment is diverse with multiple vendors, has multiple sites, distributed needs within the agency and multiple entities in the work flow. Typically, it has relational databases, multiple distributed databases, and must maintain relational integrity of the data bases, considering constraints, linked tables, and consistency.
Security is usually at the data level.
Does business process modeling and formal data modeling requiring consideration of overall system performance. Projects involve a high level of coordination and there are usually conflicting needs and significant compatibility issues. Builds implementation plans which often involve multiple vendors, multiple jurisdictions, and cross agency cooperation. Normalizes data, updates the data dictionary, and reviews other staff work for conformance with established standards. Develops bid specifications and makes high level recommendations which include costs, performance factors,and vendor selection.