TalentAQ

TalentAQ

Oracle Database Administrator Cloud Migration Specialist

Information TechnologyContract10+ yearsBrampton, Ontario

Required Skills
48 skills

User and Role Management
Tablespace and Storage Administration
SQL Tuning
Performance Optimization
AWR
ADDM
SQL Trace
TKPROF
Oracle Infrastructure Management
ASM
Cluster ware
Oracle Grid Infrastructure
Exadata
VM Provisioning
Oracle VM
Azure VMs
Azure Disk Management
IOPS Optimization
Oracle Data Pump
expdp
impdp
SQL
PL/SQL
SQL Scripting
Data Mapping
Azure
Cloud Migration
Hybrid Cloud
MultiCloud
Cloud Infrastructure
Virtual Machines
Disk Optimization
Cloud Performance
SQL Performance Tuning
Storage Management
VM Provisioning
Security Compliance
User Role Management
Migration Strategy
Cross Cloud
Documentation Skills
Troubleshooting
Communication Skills
Collaboration
Cloud Best Practices
DBA Migrations
Data Integrity
Performance Optimization

Job Description

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, Cluster ware, 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.
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, Cluster ware, 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.

Similar Jobs

10000 jobs available

Oracle
SQL Server
SQL
+17 more
Oracle Database
SQL
PL/SQL
+6 more
Oracle
MS SQL Server
SQL
+10 more
Banking Domain
Core Banking Systems
KYC
+17 more
ITFull Time7-12 years
PL/SQL Development
Data Migration
Database Performance Tuning
+2 more