Senior Specialized IT Consultant

Apply Now

Company: Cynet Systems

Location: Toronto, ON M4E 3Y1

Description:

Job Description:
  • Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, work to improve structure and efficiency of an organization's I&IT systems.
  • The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT.
  • Provides subject matter expertise in their field and highly expert technical assistance.
Nice to Have:
  • Public Sector experience preferred
General Skills:
  • cts as the technical advisor/expert on all aspects of a specific deliverable.
  • Provide the quality assurance/quality control of specific deliverables.
  • nticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations.
  • Develops processes and procedures for implementing deliverables.
  • Prepares reports and presentations including options, recommendations, implementation plans, etc.
  • Works with clients to define the scope of a project and to determine requirements
  • Defines software, hardware and network requirements.
  • nalyzes I&IT requirements giving independent and objective advice on the use of I&IT.
  • Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems.
  • Familiar with change-management principles and methodology.
  • Knowledge and understanding of Information Management principles, concepts, policies and practices.
Experience and Skill Set Requirements:
  • Oracle Database Administrator/Operational Support - 50%.
  • Demonstrated expertise with Oracle Database Enterprise Edition,Linux OS, Oracle RAC, Data Guard, DB Vault, Oracle Enterprise Monitoring (OEM),capacity planning and performance monitoring.
  • Demonstrated experience installing and testing new versions of Oracle DB EE, developing, managing and testing back-up and recovery plans; ensuring that storage, archiving, back-up and recovery procedures are functioning correctly;
  • Provision for data security and recovery control (all data is retrievable in an emergency).
  • Establishing the needs of users and monitoring user access and security;
  • Monitoring performance and managing parameters to provide fast query responses to front-end users.
  • Controlling access permissions and privileges.
  • Liaising with IT specialists and unit leads and working closely with support team members and relevant stakeholders.
  • Communicating regularly with technical, applications and operational staff to ensure database integrity and security.
  • Decommissioning and installing new applications and customizing existing applications in order to make them fit for purpose.
  • ssisting with scheduled operational data store loads as well as performing database backups and restores.
Database Modelling and Design - 50%:
  • Demonstrates advanced knowledge of BI, data warehousing, data modeling techniques, tools and approaches.
  • Participates in the analysis, design, development, and unit testing of all the project's database components.
  • Designs RDBMS, DML and DDL components for Oracle database systems
  • Maps out the conceptual design for a planned database in outline; considers both back-end organization of data and front-end accessibility for end-users.
  • Refines the logical design so that it can be translated into a specific data model; further refining the physical design to meet system storage requirements.
  • Develops and maintains data models using Power Designer as per GO-ITS standards.
  • Writes technical specifications, including data standards, procedures and definitions for the data dictionary (metadata).
  • Participating in the design of the overall solution to ensure business needs are met;
  • Leads and conducts data modelling (conceptual, logical and physical) and data flow modeling sessions with project team members.
  • rchitecture/technology standards and best practices.
  • Conflict of interest and confidentiality guidelines.
  • Security procedures and practices.

Similar Jobs