Senior Database Administrator - Information Technology Services
- AB, Canada
- Edmonton, AB, Canada
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). · Full-time
Applications open in a new tab.
Job details
- Pay
- 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).
- Job type
- Full-time
- Apply by
- Working hours
- 35 hours per week
- Posting language
- English
- Posted
Original job description
Competition Number: 26.10.269
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: The competition will remain open until a suitable candidate is found.
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:
You will have:
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:
When you become part of the MacEwan University team, you will enjoy a competitive salary. Our total compensation package includes:
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.
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: The competition will remain open until a suitable candidate is found.
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.
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.
- 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 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:
- Competitive base pay
- Generous vacation time
- Secure pension plan
- Flexible benefits package
- Continuous learning culture
- Opportunities for career growth
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.
More about this job
Responsibilities
Administer and optimize Oracle, SQL Server, and other database environments, ensuring their availability, security, performance, backup and recovery, and disaster-recovery readiness. Support PeopleSoft administration and lifecycle activities, and collaborate with technical teams, vendors, and stakeholders while maintaining documentation, procedures, and automation.
Requirements
Requires a bachelor’s degree in Computer Science, Information Technology, or a related field, and at least seven years of progressive IT experience, including three years of hands-on Oracle database administration. Candidates must have production database administration experience, cloud database experience, PeopleSoft support experience, and experience developing administrative automation; equivalent education and experience may be considered.
Skills
- Oracle Database Administration
- SQL Server Administration
- SQL
- PL/SQL
- AWS RDS
- PeopleSoft Administration
- Database Security
- Backup and Recovery
- Database Performance Tuning
- Database Migration
- Disaster Recovery
- Azure SQL
- Microsoft Fabric
- Azure Data Factory
- ETL Pipelines
- Administrative Automation
Benefits
- Competitive Base Pay
- Generous Vacation Time
- Secure Pension Plan
- Flexible Benefits Package
- Continuous Learning
- Career Growth Opportunities
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Education
Keywords
- Oracle
- Oracle Database
- SQL Server
- SQL
- PL/SQL
- AWS RDS
- PeopleSoft
- PeopleTools
- Azure SQL
- PostgreSQL
- Microsoft Fabric
- Azure Data Factory
- Data Warehousing
- ETL Pipelines
- Database Security
- Access Controls
- Auditing
- Backup and Recovery
- Patching
- Upgrades
- Capacity Planning
- Performance Tuning
- Disaster Recovery
- Database Migration
- Data Integrity
- Cloud Databases
- Scripting
- Oracle DBA Certification
- AWS Certification
- Higher Education