Systems Integrator 2 (oracle Developer)

Toronto, ON, Canada

Job Description

Job ID: 29986

  • Job Category: Information & Technology
  • Division & Section: Technology Services, Technology Services Delivery
  • Work Location: CITY HALL, 100 Queen Street West, M5H 2N1 Toronto
  • Job Type & Duration: Temporary (12 month) Vacancy
  • Hourly Rate and Wage Grade: $42.09 - $46.12, TF0205, Wage Grade 13
  • Shift Information: Monday to Friday, 35 hours per week
  • Affiliation: L79 Full-Time
  • Number of Positions Open: 1
  • Posting Period: 03-Nov-2022 to 02-Dec-2022
In this role you will provide advice and integration services related to Project & Work Package Management; Feasibility & Business Case; Business Requirements, Analysis & Design; Programming & Testing; Training & Documentation; Implementation & Rollout and, maintenance/enhancements.

Major Responsibilities:
  • Conducts feasibility studies on business opportunities & challenges.
  • Assesses, analyzes, evaluates and recommends process & policy alternatives.
  • Provides inputs on improvements to current business environment & processes.
  • Recommend improvements to current methodology, process, standards, and policies.
  • Liaises and co-ordinates with internal & external groups on accomplishment of deliverables.
  • Facilitates collection of business requirements and build consensus amongst clients on accomplishment of deliverables.
  • Prepares Business Case, Business Requirements, Gap Analysis, Logical Data Models and Design documents for proposed solutions.
  • Provides inputs to Data Management teams on transformation of clients' business requirements as represented by logical data models into physical data models.
  • Designs and implements business & data / information requirements into databases or file management systems.
  • Develops programs to translate business requirements & designs into information systems.
  • Prepares test data.
  • Conducts testing of programs and systems for unit, system, performance, usability, user acceptance, disaster recovery and implementation tests.
  • Prepares test strategy, test cases & test scripts for system, performance, usability and acceptance testing of system solutions developed.
  • Participates in walk-through of deliverables to identify potential problems.
  • Prepares implementation & rollout strategies and plans.
  • Prepares documentation for systems to facilitate transfer of knowledge.
  • Provides inputs to "Go / No Go" cut-over decisions e.g. roll-outs.
  • Travels to off-site locations.
Key Qualifications:

Your application must describe your qualifications as they relate to: * Post-secondary education in computer science or the approved equivalent combination of education and/or experience.
  • Experience in application support and administration.
  • Experience with the AMANDA application suite.
  • Considerable Experience in database administration and development for multiple environments (development, test and production databases), including writing scripts for data conversion, creating DDL scripts for database objects (tables, indexes, roles, stored procedures, functions, triggers, batch jobs, interfaces, etc.) using Oracle 19c, PL/SQL, SQL.
  • Experience in Oracle administration and development, including managing standard database security utilizing user accounts, privileges, profiles and role-based security.
  • Experience using the following or equivalent tools and methodologies is an asset
Examples include ITIL, JIRA, Service Requests, PowerBuilder

You must also have:
  • Ability to effectively communicate
  • Proven technical skills to develop and maintain high performance integrated solution to meet complex application requirements.
  • Strong analytical and problem solving skills, listening and interpersonal skills are essential.
  • Understanding of application deployment approaches, and standard dev-QA-Production cycles.
  • Understanding of security components for web-based applications.
  • Understanding of privacy, security and auditing; how these can be reviewed, monitored, and enhanced with regards to systems implementation.
  • Ability to work with competing demands and meet deadlines.
  • Ability to work effectively with a group of multidisciplinary staff in a project team setting.
  • Strong customer service orientation.
  • Knowledge of emerging technologies and understanding of secured wireless networks and remote access, authentication and authorization principles.
  • Ability to work day, afternoon and nights, including weekends as required.
  • Ability to travel 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 . 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'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 to .

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. . Learn more about the City's .

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD2079251
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    $42.09 - 46.12 per hour
  • Employment Status
    Permanent
  • Job Location
    Toronto, ON, Canada
  • Education
    Not mentioned