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 c

📌 Database Administrator (Canada)
🏢 GREATER ESSEX COUNTY DISTRICT SCHOOL BOARD
📍 Canada