Job Category: Information & Technology
Division & Section: Toronto Water, Customer Service & Technical support
Work Location: 60 Tiffield Road
Job Type & Duration: Permanent, Full-time Vacancies
Salary: $95,596.80 -$112,320.00, Wage Grade 7
Shift Information: Monday - Friday, 35 hours
Number of Positions Open: 2
Posting Period: 30-Nov-2021 to 14-Dec-2021
Toronto is Canada’s largest city, the fourth largest in North America, and home to a diverse population of about 3 million people. Consistently ranked one of the world’s most livable cities, we are a global centre for business, finance, arts and culture. Join the award-winning Toronto Public Service as Business Systems Analyst within Toronto Water.
Reporting to the team lead of Application Services 3 responsible for the Production environment, the Senior Database Administrator provides senior technical expertise in database products, management, administrative tools and utilities including installation, configuration, upgrade, quality assurance, back-up, recovery, integration and analysis. With extensive experience, including a strong commitment to quality customer service, the Senior Database Administrator will maintain and optimize the Toronto Water's RDBMS database environment at a state of good repair and provide ongoing IT support. As an integral member of the Integrated Technology Management team, the Senior Database Administrator will be at the ready whenever the need for troubleshooting arises, providing clear, effective technical advice and instructions to a wide range of users.
Implements detailed plans and recommends policies/procedures regarding program specific requirements.
Provides business/project plans and recommends modifications, upgrades and/or acquisitions for data centre consisting of large capacity servers, Storage Area Network and Enterprise Database Management Systems through analyzing the utilization and integration of the database infrastructure, evaluating the existing and market available hardware, software and network security products, studying feasibility, assessing business requirements and communicating with different levels of management across the Division.
Establishes database standards, policies and guidelines for on-line transaction processing databases and data warehouses to ensure high availability, accessibility, security and performance through analyzing the client requirements and business practices, evaluating and applying the functions available within current market database products.
Provides 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.
Develops methodologies and techniques for the ongoing assessment of database performance, capacity monitoring, problem notification to mobile devices, e-mail, and/or on-line reporting environment
Perform Evaluation, installation, configuration, maintenance and upgrades of hardware, software and related management tools.
Leads technical project teams to determine requirements, examine data flow, research and evaluate software, build logical and physical database architecture, develop and/or acquire, implement, maintain databases and provide technical and business support for application software and information solutions to meet client and business user requirements.
Provides senior level technical expertise and consultation in the area of database administration/system architecture to business users and other technical staff to ensure consistent database architecture through adherence to proper logical and physical database design techniques, data integrity and data security.
Liaises with other divisions’ or corporate Database Administrators, technical specialists and subject matter experts to assess and control database product, software resources and database license usage.
Provides senior management with recommendations of cost-effective system resources, database license utilization and integration and optimization of IT infrastructure. Communicates and coordinate internally and externally with vendors in case of hardware, systems software, network products, Cloud and/or other services acquisition.
Assists in the preparation of Requests for Proposals/Quotations, project charters and work plans and participates in the evaluation of technical solutions. Ensures corporate standards, system security and internal processing controls (audit controls) are maintained. Prepares documentation including program, systems, security and user documentation.
Establishes database backup and recovery standards and procedures. Provides backup and recovery services. Works with business and technical specialists and subject matter experts to design and implement server consolidation, disaster recovery, business continuation and other IT policies and procedures.
Establishes guidelines and monitoring rules, Information or Resource Management Standards, data security policies and procedures to identify and address common issues through analysis of patterns and trends in problems encountered by the users.
Makes recommendations such as implementing operating changes, training users, configuring parameters, allocating memory, resolving lock and/or disk space contention.
Converts, migrates and reorganizes data among different database systems, products and applications to facilitate data consolidation, integration or expansion, legacy systems upgrade and server virtualization.
Refreshes development and training database servers to support the development life cycle and training efforts. Participates in application training, acceptance testing and project quality reviews.
Designs, develops and maintains system/database program codes required for database administration, data reorganization, database and application auditing and application support. Works with application programmers and analysts to troubleshoot the application codes.
Configures and troubleshoots multi-tier connectivity, networks and related tools and other standard industry data access products. Trains and educates programmers, analysts and the users on setting up system connectivity.
Researches new software and database releases to find effective solutions in the context of evolving information architecture, evaluates alternatives and recommends policies, modifications in the standards/procedures, common software required, and the final product acquisition including solutions for high availability environment. Introduces and implements industry best practices for major enhancements and maintenance of information system services.
Supports the Division’s production databases and must be available for standby or on-call duties afterhours, during holidays, and for emergency events.
Provides input into the budget preparation and ensures that expenditures are controlled and maintained within the approved budget limits.
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, data integrity, security, backup and recovery.
Considerable experience with database concepts and design; system/network architecture, operations, protocols, design and development techniques; application support; system and services monitoring tools to support and implement database software and service activities
Considerable experience in Oracle/MS SQL Relational Database software environment, with a good working knowledge of high-availability architecture, including Oracle Real Application Cluster, Data Guard and Cloud Computing.
Considerable experience in one or more of the following tools and technical environment but not limited to: Bomgar, OEM, TOAD, SSMS,SQL Developer, Apex Admin Console, Beyond Trust; Oracle 11g to 21c including cluster environment, Oracle APEX 5.1 to 21, MS SQL 2012 to 2019 including two node cluster.
Considerable experience in Change Management processes
Considerable 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.
You must also have:
Excellent verbal and written communication skills, with the ability to convey detailed technical information clearly and effectively to a variety of audiences.
Knowledge of planning, evaluation, analysis, design, implementation and integration of enterprise products in a large, diverse computing environment.
Ability to troubleshoot incidents reported, assist with their resolution and clearly communicate the means to resolve incidents and/or enhance applications or systems.
Highly developed analytical skills to research problems, evaluate and identify business requirements and make recommendations to senior management.
Ability to lead the technical change process from planning and implementation perspectives.
Excellent interpersonal skills, with the ability to establish and maintain effective working relationships with all levels of staff and external contacts.
Commitment to customer service, performance quality, and continuous improvement.
Ability to work independently and cooperatively in a team environment.
Ability to work under time constraints and meet deadlines.
Willingness to work flexible hours and ability to work days, afternoons and nights, including weekends and holidays, as required.
Willingness to be on-call for support of production systems.
Valid Ontario Driver G license and access to a personal vehicle
Knowledge of trends in the use of current technology as it relates to data management systems.
Certification of Microsoft Certified Solution Associate (MCSA) SQL 2017 or newer, would be an asset
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. Candidates will be required to show proof of vaccination during the recruitment process.
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.
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.