Sr Database Engineer

Role Summary

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:
• 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

• 10+ 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