POSITION SUMMARY
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.
KEY RESPONSIBILITIES :
- 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.)
- Build and support the processes that drive the Board’s Active Directory environment.
- 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; maintain warehousing.
- 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
WORK PERFORMED :
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 requiredMonitor access to corporate data according to access protocols and security policyMaintain the data dictionary and provide normalization as requiredAnalyze, evaluate, document and present requirements for new or modified information in the data structuresProvide support to the information technology team and staff in other departments regarding access to, and manipulation of the data in production databasesAssist systems integration staff with the data set-up, installation and manipulationAssist with the implementation of new enterprise applications by providing database development and supportMaintain warehousing, archiving, backup and restorationPerform data modeling for the corporate web databaseDemonstrate current knowledge and skills related to database administrationQUALITIES / SKILLS / SPECIALIZED KNOWLEDGE :
Excellent interpersonal skills with effective communication skills, both orally and in writingAbility 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 work both independently and as part of a teamAbility to manage several concurrent issues, balancing priorities, deadlines, risks to deliver effective solutionsKnowledge of relational database management systems (e.g. SQL Server), operating systems (e.g. Windows Server 2016, 2019, 2022), data modelling, classification, and mappingDetailed knowledge of Structured Query Language (SQL) and Database Utilities; SSIS, SSRS, SAS and TFSGeneral understanding of computer language, coding and database calls from web applicationsEDUCATION, EXPERIENCE AND QUALIFICATIONS :
Completion of four (4) year post-secondary education in a computer related field or equivalentFive (5) years of related experience is requiredDatabase 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 DevelopmentPlease note it is the responsibility of the applicant to ensure that the application is received by Human Resources on or before the deadline date. This posting is for a permanent existing vacancy.
Thames Valley does not utilize any assistive technology in the recruitment and selection process.
The recruitment process requires a criminal background check for work with vulnerable persons at your own expense. In accordance with regulations, this will be an ongoing expectation of employment for TVDSB employees every five years of employment.
If you were educated outside of Canada, you must have your certificates and / or diplomas or degrees assessed against Canadian education standards. This will enable you to provide proof of Canadian equivalency when applying for a job. The Alliance of Credential Evaluation Services of Canada is a membership organization that offers fair and credible academic credential assessment services in Canada.