Peoplesoft Administrator

Markham (ON) Remote Only
Opportunity Number: 2072486
LanguageSecurity Clearance
English verbal and writtenCriminal Check vulnerable sector
Start PeriodDate Posted
Two weeks +Wednesday, September 14, 2022
Job Description

We are looking for a Peoplesoft Administrator to join our client full time. This is an exciting opportunity to work in the education industry. The PeopleSoft Administrator will be designated as the custodian of the data assets within their assigned scope representing the interests of the data owners (client). The primary role you will maintain our client's established computing environment through your work. You will identify related Peoplesoft system requirements and install the relevant upgrades as needed. The PeopleSoft Administrator will also monitor the system’s performance to ensure smooth operations and upgrade implementation. Applying proactive changes to prevent issues and taking corrective action to address anomalies, incidents, and business change requests.

Key Details
- Open to hybrid or remote
- Hours: 37.5 hours per week, Monday to Friday, 8:30 AM to 4:30 PM
- Benefits Package Includes: Pregnancy & Parental Leave (Top-up, up to 93% of salary for up to 52 weeks); Employee & Family Assistance Program; Tuition Reimbursement for Children; Childcare; Pension Plan (includes lifetime pension, matched contributors and survivor benefits); Professional Development Leave; 22 Vacation Days; Comprehensive Health Benefits & Insurance (life insurance, critical illness insurance, disability, dental coverage, and more)

Roles and Responsibilities

  • Responsible for the design and implementation of our PeopleSoft/ERP ecosystem which includes application and database tiers. As well as maintaining structures, policies and procedures. Manages database resources and services, ensures data quality for the integrity and availability to application
  • Plan, define, install and configure PeopleSoft/ERP ecosystem applications
  • Application support to ensures that services are running within acceptable limits
  • Monitor, analyze, tune and otherwise maintain Peoplesoft system performance
  • Performance monitoring, tuning, and query optimization
  • Troubleshooting system hardware, software, networks, issues, and operating and system management systems
  • RMAN Backups, Data Guard, Cloning
  • Implementation – tables, queries, stored procedures, triggers, relationship DB setup
  • Troubleshooting and resolving database integrity issues; such as, but not limited to, logs, duplications, data corruption, connectivity, blocking, deadlocking
  • Validation of all installation requests or submissions for application deployment to ensure completeness of the installation package and that it complies with configuration management standards definition.
  • Takes charge of the installation and coordinates activities with the requestors. Reviews installation plans prior to execution and reviews the installation results and post install verification tests with the requestor to ensure that the installation was successful
  • Coordinates system integrations of data from other systems including the use of remote data or the automated population of external data and content into applications under the scope of the incumbent. Coordinates the export, import, and copying of content as requested by clients. Ensures data content complies with data governance rules and has been reviewed by the database administrator if required
  • Problem and resolution management: Involved with issues surrounding the production services area. Active participant in the analysis of problems, impact analysis and resolving actions
  • Monitoring and reporting services are defined and applied producing analytics accessible through Key Performance Indicators, dashboards and reports
  • Administrative production and development database systems
  • Participation in project planning and support
  • Provide leadership and support for departmental initiatives outside of ITS on the best practices for implementing and maintaining database and application infrastructure for new systems
  • Provide thorough technical expertise, thoughtful leadership, and effective persuasion to peers and junior staff
  • Participating in assigned projects, evaluates the required assigned tasks and submits the estimate to complete the effort
  • Provides staff with one-on-one or group basis support and/or training in the application. The administrator demonstrates advanced techniques within the database and application to solve issues that clients or ITS resources may not be able to address through a general understanding of the application. Provides training services according to needs
  • Actively involved in the collaboration with other workgroups involving other institutions using similar applications, sharing information and discerning best practices. Monitors developments in similarly used applications in a higher education context
  • Plans for the effective use of applications. Matches user needs with product functionality. Recommends and implements policies and procedures to integrate the application within the college technical and administrative infrastructure
  • Performance management and support of production application systems. Reviews and evaluates the monitor reports supplied by the data center to ensure that production database and applications performance continues to operate within the acceptable limits. Analyses application performance determines appropriate action and recommendations
  • Coordinate communications and reviews with the appropriate resources
  • Coordinate and track corrective actions if needed
  • Evaluation of software update notices in relation to production applications, planning scheduled updates, including impact analysis, recovery planning and testing
  • Capacity Planning, DR support
  • Installation, configuration and upgrading of relational database server software, application server software and related products
  • Works with technical and academic staff to integrate new academic or service technology tools into existing computing infrastructure and to recommend infrastructure enhancements where appropriate
  • Supports the Architecture & Data Centre teams with strategic planning and designs involved with software and hardware configurations
  • Data quality (DB admin); developing metrics, measures and actively tracking quality.
  • Security: ensure data assets are secured. Continuously evaluating potential risks and applying preventative measures

Qualifications and Experience
  • Oracle Database Administration Certification is considered an asset.
  • ERP Training is considered an asset.
  • Experience in ERP application (PeopleSoft) administration and Oracle database development and administration in multiple database environments.
  • Ability to detect and troubleshoot database server related CPU, memory, I/O, disk space and other resource contention.
  • Strong knowledge of backups, restores, recovery models, database shrink operations, Clustering, Database mirroring, Replication, disaster recovery planning, index management.
  • Ability to adapt third-party tools into existing environment.
  • Strong knowledge of application systems administration and software support methods that would be adaptable to the changing environment.
  • Knowledge and experience of the software development lifecycle and the project management lifecycle with excellent organizational and time management skills.
  • Experience integrating multiple applications through workflow and other technologies
  • Must possess strong communication and interpersonal skills to deal with management, development teams, vendors and system administrators.
  • Excellent written, verbal and interpersonal skills, with an effective approach in client communications.
  • Excellent organizational and time management skills

We’re an equal opportunities employer committed to increasing diversity and inclusion in today’s workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. Minorities, women, LGBTQ candidates, and individuals with disabilities are encouraged to apply. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions.
Merci de l’intérêt que vous manifestez pour ce poste. La description du poste nous a été fournie en anglais par notre client. Si vous souhaitez passer l’entrevue avec nous en français ou fournir votre CV en français, nous vous confierons à une personne de notre équipe qui parle français.

Opportunity Number: 2072486

Similar Jobs

Network Engineer (Hybrid - Ottawa)



 Two weeks +

RPA Architect




PeopleSoft Developer

 24 Month Contract


 Two weeks +