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.

Toronto is home to more than 2.9 million people whose diversity and experiences make this great city Canadas leading economic engine and one of the worlds 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.