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.