Data Migration

Job Description:

• 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