Senior Database Administrator - Information Technology Services

MacEwan University; Edmonton; On-site; CAD 76,000 - 110,000; Full time

Benefits offered by this job

Competitive base pay

Generous vacation time

Secure pension plan

Flexible benefits package

Continuous learning culture

Career growth opportunities

Job summary

MacEwan University seeks a Senior Database Administrator to lead enterprise database technologies within ITS. You will design ETL pipelines, manage data migrations, and optimize Oracle and MS SQL databases while collaborating with IT, Finance, and HR to support university services.

The role requires 7+ years in IT with 3+ in data engineering or DBA, plus cloud experience (Azure/AWS). This is a full-time continuing position with a 35-hour work week and competitive benefits.

Qualifications

• Bachelor’s Degree in Computer Science, Information Technology, Data Science, or a related field.
• 7+ years of progressive IT experience with at least 3 years in data engineering or database administration, including cloud platforms (Azure, AWS, Fabric).
• Experience designing and implementing ETL pipelines (Azure Data Factory, Fabric or similar).
• Experience with Oracle databases, MS SQL, Azure SQL, AWS RDS; data integration and migration from legacy systems to cloud.
• Exposure to data warehousing concepts and BI tool architectures (Power BI).
• Certifications in Azure Data Engineer, AWS Solutions Architect, Oracle DBA, or Power BI Data Analyst are assets.

Responsibilities

• Design, develop, and maintain ETL pipelines from source systems into the data warehouse.
• Work with Azure Data Factory and Microsoft Fabric to automate and optimize data flows and reporting with Power BI.
• Manage migration from legacy systems to cloud-based environments, ensuring data integrity.
• Maintain and optimize database systems including Oracle, MS SQL, Azure SQL, AWS databases.
• Monitor data storage, performance tuning, and security compliance for data assets.
• Liaise with Data and Analytics team and other departments to align data needs with business objectives.
• Provide training on data tools and technologies including Microsoft Fabric, Azure, Power BI, and Oracle databases.

Skills

SQL Proficiency

ETL pipelines

Azure Data Factory

Power BI

Oracle databases

Cloud migration

Data warehousing

Performance tuning

Data security

Communication skills

Education

Bachelor’s Degree in CS/IT/Data Science

Tools

Azure

AWS

Microsoft Fabric

Oracle

MS SQL

Power BI

Job description

Competition Number: 26.09.235

Category: Full-Time Continuing (35 hours per week)

Salary: MSU Band G (Steps 1-8): $41.674 - $60.619 per hour. $75,846 - $110,326 per annum (Based on 35 hours per week).

Closing Date: October 6, 2026

MacEwan University is seeking a Senior Database Administrator for a full-time continuing opportunity with Information Technology Services.

Reporting to the Team, Lead, IT Data and Analytics, the Senior Database Administrator is a technical subject matter expert responsible for leading activities related to enterprise database technologies within Information Technology Services (ITS). You will coordinate the development and design of enterprise database systems supporting key business applications including online course management (CMS), enterprise resource planning (ERP), enterprise data warehouse and business intelligence (BI) technologies critical to key University services.

Key responsibilities

• Designing, developing, and maintaining ETL pipelines to move data efficiently and securely from source systems, including Oracle Applications and Databases, into the data warehouse;
• Working with Azure Data Factory and Microsoft Fabric to ensure data flows are automated, optimized, and reliable. This includes creating, managing, and testing data pipelines, and using Microsoft Power BI for reporting and visualization of data;
• Managing the transition from existing systems (including Oracle, IBM Infosphere, etc.) to updated cloud-based environments, ensuring seamless data migration and integration;
• Maintaining, optimizing, and troubleshooting the university’s database systems, including MSQL, Azure SQL databases, AWS databases, and Oracle databases/applications;
• Monitoring and ensuring efficient data storage, performance tuning, and security compliance for all data assets;
• Acting as a liaison between the Data and Analytics team and other departments (e.g., IT, Finance, HR, etc.) to identify data needs, prioritize projects, and ensure alignment with business objectives; and
• Providing ongoing support and training on data tools and technologies, including Microsoft Fabric, Azure, Power BI, Oracle databases, and data management best practices.

Skills

• Comprehensive knowledge of database administration principles and best practices;
• Excellent SQL, relational and multidimensional database design skills;
• Excellent knowledge of data movement, data migration, and data conversion practices;
• Strong knowledge of enterprise database architectures, theories, principles, and practices;
• Strong knowledge of data warehousing concepts and methodologies;
• Knowledge of BI tool architectures, functions, and features;
• Demonstrated ability to troubleshoot and resolve data integrity and performance issues across diverse platforms;
• Excellent analytical and problem-solving skills, with the ability to prioritize and manage multiple tasks effectively;
• Strong troubleshooting skills to diagnose and resolve complex database issues;
• Strong interpersonal and communication skills (verbal and written);
• The ability to analyze system performance and suggest improvements;
• The ability to adapt to new technologies (e.g., Azure, AWS, Microsoft Fabric) and tools; and
• Familiarity with Learning Management Systems (e.g., Moodle) and Enterprise Resource Planning (ERP) systems (e.g., PeopleSoft).

Qualifications

• A minimum of a Bachelor’s Degree in Computer Science, Information Technology, Data Science, or a related field.
• A minimum of 7 years of progressive experience in Information Technology with at least 3 years of related experience in data engineering, database administration, or a similar role, including:
  • Experience with cloud platforms such as Azure, AWS, and Microsoft Fabric
  • Hands-on experience in designing and implementing ETL pipelines (using Azure Data Factory, Microsoft Fabric, or similar tools)
  • Experience working with Oracle databases, MSQL, and other relational databases (e.g., Azure SQL, AWS RDS)
  • Experience in data integration and migration projects, particularly migrating from legacy systems (e.g., Oracle) to cloud-based environments
  • Experience and proficiency in developing and maintaining ETL Pipelines
  • Experience in database performance tuning, including query optimization and indexing
• The following would be considered an asset:
  • Familiarity with or experience in a post-secondary or other public sector environment
  • Certification in:
    • Microsoft Certified: Azure Data Engineer Associate
    • AWS Certified Solutions Architect
    • Oracle Database Administrator Certification
    • Microsoft Certified: Power BI Data Analyst Associate
    • An equivalent combination of education and experience may be considered.

Benefits

• Competitive base pay
• Generous vacation time
• Secure pension plan
• Flexible benefits package
• Continuous learning culture
• Opportunities for career growth

This position is included under the MacEwan Staff Union Collective Agreement.

All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.