Database/Information Services will:
• Develop methods to achieve inter-operability of school data bases and “School Interoperability Framework” (SIF) compliance
• Manage all database protocols across information systems within the district.
• Manage PowerSchool, MEDMS, CLAS, Library CIRC/CAT, Food Service POS, etc.
• Control data resources, using data dictionary to ensure data integrity and security
• Recover corrupted data and eliminate data redundancy
• Uses tuning tools to improve database performance.
Typical work activities
The work of the database administrator (DBA) will vary according to the nature of the project but will fall directly under the supervision and evaluation of the Director of Technology Services.
Responsibilities include some or all of the following:
* establishing the needs of end-users;
* planning dataflows for a new or revised database;
* mapping out the 'conceptual design' for a planned database in outline;
* refining the 'logical design' so that it can be translated into a specific data model;
* further refining the 'physical design' to meet system storage requirements;
* testing new systems;
* maintaining data standards, including adherence to the Data Protection Act;
* writing database documentation, including data standards, procedures and definitions for the data dictionary ('metadata');
* controlling access permissions and privileges;
* training users;
* meeting users' access requirements and resolving their problems;
* ensuring that storage, archiving, backup and recovery procedures are functioning correctly;
* capacity planning;
* working closely with IT project managers, database programmers and web developers;
* providing technical support for outdated 'legacy' systems;
* communicating regularly with technical, applications, and operational staff, to ensure the database integrity and security;
* commissioning and installing new applications.
|