Our Ability Jobs

Job Information

City of Toronto Career Opportunities: SYSTEM DEVELOPMENT SPECIALIST(ORACLE DB / SAP BI) (24046) in Toronto, Ontario


Requisition ID 24046 - Posted - METRO HALL - Business Solutions Services - Information & Technology - L79 Full-time - Full-time

   Job Description Print Preview

  • Job ID:24046

  • Job Category:Information & Technology

  • Division & Section:Technology Services, Technology Services Delivery

  • Work Location: Metro Hall, 55 John Street

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

  • Hourly Rate:$49.44 - $54.16

  • Shift Information: Monday to Friday, 35 hours per week

  • Affiliation:L79 Full-time

  • Number of Positions Open:1

  • Posting Period: 24-Jun-2022 to 11-Jul-2022

  • Job Description

    As a member of Business Application Services team in the Technology Services Division, you will provide systems analysis and computer programming expertise and advice related to application development and sustainment.

    Major Responsibilities:

  • Performs analysis and design duties as well as programming, modelling and scripting, testing, documentation and deployment preparation.

  • Coordinates and prepares needs analysis and detailed systems design.

  • Conducts user interviews to determine detailed systems requirements.

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

  • Designs, codes, tests, implements and maintains enterprise systems.

  • Designs and develops systems that comply with access and privacy legislation.

  • Coordinates and develops program specifications and documentation.

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

  • Liaises and coordinates with internal and external consultants in detailed systems deliverables and technical problem resolution.

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

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

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

  • Conducts quality assurance on departmental and external developments.

  • Develops systems interfaces between enterprise and departmental systems.

  • Performs information and application data conversions.

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

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

  • Designs and develops application security interfaces to enable clients in controlling and administering access to their systems.

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

  • Conducts research and evaluation of hardware/software/framework and makes recommendations.

  • Recommends, presents and demonstrates system solutions to City management and corporate business clients.

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

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

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

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

  • Conducts research, investigates and recommends best practices for information and application services.

  • Contributes to post-implementation project reviews.

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

  • Contributes in planning of future system growth and provides detailed work plans.

  • Participates in enterprise projects.

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

  • Determines user training needs.

    Key Qualifications:

    Your application must describe your qualifications as they relate to:

  • Post-secondary education in Computer Science or a related discipline with extensive development / sustainment experience in large-scale IT solutions, or the approved equivalent combination of education and/or experience.

  • Considerable experience in Database development including such areas as, data architecture, data modelling, data normalization, ETL processes, performance optimization and administration with Oracle 12c or higher.

  • Considerable experience in Data analysis, using SQL and Oracle PL/SQL coding techniques to extract, and report upon, information, business trends, insights and metrics from data stored in the database.

  • Considerable experience in SAP Business Objects BI development (version 4.x) including Crystal Reports, Webi, Dashboards and Universe Designer.

  • Considerable experience in writing application architecture documentation using structured systems analysis and design techniques, systems development methodologies and templates.

  • Experience with a variety of software packages, including MS Office (e.g., Word, Excel, PowerPoint), process design software (e.g., MS Visio), software requirements management and quality assurance tools (e.g., Blue Print, HP Quality Center), data modelling (e.g., Oracle SQL Developer), project management software (e.g., MS Project) and software version control (e.g., Bitbucket, GitHub).

    You must also have:

  • Excellent communication, problem-solving, leadership, facilitation and interpersonal skills.

  • Ability to elicit, drive and/or develop application requirements to ensure that business needs and requirements have been adequately defined and documented, and/or the root cause of the problem accurately stated.

  • Strong customer service orientation along with a demonstrated ability to establish and maintain effective stakeholder relationships.

  • Ability to work effectively as a member of a team, collaboratively with others in multidisciplinary team environment and work independently, as required.

  • Advanced time management and estimation capabilities, and ability to perform several tasks and projects concurrently.

  • Ability to develop technology standards, techniques and product specifications.

  • Knowledge of current and emerging technologies and skills to evaluate and recommend new technology for introduction into a complex technical environment.

  • Ability to develop project plans, projections and cost/benefit analysis of proposed solutions.

  • Ability to develop and maintain database and application design, specifications and operational documentation.

  • Ability to develop, maintain and execute both test plans and disaster recovery plans.

  • Ability to work flexible hours including days, afternoons, nights and weekends, as required.

  • Ability to be on call for support of production systems, as required.

  • Ability to travel across various office locations within the City of Toronto, as required.

    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. Candidates will be required to show proof of vaccination during the recruitment process. 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'sInternalJob 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 (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 theapplication processis 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) .