Database Developer / Engineer

We re looking for a senior database engineer with strong experience in SQL Server, Oracle, and SSIS/SSRS to support a critical migration initiative. This is a hands-on role focused on converting database logic, handling dynamic SQL, migrating data, and ensuring the system runs reliably on Oracle while maintaining existing ETL processes and reports.

Key Responsibilities Database Migration & Conversion 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: o Transactions and error handling o 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: o Connection managers to point to Oracle o 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

10+ years of experience in database development/engineering Strong hands-on experience in: o SQL Server (T-SQL, stored procedures, dynamic SQL, SSIS, SSRS) o 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