ERP Oracle DBA Specialist - Information Technologies

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, environment 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 deficiencies and 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-transfer needs.
  
  

Documentation, Automation, Metrics and Knowledge Transfer

• Performs current operational tasks by strictly following existing documented procedures and logging methods.
• Develops and maintains scripts, automation, runbooks, technical standards, inventories, checklists, and operational evidence that improve consistency and reduce manual effort.
• Establishes and maintains practical metrics and controls for patch management, vulnerability remediation, recovery testing, monitoring, operational capacity and process reliability.
• Mentors technical staff in the use and maintenance of revised procedures and verifies that knowledge is transferred to accountable operational owners.
  
  

Application Deadline: November 03, 2026

We would like to thank all applicants in advance for submitting their resumes. Please note, only those candidates chosen to continue on through the selection process will be contacted.

This position is part of the AUPE bargaining unit, and falls under the Technical Job Family, Phase 3.

For a listing of all management and staff opportunities at the University of Calgary, view our Management and Staff Careers website.

About The University Of Calgary

UCalgary is Canada's entrepreneurial university, located in Canada's most enterprising city. It is a top research university and one of the highest-ranked universities of its age. Founded in 1966, its 36,000 students experience an innovative learning environment, made rich by research, hands-on experiences and entrepreneurial thinking. It is Canada's leader in the creation of start-ups. Start something today at the University of Calgary. For more information, visit ucalgary.ca.

The University of Calgary has launched an institution-wide Indigenous Strategy ii' taa'poh'to'p committing to creating a rich, vibrant, and culturally competent campus that welcomes and supports Indigenous Peoples, encourages Indigenous community partnerships, is inclusive of Indigenous perspectives in all that we do.

The university's commitment to the Indigenous Strategy is evident through the oversight of 18 Elders serving on the Circle of Advisors and the many unit-based circles working towards implementation of the strategy including the Faculty Advisory Circle and teams such as the Office of Indigenous Engagement, the Writing Symbols Lodge, and the Indigenous Research Support Team. Many Indigenous-based events and processes are impacting curriculum, programming and polices at the University of Calgary.

As an equitable and inclusive employer, the University of Calgary recognizes that a diverse staff/faculty benefits and enriches the work, learning and research experiences of the entire campus and greater community. We are committed to removing barriers that have been historically encountered by some people in our society. We strive to recruit individuals who will further enhance our diversity and will support their academic and professional success while they are here. In particular, we encourage members of the designated groups (women, Indigenous peoples, persons with disabilities, members of visible/racialized minorities, and diverse sexual orientation and gender identities) to apply. To ensure a fair and equitable assessment, we offer accommodation at any stage during the recruitment process to applicants with disabilities. Questions regarding [diversity] EDI at UCalgary can be sent to the Office of Institutional Commitments ([email protected]) and requests for accommodations can be sent to People & Culture ([email protected]).

Do you have most but not all the qualifications? Research show that women, racialized and visible minorities, and persons with disabilities are less likely to apply for jobs unless they meet every single qualification. At UCalgary we are committed to achieving equitable, diverse, inclusive and accessible employment practices and workplaces and encourage you to apply if you believe you are right for this role.

We encourage all qualified applicants to apply, however preference will be given to Canadian citizens and permanent residents of Canada.