Application & Technical Support Specialist 1 – Oracle APEX and Database

Provide expertise and advice in the end to end delivery and support of Water Meter Program application systems and related infrastructure;

Major Responsibilities:

Under the direction of the Senior System Integrator Toronto Water, provide expertise of a technical and business nature related to Application Support in addressing opportunities/challenges

• Schedules work load and set priorities.
• Leads team in identification and resolution of issues and problems.
• Provides expertise in assessment, analysis, evaluation of alternatives and resolution of issues & problems.
• Liaises and coordinates with internal & external groups on the resolution of problems.
• Recommends preventative solutions to mitigate the recurrence of similar problems.
• Develops and recommends improvements to current environment, policies & processes.
• Acquires configures and disposes of hardware and software.
• Configures network and server-related hardware and software.
• Monitors and maintains access and security of data and infrastructure.
• Advises teams on hardware & software technologies and deployment alternatives and connectivity and backup/recovery alternatives.
• Advises security management & control teams on security-related technologies and access control alternatives.
• Performs capacity planning.
• Prepares statistics and drafts summary reports.
• Prepares, directs, and recommends for approval training material and documentation Reviews work of staff and provides training
• Provides training to clients in use of technology.
• Supports the centralized management of access control.
• Installs /rolls out application, hardware and/or software and takes inventory of such assets.
• Designs and creates databases.
• Attends committee meetings.
• Travels to off-site locations.

Key Qualifications:

Your application must describe your qualifications as they relate to:

1. Post-secondary degree/diploma in Computer Sciences, Information Technology or related discipline; or an equivalent combination of education.
2. Considerable job-specific professional experience.
3. Considerable experience in planning, designing, developing, implementing, supporting and maintaining information and/or industrial technology systems in a highly complex enterprise environment.
4. Progressive experience in providing back-end systems, infrastructure and/or client-side support; and demonstrated active participation in multiple and complex technology-related projects and in system administration activities.
5. Significant experience in the following:

1. APEX and Database: Able to support and maintain APEX and database development and infrastructure.
   1. Developing, configuring and maintaining applications using Oracle APEX version 4 or higher, and SQL languages including but not limited to the development and maintenance of tables, views, stored procedures, triggers, and functions.
   2. Configuring and maintaining Oracle REST Data Services.
   3. Configuring and maintaining Oracle 10 or higher infrastructure in a highly complex enterprise environment.
   4. Configuring and maintaining SQL Server 2008 or higher infrastructure in a highly complex enterprise environment.
   5. Experience using PL/SQL.
   6. Experience with XS FO editor for use with Oracle APEX. Preference is given to Altova Stylevision.
   7. Data modeling (LDM, PDM). Preference is given to modeling experience with ERWIN.
   8. Gathering and documenting business, technical and report requirements, technical specifications, Statement of Work, system analysis, and design.
   9. Progressive experience with information technology systems related to business intelligence, operational intelligence, and performance management.
   10. Performing detailed analysis of business processes and data to identify problems and potential solutions. Able to perform business systems analysis; understand and articulate the relationship between the technical components of the solutions and the business processes and stakeholders the system provides support for.
   11. Providing dependable estimates for work effort.
   12. Design and implement system test strategies and cases. Support the User Acceptance Testing process.
   13. Project coordination for IT projects.
   14. Experience with version control, ticketing, and QA systems. Preference is given to experience with tools such as HP ALM, CVS, SVN.

You must also have:

• Excellent interpersonal, listening, presentation, oral and written communication; and ability to communicate ideas in both technical and user-friendly language. Ability to prepare and deliver technical documentation and reports; and to deal effectively with all levels of management and staff.
• Strong conceptual, analytical and problem-solving skills (prioritize and execute tasks).
• Proven systems management skills. Technical skills to configure and troubleshoot servers; install software and provide troubleshooting and problem resolution.
• Willingness and ability to acquire or update knowledge of business applications, control systems and communication network technologies.
• Proven commitment to delivering superior customer service, performance quality and continuous improvement.
• Ability to work effectively within a dynamic team and collaborative environment.
• Ability to prioritize and execute tasks.
• Certification in ITILv3 and demonstrate good overall understanding ITIL framework, concepts, and practices.
• Ability to learn and support a variety of different technologies.
• Knowledge of document management systems. Preference is given to OpenText Content Suite.
• Demonstrated a fundamental knowledge of industry standards, protocols, system architectures and operating systems as related to the position.
• Knowledge and application of IT and software best practices.
• Ability to contribute to the development and refinement of information technology and software standards.
• Must be available for occasional after-hour (evening, weekend or overnight) work.
• Must be physically able to participate in training sessions, presentations, and meetings.
• Possession of valid Ontario Class “G” Driver’s License and access to a motor vehicle to travel within the GTA for business purposes.

Please note that all applicants are encouraged to provide a valid email address for communication purposes. Applicants may receive written correspondence regarding this job posting directly to the email address provided on their resume or to the one used to set-up their Candidate Profile if applying on TalentFlow. As an applicant, it is your responsibility to ensure that you check your email regularly.