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.