Senior Database Administrator

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

Job summary

MacEwan University is seeking a Senior Database Administrator for a full-time continuing role within Information Technology Services. You will administer Oracle and SQL Server environments, ensure availability, security, backups, and performance, and support PeopleSoft, cloud, and data platforms.

This hands-on role requires a bachelor’s degree and seven years of IT experience with Oracle databases, plus experience with PeopleSoft and Azure/AWS data services.

Qualifications

• Bachelor's degree in CS/IT or related field.
• Seven years IT experience with at least 3 years Oracle DB administration.
• Experience with PeopleSoft, Oracle, SQL Server in production environments.

Responsibilities

• Administer Oracle databases in AWS RDS and on-premise environments.
• Ensure database availability, security, backup/recovery, patching, upgrades.
• Troubleshoot complex Oracle database issues in production.
• Plan PeopleSoft migrations, refreshes, upgrades, and lifecycle activities.
• Support PeopleSoft administration, including patches and migrations.
• Collaborate with teams to ensure reliable operation and document procedures.
• Provide support for SQL Server, Azure SQL, and other data platforms.
• Support data warehousing and ETL pipelines (Microsoft Fabric, Azure Data Factory).

Skills

Oracle DBA

SQL/PLSQL

AWS

PeopleSoft

Azure SQL

SQL Server

PostgreSQL

Microsoft Fabric

Data warehousing

Documentation

Communication

Analytical skills

Education

Bachelor's degree in Computer Science, Information Technology, or related field

Tools

AWS RDS for Oracle

Azure Data Factory

Azure SQL

SQL Server

PostgreSQL

Oracle in AWS RDS

PeopleSoft

Job description

Full-Time Continuing (35 hours per week) MSU Band G (Steps 1-8): $41.674 - $60.619 per hour. $75,846 - $110,326 per annum (Based on 35 hours per week). The competition will remain open until a suitable candidate is found.

About Us

MacEwan University is where caring faculty help people connect their passions to their future paths. Located in the heart of Edmonton's diverse and dynamic downtown community, and on the traditional lands of Treaty 6 First Nations and homelands of the Métis people, MacEwan is known for exceptional undergraduate learning. With its dedication to teaching excellence, informed by scholarly research, innovation, and creative activity, MacEwan provides an exceptional collaborative and supportive learning environment with a commitment to human rights, environmental sustainability, and opportunities for community engagement. We are committed to creating an equitable, diverse, inclusive, and welcoming community for all peoples, cultures, and identities.

Our comprehensive undergraduate university offers 55 programs to more than 21,000 full- and part-time students in business, communications, community and human services, design, fine and performing arts, health, humanities, natural science, nursing, public safety, and social science. Through a wide array of experiential learning opportunities, and strategic relationships in the community, we partner with others to produce graduates of stature. Along with a robust grounding in their chosen disciplines, MacEwan students are given durable life skills that prepare them to take on the world.

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 the technical subject matter expert responsible for the administration, availability, security, performance, and lifecycle management of the University’s Oracle, SQL Server, and other database environments. The role also supports PeopleSoft administration and, as operational priorities require, other enterprise database and data platforms.

Key responsibilities include:

• Administering, maintaining, monitoring, and optimizing Oracle databases hosted in AWS RDS and Oracle applications that support critical University services;
• Managing database availability, security, backup and recovery, patching, upgrades, capacity planning, performance tuning, and disaster-recovery readiness;
• Troubleshooting complex Oracle database issues, including SQL performance, indexing, data integrity, integrations, and production incidents;
• Planning and executing PeopleSoft code migrations, refreshes, upgrades, and lifecycle-management activities across on-premises and cloud environments;
• Supporting PeopleSoft administration, including environment management, application and PeopleTools upgrades, patching, migrations, and technical troubleshooting;
• Collaborating with application teams, infrastructure teams, vendors, and business stakeholders to ensure reliable and secure operation of Oracle and PeopleSoft environments;
• Maintaining technical documentation, operational procedures, standards, and automation for database and application administration;
• Providing support for Microsoft SQL Server, Azure SQL, other AWS database services, and related enterprise data platforms; and
• Providing support for Microsoft Fabric, Azure Data Factory, data warehousing, ETL pipelines, and legacy data-integration tools, as operational priorities require.

Skills

You will have:

• Comprehensive knowledge of Oracle database administration principles, architectures, and best practices;
• Strong knowledge of Oracle database security, access controls, auditing, backup and recovery, patching, upgrades, capacity planning, and disaster recovery;
• Excellent SQL and PL/SQL skills, including query optimization, indexing, execution-plan analysis, and performance tuning;
• Demonstrated ability to monitor, troubleshoot, and resolve complex database availability, performance, integration, and data-integrity issues in production environments;
• Knowledge of AWS RDS for Oracle administration, including monitoring, configuration, snapshots, restoration, maintenance, and upgrades;
• Knowledge of database migration, refresh, conversion, and lifecycle-management practices;
• Knowledge of PeopleSoft administration, including PeopleTools, environment management, patching, upgrades, migrations, and technical troubleshooting;
• Familiarity with Microsoft SQL Server, Azure SQL, PostgreSQL, and other cloud-hosted database services;
• Familiarity with Microsoft Fabric, Azure Data Factory, data warehousing, ETL pipelines, and related data-integration technologies;
• Ability to develop and maintain technical documentation, operational procedures, standards, and administrative automation;
• Excellent analytical, organizational, and problem-solving skills, with the ability to manage competing operational priorities; and
• Strong interpersonal and written and verbal communication skills, including the ability to collaborate effectively with technical teams, vendors, and business stakeholders.

Qualifications

• A minimum of a bachelor’s degree in Computer Science, Information Technology, or a related field.
• A minimum of seven years of progressive information technology experience, including at least three years of hands-on Oracle database administration experience, including:
  • Administering Oracle databases in production environments;
  • Administering Microsoft SQL Server databases in production environments;
  • Managing database security, backup and recovery, patching, upgrades, capacity, and disaster-recovery readiness;
  • Monitoring and tuning database performance, including SQL optimization, execution-plan analysis, and indexing;
  • Troubleshooting database availability, performance, integration, and data-integrity issues;
  • Performing database migrations, refreshes, conversions, and lifecycle-management activities; and
  • Administering Oracle databases in AWS RDS or a comparable cloud environment.
• Experience supporting PeopleSoft environments, including PeopleTools, environment management, patching, upgrades, migrations, and technical troubleshooting.
• Experience developing administrative automation using scripting or related tools.
• The following would be considered an asset:
  • Experience administering Azure SQL, PostgreSQL, or other cloud-hosted database services;
  • Experience with Microsoft Fabric, Azure Data Factory, ETL pipelines, data warehousing, or related data-integration technologies;
  • Experience working in a post-secondary or public-sector environment;
  • Oracle Database Administrator certification;
  • AWS certification; and
  • PeopleSoft or PeopleTools training or certification.
• An equivalent combination of education and experience may be considered.

When you become part of the MacEwan University team, you will enjoy a competitive salary. Our total compensation package includes:

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

However, Canadians and permanent residents will be given priority.

MacEwan University is committed to fostering the principles of equity, diversity, and inclusion within our community, and we are dedicated to removing barriers that have been historically encountered and are currently experienced by some members of our society. We welcome and encourage applications from Indigenous peoples, racialized persons, visible minorities, women, persons with disabilities, sexual and gender minorities, and members of all equity-deserving groups. We believe that the diversity of our students, staff, and faculty serves as a strength of our institution and benefit to society. We are committed to ensuring full and inclusive participation for all in our community.

Accessibility Statement

We strive to provide an inclusive and barrier-free work environment, beginning with the hiring process. If you require accommodation, we want to ensure you have the support you need to showcase your abilities. Please contact [e-mail] and we will support you to the best of our ability.

Personal Information Collection Notification
The personal information collected through MacEwan University’s application for employment and is used to determine your qualifications for employment. If your application progresses to the next stage of the hiring process, this information may be shared with non-HR members of the hiring committee and interview panel. This collection is authorized by section 4(c) of the Protection of Privacy Act. For questions about the collection of personal information, contact Human Resources at [e-mail] or phone [phone].