ENTERPRISE TECHNICAL SUPPORT SPECIALIST (DATABASE ADMINISTRATOR)

City of Toronto; Toronto; On-site; CAD 100,000 - 125,000; Full time

Job summary

An established industry player is seeking an Enterprise Technical Support Specialist to enhance their database management systems. This role includes analyzing software and hardware, ensuring optimal operation, and implementing security solutions. The successful candidate will work with various RDBMS products and tools, providing critical support and recommendations for system improvements. Join a dynamic team dedicated to enhancing technology solutions within a government administration framework, where your contributions will foster equity, diversity, and inclusion in the workplace.

Qualifications

• Experience with Oracle, SQL Server, and PostgreSQL RDBMS products.
• Ability to analyze software and hardware using diagnostic tools.

Responsibilities

• Perform analysis of enterprise software and hardware using diagnostic tools.
• Ensure proactive operation and support of enterprise systems.

Skills

Oracle

SQL Server

PostgreSQL

Troubleshooting

Security Solutions

Tools

Oracle Enterprise Manager

RMAN

OID

APEX

Warehouse Builder

Job description

ENTERPRISE TECHNICAL SUPPORT SPECIALIST (DATABASE ADMINISTRATOR)

Join to apply for the ENTERPRISE TECHNICAL SUPPORT SPECIALIST (DATABASE ADMINISTRATOR) role at City of Toronto.

Get AI-powered advice on this job and more exclusive features.

Job ID: 53766
Job Category: Information & Technology
Division & Section: Technology Services, Enterprise Services & Operations
Work Location: Metro Hall, 55 John St, Toronto, ON M5V 3C6
Job Type & Duration: Full-time, Temporary, 12-month Vacancy
Hourly Rate: $48.49 - $53.14 (2024 wages)
Shift Information: Monday to Friday, 35 hours/week
Affiliation: L79 Full-time
Qualified List: Candidate List will be established. For applicability and duration, see below.
Number of Positions Open: 1
Posting Period: 23-04-2025 to 07-05-2025

Major Responsibilities

• Perform analysis of enterprise software, hardware, and transmission facilities using diagnostic tools to ensure optimal operation and maintenance of technology solutions.
• Ensure proactive action for the operation, installation, and support of enterprise systems and solutions.
• Assist in planning, assessment, design, construction, and implementation of upgrades and enhancements to existing systems and future enterprise technologies.
• Research and evaluate enterprise hardware/software solutions and make recommendations.
• Maintain security on all enterprise server hardware, software, and network, including setup, revision, and cancellation of securities.
• Monitor enterprise systems, products, and network usage, performance, and capacity; perform trend analysis for system improvements.
• Manage enterprise-wide user accounts, including addition, deletion, and changes, according to policies.
• Respond to user inquiries, investigate problems, and develop solutions or action plans.
• Review and improve documentation, manuals, standards, and procedures.

Key Qualifications

• Extensive experience with Oracle, SQL Server, and PostgreSQL RDBMS products and tools, including Oracle Enterprise Manager, RMAN, OID, APEX, and Warehouse Builder.
• Experience with high availability and disaster recovery solutions such as Oracle RAC, Data Guard, SQL clustering, replication, and always-on availability groups.
• Experience installing, configuring, and supporting Oracle and PostgreSQL in Linux environments, and SQL Server on Windows.
• Experience implementing backup, recovery, and disaster recovery solutions.
• Experience applying patches and upgrades for Oracle, SQL Server, and PostgreSQL.

You Must Also Have

• Ability to analyze enterprise software, hardware, and transmission facilities using diagnostic tools.
• Troubleshooting skills for performance issues and providing recommendations.
• Ability to implement security solutions in line with standards.
• Proactive planning skills for enterprise system operation, installation, and support.
• Knowledge of installing, configuring, maintaining, and upgrading RDBMS and related tools.
• Effective communication skills for technical support and system upgrades.
• Knowledge of enterprise hardware and software solutions.
• Ability to review and improve documentation, manuals, standards, and procedures.

Additional Notes

City of Toronto employees must apply through the City's Internal Job Posting Portal.

The City is committed to equity, diversity, and inclusion, creating an accessible and inclusive workplace in compliance with AODA. Accommodation requests during the recruitment process are available upon request.

Other Details

• Seniority level: Entry level
• Employment type: Full-time
• Job function: Information Technology
• Industries: Government Administration