Oracle Database Administrator

Systematix

Oakville

Remote

CAD 110,000 - 131,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Systematix is seeking a senior Oracle DBA with PeopleSoft upgrade experience to support a PeopleTools upgrade on OCI. The contract role is remote with occasional onsite visits to Oakville, Ontario, Canada, for a 10-month period starting late November 2026.

The candidate will lead upgrades, performance tuning, backups, and DR planning, coordinating with Oracle Managed Services and the internal team. 10+ years of Oracle DB experience required.

Qualifications

  • 10+ years of Oracle DBA experience with PeopleSoft databases.
  • Hands-on Oracle Database upgrades to current versions.
  • Proficiency with RMAN, Data Guard, SQL tuning, and OEM.
  • Familiarity with PeopleSoft Application Designer and related DB structures.
  • Strong problem-solving skills and ability to work under time pressure during upgrade windows.

Responsibilities

  • Create the database upgrade plan, pre-upgrade health checks, compatibility assessments, remediation actions, and rollback procedures.
  • Execute or oversee upgrades, patches, and OCI migrations across environments; validate schemas and PeopleSoft functionality.
  • Benchmark performance and resolve regressions via SQL plans, indexes, and statistics.
  • Validate backups and recovery, Data Guard or HA, and OCI DR policies.
  • Review auditing, encryption, and access controls per client policies and IT standards.
  • Support system integration and performance testing with DB scripts and diagnostics.
  • Produce upgrade documentation and DBA operations runbook; transfer knowledge to internal DBA team.

Skills

Oracle DBA
PeopleSoft experience
PeopleTools upgrade
Problem solving under pressure
Upgrade planning

Education

Oracle Database Certification or equivalent

Tools

RMAN
Data Guard
SQL tuning
Oracle Enterprise Manager

Job description

We are Systematix and we are currently looking for a senior Oracle DBA with Peoplesoft projects experience, to support a PeopleTools upgrade for our client in Education. This is a remote contract with occasional onsite visits to Oakville.

ABOUT THE PROJECT

Our client in the higher education sector is upgrading PeopleTools from 8.60 to 8.63, applying cumulative PUM images, and migrating Oracle Database 19c to 26ai on Oracle Cloud Infrastructure (OCI), in partnership with Oracle Managed Services. The project spans HCM, FSCM, and Campus Solutions.

ABOUT THE RESPONSIBILITIES

In this role, you will support the Oracle Database 19c to 26ai upgrade on OCI for PeopleSoft HCM, FSCM, and Campus Solutions. You will work with the Technical Upgrade Lead and Oracle Managed Services to maintain database integrity, performance, security, and availability throughout the upgrade.

  • Create the database upgrade plan, pre-upgrade health checks, compatibility assessments, remediation actions, and rollback procedures.
  • Execute or oversee upgrades, required patches, and OCI migration activities across Development, Test, and Production; validate schemas, data integrity, and PeopleSoft functionality.
  • Benchmark performance and resolve regressions through SQL execution plans, indexes, table statistics, monitoring thresholds, and relevant Oracle 26ai features.
  • Validate RMAN backups and recovery, restore and failover procedures, Data Guard or equivalent high availability, and OCI disaster recovery policies.
  • Review auditing, encryption, and access controls against client security policies and IT standards.
  • Support system integration and performance testing with database scripts, diagnostics, error resolution, and performance data.
  • Produce upgrade documentation and a DBA operations runbook; transfer Oracle 26ai and OCI operational knowledge to the internal DBA team.
ABOUT THE REQUIREMENTS
  • 10+ years of Oracle DBA experience, including demonstrated support for PeopleSoft database environments.
  • Hands-on Oracle Database upgrades from 19c or earlier to current Oracle versions.
  • Proficiency with RMAN, Data Guard, SQL tuning, and Oracle Enterprise Manager or equivalent tools.
  • Familiarity with PeopleSoft Application Designer, batch processes, and integration-related database structures.
  • Strong problem-solving skills and ability to work under time pressure during upgrade windows.
PREFERRED QUALIFICATIONS
  • OCI database services experience is strongly preferred.
  • Oracle Database 21c, 23ai, or 26ai experience.
  • Oracle Database Certified Professional or equivalent certification is preferred.
ABOUT THE ROLE

This is a remote, 10-month contract opportunity, with on-site attendance as required, in Oakville, with an anticipated start date of approximately November 30, 2026; based on 7.5-hour days, the weekly schedule will be confirmed.

PAY DISCLOSURE

Expected hourly pay range for this contract: CAD $80-$95/hour.

Compensation is based on experience, skills, and engagement terms.

AI DISCLOSURE

As part of our recruitment process, Systematix may use artificial intelligence (AI) tools to assist with resume screening, candidate matching, and recruitment administration. All hiring decisions are ultimately made by our recruitment and hiring teams.

ABOUT SYSTEMATIX

Systematix is a Canadian-owned Global Consulting and Resourcing firm with more than 50 years of experience delivering technology solutions to clients across North America and the United Kingdom.

We provide the highest-caliber consulting solutions to a diverse client base across all levels of government and private industry.

Systematix is committed to creating a diverse, inclusive environment and is proud to be an equal opportunity employer. At Systematix, we value diverse perspectives, experiences, and backgrounds.

Systematix. Solutions Focused. People Driven.

Know someone who would be a great fit? We welcome referrals of qualified candidates and are always interested in connecting with talented technology professionals.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Oracle Database Administrator
Oracle Database Administrator

Systematix • Oakville

Remote
CAD 110,000 - 131,000
PeopleSoft Technical Upgrade Lead
PeopleSoft Technical Upgrade Lead

Systematix • Oakville

Hybrid
CAD 138,000 - 165,000
PeopleSoft Technical Upgrade Lead
PeopleSoft Technical Upgrade Lead

Systematix • Canada

Hybrid
CAD 138,000 - 165,000
Change Management Lead
Change Management Lead

Systematix • Oakville

Hybrid
CAD 138,000 - 158,000
Oracle DBA: OCI Upgrade & PeopleSoft Specialist (Remote)
Oracle DBA: OCI Upgrade & PeopleSoft Specialist (Remote)

Systematix • Oakville

Remote
CAD 110,000 - 131,000
Change Management Lead
Change Management Lead

Systematix • Oakville

Hybrid
CAD 138,000 - 158,000
RQ09096 - Software Developer - ETL - Senior
RQ09096 - Software Developer - ETL - Senior

Rubicon Path • Toronto

Hybrid
CAD 85,000 - 110,000
Senior Systems Administrator/Operations Support Specialist - Toronto
Senior Systems Administrator/Operations Support Specialist - Toronto

Randstad • Toronto

On-site
CAD 110,000 - 150,000
Oracle PeopleSoft HCM Senior Technical Consultants
Oracle PeopleSoft HCM Senior Technical Consultants

Ampstek • Canada

Remote
CAD 90,000 - 120,000
IT - Database Analyst V-Oracle
IT - Database Analyst V-Oracle

Skillhub Solutions Inc. • Toronto

Hybrid
CAD 85,000 - 95,000
Hybrid work