DataBase Administrator (IT)

The Thames Valley District School Board (TVDSB) is the fourth largest school board in Ontario and a major employer in one of Canada’s fastest growing regions. Our inclusive and diverse board serves 83,000 students and employs nearly 12,000 staff across the City of London, Elgin, Middlesex and Oxford Counties, Chippewas of the Thames First Nation, Munsee-Delaware Nation and Oneida Nation of the Thames. We offer competitive benefits including a pension program and comprehensive mental health and well-being support. Best of all, every role at TVDSB directly supports the success of children and families in YOUR community. Join TVDSB to build each student's tomorrow, every day!

DATABASE ADMINISTRATOR

Database Administrator

Immediate

The Database Administrator supports the administration of the Board’s production, test, development, and web databases and ensures that access to databases meets with the applicable access and security protocols. The incumbent defines data structures and assumes responsibility for data relationships and inter-database integration, including data warehousing components. The incumbent supports Active Directory processes and provides technical support for all the Board’s applications and systems. The incumbent works with the IT Security Administrator to ensure the integrity and protection of all Board data and is responsible for the implementation, configuration, maintenance and performance of critical SQL Server RDBMS systems.

Provide advanced end-to-end technical support and complex problem resolution for ITS staff (including the service desk and SIS teams) and vendors utilizing Board-based databases applications (including, but not limited to, Student Information Systems, EQAO, Payroll, Finance, etc.)
Define Board data structures for the integration and replication throughout the distributed server environment; monitor and ensure that access adheres to the Board’s protocols and security policies; monitor database server performance; monitor data security on an ongoing basis; maintain database data dictionaries and provide normalization as required; Provide support to staff regarding access to, and manipulation of, the data in test and production databases; assist Systems Integration team with data setup, installation and manipulation; assist with the implementation of new enterprise applications by providing database development and support; work with the Infrastructure team to ensure appropriate archiving, backup and restoration of databases and datasets
Maintain effective and cooperative liaison with staff, affiliated agencies, vendors, supplies, consultants, service providers, and staff in other government and community organizations; continually seek opportunities to increase customer satisfaction and strengthen customer and vendor relationships

Complete tasks to define data structures, follow protocols to integrate data across the distributed servers and the replicated corporate data on to other servers as required
Monitor access to corporate data according to access protocols and security policy
Maintain the data dictionary and provide normalization as required
Analyze, evaluate, document and present requirements for new or modified information in the data structures
Provide support to the information technology team and staff in other departments regarding access to, and manipulation of the data in production databases
Assist systems integration staff with the data set-up, installation and manipulation
Assist with the implementation of new enterprise applications by providing database development and support
Perform data modeling for the corporate web database
Demonstrate current knowledge and skills related to database administration

QUALITIES/SKILLS/SPECIALIZED KNOWLEDGE:

Excellent interpersonal skills with effective communication skills, both orally and in writing Ability to create and share documentation through Microsoft O365 and applicable MS Office Suite, in addition to IT work processing tools (e.g. JIRA, DevOps, Topdesk, etc) Ability to manage several concurrent issues, balancing priorities, deadlines, risks to deliver effective solutions Knowledge of relational database management systems (e.g. SQL Server), operating systems (e.g. Windows Server 2016, 2019, 2022), data modelling, classification, and mapping Detailed knowledge of Structured Query Language (SQL) and Database Utilities; SSIS, SSRS, SAS and TFS General understanding of computer language, coding and database calls from web applications

Completion of four (4) year post-secondary education in a computer related field or equivalent
Five (5) years of database administration specific experience is preferred
Database Administrator Associate, Microsoft Certified Solutions Associate (MSCA) Certification in the following areas is an asset: SQL Server, SQL Database Development, SQL Database Administration, SQL Business Intelligence Development

In accordance with regulations, this will be an ongoing expectation of employment for TVDSB employees every five years of employment.

This posting is for a permanent existing vacancy.

The Alliance of Credential Evaluation Services of Canada is a membership organization that offers fair and credible academic credential assessment services in Canada. (NOTE: This is different from translating credentials into English).

.

The Thames Valley District School Board is committed to equity and inclusion in the recruitment of qualified staff who reflect and support the diverse perspectives, experiences and needs of our students and school communities. The Thames Valley District School Board seeks to ensure that all recruiting processes are non-discriminatory and barrier-free and will provide accommodations to applicants in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act (AODA).