| Date: |
February 3, 2014 |
| Reports to (Job Title): |
Administrator, Centre for Sight Enhancement |
| Jobs Reporting (Job Titles): |
None |
| Location: |
Main Campus |
| Grade: |
USG 9
35 hr/wk
|
Primary Purpose
Responsible for administration and management of the Sight Enhancement Equipment Pool and Assessment Centre (SEEPAC) database management system.
Key Accountabilities:
1. Administers and manages the Oracle database and its network
- Monitors network and database security to ensure the stored personal health information is secure
- Maintains system file systems and system documentation
- Maintains database user accounts
- Develops new applications and refines existing applications for database
- Responsible for data integrity, maintenance of a backup and recovery system and resolution of error messages on database
- Responsible for system maintenance and development of batch processing, interpretation and resolution of system log error messages
- Maintains peripheral devices and their processes
- Plans, executes and documents developments and upgrades to the database and system in consultation with CSE Administrator
2. Provides support and training for off-site users:
- Develops and maintains user documentation
- Answers support questions from users by phone and e-mail
- Provides face-to-face training at Centre meetings
3. Develops and runs statistical reports for the Ministry of Health and Long-Term Care, auditors, remote sites and SEEPAC staff
4. Manages and co-ordinates the annual inventory at SEEPAC and the remote sites
Position Requirements
Education:
Completion of a Bachelor’s degree or College Diploma in a computing discipline or equivalent education and experience.
Experience:
Experience in network security, RDBMS, and form and report development.
Technical:
Familiarity with SQL and Unix is beneficial. Experience with Oracle would be an asset.
Technical:
| MS Word |
Excel |
PowerPoint |
Other |
| Intermediate |
Intermediate |
|
|
Nature and Scope
Interpersonal Skills:
Internally, communicates with all SEEPAC staff to resolve issues with database, system and reports and evolve applications for staff use on database. Participates in quarterly meetings with the entire Centre faculty and staff. Communicates with IST staff in Optometry and across campus. Externally, this position has contact with ADP authorizers at Regional Assessment Centres to provide training on the database, to resolve problems with the database and to complete an annual equipment inventory. Also communicates with Oracle regarding problem tickets, upgrades and network support contracts.
Level of Responsibility:
The position is responsible for the secure day to day running of the system and database and for identifying and recommending future database and system developments and upgrades.
Decision-Making Authority:
Identifies and recommends future database and system developments and upgrades to Administrator.
Physical and Sensory Demands:
Minimal demands typical of IST personnel operating a computer daily.
Working Environment:
Minimal exposure to disagreeable conditions. Occasionally exposed to stress and pressure associated with sudden system blackouts, upgrade complications or tight deadlines for reports.
