HM Note: This hybrid contract role is three 3 days in office. Candidates resume must include first and last name.
Description
Responsibilities: and nbsp;
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 organizations I and amp;IT systems. and nbsp;
The I and amp;IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management and amp; 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. and nbsp;
General Skills and nbsp;
Acts as the technical advisor/expert on all aspects of a specific deliverable and nbsp;
Provide the quality assurance/quality control of specific deliverables and nbsp;
Anticipates and resolves problems to ensure that the deliverables are completed within budget to the highest quality meeting or exceeding expectations and nbsp;
Develops processes and procedures for implementing deliverables and nbsp;
Prepares reports and presentations including options recommendations implementation plans etc. and nbsp;
Works with clients to define the scope of a project and to determine requirements
Defines software hardware and network requirements and nbsp;
Analyzes I and amp;IT requirements giving independent and objective advice on the use of I and amp;IT and nbsp;
Designs tests installs and monitors new systems and develops solutions and implementation of new systems and nbsp;
Familiar with change-management principles and methodology and nbsp;
Knowledge and understanding of Information Management principles concepts policies and practices
Skills
Experience and Skill Set Requirements
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.
- and nbsp;Understanding of change data capture (CDC) concepts and implementation.
- Ability to optimize database performance and ensure data integrity during replication processes.
- and nbsp; and nbsp;Proficiency in SQL and PL/SQL for Oracle databases.
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.
and nbsp; and nbsp;
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
and nbsp;
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
- Experience and Skill Set Requirements
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.
- and nbsp;Understanding of change data capture (CDC) concepts and implementation.
- Ability to optimize database performance and ensure data integrity during replication processes.
- and nbsp; and nbsp;Proficiency in SQL and PL/SQL for Oracle databases.