Senior- Specialized IT Consultant

Temporary/Contract

Toronto, Ontario

28 Nov 2024

    The Ontario Government Client is seeking an experienced Oracle Database Administrator to manage large-scale databases, ensure high-performance replication processes, and optimize data solutions.

    Duration:6+ Months

    Must-Haves:

    • Hands-on experience administering large-scale Oracle databases on RAC.

    • Proficiency in Oracle Data Guard and Oracle GoldenGate data replication, including setup and configuration for on-premises to cloud environments.

    • Knowledge of change data capture (CDC) concepts and implementation.

    • Expertise in SQL and PL/SQL for Oracle databases.

    • Ability to optimize database performance and ensure data integrity.

    Responsibilities

    Technical Knowledge and Implementation:

    • Administer Oracle databases on RAC with high availability and performance.

    • Configure Oracle GoldenGate and Data Guard for data replication and disaster recovery.

    • Implement data solutions in Azure, including integration with Azure Storage and Databricks.

    • Automate data replication and processing tasks using scripting languages like Python, Shell, and SQL.

    • Design and implement ETL processes and DevOps methodologies for database management.

    • Ensure compliance with best practices for data masking, architecture, and performance optimization on Oracle Database 19c.

    Methodology, Testing, and Troubleshooting:

    • Analyze, troubleshoot, and resolve database and application issues.

    • Collaborate with cross-functional teams in an agile environment.

    • Conduct code reviews, write unit tests, and support development and testing teams.

    • Promote best practices and contribute to solution design risk management.

    Planning, Documentation, and Communication:

    • Develop work plans, track progress, and address risks.

    • Prepare technical documentation and conduct knowledge transfer sessions.

    • Provide user and system documentation and deliver clear communication to stakeholders.

    Additional Skills:

    • Familiarity with Azure services, big data platforms, and ETL tools.

    • Experience with DevOps and agile methodologies to enhance operational efficiency.