Press Tab to Move to Skip to Content Link
Select how often (in days) to receive an alert:
Select how often (in days) to receive an alert:
Date Posted: 05/30/2024
Req ID: 37630
Faculty/Division: Ofc of the Chief Information Officer
Department: Enterprise Apps & Solutions Integration
Campus:St. George (Downtown Toronto)
Position Number: 00036374
Description: About us:
The Enterprise Applications and Solutions Integration (EASI) department within the Chief Information Officer's (CIO) Division is a central department responsible for all matters pertaining to the development, maintenance and effectiveness of the core administrative management and student systems at the U of T. Included within these responsibilities are all central SAP systems, such as Financial Services, Human Resources, Research Administration and Procurement; the central U of T Student System (ROSI); approximately 40 related vendor and specialized web applications.
Your opportunity:
Under the general direction of the Manager, DevOps, the incumbent is responsible for making database design, maintenance and operational decisions within EASI. The incumbent must ensure that the decisions coincide and follow the overall technical vision and strategy of EASI Technical Services. The incumbent is responsible for database management, technical support and monitoring of databases (application usage and resource utilization). The incumbent will liaise with developers, application/operational staff, IT project managers and other technical staff. The incumbent will be responsible for devising and implementing processes for resolving faults and data loss and writing disaster recovery plans.
Your responsibilities will include: Developing and updating architectural framework for highly complex and confidential university-wide databasesAnalyzing and recommending suitability of major new equipment or software systemsLeading and planning IT projects related to IBM DB2 and Azure SQL Server Managed InstancePlanning and implementing tools and procedures to monitor database system performanceChecking that security authorization meets University guidelines and project requirementsServing as a resource on specific issues to a group of specialistsEssential Qualifications: Bachelor's Degree or acceptable combination of equivalent experience.Minimum 5 years experience with enterprise-level DB2 administration, performance tuning and resource utilization (including day-to-day administration of DB2 databases, security, backup/recovery, capacity planning and performance tuning) which includes:Minimum 2 years experience withHADR option for Pacemaker-managed DB2 instances on RHEL (RedHat Enterprise Linux) or SLES (SUSE Linux Enterprise Server)Minimum 3 years experience with Linux shell scripts (bash or ksh) to perform day to day activitiesExperience with enterprise-level Azure SQL Server or Azure SQL Server Managed Instance, and T-SQL queriesExperience with installation, configuration, upgrades and troubleshooting of DB2 databasesExperience with testing and using DB2 related software to streamline tasksExperience with tuning applications, systems and SQL queries in conjunction with system adminstratorsExperience with creating efficient logical and physical designs with developers for new DB2 entities and review requested changes for production.Experience with designing/implementing system migration procedures and creating backup/recovery procedures Assets (Nonessential): Experience with backup and restoration ofAzure SQL databasesExperience with monitoring and optimizing the performance of cloud databasesExperience with automating common cloud management tasks using PowerShellExperience with data replication using Qlik Replicate To be successful in this role you will be: Goal orientedProactiveResourcefulTeam player Closing Date: 06/14/2024, 11:59PM ET
Employee Group: USW
Appointment Type: Budget - Continuing
Schedule: Full-Time
Pay Scale Group & Hiring Zone:
USW Pay Band 16 -- $99,548 with an annual step progression to a maximum of $127,305. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation/Pay Equity Maintenance Protocol.
Job Category: Information Technology (IT)
Recruiter: Khristen Sivaramalingam
Lived Experience Statement
Candidates who are members of Indigenous, Black, racialized and 2SLGBTQ+ communities, persons with disabilities, and other equity deserving groups are encouraged to apply, and their lived experience shall be taken into consideration as applicable to the posted position.
All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.
Diversity StatementThe University of Toronto embraces Diversity and is building a culture of belonging that increases our capacity to effectively address and serve the interests of our global community. We strongly encourage applications from Indigenous Peoples, Black and racialized persons, women, persons with disabilities, and people of diverse sexual and gender identities. We value applicants who have demonstrated a commitment to equity, diversity and inclusion and recognize that diverse perspectives, experiences, and expertise are essential to strengthening our academic mission.
As part of your application, you will be asked to complete a brief Diversity Survey. This survey is voluntary. Any information directly related to you is confidential and cannot be accessed by search committees or human resources staff. Results will be aggregated for institutional planning purposes. For more information, please see http://uoft.me/UP .
Accessibility StatementThe University strives to be an equitable and inclusive community, and proactively seeks to increase diversity among its community members. Our values regarding equity and diversity are linked with our unwavering commitment to excellence in the pursuit of our academic mission.
The University is committed to the principles of the Accessibility for Ontarians with Disabilities Act (AODA). As such, we strive to make our recruitment, assessment and selection processes as accessible as possible and provide accommodations as required for applicants with disabilities.
If you require any accommodations at any point during the application and hiring process, please contact ****** .
Job Segment: System Administrator, Database, Cloud, Testing, ERP, Technology
#J-18808-Ljbffr
