Senior Performance Tuning Specialist

Alberta Health Services

Edmonton

On-site

CAD 120,000 - 180,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Alberta Health Services in Edmonton is seeking a Senior Oracle Performance Tuning Expert to troubleshoot large PeopleSoft HCM deployments and optimize Oracle databases across Linux, Windows, and UNIX environments.

The role requires deep hands-on experience with PL/SQL, PeopleTools, and end-to-end performance management, plus the ability to guide architecture decisions, design monitoring, and lead on-call escalation in a fast-paced health services portfolio.

Qualifications

  • Provide guidance in designing the application architecture for high availability and maximum reliability.
  • Create monitoring/alerting scripts to alert support for issues in all layers of the application.
  • Develop/Enhance PL/SQL packages for proactive alerts related to LOCK conflicts.
  • Perform end-to-end performance management and root cause analysis in a PeopleSoft environment.
  • Lead load testing during upgrades of PeopleTools/Oracle RDBMS/PUMs.
  • Collaborate with developers and PeopleSoft Administrators to optimize programs and configurations.

Responsibilities

  • Provide guidance in designing the application architecture for high availability and maximum reliability.
  • Create monitoring/alerting scripts to notify the support team of issues across web, app, and scheduler layers.
  • Lead on-call rotation and escalate issues to Oracle support or third parties when needed.
  • Analyze performance end-to-end and identify suboptimal code or misconfigurations in PeopleSoft environments.
  • Assist with load testing during upgrade cycles and sign-off activities.

Skills

Oracle performance tuning
PeopleSoft HCM
PL/SQL
PeopleSoft administration
Database performance analysis
Scripting
On-call support
Linux/Unix administration

Tools

Oracle RDBMS
PeopleTools
Load testing
Performance monitoring

Job description

Your Opportunity:
Reporting to Director IT - Provincial Workforce Systems, a Senior Oracle Performance Tuning Expert will provide many years of in-depth industry experience in: Troubleshooting chronic performance problems in large applications including PeopleSoft HCM based on Oracle databases and providing optimal tuning solutions at Oracle database level and/or in PeopleSoft code. Web based applications running on Linux, Windows, AIX, UNIX platforms as Senior PeopleSoft Administrator. The incumbent must interpret the strategic direction of the organization and external industry trends to provide technological direction and recommend best practices within ‘Provincial workforce Systems’ Portfolio and to the business clients with the goal of improving business processes and the quality of services offered. By applying fundamental theories, principles and concepts in the development, testing, implementation and support of complex technical solutions, this position ensures the business client’s needs are met. In collaboration with the business client & Technology Services, this position develops a thorough understanding of the client’s business processes, system use, and performance expectations and applies this broad-based knowledge to anticipate customer needs and identify innovative/effective solutions for the client. The position engages various groups in Technology services as needed for H/W upgrades/migrations/configurations in supporting Tier-1 applications such as e-People (PeopleSoft HCM). The incumbent will utilize strong written, oracle and interpersonal skills in a challenging customer driven, profession environment. The incumbent will work independently and/or collaboratively within the team with minimum guidance, other operational teams and vendor to ensure reliable operations of the applications with Primary support responsibilities.
Description:
Senior Performance Tunning Specialist will be Responsible for: Provide guidance in designing the application architecture for high availability and maximum reliability. Creating monitoring/alerting scripts/programs to alert support team for any problem in any layer of the application such as web domains, Application domains, Process scheduler domains etc. Escalating issues/problems to Oracle support and third parties as appropriate. Develop/Enhance custom PL/SQL packages, procedures used for proactive alerts related to LOCK conflict within the application that may cause application meltdown. Develop/Enhance custom PL/SQL packages, procedures for proactive application performance monitoring/alerting due to suboptimal application performance caused due to poor. End-to-end performance management, in-depth application/database performance analysis, doing complex problem root cause analysis, finding the problematic/suboptimal code or system configuration in complex PeopleSoft environment, advising/helping the developers and PeopleSoft Administrators in the team for/in optimizing Programs & system configuration. Load testing (directly or provide assistance) of the upgraded application during PeopleTools/Oracle RDBMS, PUMs upgrade as part of sign-off for final upgrade. Fully Capable of leading self with minimum direction from the Manager or Portfolio director. Ability to set & meet personal deadlines and adapt to changes in priority. Participate in 7-24 on-call rotation if required.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Peoplesoft Consultant
Senior Peoplesoft Consultant

Apptoza Inc. • Toronto

On-site
CAD 82,656 - 110,208
RQ09096 - Software Developer - ETL - Senior
RQ09096 - Software Developer - ETL - Senior

Rubicon Path • Toronto

Hybrid
CAD 85,000 - 110,000
PeopleSoft Admin
PeopleSoft Admin

Galent • Toronto

Hybrid
CAD 100,000 - 130,000
Oracle PeopleSoft HCM Senior Technical Consultants
Oracle PeopleSoft HCM Senior Technical Consultants

Ampstek • Canada

Remote
CAD 90,000 - 120,000
Oracle performance tuning expert - Brampton, ON
Oracle performance tuning expert - Brampton, ON

Info-Ways • Brampton

On-site
CAD 96,432 - 123,984
Oracle Database Administrator
Oracle Database Administrator

Systematix • Oakville

Remote
CAD 110,000 - 131,000
Peoplesoft Administrator
Peoplesoft Administrator

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 90,000 - 120,000
PeopleSoft techno functional Developer
PeopleSoft techno functional Developer

ThoughtStorm • Edmonton

On-site
CAD 80,000 - 100,000
Systems Analyst - Senior - PeopleSoft
Systems Analyst - Senior - PeopleSoft

isgSearch • Toronto

On-site
CAD 90,000 - 140,000
Peoplesoft Technical Consultant
Peoplesoft Technical Consultant

Galent • Toronto

On-site
CAD 100,000 - 130,000