ENTERPRISE TECHNICAL SUPPORT SPECIALIST (DATABASE ADMINISTRATOR)

Job ID: 41022

Job Category: Information & Technology

Division & Section: Technology Services, Technology Services Delivery

Work Location: 703 Don Mills 3rd Floor

Job Type & Duration: Full-time, Temporary Vacancy (12 months)

Hourly Rate and Wage Grade:  $48.49 - $53.14

Shift Information: Monday to Friday, 35 hours per week 

Affiliation: L79 Full-time

Number of Positions Open: 1

Posting Period: 04-JUL-2024 to 18-JUL-2024 

Major Responsibilities:

• Performs analysis of enterprise software, hardware and transmission facility using diagnostic tools to ensure the optimum operation and maintenance of technology solutions.
• Ensures pro-active action is taken for the operation, installation and support of the enterprise systems and solutions.
• Provides assistance and technical support in the planning, assessment, design, construction and implementation of upgrades to the existing systems and enhancements/additions of future enterprise technologies.
• Conducts research and evaluations of enterprise hardware/software solutions and makes recommendations.
• Maintains security on all enterprise server hardware, software and network, including set up, revision and cancellation of securities.
• Monitors enterprise systems, products and network usage, performance and capacity. Performs trend analysis for system improvements.
• Performs enterprise-wide user accounts administration including addition, deletion and change of user accounts according to approved policy, standards and procedures.
• Responds to user inquiries, investigates and analyzes problems and develops solutions and/or action plans.
• Conducts, updates and improves reviews of documentation, manuals, standards and procedures.

     Key Qualifications:

1. Extensive experience working with Oracle, SQL Server and PostgreSQL RDBMS products & its tools, including Oracle Enterprise Manager, Oracle RMAN, OID, Oracle APEX & Warehouse Builder, Enterprise Manager.
2. Considerable experience with database high availability and disaster recovery solutions, including Oracle Real Application Cluster, Data Guard, SQL clustering, replication and always-on availability groups.
3. Experience in installing, configuring and supporting Oracle and PostgreSQL in Linux along with SQL Server on Windows.
4. Experience in implementing backup and recovery solutions as per applications requirements along with disaster recovery solutions.
5. Experience in implementing security standards and applying patches and upgrades for Oracle, SQL Server and PostgreSQL.

     You Must Also Have:

• Ability to perform enterprise software, hardware and transmission facility analysis using diagnostic tools to ensure the optimum operation and maintenance of technology solutions.
• Ability to troubleshoot and investigate performance related issues and provide recommendations to achieve optimal execution.
• Ability to suggest and implement security solutions and strategies in line with set standards and guidelines.
• Ability to proactively think and plan for the operation, installation and support of the enterprise systems and solutions.
• Knowledge of installing, configuring, administrating, maintaining and upgrading Relational Database Management System (RDBMS) and companion products & tools.
• Effective coordination and communication in providing assistance and technical support in the planning, assessment, design, construction and implementation of upgrades to the existing systems and enhancements or additions of future enterprise technologies.
• Excellent verbal and written communication skills, with the ability to communicate detailed technical information clearly and effectively to a variety of audiences.
• Knowledge of enterprise hardware and software solutions.
• Ability to conduct, update and improve reviews of documentation, manuals, standards and procedures.

NOTE TO INTERNAL FULL-TIME AND PART-TIME CITY OF TORONTO EMPLOYEES:

City of Toronto employees must apply to full-time or part-time employment opportunities posted on the City's Internal Job Posting Portal.

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.

Accommodation

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.