SQL Developer (Oracle to PostgreSQL Migration)

You are a strong SQL Developer with hands-on experience in Oracle PL/SQL, PostgreSQL, and Database Migration. You will be supporting the migration and re-implementation of an Oracle-based reporting database onto the RisingWave platform (PostgreSQL-compatible streaming database). Key Responsibilities: - Migrate Oracle-based reporting databases to RisingWave - Convert complex Oracle PL/SQL procedures, ETL logic, and reporting views into PostgreSQL-compatible SQL - Develop and optimize materialized views and streaming views - Ensure business logic and reporting outputs remain consistent in the new environment - Perform data validation, testing, and performance optimization - Collaborate with engineering and business teams throughout the migration lifecycle Mandatory Skills: - SQL Development - Oracle Database - Oracle PL/SQL (Stored Procedures, Functions, Packages) - PostgreSQL - ANSI SQL - ETL Development & Logic Conversion - Reporting Views & Materialized Views - Database Migration (Oracle to PostgreSQL) - Query Optimization & Performance Tuning - Data Validation & Reconciliation Note: No additional details of the company are provided in the job description. You are a strong SQL Developer with hands-on experience in Oracle PL/SQL, PostgreSQL, and Database Migration. You will be supporting the migration and re-implementation of an Oracle-based reporting database onto the RisingWave platform (PostgreSQL-compatible streaming database). Key Responsibilities: - Migrate Oracle-based reporting databases to RisingWave - Convert complex Oracle PL/SQL procedures, ETL logic, and reporting views into PostgreSQL-compatible SQL - Develop and optimize materialized views and streaming views - Ensure business logic and reporting outputs remain consistent in the new environment - Perform data validation, testing, and performance optimization - Collaborate with engineering and business teams throughout the migration lifecycle Mandatory Skills: - SQL Development - Oracle Database - Oracle PL/SQL (Stored Procedures, Functions, Packages) - PostgreSQL - ANSI SQL - ETL Development & Logic Conversion - Reporting Views & Materialized Views - Database Migration (Oracle to PostgreSQL) - Query Optimization & Performance Tuning - Data Validation & Reconciliation Note: No additional details of the company are provided in the job description.