Database Administrator (Temporary)

Greater Essex County District School Board; Windsor; Presencial; CAD 81.000 - 95.000; Jornada completa

Descripción de la vacante

The Greater Essex County District School Board invites applications from qualified, team-oriented individuals for the full-time position of Database Administrator. This is an 18-month contract, Non Bargaining position in the Information Technology Services Department.

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.

Formación

• Minimum three years of progressive experience in database administration and development.
• Experience with Microsoft SQL Server, T-SQL, and data modelling.
• Proficiency in web/app development with HTML/CSS/JavaScript/.NET C# or PHP.
• Automation using PowerShell, SQL Agent, SSIS and SSRS or equivalent.
• Experience with data warehouses, data quality, and privacy practices.
• Comfort working across teams and on-call support.

Responsabilidades

• Administer, secure, optimize and support databases and related apps.
• Install, configure, upgrade, backup, recover, and monitor DB systems.
• Design data models, plan migrations, and assess vendor solutions.
• Develop internal apps and tools using HTML, JS, .NET C#, PHP and SQL.
• Create data extracts, reports and dashboards for various stakeholders.
• Maintain access controls in line with MFIPPA and board policies.

Conocimientos

Microsoft SQL Server

T-SQL

Relational DB modelling

Performance tuning

Security and backups

REST APIs

Scripting automation

PowerShell

SQL Agent

Educación

Bachelor's degree in Computer Science / IT or related field

Equivalent combination of education and experience

Herramientas

SSIS

SSRS

Azure

Descripción del empleo

The Greater Essex County District School Board invites applications from qualified, team-oriented individuals for the full-time position of Database Administrator. This is an 18-month contract, Non Bargaining position in the Information Technology Services Department.

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.

Qualifications:

• 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.

Additional Assets:

• 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.

We recognize that many of these identities intersect and therefore, equity, diversity and inclusion can be complex. We value and respect the contributions that each person brings to enriching the Board and are committed to ensuring full and equal participation for all in communities that we serve.

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.