DISTRICT SCHOOL BOARD OF NIAGARA
Invites Applications For
Database Administrator
The DSBN is a supportive, innovative community that works towards doing what’s best for kids, and helps every student achieve success. Whether you’re in the classroom, on the playing fields, in the office or in the cafeteria, we know it’s the dedicated staff who bring our mission to life – you are what creates a child’s school experience and contribute to students reaching their full potential.
We proudly serve over 40,000 students across almost 100 elementary and secondary schools in Niagara, located between Lake Erie in the South and Lake Ontario to the North.
This position is part of the CUPE-OCTIS Union Group. The role offers a comprehensive benefits plan through a provincial trust plan (extended health, dental, life insurance, AD&D), and enrolment in the OMERS pension plan.
POSITION: Database Administrator
LOCATION: Education Centre (St. Catharines, Ontario)
RATE OF PAY: $35.56 - $42.15 per hour
SCHEDULE: 40 hours per week
Position Summary
Responsible for the secure, reliable and strategic management of DSBN data platforms and databases supporting academic and business operations. The position combines database administration, data integration, application interoperability, business intelligence, reporting modernization and analytics. It translates operational needs and legacy reporting logic into governed, maintainable data products, dashboards and reports that provide timely insight, reduce dependency on aging infrastructure and redundant databases, and support evidence-informed decision making across Curriculum Services, Human Resource Services, Payroll, Finance and other departments.
The functions of this position could include (but are not limited to):
DATABASE PLATFORM ADMINISTRATION AND RELIABILITY
- Install, configure, administer and maintain Microsoft SQL Server, MongoDB, MySQL and other relational and NoSQL database services in on-premises and cloud environments, including upgrades, patches, performance monitoring, capacity planning and tuning.
- Design and maintain relational schemas, tables, views, stored procedures and functions, as well as NoSQL document models, collections and indexes, along with permissions and technical documentation, using consistent standards and source control.
- Implement and test backup, restoration, high availability, disaster recovery, replication and business continuity procedures; monitor services and respond to database or data-pipeline incidents.
- Apply security, encryption, least-privilege access, auditing, retention and privacy controls appropriate to sensitive student, employee, payroll and financial information.
DATA INTEGRATION, INTEROPERABILITY AND QUALITY
- Design, operate and support secure data integrations among Aspen SIS, board applications, business systems, third-party services and reporting platforms using APIs, SFTP, SSIS or comparable orchestration tools.
- Build, schedule and monitor extraction, transformation and loading processes; validate completeness and accuracy, reconcile failures and maintain dependable data refreshes.
- Partner with system owners and vendors on application upgrades, interface changes, data conversions, historical migrations and release testing.
- Establish data quality checks, shared definitions, lineage and documentation so that trusted data can be used consistently across departments.
BUSINESS INTELLIGENCE, ANALYTICS AND REPORTING
- Consult with Curriculum Services and business departments to understand operational problems, decision needs, measures and reporting requirements, then convert them into practical data solutions.
- Design, develop and maintain accessible dashboards, semantic models, scorecards and operational reports using Microsoft Power BI, SQL Server Reporting Services, Crystal Reports and related tools.
- Create useful visualizations, drill-through analysis, scheduled reporting and governed self-service datasets that help leaders and staff identify trends, exceptions, risks and opportunities.
- Develop and maintain row-level security, workspace and report permissions, refresh schedules, data gateways and deployment practices for business intelligence solutions.
- Validate results with subject-matter experts and clearly communicate data limitations, definitions and appropriate interpretation.
LEGACY REPORT AND DATA MODERNIZATION
- Analyze existing reporting solutions to identify business rules, calculations, data sources, dependencies and functional requirements.
- Collaborate with business owners to establish requirements and acceptance criteria, ensuring the accuracy, integrity and consistency of modernized reporting solutions prior to implementation.
DATA PLATFORM AND GOVERNANCE MODERNIZATION
- Contribute to the design and implementation of a scalable data lake, lakehouse or modern analytics platform, including ingestion patterns, curated data layers, metadata, access controls, retention and monitoring.
- Develop reusable data models and common measures that reduce duplicate extracts and conflicting definitions across departments.
- Evaluate and recommend database, integration and analytics technologies through proof-of-concept work, security and privacy review, supportability assessment and total-lifecycle considerations.
- Promote standards for naming, documentation, testing, deployment, version control, change management and operational ownership.
APPLICATION SUPPORT, COLLABORATION AND SERVICE
- Provide advanced technical support for database-backed applications, data integrations and reporting services that cannot be resolved by the Service Desk or field support staff.
- Investigate complex data issues, coordinate resolution with application teams and vendors, and communicate impact, workarounds and restoration status to stakeholders.
- Work collaboratively across the Database Administration team so knowledge, operational responsibilities and critical reporting services are shared and supported rather than siloed.
- Create technical and user documentation, transfer knowledge, and provide guidance or training to report consumers and departmental data stewards.
- Participate in project planning, change control, incident response, on-call or after-hours maintenance as required, and perform other related duties assigned.
Skills, Qualifications And Education Requirements
- Minimum 3-year diploma/degree in Computer Studies, Information Technology, Computer Science or a related field, or an equivalent combination of education and relevant experience.
- Minimum 5 years of progressively responsible experience with Microsoft SQL Server database administration, data integration, reporting or business intelligence, including experience with MongoDB or other NoSQL databases. Experience supporting K-12 education, student information, HR, Payroll or Finance systems is preferred
- Minimum 3-year experience, working in a K-12 educational or related environment, supporting staff and students preferred
- A valid driver’s license is required, along with the ability to travel to schools, offices and offsite locations as required.
- Excellent learning, communication and organizational skills. Professionalism and client-focused service is essential.
Application Process
- All applications are accepted through ApplyToEducation
- Applications packages should include:
- Cover Letter
- Resume
- Three (3) professional references.
Selection Process
- We thank all the candidates for their interest, however, only those selected for an interview will be contacted.
The District School Board of Niagara is committed to equity and inclusion in the recruitment and hiring of its employees, who reflect the diversity of our community and students we serve. We encourage and welcome submissions from candidates from diverse backgrounds to build a supportive and inclusive workplace. DSBN welcomes applications from: Indigenous peoples, members of visible minorities, women, persons with visible and non-visible disabilities, persons of minority sexual orientations and gender identities, and others with the skills and knowledge to productively engage with diverse communities. The DSBN is committed to Achieving Success Together and recognizes that increasing the diversity of its workforce supports this objective.
DSBN will make interview and employment accommodations during the selection process, based on any of the human rights protected grounds. Please notify us in advance and we will work with you to meet your needs. Applicants are thanked for making known their interest in working for the District School Board of Niagara. We encourage applications from all qualified individuals; however, only those under consideration will be contacted.
Conditions Of Employment
- Upon hire, provide a Criminal Background Check with Vulnerable Sector Screening (dated within six months);
- Agreement to comply with the Board’s policies, procedures and code of conduct;
- Complete an annual offence declaration process.
Reason for posting: Vacancy.
Additional Information
In accordance with Section 29(2) of the Municipal Freedom of Information and Protection of Privacy Act, this is to advise that the information you provide on this for is collected under legal authority of the Education Act, and will be used as necessary for the recruitment, selection and employment purposes of the Board.
The DSBN is committed to equity for all students and staff, and to deliver quality education through a qualified workforce that reflects the diversity of the communities we serve. Upon request, we will provide reasonable accommodations in the hiring process to support applicants with disabilities.
Personal information on this form is collected, used and disclosed in accordance with the Education Act, R.S.O. 1990, c.E.2, as amended and the Municipal Freedom of Information and Protection of Privacy Act. R.S.O 1990, c.M. 56, as amended and will be used for the purpose of determining eligibility of the above-noted position and any similar or related purpose(s). Questions about this collection, use and disclosure should be directed to the Freedom of Information Coordinator, District School Board of Niagara, 191 Carlton Street, St. Catharines, ON L2R 7P4 905-641-1550.
DSBN does not utilize Artificial Intelligence (AI) in the screening, assessment, or selection of applicants.
Land Acknowledgement
The land on which we gather is the traditional territory of the Haudenosaunee and Anishinaabe peoples, many of whom continue to live and work here today. This territory is covered by the Upper Canada Treaties and is within the land protected by the Dish with One Spoon Wampum agreement. Today this gathering place is home to many First Nations, Métis, and Inuit peoples acknowledging this reminds us that our great standard of living is directly related to the resources and friendship of Indigenous people.