RQ08966 - Specialized IT Consultant - Senior

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 changemanagement principles and methodology Knowledge and understanding of Information Management principles concepts policies and practices.
  

Requirements

Technical Knowledge and experience

• Handson experience administering largescale Oracle databases on RAC
  
• Handson experience with Oracle Data Guard and Oracle GoldenGate data replication including setting up and configuring GoldenGate for data replication from onpremises databases to cloud environments.
  
• Understanding of change data capture (CDC) concepts and implementation.
  
• Ability to optimize database performance and ensure data integrity during replication processes.
  
• Experience with configuring and managing Oracle GoldenGate Big Data Edition
  
• Familiarity with Azure cloud services especially Azure Storage and its integration with databases.
  
• Experience in deploying and managing data solutions in Azure.
  
• Knowledge of creating and managing flat files including various data formats for storage in Azure.
  
• Understanding of best practices for data organization and retrieval in cloud storage.
  
• Experience with Azure Databricks or similar big data processing platforms.
  
• Proficiency in scripting languages (e.g. Python Shell SQL) to automate data replication and processing tasks.
  
• Experience with ETL (Extract Transform Load) processes and tools.
  
• Experience with DevOps methodologies and tools to streamline database deployment and management processes.
  
• Ability to collaborate with development teams to integrate database management into automated workflows and enhance overall operational efficiency.
  
• Proficiency in SQL and PL/SQL for Oracle databases.
  
• Expertlevel knowledge of 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.
  

Methodology testing and troubleshooting

• Excellent analytical problemsolving and decisionmaking 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 crossfunctional 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

• 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
  

MustHaves:

• Handson experience administering largescale Oracle databases on RAC
  
• Handson experience with Oracle Data Guard and Oracle GoldenGate data replication including setting up and configuring GoldenGate for data replication from onpremises databases to cloud environments.
  
• Understanding of change data capture (CDC) concepts and implementation.
  
• Ability to optimize database performance and ensure data integrity during replication processes.
  
• Proficiency in SQL and PL/SQL for Oracle databases.