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

Relevantz Technology Services

Open Positions (1)

Engineering

Sr Database Engineer