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 include:
- 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
You will have:
- 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 environmentCertification 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
When you become part of the MacEwan University team, you will enjoy a competitive salary. Our total compensation package includes:
- Competitive base pay
- Generous vacation time
- Secure pension plan
- Flexible benefits package
- Continuous learning culture
- Opportunities for career growth
How To Apply
To apply, please head to our MacEwan University Opportunities Page, select the job opportunity and click Apply Now. If you require assistance, please contact us at careers@macewan.ca.
If you are experiencing technical difficulties when submitting your application, please try submitting through a different browser (i.e., Safari, Firefox, Chrome, etc.). If the issue persists, please send a screenshot of the error message to careers@macewan.ca so we can assist and ensure your application is received.
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.
