Data Systems Administrator

Reporting to the Associate Director of Technology Integration and Innovation, the Data Systems Administrator holds a crucial position in managing and enhancing all integrated database systems used by the school. Whether these systems are hosted locally or in the cloud, this role demands expertise in database management, security, capacity planning, and ensuring smooth data flow coordination across various departments. As a vital member of the Information Technology team, the Data Systems Administrator provides support to users across different academic divisions and departments, including Lower School, Middle School, Upper School, Advancement, Student Service, Finance and Enrollment.

Responsibilities:

• Research, test, and coordinate patches and upgrades to database servers and systems.
• Implement best practices for backup and recovery of databases.
• Stay informed about emerging threats to data security and recommend strategies to mitigate vulnerabilities.
• Monitor the health and performance of database servers.
• Implement and enforce security measures to protect sensitive student and staff information.
• Ensure compliance with relevant data protection regulations and standards.
• Data Quality, Analytics and Reporting
• Develop customized reports and dashboards to provide enhanced insights to School users.
• Train, coordinate, and support data owners and departmental database users to ensure accuracy, validity, and security of data.
• Prepare electronic data submissions to the Ontario Ministry of Education and Ontario University Application Centre.
• Resolve Help Desk tickets related to database systems and collaborate with software vendors to address issues.
• Work closely with external software providers to integrate the school information system with other applications and services, ensuring data consistency across platforms.
• Oversee the continued interconnection and integration of all database systems to ensure consistency, single-instance storage, and automation of data flows.
• Develop and maintain responsively-coded applications for teacher coverage requirements, parent-teacher interview scheduling, course selection, etc.
• Participate in planning the next generation of integrated data systems, including migration to cloud-based SaaS where applicable.
• Maintain comprehensive documentation of database configurations, processes, and procedures.

The successful candidate will have:

• University degree in computer science or related field, with a minimum of 5 years of relevant experience.
• Experience with popular SIS (Student Information System) and LMS (Learning Management System), such as Blackbaud Suite, Google Classroom, Schoology, Moodle, Canvas, or others.
• Proficient in Windows Server, Windows 10/11, Mac OS, and Chrome OS.
• Proficient in SQL and database management systems (e.g., MySQL, Oracle, SQL Server). Strong understanding of database security, data backup, and recovery procedures.
• Experience with cloud-based databases and services.
• Programming experience, including C# with .Net, VBA, Python, SQL, JavaScript, HTML/CSS.
• Experience with Ministry data requirements (ONSIS, OUAC, OSSLT) is a definite asset.
• Advanced experience with Google Workspace for education, including Gmail/Google Drive/Google App/Google Sheet.
• Expertise with Microsoft 365, including Word/Excel/PowerPoint/Access, Teams, PowerBI, SharePoint.
• Desire to become a supportive and engaged community member fostering the school’s positive and progressive culture.
• Ability to build authentic relationships, mentor, and model integrity, honesty, and trust.
• Possesses a growth mindset with good professional judgment.
• Excellent problem-solving skills and the ability to work collaboratively in a team environment.
• Effective communication skills to interact with technical and non-technical stakeholders.
• Knowledge of educational technology trends and best practices.