PeopleSoft Database Administrator

Seneca College of Applied Arts and Technology - Markham, ON (il y a 30+ jours)

Postuler dès maintenant

Posting Date:
February 20, 2020

Closing Date:
March 5, 2020

Employee Group:
Support

Type:
Permanent

Pay Range:
Payband K - $39.82 - $46.18 (start rate: $39.82)

Hours:
37.5

Position Summary:
The PeopleSoft Database Administrator (PSDBA) is 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 company’s established computing environment through your work. You will identify related Peoplesoft system requirements and install the relevant upgrades as needed. You 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.

Responsibilities:
Operations

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.

Assignments include, but are not limited to:
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

Performance tuning; troubleshooting system hardware, software, networks and operating and system management systems

Issues management

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.

Services and Support

Monitoring and reporting services are defined and applied producing analytics accessible through Key Performance Indicators, dashboards and reports.

Administrative production and development database systems.

Academic 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

Strategy and Planning

Maintains application and database performance by performing system monitoring and analysis, and performance tuning; troubleshooting system hardware, software, networks and operating and system management systems; designing and running system load/stress testing; patching, escalating application problems to vendor.

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.

Produce overall summary reports.

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

Accomplishes organizational goals by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.

Capacity Planning

DR support

Installation, configuration and upgrading of relational database server software, application server software and related products.

Evaluation of software update notices. In relation to production applications, planning scheduled updates, including impact analysis, recovery planning and testing.

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 governance

Policies and procedures development and enforcement.

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.

Other Related Duties as assigned.

Qualifications:
Education

Minimum completed three (3) year diploma / degree preferably Computer Science or IT related. If education is in a related field of study, state how it is relevant.

Oracle Database Administration Certification is required.

ERP Training is considered an asset.

Experience

Minimum of eight (8) years’ experience in PeopleSoft application and Oracle database development and administration in multiple database environments

Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, performance tuning, query optimization etc.

Skills

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

Note: A skills assessment test will be administered during the recruitment process.

Seneca is committed to diversity and encourages applications from qualified candidates, especially indigenous persons, members of sexual minority groups, visible minorities, women, and persons with disabilities. View Seneca's Diversity Policy.
Note: Seneca requires copies of educational credentials at the time of an interview. Confirmation of educational credentials in the form of an official Canadian transcript or an official evaluation of international credentials which determines Canadian equivalency will be required upon hire.
We thank all applicants for their interest in this position, however, only those selected for an interview will be contacted.