Job Information
City of Toronto SYSTEM DEVELOPMENT SPECIALIST (OpenEdge/SQL Developer) in Toronto, Ontario
SYSTEM DEVELOPMENT SPECIALIST (OpenEdge/SQL Developer)
Job ID: 49783
Job Category: Information & Technology
Division & Section: Technology Services, Technology Standardization Delivery
Work Location: 100 Queen St W, Toronto, ON M5H 2N2
Job Type & Duration: Full-time, Temporary Vacancy (12 months)
Hourly Rate and Wage Grade: $51.19 - $56.07
Shift Information: Monday to Friday, 35 hours per week
Affiliation: L79 Full-time
Number of Positions Open: 1
Posting Period: 30-Aug-2024 to 20-Sept-2024
As a System Development Specialist (OpenEdge/SQL Developer) and a key member of a small team, you will be working primarily, but not exclusively, on supporting and enhancing internal City of Toronto on-premise applications related to business and animal licensing for the Municipal Licensing & Standards (ML&S) Division.
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 the 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 for the role of System Development Specialist should describe yourqualifications as they relate to:
Post-secondary education in computer science or a related discipline, or the approved equivalent combination of education and/or experience.
Extensive experience in technical support, troubleshooting, maintaining, and enhancing large enterprise-scale relational database management systems in an OpenEdge (ChUI/CUI) or Microsoft SQL Server environment.
Extensive experience with the design, development, implementation, and sustainment of medium to large scale systems specifically regarding programming, code management, systems development life cycle approach, testing (unit, acceptance, stress, performance), disaster recovery, and integration with diverse applications and platforms.
Considerable experience in system documentation preparation including user requirements, user guides, IT operational manuals, technical specifications, test cases, test scripts, and release notes.
Experience in working with one or more of the following (in order of preference): OpenEdge, SQL Server, Unix/Linux scripting, Chameleon software products, Java, Jira, PDFBlock/PDFLib/VPSX, Mediawiki, and HTML5.
You Must Also Have:
Ability to master new database programming languages using online documentation and existing code base.
Experience in the public sector and/or the licensing and permitting industry is an asset.
Excellent communication skills to work with business clients and determine their requirements, analyze information processes, and recommend solutions.
Ability to be self-motivated and work with minimal supervision.
Strong analytical, problem solving, listening, and interacting skills.
Ability to work with competing demands, prioritize and meet deadlines.
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) .
