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.
  

Technical Knowledge and experience

• Hands-on experience administering large-scale Oracle databases on RAC
  
• Hands-on experience with Oracle Data Guard and Oracle GoldenGate data replication, including setting up and configuring GoldenGate for data replication from on-premises 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.
  
• Expert-level 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, 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

• 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
  

Must-Haves:

• Hands-on experience administering large-scale Oracle databases on RAC
  
• Hands-on experience with Oracle Data Guard and Oracle GoldenGate data replication, including setting up and configuring GoldenGate for data replication from on-premises 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.