System Development Specialist (Oracle SQL & PowerBuilder)

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.