Specialized IT Consultant

Assignment : RQ07581 Specialized IT Consultant Senior Job Title : Specialized IT Consultant Requisition (SS) : RQ07581 Start Date : 2024-07-09 End Date : 2025-03-31 Client : Children, Youth & Social Services Cluster Office Location : 5700 Yonge St.

Toronto Organization : Children, Youth & Social Services Cluster Extension # of Days : 41.00 Ministry : Ministry of Children, Community and Social Services # Business Days : 187.00

Note : Hybrid Work Arrangement and resource(s) will be required to work at a minimum of 2 days per week at 5775 Yonge St.

Must have :

• Hands-on experience in multiple large scale Oracle data masking and sub setting projects to mask copes of Production data.
• Hand-on experience with Oracle Data masking and sub setting pack using OEM.
• Proficiency in SQL and PL / SQL for Oracle databases.

Description

Responsibilities :

• 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.

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

Technical Knowledge and experience 50%

• Hands-on experience in multiple large scale Oracle data masking and sub setting projects to mask copes of Production data.
• Hand-on experience with Oracle Data masking and sub setting pack using OEM.
• Proficiency in SQL and PL / SQL for Oracle databases.
• Expert level knowledge in best practices for implementing data masking in enterprise environments.
• Deep understanding of Oracle Database 19c, including its architecture, features, and performance optimization on Exadata platforms.
• Experience in Oracle Exadata, EBS, Weblogic, ASM / RAC, Siebel is an asset
• Understanding of audit requirements and how data masking can address specific audit findings related to data privacy and security.

Methodology, testing, and troubleshooting 30%

• Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
• Experience working in agile development environment
• Ability to provide user and system documentation as required
• Contribute to the effective management of risks and issues associated with Solution designs
• Collaborate with cross-functional and distributed teams, including designers, developers, architects, project managers, and QA
• Promotes industry standards and best practices with the product teams.
• Perform thorough code reviews including unit tests and ensure high quality of the software.
• Fix defects and support developers, testers and end users

Planning, documentation, and communication 20%

• Prepare work plans with CYSSC Managers, report and adjust completion status, report issues and risks in a timely manner
• Write technical documentation that supports and thoroughly explains the architecture
• Deliver knowledge transfer sessions to the team on the work completed

J-18808-Ljbffr