Opens LinkedIn
- Employment type
- Full-time
- Experience level
- Senior
- Minimum education
- Bachelor’s degree
- Posting language
- English
Job summary
Lead end-to-end performance analysis and tuning across PeopleSoft applications, Oracle databases, middleware, and supporting infrastructure, including identifying bottlenecks and optimizing code and system configurations. Design high-availability solutions, develop monitoring and alerting tools, support upgrades and load testing, and provide reliable production support, including participation in an on-call rotation if required.
Job details
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. Transition Company: Health Shared Services Classification: IT Application Srvcs Level 4 Union: Exempt Unit and Program: Provincial Workforce Systems, IT Corp Services Primary Location: CN Tower Location Details: Eligible to work hybrid (on/off site) within Alberta Employee Class: Regular Full Time FTE: 1.00 Posting End Date: 25-NOV-2026 Date Available: 14-DEC-2026 Hours per Shift: 7.75 Length of Shift in weeks: 2 Shifts per cycle: 10 Shift Pattern: Days, Evenings, Nights, Weekends Days Off: Saturday/Sunday Minimum Salary: $38.73 Maximum Salary: $66.42 Vehicle Requirement: Not Applicable Required Qualifications: Bachelor’s or master’s degree in computer science, Information Technology, Software Engineering, or a related field; an equivalent combination of education & extensive experience will be considered. Minimum 10 years’ progressive experience as a Senior PeopleSoft Developer, PeopleSoft Technical Architect, and Oracle Performance Tuning Specialist, supporting large-scale PeopleSoft HCM & Payroll environments. Extensive knowledge of Oracle PeopleSoft architecture and application framework, with deep expertise in PeopleSoft HCM 9.2 & PeopleTools 8.60/8.61. Proven experience implementing performance optimization across applications, middleware, and database layers to improve scalability, stability, and throughput. Demonstrated ability to perform end-to-end performance assessments, identify bottlenecks, implement tuning solutions across Oracle Databases, PeopleSoft applications, integrations, and supporting infrastructure within mission-critical enterprise environments. Experience supporting complex, highly available PeopleSoft ecosystems, including performance monitoring, capacity planning, disaster recovery, batch processing optimization, and production support. Additional Required Qualifications: Strong understanding of 4-tier PeopleSoft architecture including Integration Broker, middleware, and database tiers, with extensive experience supporting, troubleshooting, and optimizing large-scale PeopleSoft HCM and Payroll environments. Proven ability to analyze end-to-end transactions, identify performance bottlenecks, and improve system responsiveness, scalability, and availability. Expert-level knowledge of Oracle SQL, PL/SQL, Oracle Database/SQL performance tuning, stored procedures, database objects, and application workloads through execution plan analysis, indexing, partitioning, optimizer statistics management, and resource utilization improvements. Proven ability to tune Application Engine, SQR, COBOL, and high-volume payroll workloads supporting organizations with over 120,000 employees. Advanced expertise in Oracle Database diagnostics using AWR, ASH, Statspack, Oracle Enterprise Manager, Diagnostic Pack, and Tuning Pack across Oracle 19c and 23ai environments. Strong knowledge of wait-event analysis, memory management, lock contention, concurrency issues, I/O optimization, and root-cause analysis. Experience conducting load testing with LoadRunner or similar tools to establish baselines, identify capacity constraints, validate scalability, and measure performance improvements. Preferred Qualifications: Advanced proficiency with Linux/AIX operating systems, including development & maintenance of Unix Shell/Bash scripts for automation, monitoring, workload management & performance diagnostics. Excellent communication, documentation, and presentation skills. Experience in Change Management systems such as ServiceNow. Proficient in SDLC and ITIL methodologies.
What you’ll do
Lead end-to-end performance analysis and tuning across PeopleSoft applications, Oracle databases, middleware, and supporting infrastructure, including identifying bottlenecks and optimizing code and system configurations. Design high-availability solutions, develop monitoring and alerting tools, support upgrades and load testing, and provide reliable production support, including participation in an on-call rotation if required.
Requirements
Requires a bachelor’s or master’s degree in a relevant field, or equivalent education and extensive experience, plus at least 10 years of progressive experience supporting large-scale PeopleSoft HCM and Payroll environments. Candidates need expert Oracle SQL and PL/SQL tuning and diagnostics skills, deep PeopleSoft architecture knowledge, experience with high-volume workloads and load testing, and strong communication and troubleshooting abilities.
Listed skills
- SQL · Preferred
- Performance Monitoring · Preferred
- Root Cause Analysis · Preferred
- COBOL · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Oracle Performance Tuning
- PeopleSoft HCM
- Oracle Database Administration
- SQL
- PL/SQL
- Performance Monitoring
- Root-Cause Analysis
- Application Architecture
- Load Testing
- Linux and AIX
- Unix Shell Scripting
- Application Engine
- SQR
- COBOL
- Capacity Planning
- Production Support
Job areas
- Technology
- Software
- Data & Analytics
- Healthcare
More jobs from Alberta Health Services
Environmental services
- On-site
- Peace River, AB
- Posted Nov 19, 2026
Administrative support ii - e-records assistant
- On-site
- Edmonton, AB
- Posted Nov 19, 2026
Team lead- ci naryc
- On-site
- Edmonton, AB
- Posted Nov 19, 2026
Rural acute care manager
- On-site
- Drumheller, AB
- Posted Nov 19, 2026
