Epicareer Might not Working Properly
Learn More

Senior Specialized IT Consultant

Salary undisclosed

Checking job availability...

Original
Simplified
We are looking for Senior Specialized IT Consultant for our client in Toronto, ON
Job Title: Senior Specialized IT Consultant
Job Location: Toronto, ON
Job Type: Contract
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:
  • Acts as the technical advisor/expert on all aspects of a specific deliverable.
  • Provide the quality assurance/quality control of specific deliverables.
  • Anticipates 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.
  • Analyzes 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.
  • Assisting 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.
  • Architecture/technology standards and best practices.
  • Conflict of interest and confidentiality guidelines.
  • Security procedures and practices.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job
We are looking for Senior Specialized IT Consultant for our client in Toronto, ON
Job Title: Senior Specialized IT Consultant
Job Location: Toronto, ON
Job Type: Contract
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:
  • Acts as the technical advisor/expert on all aspects of a specific deliverable.
  • Provide the quality assurance/quality control of specific deliverables.
  • Anticipates 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.
  • Analyzes 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.
  • Assisting 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.
  • Architecture/technology standards and best practices.
  • Conflict of interest and confidentiality guidelines.
  • Security procedures and practices.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job