Database/student Information System Administrator

**Duties and Responsibilities**:

- Portal assignments in PowerSchool, manage Access/Roles (SIS)
- Identify data requirements and develop queries using standard query languages to extract, load, report, and analyze data.
- Administer Microsoft SQL database version upgrades, new installation, maintenance, performance tuning, and security-related tasks
- Develop custom webpages and reports for the Student Information System using HTML, JavaScript (jQuery) and CSS
- Administer, troubleshoot and support existing and develop new Microsoft Power Apps, Power Automate and Power BI solutions
- Manage updates or patch updates to various systems and databases to ensure software maintenance
- Diagnose and troubleshoot problems related to the various databases, Tier 1/2 Support
- Work with systems manager to provide database solutions
- Design and implement database security with the guidance of the Security Lead
- Work with back-up and recovery team to ensure database are backed up and restorable
- Work with other IT staff to maintain and support Active Directory/EntraID
- Work with server staff to deploy and configure database servers

**Qualifications, Skills and Abilities**:

- Qualifications_
- Bachelor’s degree (B. Sc.) or Diploma in Computer Technology (preferred)
- Microsoft Certified IT Professional (MCITP) Database Administrator or Microsoft Certified Technology Specialist (MCTS) (preferred)
- Information Technology Infrastructure Library (ITIL) methodologies and/or IT current best practices (preferred)
- Experience with computer hardware, software, and networks in a Windows environment are essential
- 3 to 5 years of demonstrated technical expertise or equivalent required
- Skills and abilities _
- Knowledge of various databases with a specialty in Microsoft SQL and Oracle
- Good understanding queries and reports development
- Ability to export and import data from one database to another, or software systems
- Ability to respond and successfully interact with coworkers, and administrative staff
- Understanding of web servers that utilize databases for information storage and retrieval
- Good understanding of Active Directory (AD)
- Knowledge of multiple backend languages (e.g. Java, Python) and JavaScript frameworks (ex. Angular, React, Node.js)
- Strong understanding and experience with Microsoft Excel
- Ability to communicate orally and written in a professional manner
- Strong desire to stay informed of new initiatives
- Ability to respond and positively interact with coworkers, and administrative staff
- Ability to work with cross-functional teams that have limited technical expertise
- Ability to positively interact with other school division technical teams and vendors
- Proven analytical mind with strong problem-solving skills
- Good organization skills

**Physical Demands and Working Conditions**:

- Physical demands:_
- Sitting or standing for extended periods of time
- Hand-held telephone receiver may require repetitive arm-stretching and elbow-bending action
- Extensive use of computer mouse and keyboard
- Prolonged periods of viewing computer monitor
- Lifting and carrying up to 20 lbs. may be required
- The ability to safely climb a ladder
- Working conditions:_
- Exposure to noise and frequent interruptions with conflicting demands and deadlines

**Confidentiality**:
Demonstrated professionalism and respect for privacy in dealing with sensitive and confidential organizational, employee and student data and information.
- The above statements reflect the general duties considered necessary to describe the principal functions of the position identified and shall not be construed as a detailed description of all work requirements that may be inherent to the position._

**Job Types**: Full-time, Permanent

**Salary**: From $66,576.00 per year

**Benefits**:

- Dental care
- Disability insurance
- Extended health care
- Life insurance
- On-site parking
- Paid time off
- RRSP match
- Vision care

Flexible Language Requirement:

- French not required

Schedule:

- Monday to Friday

**Experience**:

- system administration: 1 year (preferred)

Ability to Commute:

- Winnipeg, MB R2K 2P7 (required)

Ability to Relocate:

- Winnipeg, MB R2K 2P7: Relocate before starting work (required)

Work Location: In person