Note :: Interview Process: • L1 – Internal technical round (Virtual) • L2 – Client discussion (In-person – Pittsburgh, PA)
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