Job Description

Job Number:
J0825-0131
Posting Date:
September 18, 2025
Closing Date:
September 26, 2025
Job Title:
Database Specialist
Branch/Department:
120 Martin Ross
Division:
Information & Technology Services
Employment Type:
Permanent Full Time
Status:
Full-Time
# of Open Positions:
1
Salary:
$78,041.60 - $88,142.60/Year
Pay Band:
PE017

Hours per week and Schedule of Work

(Hours and Schedule of work are subject to change in accordance with Article 19): 35 hours per week.

JOB SUMMARY:

The Database Specialist is responsible for supporting the Manager and Lead in implementing and maintaining enterprise infrastructure on premises and in the cloud. The Database Specialist provides subject matter expertise on a grouping of database technologies, for either services or corporate infrastructure, and provides support in the selection and implementation of new database technology on-premise or cloud hosted. The Database Specialist is also responsible for on-going operational support which includes problem/incident resolution, routine maintenance, and delivering on enhancement and change requests. The Database Specialist also supports technology roadmap planning and is accountable for maintaining current awareness of vendor product development cycles. In supporting the Enterprise Technology portfolio, the Database Specialist works with business stakeholders to ensure database services deliver value and meets business requirements for functionality, availability, and performance.

DUTIES:

Under the general direction of the designated Lead, and working within a team structure, this position is responsible for duties in database management & support:


Manages and monitors database services within a hybrid multi-cloud infrastructure, on-premises and cloud-based services Administers, installs, configures and maintains database management and operating systems, and critical business applications and technology tools Designs, builds and implements database systems of high availability and quality, either on-premises or cloud based, to meet the requirements of various departments, applications and users Defines users and enabling data distribution, in appropriate format and in a timely manner, integrating, investigating and reporting with operational and security monitoring tools. Ensures security through access controls, integrating, investigating and reporting with operational and security monitoring tools Acts as the subject matter expert on technologies in area of responsibility Monitoring critical production processes, technologies, and applications that have high visibility and impact on business operations Proactively identifying application risk and mitigation, capacity availability & continuity management, providing input to organizational disaster recovery and emergency planning. Provides security operations tasks, including monitoring, investigation, and reporting. Ensures database technologies are backed up successfully, and performs restore operations according to corporate policies and procedures Provides support, issue resolution, and request management, while working closely with other internal ITS teams, business, and vendors to resolve incidents and problems requiring multi-department involvement Works closely with the ITS team to collaborate on technical issues and solutions and providing knowledge transfer, training, and documentation Works closely with vendors to resolve technical issues, facilitating infrastructure upgrades as part of the technology life cycle management, while holding vendors accountable for contractual obligations and Service Level Agreements (SLAs) Maintains infrastructure architecture and support documentation and relevant training material that is available to team members and ensures that this material is being effectively employed. Proactively identifies infrastructure risk and mitigation, capacity availability & continuity management. Provides input to organizational disaster recovery and emergency planning. Conducts research, evaluations and supports report development and preparation of procurement documentation Participates in regular team, business, and committee meetings Performs other duties as assigned On-call evening, weekend and callback work, as well as occasional work from other TPL branches/locations may be required

Qualifications

Post-secondary degree or diploma in computer science or related discipline, or an equivalent combination of education, experience and certification Minimum of five (5) years of related experience in hybrid multi-cloud technology, planning, implementing and maintaining infrastructure Extensive hands-on experience and specific skill set in IT infrastructure technologies within the area of assignment and demonstrated ability in supporting installation, administration, troubleshooting, and security issues Hands-on experience to build, configure, test, and deploy enterprise and multi-cloud Windows, Solaris/Linux based infrastructure Knowledge of Database performance, monitoring tuning experience including troubleshooting complex procedures and query optimization Knowledge of architecture principles, networking, security standards, IaaS, PaaS and SaaS Excellent analytical and problem solving skills Demonstrated ability to provide leadership, show initiative and self-direction, maintain currency of knowledge, and identify and solve problems that require investigation and creativity, under sustained pressure in a results-oriented team environment Demonstrated ability to respond flexibly and productively to multiple and changing priorities in a variety of work environments, including joint project teams, work with consultants, and on individual assignments Ability to work simultaneously on multiple projects and assignments with high quality deliverables Ability to hold vendors accountable for contractual obligations and Service Level Agreements (SLAs) Excellent interpersonal skills and effective communication skills

Assignment Technologies:

The Database Specialist supports implementation and maintenance of the following or similar technologies, including provision of subject matter expertise:


Oracle, SQL Server, MySQL, PostgreSQL, Redis, CosmoDB, security incident and event management and data analytics processes and platforms

About TPL

Toronto Public Library (TPL) is North America's busiest public library system. TPL employs approximately 2,400 staff who provide high quality library services to the people of Toronto across 100 locations.


The Toronto Public Library does not ask for a credit card, banking information, or social insurance number during the recruitment process. Do not respond to emails or requests for information about jobs at TPL that are not sent from an @tpl.ca address.

ACCOMMODATION:

We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require Code-protected accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs.

APPLICATION PROCESS:

Toronto Public Library (TPL) invites applications from all qualified individuals. The Library is committed to equal opportunity, diversity in the workplace, equity and reconciliation, and welcomes applications from Indigenous people, Black and racialized groups, people with disabilities, 2SLGBTQ+ people and women.


All applicants must be legally entitled to work in Canada. Toronto Public Library (TPL) will be using email to communicate with you for all job competitions. It is your responsibility to include an updated email address that is checked daily. As we send time sensitive correspondence, we recommend that you check your email regularly. If no response is received, we will assume you are no longer interested in pursuing the opportunity. Please be advised that a Criminal Record Check may be required of the successful candidate. Should it be determined that any background information provided be misleading, inaccurate or incorrect, Toronto Public Library (TPL) reserves the right to discontinue with the consideration of your application.