SQL Developer - PostgreSQL/Oracle DB

Job Description :

SQL Developer (Oracle to PostgreSQL Migration)

Location : Hyderabad.

Work Mode : Work From Office (Mandatory).

Experience : 4 to 7 Years.

Interview Process : 1 Round Face-to-Face Interview (Mandatory).

Note : Candidates must be comfortable with Work From Office and should be available for a Face-to-Face Interview as part of the selection process.

We are looking for a strong SQL Developer with hands-on experience in Oracle PL/SQL, PostgreSQL, and Database Migration to support the migration and re-implementation of an Oracle-based reporting database onto the RisingWave platform (PostgreSQL-compatible streaming database).

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

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.

Good to Have :

• Experience with RisingWave
• Streaming Databases
• Real-Time Data Processing
• Data Warehousing Concepts