Database Administrator (Temporary)
- Windsor, ON, Canada
RATE OF PAY: $81,026.40 to $95,368 · Full-time
Applications open in a new tab.
Job details
- Pay
- RATE OF PAY: $81,026.40 to $95,368
- Job type
- Full-time
- Apply by
- Working hours
- 35 hours per week
- Posting language
- English
- Posted
Original job description
Job Summary
POSITION: Database Administrator
START DATE: ASAP
LOCATION: Administration Building
FTE: 1.0 (35 hours per week)
RATE OF PAY: $81,026.40 to $95,368
Nature & Scope Of Position
The Database Administrator is a technical lead for the databases, data integrations, data warehouse, reporting and internally developed applications that support the Board’s student and business systems. The Database Administrators work as one team across both areas: each has a primary focus, but all are expected to contribute to the full range of the Board's systems, share on-call and escalation duties, and provide coverage during absences. The successful candidate's primary focus will be determined by their strengths and the needs of the department The successful applicant will be responsible for:
- Administer, secure, optimize and support the Board's databases and related application databases, including the SIS year-end rollover and term transitions and the fiscal year-end, payroll and reporting cycles of the business systems, ensuring data integrity, accuracy and consistency.
- Install, configure, maintain and upgrade database and related server software; design and maintain backup and recovery procedures; monitor performance and resolve issues; and maintain change control, testing and documentation processes.
- Translate functional requirements into technical designs, specifications and estimates; create data models; assess the impact of changes on other systems; plan and validate data migrations; and provide technical assessments to support the evaluation of vendor solutions.
- Develop and maintain internal applications, scripts and tools using HTML, CSS, JavaScript, .NET/C#, PHP and SQL.
- Develop, schedule and monitor data integrations between the Board's systems and connected platforms using SQL Agent jobs, ETL, APIs, SFTP and PowerShell scripting, and coordinate testing with users and vendors.
- Automate manual and repetitive data and application processes, recommend opportunities for further automation, and evaluate, pilot and apply artificial intelligence tools in accordance with Board policy and privacy requirements.
- Develop and maintain data extracts, validation queries and error-correction processes for OnSIS, EQAO and other Ministry of Education submissions, and the extracts and reports required for financial, human resources and payroll reporting and audits.
- Create reports and dashboards on student, financial, human resources and operational data for schools and departments, including development of the Board's data warehouse.
- Implement and maintain role-based access, auditing and secure handling of student, employee and Board data in accordance with the Municipal Freedom of Information and Protection of Privacy Act (MFIPPA) and Board policy, and comply with Board policies, licensing agreements and related legislation, including accessibility requirements.
- Act as the technical escalation point for database, application and integration issues, including on call support during critical periods; work with the Board's other Database Administrator to maintain common standards and provide backup coverage; and train and support users as appropriate.
- Demonstrate a commitment to and documented success in working to create a fair, inclusive, anti racist environment for all stakeholders, and to supporting diverse constituencies and populations.
- Perform other related duties as assigned.
- Bachelor's degree, diploma or technical training in Computer Science, Information Technology or a related discipline, or an equivalent combination of education and experience as approved by the Board.
- A minimum of three years of progressive experience in database administration and development, including Microsoft SQL Server, T-SQL, relational database modelling, performance tuning, security, and backup and recovery.
- Experience developing and maintaining web and business applications using HTML, CSS, JavaScript, .NET/C# and PHP, and integrating applications through REST APIs.
- Proficiency with scripting, automation and data integration technologies such as PowerShell, SQL Agent, SSIS and SSRS or equivalent, and a demonstrated ability to automate manual processes.
- Experience with AI-assisted development or analytics tools is an asset.
- Knowledge of data warehouses, data integration, data quality controls, reporting processes, identity and access management, and database security and privacy practices.
- Strong analytical, problem-solving and communication skills, a customer service orientation, the ability to work independently, and the flexibility to support colleagues across teams.
- An understanding of how artificial intelligence tools can be applied responsibly to data, reporting and development work.
- Knowledge of Ontario Ministry of Education reporting requirements (OnSIS, OEN and enrolment reporting).
- Experience supporting finance, human resources or payroll systems.
- Experience with K–12 student information systems and Education Computing Network of Ontario (ECNO) applications.
- Experience with Azure or other cloud-hosted database platforms.
- Microsoft Certified: Azure Database Administrator Associate or equivalent certification.
Todd Awender, Superintendent of Education
Greater Essex County District School Board
451 Park Street West, Box 210
Windsor, ON N9A 6K1
Posting Number: 2026-159/ 4077116
The Greater Essex County District School Board Actively Encourage Applications From Members Of Groups With Historical And/or Current Barriers To Equity, Including, But Not Limited To
- First Nations, Métis and Inuit peoples, and all other Indigenous peoples;
- members of groups that commonly experience discrimination due to race, ancestry, colour, religion and/or spiritual beliefs, or place of origin;
- persons with visible and/or invisible (physical and/or mental) disabilities;
- persons who identify as women; and
- persons of marginalized sexual orientations, gender identities, and gender expressions.
The Greater Essex County District School Board has an accommodation process in place that provides accommodations for employees and applicants. In accordance with the Accessibility for Ontarians with Disabilities Act (AODA), the GECDSB strives to ensure that all recruiting processes are non-discriminatory and barrier-free. If you require an accommodation based on any Code-protected ground under the Ontario Human Rights Code for your interview, testing, and/or practicum, please advise the Recruitment Team member when contacted for an interview, testing and/or practicum. This will ensure that the appropriate accommodation(s) are in place prior to you attending.
More about this job
Responsibilities
Administer, secure, optimize, and support databases, applications, integrations, and the data warehouse, including backups, migrations, reporting, and Ministry of Education submissions. Develop and automate applications and data processes, protect sensitive information, resolve escalated technical issues, and collaborate with users, vendors, and the other Database Administrator.
Requirements
Requires a degree, diploma, or technical training in Computer Science, Information Technology, or a related discipline, or an approved equivalent combination of education and experience. Requires at least three years of progressive database administration and development experience, including SQL Server, T-SQL, application development, integrations, scripting, security, and backup and recovery.
Skills
- Microsoft SQL Server
- T-SQL
- Database Administration
- Relational Database Modeling
- Performance Tuning
- Database Security
- Backup and Recovery
- HTML
- CSS
- JavaScript
- .NET/C#
- PHP
- REST APIs
- PowerShell
- SQL Agent
- Data Integration
Visa sponsorship
Not detected in the job text
Hiring contact
Todd Awender
Categories
- Technology
- Data & Analytics
- Software
- Education
Keywords
- Microsoft SQL Server
- T-SQL
- Relational Database Modeling
- Database Administration
- Performance Tuning
- Database Security
- Backup and Recovery
- Data Warehouse
- Data Integration
- ETL
- SQL Agent
- SSIS
- SSRS
- PowerShell
- REST APIs
- SFTP
- HTML
- CSS
- JavaScript
- .NET/C#
- PHP
- Data Modeling
- Data Migration
- Reporting and Dashboards
- OnSIS
- OEN
- Microsoft Azure
- Identity and Access Management
- MFIPPA
- Artificial Intelligence