Position Overview
We are seeking an experienced Subject Matter Expert (SME) with strong expertise in Netezza to Oracle database migration. The ideal candidate will bring a blend of technical depth, hands-on migration experience, and strategic oversight to ensure seamless, secure, and optimized transitions from legacy Netezza platforms to modern Oracle environments (on-prem, Exadata, or Oracle Cloud Infrastructure).
Key Responsibilities
-
Lead and manage end-to-end migration projects from Netezza to Oracle, including assessment, planning, execution, validation, and optimization.
-
Analyze existing Netezza environments (schemas, data, stored procedures, ETL jobs) and design corresponding Oracle-compatible structures.
-
Oversee schema conversion, data type mapping, and SQL/PLSQL refactoring, ensuring functional equivalence and performance.
-
Implement data migration strategies (connected/disconnected modes, incremental loads, delta strategies) for large-scale databases.
-
Automate migration workflows using ETL/ELT tools (Oracle Data Integrator, Informatica, DataStage) and scripting languages (Python, UNIX shell).
-
Ensure data quality and integrity via robust validation and reconciliation processes.
-
Optimize post-migration Oracle database performance, leveraging features like partitioning, indexing, and Exadata enhancements.
-
Collaborate with cross-functional teams (DBAs, architects, data engineers, and business stakeholders) to align migration with business goals.
-
Provide documentation, training, and knowledge transfer for smooth post-migration operations.
-
Ensure compliance with security, governance, and industry best practices during migration.