SYSTEMS INTEGRATION SPECIALIST (Oracle PL/SQL Developer)

• Job ID: 40050

• Job Category: Information & Technology

• Division & Section: Public Health, Operation and Business Services

• Work Location: 277 Victoria Street

• Job Type & Duration: Full-time, 1 Permanent Vacancy

• Hourly Rate and Wage Grade: $53.98 - $59.17

• Shift Information: Mon-Fri 7hrs/day 35hrs/wk

• Affiliation: L79 Full-time

• Number of Positions Open: 1

• Posting Period: 8-Nov- 2024 to 25-Nov-2024

Major Responsibilities:

To provide expertise and advice in the areas of initiation, analysis, design, development, implementation and sustainment of enterprise solutions. To contribute to the development of system architecture, methodologies, standards, policies, procedures and guidelines.

• 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 systems

• Designs and develops systems that comply with access and privacy legislation. and/or provincial standards.

• 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

• Provides direction to programmers in implementing details of new/revised systems; as the senior technical authority on system projects

• Leads teams of intermediate/junior-level development staff in implementing software components and interfaces, in accordance with the Division's software standards and methodologies

• Liaises and coordinates with staff in detailed systems deliverables and technical problem resolution

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

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

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

• Conducts quality assurance on divisional and external developments

• 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

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

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

• Recommends, presents and demonstrates system solutions to Divisional and business/community 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 plans and project status reports

• 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

• Conducts feasibility studies, business cases, Request For Information proposals & quotations, technical reports by researching and participating in evaluations and recommending solutions

• Determines user training needs. Develops and prepares user training guides and manuals

• Designs security roles and ensures security design for the Applications meet the needs of the business

• Ensures the day to day system security of the production application environment

• Develops and maintains disaster recover procedures and sustain technology solutions to meet business requirements

• Participates in sustaining and improving infrastructures, methodologies, tools, techniques and standards, ensuring their conformance and adherence in daily practice among business and technical teams

• Leads and directs appropriate system staff through the application development life cycle to produce business need solutions in conformance with the current System Architecture

• Leads various stages of projects, directs project team members and resources and reports progress to Project Managers, Stakeholders and Business Units, ensuring successful delivery of solutions through proper coordination, change management, resource management, budget control, quality assurance, contingency measures and risk solutions

• Assists in preparing RFP, RFQ's and participates in evaluating, selecting, recommending technical solutions and in managing vendors and contracts

Key Qualifications:

Your application must describe your qualifications as they relate to:

1. University degree in computer science or the approved equivalent combination of education and/or experience.

2. Extensive experience coding PL/SQL, Oracle RDBMS especially 19c or higher.

3. Extensive experience in data extraction, transformation, analysis and reporting.

4. Considerable experience designing robust, scalable, secure, auditable, and functionally sound systems, including testing, integrating, and deploying systems, and in the preparation of IT related documentation.

5. Considerable experience in data modelling.

You must also have:

• Knowledge of application deployment approaches, and standard DEV-QA-PROD cycles.

• Knowledge of privacy and security regulations especially in a Public Health environment would be an asset.

• Ability to effectively communicate both orally and in writing.

• Ability to work in multi-disciplinary teams.

• Knowledge of the City’s technology Change Management process and ability to create and manage Change tickets using Service Now, is an asset.

• Experience with Oracle Application Express (APEX), is an asset.

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 toemployment equity (https://jobs.toronto.ca/jobsatcity/content/Hiring-Policies-and-Statements/?locale=en_US) .

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’sHiring Policies and Accommodation Process (https://jobs.toronto.ca/jobsatcity/content/Hiring-Policies-and-Statements/?locale=en_US) .