• Skip to primary navigation
  • Skip to main content
  • Skip to footer
  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter

1.844.822.0541

info@nexusgroup.ca

  • English
    • Français
  • Consultant Login
  • Find Your Opportunity
Nexus Systems Group

Nexus Systems Group

  • Home
  • What We Do
    • Staffing Solutions Made Easy
    • Contingent Workforce Management and Payroll Solutions
    • Technology Consulting and Delivery
  • Who We Serve
  • Who We Are
    • Our Team
    • News and Awards
    • Associations and Community
  • Contact Us
  • News

Oracle DBA

November 27, 2024 by

Oracle DBA 
Ministry – Government Client 
2024-12-09 – 2025-03-31 + ext
2-3 days per week in North York, Toronto 
CRJMC

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.

 

  • 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 – 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 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
– Experience and Skill Set Requirements

 

  • Apply Now
  • See All Jobs

Footer

ABOUT NEXUS SYSTEMS GROUP

Nexus is one of North America’s leaders in the provision of technology staff augmentation and strategic resource consulting. With a team of talented professionals using best of breed methodologies, Nexus consistently over delivers with quick, quality and trusted results to its clients and consultants.

LATEST OPPORTUNITIES

  • Junior IT Business Analyst – AI/Archer July 3, 2025
  • Senior IT Business Analyst – AI/Archer July 3, 2025
  • QA Analyst July 3, 2025
  • ServiceNow Developer/Designer x2 July 3, 2025

SOCIAL

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
Report on Business Canada's Top Growing Companies - Nexus Group
Nexus Group Growth 500 2019
Nexus Systems Group Growth 500 2018
NEXUS GROUP SYSTEMS GROUP INC. NEXUSGROUP.CA
  • Contact Us
  • Terms & Conditions
  • Privacy Policy