Titre du poste ou emplacement
RECHERCHES RÉCENTES

Oracle Database Administrator

Galent - 17 emplois
Brampton, ON
Publié il y a 2 jours
Détails de l'emploi :
Temps plein
Gestion

Job Description

Position Summary:

We are seeking a highly skilled and certified Oracle Database Administrator with proven experience in migrating Oracle databases from on-premises Exadata platforms to Oracle Autonomous Database on Azure.

The ideal candidate will possess deep expertise in Oracle database administration, cloud migration, storage and performance management, and infrastructure provisioning in hybrid cloud environments.

Key Responsibilities:

  • Lead and execute end-to-end migrations from on-premises Oracle Exadata systems to Oracle Autonomous Database on Azure.
  • Administer and manage user accounts, roles, and privileges in compliance with security policies.
  • Oversee tablespace and storage management, ensuring efficient space utilization and scalability.
  • Perform advanced SQL performance tuning and query optimization.
  • Provision and configure virtual machines (VMs) to support migration and operational workloads.
  • Utilize Oracle Data Pump and related tools for data export/import during migration processes.
  • Configure and optimize Azure-managed disk storage, focusing on performance (IOPS) and cost-efficiency.
  • Leverage Oracle Cloud Migration Services and other utilities for seamless database transitions.
  • Conduct and document data mapping to ensure integrity and consistency across systems.
  • Collaborate with cloud infrastructure teams for architecture alignment and integration.
  • Monitor and maintain database performance, availability, and compliance post-migration.

Proficient In:

  • User and Role Management:

Expertise in managing database users, roles, and privileges to enforce granular access control and ensure security compliance across environments.

  • Tablespace and Storage Administration:

Skilled in planning, creating, resizing, and monitoring tablespaces for optimized performance, along with efficient space utilization strategies.

  • SQL Tuning and Performance Optimization:

Proficient in analyzing execution plans, identifying performance bottlenecks, and optimizing SQL queries using tools like AWR, ADDM, SQL Trace, and TKPROF.

  • Oracle Infrastructure Management:

In-depth knowledge of Oracle infrastructure components including ASM, Clusterware, and Oracle Grid Infrastructure, with experience supporting Exadata deployments.

  • VM Provisioning and Management:

Hands-on experience provisioning virtual machines in both on-premise and cloud environments using Oracle VM, Azure VMs, and other hypervisors.

  • Azure Disk Management and IOPS Optimization:

Practical expertise in configuring and tuning Azure-managed disks for Oracle workloads, ensuring optimal IOPS performance and cost-effective storage tiering.

  • Oracle Data Pump (expdp/impdp):

Advanced usage of Oracle Data Pump utilities for logical backups, cross-platform migrations, and schema-level data movement during enterprise migrations.

  • SQL Scripting and Data Mapping:

Strong command over SQL and PL/SQL, with the ability to analyze source-target mappings, develop custom scripts, and validate data accuracy post-migration.

Required Skills and Qualifications:

  • Minimum 10 years of experience in Oracle database administration, with hands-on expertise in Exadata environments.
  • Solid understanding of Oracle and Azure cloud ecosystems, and best practices in cross-cloud data movement.

Preferred Qualifications:

  • Experience working in hybrid and multi-cloud environments.
  • Familiarity with automation and orchestration tools for provisioning and database management.
  • Strong documentation, communication, and troubleshooting skills.
  • Demonstrated experience in migrating databases to Oracle Autonomous DB on Azure

Partager un emploi :