Oracle Database Administrator
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+5 more
Job description
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., 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., This is a remote contract opportunity, with on-site attendance at Sheridan College as required., 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.
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.
- Higher education sector experience.
Benefits & conditions
The contract duration is 10 months, with an anticipated start date of November 30, 2026, to be confirmed upon award with flexibility. Work is 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., Mme Autre
- PrΓ©nom
- Nom de famille
- Adresse e-mail
- TΓ©lΓ©verser mon CV (.doc, .docx, .rtf, ou .pdf)
- RΓ΄le recherchΓ© Permanent Contractuel Salaire souhaitΓ© Remarques Jβai pris connaissance de la politique de confidentialitΓ© et je consens Γ ce que les renseignements personnels relatifs Γ ma candidature soient transmis Γ Systematix.
About the company
Know someone who would be a great fit? We welcome referrals of qualified candidates and are always interested in connecting with talented technology professionals.
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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦