Data Base Analyst

Avanti Software Inc.; Fort McMurray; On-site; CAD 76,000 - 77,000; Full time

Benefits offered by this job

Health & dental

LAPP pension

Northern Living Allowance

Paid holidays

Life insurance

Paid sick days

Employee discounts

Tuition waiver

Job summary

Keyano College's Information Technology Services Department is seeking a Data Base Analyst to design, install, and maintain production databases while ensuring high levels of data availability and system resiliency. The role will develop and oversee database policies, procedures, and proactive monitoring solutions on campus in Fort McMurray, AB.

Relocation to Fort McMurray is required. The position offers a comprehensive health and dental benefits package, a defined benefit pension plan (LAPP),

Qualifications

• 3+ years of experience managing and troubleshooting MS-SQL databases and ETL development
• Experience with data warehouse design or management (Azure Data Lake or equivalent)
• Industry certifications in SQL (e.g., MCSA) will be an asset

Responsibilities

• Design and maintain database and data warehouse structures
• Monitor performance and resolve access, reliability, and efficiency issues
• Plan and coordinate data migrations and integrations
• Develop reports, ETL processes, and data solutions to support operations
• Implement monitoring, auditing, logging, backup, and security controls
• Participate in technology projects and document technical work

Skills

MS-SQL databases

ETL development

Azure Data Lake

XML constructs

Data warehouse modeling

Education

Degree/Diploma in a technical field (CS/CE)

Tools

SQL platforms (MySQL)

XML schemas

Job description

Keyano College's Information Technology Services Department is currently seeking a Data Base Analyst to join their dynamic team. The Database Analyst's role is to design, install, and maintain production databases while ensuring high levels of data availability, and system resiliency. This position will be responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Included in the responsibilities of this position is the implementation of audit, logging, and monitoring solutions to provide proactive operational support.

Note: this is not a remote or hybrid work opportunity, you will be required to work on campus and relocate to Fort McMurray, AB.

About Us

Keyano College is a comprehensive post-secondary educational institution located in Fort McMurray, nested in the Regional Municipality of Wood Buffalo on traditional Treaty 8 territory. We are a strategic community partner that meets both the training and talent upgrading needs of industry, as well as the personal enrichment and cultural needs of the Wood Buffalo community. We take pride in offering a safe work and study environment that embraces Equity, Diversity, Inclusion and Belonging. Our students and customers come from all walks of life and so do we. That is why we are committed to hiring great people from a variety of backgrounds because it makes our employee community stronger.

Duties & Responsibilities

• Design and maintain database and data warehouse structures to support business and application needs.
• Monitor database performance and resolve access, reliability, and efficiency issues.
• Provide technical support for applications that use organizational databases.
• Plan and coordinate data migrations, system integrations, and data transfers between platforms.
• Manage database changes, testing, and quality assurance processes to ensure system stability.
• Develop and maintain reports, datasets, ETL processes, and data solutions to support business operations.
• Implement monitoring, auditing, logging, backup, and security controls to protect data and support operations.
• Perform database maintenance activities, including upgrades, patching, and ongoing performance improvements.
• Develop database strategies, architecture standards, governance practices, and disaster recovery solutions in collaboration with stakeholders.
• Participate in technology projects, develop technical documentation, write scripts to enhance system functionality, and provide guidance to junior team members.

Qualifications

Required Qualifications:

• Degree/Diploma in a technical field such as computer science, computer engineering or related field
• 3+ years of experience in the management and troubleshooting of MS-SQL databases, queries, and development of ETL code and integrations
• One of the many available industry certifications in SQL (Microsoft MCSA or similar)
• Competency with XML constructs and schemas. Knowledge of programming, scripting methods, and best practices is required
• Experience in working with or managing a data warehouse and report/dashboard modeling (preferably Azure Data Lake or similar cloud-based solutions)
• Project management experience
• Experience with data processing flowcharting techniques

Preferred Qualifications:

• Experience with API protocols and schemas such as SOAP and REST
• Experience working with other SQL platforms (MySQL, etc.) would be desirable.
• Familiarity with change management processes, testing methodology, and agile development methodology
• A collaborative and approachable style with an ability to build consensus with competing departments
• Ability to communicate effectively with and influence end user clients
• Experience in the education sector (preferably Post-secondary) is a plus

Please note that if your education was received internationally, upon hire we will require you to provide an international education assessment completed through WES, IQAS or one of the other IRCC approved designated organization.

Compensation and Benefits

• Compensation is $76,108.66 (CUPE TS8-1) with the following health and benefit package.
• Employer paid comprehensive health and dental benefits, including a health spending account.
• Generous defined benefit pension plan though LAPP starting on day 1 of employment.
• This position qualifies for additional payment of the Northern Living Allowance of $1,040.00 per month.
• Generous vacation entitlement and the bonus of paid holidays between Christmas and New Years
• Life insurance is 2.5 times your annual salary
• Paid sick days

We offer various perks and discounts to our employees:

• Employee Service and Academic Achievement recognition
• Greatly discounted employee membership to the Syncrude Sports and Wellness Centre (our well-known gym and recreational facility).
• Tuition waiver for all employees and dependents to take courses at Keyano College to support your thirst for learning.
• Employee Discounts for the Keyano Theatre and the Keynotes Bookstore.

Additional Information

At Keyano College, we are committed to fostering an equitable, caring and resilient environment where everyone feels valued and connected to the common goal and the college community. We welcome applications from all qualified individuals and encourage candidates who will contribute to the diversity of the College to apply.

We would like to thank all applicants in advance for submitting their resumes. Please note, only those candidates chosen to continue through the selection process will be contacted.