Jobs.ca
Jobs.ca
Language
City of Toronto logo

System Development Specialist (Oracle SQL & PowerBuilder)

City of Torontoabout 13 hours ago
Toronto, ON
$55 - $61/hourly
Senior Level
Full-Time

About the role

  • Job ID: 62425
  • Job Category: Information & Technology
  • Division & Section: Technology Services, Enterprise Application Solutions
  • Work Location: North York Civic Centre, 5100 Yonge St, Toronto, M2N 5V7
  • Job Type & Duration: Full-time, Permanent Vacancy
  • Hourly Rate: $55.29 - $60.55
  • Shift Information: Monday to Friday, 35 hours per week
  • Affiliation: L79 Full-time
  • Number of Positions Open: 1
  • Posting Period: 02-Mar-2026 to 23-Mar-2026

As a System Development Specialist supporting Revenue Services IT, you will play a key role in maintaining and enhancing two mission-critical enterprise applications that support the billing and collection of property taxes, water, and solid waste services across the City of Toronto.

You will collaborate with a skilled technical team to deliver system enhancements, resolve complex issues, and contribute to major initiatives that directly impact essential City services.

Major Responsibilities:

Your primary responsibilities as a System Development Specialist will be varied. Specifically, you will:

  • Perform analysis, design, programming duties as well as testing, documentation, and deployment preparation.

  • Conduct user interviews to determine detailed systems requirements.

  • Complete analysis, system and functional design, workflow diagrams for quality systems development.

  • Design, code, test, implement, and maintain enterprise systems.

  • Design and develop systems that comply with access and privacy legislation.

  • Coordinate and develop program specifications and documentation.

  • Design and conduct all levels of testing i.e. unit, system, integration, regression, performance, security, usability, optimization/configuration, and coordinates user acceptance testing.

  • Liaise and coordinate with internal and external consultants in detailed systems deliverables and technical problem resolution.

  • Implement enterprise in-house developed/custom/packaged systems and systems changes.

  • Test integrated systems to ensure system compatibility and proper functional integration.

  • Provide application maintenance and enhancement including implementation of vendor systems fixes and patches.

  • Conduct quality assurance on departmental and external developments.

  • Develop systems interfaces between enterprise and departmental systems.

  • Perform information and application data conversions.

  • Provide development support to users by providing technical assistance and troubleshooting.

  • Provide documentation and instruction/training to users of the system.

  • Design and develop application security interfaces to enable clients in controlling and administering access to their systems.

  • Provide expertise, advice and technical skills for information and application service delivery.

  • Recommend, present, and demonstrate system solutions to City management and corporate business clients.

  • Conduct research and evaluation of hardware/software/framework and make recommendations.

  • Conduct presentations, system demonstrations and system walk-throughs at project review meetings.

  • Participate as a team member in the execution of project plans providing technical expertise and advice re: architecture, development tools, work effort estimates.

  • Direct the activities of staff, mentors, and recommends training.

  • Contribute to project charters, statements of work and project plans, project status reports and variance explanations, risk identification and mitigation planning.

  • Conduct research, investigate, and recommend best practices for information and application services.

  • Contribute to post-implementation project reviews.

  • Recommend improvements to current methodologies, processes, standards, policies, and guidelines.

  • Contribute to planning of future system growth and provides detailed work plans.

  • Participate in enterprise projects.

  • Conduct feasibility studies, business cases, RFI/P/Q’s, technical reports by researching and participating in evaluations and recommending solutions.

  • Determine user training needs.

Key Qualifications:

Your application for the role of System Development Specialist should describe your qualifications as they relate to:

  • Post-secondary education in computer science, information technology, or a related discipline, or an equivalent combination of education and relevant experience.

  • Considerable experience working with enterprise relational databases (Oracle), including advanced SQL development, stored procedures, performance tuning, and database design. Oracle certification would be considered an asset.

  • Considerable experience developing and maintaining applications using PowerBuilder.

  • Considerable experience in the design, development, testing, system integration, and deployment of enterprise-level applications.

You must also have:

  • Demonstrated experience providing technical leadership within project teams, including guiding technical activities, contributing to project planning and documentation, and supporting the successful delivery of technical components.

  • Excellent communication and interpersonal skills with the ability to engage business clients, understand requirements, present findings, and build and maintain effective working relationships across the organization.

  • Strong analytical and diagnostic abilities, including identifying root causes of issues, recommending effective technical solutions, and implementing long-term preventative measures.

  • Strong organizational skills with the ability to manage competing priorities, meet deadlines, work independently with minimal supervision, and contribute effectively within multidisciplinary technical project teams.

  • Ability to develop and document technology standards, methodologies, and product specifications in support of enterprise systems and solutions.

  • Ability to travel across various City locations and flexibility to work non-standard hours, overtime, and provide on-call support as required to support critical service delivery.

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.

About City of Toronto

Government Administration
10,000+

The City of Toronto is committed to fostering a positive and progressive workplace culture, and strives to build a workforce that reflects the citizens it serves. We are committed to building a high performing public service, with strong and effective leaders to enable service excellence, through high engagement and healthy and safe workplaces.

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.

Toronto Public Service consists of approximately 35,771 employees, providing programs and services to Toronto residents, businesses and visitors. Additionally, the City of Toronto has a number of agencies and corporations including the Toronto Police Service, Toronto Public Library and the Toronto Transit Commission, which make up the broader municipal organization.

There are 44 operating divisions and offices providing an extensive level of programs and services. We offer diverse career opportunities across a wide variety of professional, trade, administrative, managerial and other employment roles. The Toronto Public Service has won numerous awards for quality, innovation and efficiency in delivering citizen-focused services. We are proud to have been named one of Canada's Top 100 Employers, Canada's Best Diversity Employers, Top Family Friendly Employers and Greater Toronto's Top Employers.

Consider joining the award-winning Toronto Public Service and help us make a difference in a great City!