Database migration and optimization

Overview

On Site
$50 - $70
Contract - Independent
Contract - W2
Contract - 6 Month(s)
No Travel Required

Skills

Data Warehouse
Database
OLTP
Database Migration
Microsoft SSIS
Microsoft Azure
PL/SQL
SQL
Migration

Job Details

  • Replication & Synchronization: Designing OLTP peer-to-peer replication for seamless data flow.

  • Data Warehousing & Optimization: Architecting data solutions aligned with business intelligence.

  • Migration Strategy: Leading end-to-end Oracle-to-Azure SQL/MS SQL migrations, emphasizing high automation and minimal disruption.

  • Automation & Frameworks: Implementing automation tools for schema conversion, data transfer, and validation.

  • Technical Execution: Utilizing Oracle GoldenGate, Azure Data Factory, SSIS, and scripting languages (Python, PowerShell, SQL).

  • Database Assessment: Conducting deep Oracle database analysis, including PL/SQL, stored procedures, partitions, and performance tuning.

  • T-SQL Optimization: Refactoring PL/SQL into T-SQL, ensuring performance improvements.

  • Migration Tools: Leveraging DMA, SSMA, Azure DMS, and other specialized solutions.

  • Compatibility & Risk Mitigation: Addressing compatibility issues, ensuring compliance, and minimizing security risks.

  • Post-Migration Optimization: Enhancing query tuning, indexing strategies, partitioning, and workload balancing.

  • Collaboration & Execution: Working with application teams, providing roadmaps, and maintaining fast-paced execution.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.