City of Toronto
Two (2) permanent, full-time positions – Toronto, ON
Toronto Water is the City of Toronto division responsible for all aspects of drinking water treatment and supply, wastewater collection and treatment, and stormwater management. The Division’s six business sections manage a large number of facilities and assets across the city, including treatment plants, pumping stations, water and sewer mains, laboratories and yards.
As a Senior Database Administrator, you will play an integral role in delivering on Toronto Water’s mandate by working collaboratively with other Database Administrators, business and technical specialists, and subject matter experts, and providing senior-level technical expertise and consultation in the area of database administration and system architecture to business users and other technical staff.
What will you accomplish?
Recognized for your commitment to customer service, performance quality, and continuous improvement, you will provide business and project plans and recommend modifications, upgrades and/or acquisitions for a data centre consisting of large capacity servers, Storage Area Network and Enterprise Database Management Systems. This will see you analyzing the utilization and integration of the database infrastructure, evaluating the existing and market-available hardware, software and network security products, studying their feasibility, assessing business requirements, and communicating with different levels of management across the Division.
The Division will rely on you to establish database standards, policies and guidelines for on-line transaction processing databases and data warehouses to ensure high availability, accessibility, security and performance. With this in mind, you will analyze the client requirements and business practices, and evaluate and apply the functions available within current market database products. You will also provide senior-level support of the software product installation, configuration, maintenance, upgrade, user account administration, troubleshooting, system/database monitoring, capacity planning and performance tuning for production, development, test and training databases in a distributed database environment.
Leading by example, you will head technical project teams to determine requirements, examine data flow, research and evaluate software, build logical and physical database architecture, develop and/or acquire, implement, and maintain databases and provide technical and business support for application software and information solutions to meet client and business user requirements. At the same time, senior management will value your recommendations regarding cost-effective system resources, database licence utilization, and the integration and optimization of the IT infrastructure, and your ability to convert, migrate and reorganize data among different database systems, products and applications to facilitate data consolidation, integration or expansion, legacy systems upgrade and server virtualization.
Among the strengths you bring to the role of Senior Database Administrator will be the following key qualifications:
- Post-secondary degree or diploma in Database System Management or Computer Sciences, or an equivalent combination of education and related experience.
- Certification – Oracle Certified Professional (OCP) – most current.
- Extensive experience in Oracle Database, Oracle Grid infrastructure, Oracle WebLogic Server, Oracle REST Data Services (ORDS), APEX and MS SQL Server cluster environment, including installation, configuration, administration, performance tuning, patching, maintenance and troubleshooting in a complex environment.
- Extensive experience providing implementation analysis and support in data management systems, and data integrity, security, backup and recovery.
- Considerable work experience with database concepts and design; system/network architecture, operations, protocols, design and development techniques; application support; and system and services monitoring tools to support and implement database software and service activities.
- Considerable work experience in Oracle Relational Database software environment, with a good working knowledge of high-availability architecture, including Oracle Real Application Cluster, Data Guard and Cloud Computing.
- Considerable work experience in one or more of the following tools and technical environments, but not limited to: Bomgar, OEM, TOAD, SSMS,SQL Developer, Apex Admin Console, Beyond Trust; Oracle 10g to 19c, including cluster environment, Oracle APEX 5.1 to 20, MS SQL 2012 to 2017, including two node cluster.
- Considerable work experience in Change Management processes.
- Considerable work experience in Quality Assurance and Test processes.
- Experience on Windows- and Unix-based computer operating systems in physical and virtual environments, and good understanding of Oracle and MS SQL RDBMS software licensing concepts.
Given this background, you possess knowledge of planning, evaluation, analysis, design, implementation and integration of enterprise products in a large, diverse computing environment, combined with knowledge of trends in the use of current technology as it relates to data management systems. You have also honed your ability to troubleshoot, and assist in resolving, incidents reported, clearly communicate the means to resolve incidents and/or enhance applications or systems, and lead the technical change process from planning and implementation perspectives.
You are an analytically minded professional with excellent communication and interpersonal skills, adept at establishing and maintaining effective working relationships with all levels of staff and external contacts, conveying detailed technical information clearly and effectively to a variety of audiences, evaluating and identifying business requirements, and making recommendations to senior management. The ability to work independently and cooperatively in a team environment, while meeting tight deadlines, will prove invaluable in this role.
Due to the nature of the position, you must be willing to work flexible hours, and be on-call for support of production systems, and be able to work days, afternoons and nights, including weekends and holidays, as needed. A valid Ontario Class G Driver’s Licence and access to a personal vehicle are also required.
Certification of Microsoft Certified Solution Associate (MCSA) SQL 2016 or newer would be an asset.
NOTE: All City of Toronto employees are required to be fully vaccinated as a condition of hire in accordance with the City’s Mandatory Vaccination Policy < https://www.toronto.ca/city-government/accountability-operations-customer-service/city-administration/corporate-policies/people-equity-policies/covid-19-mandatory-vaccination-policy/ >. Candidates will be required to show proof of vaccination during the recruitment process.
Salary Range: $95,596.80 – $112,320.00 per annum
Toronto is home to more than 2.9 million people whose diversity and experiences make this great city Canada’s leading economic engine and one of the world’s most diverse and livable cities. As the fourth largest city in North America, Toronto is a global leader in technology, finance, film, music, culture, and innovation, and consistently places at the top of international rankings due to investments championed by its government, residents and businesses. For more information, visit jobs.toronto.ca or follow us on Twitter at Twitter.com/CityTOjobs, on LinkedIn at Linkedin.com/company/city-of-toronto or on Facebook at Facebook.com/CityTOjobs.
How to Apply:
For more information on these and other opportunities with the City of Toronto, visit us online at https://jobs.toronto.ca/jobsatcity/. To apply online, submit your resume, quoting Job ID 21250, by Friday, December 09, 2022.
A Qualified List of candidates will be established for the Senior Database Administrator position in the Toronto Water Division and will be in effect for up to one year from the date the list is created. Qualified candidates on the list may be considered when filling future permanent and/or temporary vacancies in this position.
Equity, Diversity and Inclusion
The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment to employment equity < https://jobs.toronto.ca/jobsatcity/content/Hiring-Policies-and-Statements/?locale=en_US >.
The City of Toronto is committed to creating an accessible and inclusive organization. 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. Disability-related accommodation during the application process is available upon request. Learn more about the City’s Hiring Policies and Accommodation Process < https://jobs.toronto.ca/jobsatcity/content/Hiring-Policies-and-Statements/?locale=en_US >.
To apply for this job please visit jobs.toronto.ca.