Description The Information Technologies is currently seeking a Full-time Limited Term ERP Oracle DBA Specialist for approximately 24 months. This position is within ERP Systems & Services in Information Technologies and reports to the PeopleSoft Technical Application Architect. The team supports the University’s PeopleSoft environment, including student, finance, human resources, learning, portal, and related administrative services. The technical environment includes Oracle databases, PeopleTools middleware, Linux, integrations, monitoring platforms, and recovery capabilities. The work spans database, middleware, operating system, network, security, and application boundaries, where decisions can affect service availability, security, recovery readiness, and change delivery. The incumbent works with Database Administrators, Technical Application Specialists, application architects, developers, business analysts, security and infrastructure teams, service owners, and vendors. The position normally works 35 hours per week; work outside regular hours is periodically required for releases, patching, maintenance, recovery exercises, upgrades, and critical incident response. Please note that this position is a Two-year term appointment. Summary of Key Responsibilities (job functions include but are not limited to): Post-secondary degree in computer science, information systems, engineering, or a related technical discipline, plus a minimum of five years of progressively responsible related experience; equivalent education, training, and experience will be considered. Advanced practical experience administering Oracle databases, including installation, upgrades, patching, backup/recovery, refreshes, integrity, security, performance monitoring, and capacity planning. Working knowledge of PeopleSoft middleware, or a comparable enterprise application platform. Demonstrated experience working in Linux and virtualized server environments. Experience diagnosing and resolving issues that span database, middleware, operating system, integration, network, security, or application layers. Experience coordinating technical activities across operational teams, vendors, developers, analysts, infrastructure teams, security teams, and service owners. Knowledge of patching, recovery, monitoring, workplace management, vulnerability remediation, change management, and ITSM practices.



Experience developing or maintaining scripts, automation, runbooks, technical standards, service records, operational evidence, or practical metrics. Advanced analytical, organizational, communication, and problem-solving skills, including the ability to explain technical information and build agreement on practical operational responses. Ability to coach, mentor, train, and advise less experienced technical staff. Assets Experience with Oracle Database lifecycle management, RMAN, Veeam, Data Guard, multitenant architecture, TDE, Oracle Enterprise Manager, OID, or Oracle Critical Patch Updates. Experience with PeopleTools, WebLogic, Tuxedo, Java, Process Scheduler, Integration Broker, Change Assistant, OpenSearch, or Phire Architect. Experience with disaster recovery, web application firewalls, security monitoring, traffic visibility, enterprise logging, ServiceNow, or comparable ITSM tools. Experience supporting enterprise applications in a post-secondary, public-sector, or other complex organization. Qualifications / Requirements: Senior Operational Coverage and Coordination Provides advanced coverage across PeopleSoft database and middleware services, resolving incidents, performance issues, monitoring, security, migration failures, environment problems, and vendor escalations to maintain reliable ERP services. Provides additional coverage with migrating code between development, test and production systems. Coordinates assigned activities, incidents, and service requests within established priorities, including technical sequencing, readiness, validation, evidence, records, and follow‑up. Acts as a senior technical escalation point for less experienced staff, reviews technical work for completeness and consistency, and provides coaching and guidance. Coordinates technical work with application, infrastructure, and security teams, service owners, and vendors; identifies risks and practical responses, and escalates decisions that require architecture, service‑owner,



or risk authority. Patching, Vulnerability and Change Operations Plans and executes scheduled database, OEM, OID, WebLogic, Java, Linux, and related PeopleTools patching activities across development, test, standby, and production environments. Coordinates prerequisites, outages, implementation steps, regression support, rollback readiness, validation, and evidence for assigned patch and vulnerability‑remediation work. Analyzes vendor advisories and vulnerability findings in the context of the deployed ERP environment and recommends remediation, technical exceptions, or compensating controls to accountable service and security owners. Improves patch inventories, validation procedures, technical checklists, automation, and evidence collection based on operational experience and established standards. Works with Oracle and other vendors to reproduce issues, assess fixes and one‑off patches, and verify compatibility with subsequent updates. Backup/Recovery, Resiliency and Operational Readiness Executes and coordinates assigned database backups, refreshes, restores, failover, service recovery, and disaster‑recovery testing activities. Validates recovery runbooks, dependencies, acceptance criteria, and evidence through scheduled exercises; identifies deficienciesand recommends improvements. Supports the implementation and operational transition of planned database recovery, monitoring, web application firewall, traffic visibility, and security‑control changes. Coordinates remediation of issues identified through database recovery tests, incidents, monitoring, audit, or vulnerability‑management activities. Platform Transition, Upgrades and Operationalization Supports permanent technical staff in testing and implementing new or established Linux, Oracle database, PeopleTools, middleware, monitoring, and recovery designs. Evaluates new designs against current operational standards, including monitoring, recovery, and documentation, to support production stability. Assists in the execution of technical tests, migration rehearsals, rebuilds, validations, and cutover activities assigned by the PeopleSoft Technical Application Architect or permanent technical staff. Prepares adopted designs for ongoing team support by confirming procedures, monitoring, evidence, and knowledge‑

📌 Erp Oracle Dba Specialist - Information Technologies (Calgary)
🏢 University of Calgary
📍 Calgary