ETL Database

Work on end-to-end migration from SQL Server to Oracle

Convert schemas tables indexes views and functions to Oracle-compatible formats

Identify and resolve platform-specific differences between SQL Server and Oracle

Ensure database design aligns with Oracle best practices

Stored Procedure & Query Conversion (Core Area)

Convert complex T-SQL stored procedures and queries into PL/SQL

Work extensively with dynamic SQL conversion and refactoring

Handle differences in:

Transactions and error handling

Temporary tables and session-level objects

Refactor logic where direct conversion is not feasible

Ensure converted code is stable optimized and easy to maintain

Data Migration

Support migration of large datasets with controlled downtime

Design and implement efficient data movement strategies

Validate and reconcile data between source and target systems

Handle edge cases to ensure data accuracy and completeness

ETL & Reporting (SSIS / SSRS)

Work on existing ETL and reporting layers with no major redesign

Update and validate:

Connection managers to point to Oracle

Inline queries and stored procedure calls

Ensure compatibility of ETL workflows and reports with Oracle backend

Perform end-to-end validation to confirm processes run as expected

Performance Tuning

Analyze and optimize query performance in Oracle

Compare behavior between SQL Server and Oracle execution

Trouble shoot issues observed after migration

Tune indexes execution plans and database design as needed

Testing & Validation

Support unit integration and system testing cycles

Help identify and fix issues discovered during testing

Work closely with QA and business teams to validate outcomes

Cutover & Production Support

Participate in migration rehearsals and production cutover

Support deployment and provide hyper care after go-live

Troubleshoot and resolve production issues quickly

Required Skills & Experience

7 years of experience in database development/engineering

Strong hands-on experience in:

SQL Server (T-SQL stored procedures dynamic SQL SSIS SSRS)

Oracle (PL/SQL performance tuning)

Solid understanding of differences between SQL Server and Oracle

Experience working on database migration or modernization efforts

Nice to Have

Experience with large-scale data migration

Familiarity with tools like Oracle Data Pump Goldengate or similar

Exposure to ETL and reporting tools (SSIS SSRS)

Experience in financial or regulatory systems

What We re Looking For

Strong focus on logic-driven conversion especially dynamic SQL handling

Comfortable working in critical migration paths with dependencies

Strong troubleshooting and analytical mindset

Ability to collaborate across DBA development and QA teams

Success in This Role Looks Like

Stable and performant Oracle environment post-migration

Smooth migration with no disruption to ETL and reporting

Clean cutover and quick stabilization during hyper care