Job Description:
Responsibilities:

• Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems.
• Works to improve the 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.
• Provides 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 - 50%:

• 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 - 30%:

• Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills.
• Experience working in an 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.