Senior Database Developer / Engineer (SQL Server to Oracle Migration)

Job Title: Senior Database Developer / Engineer (SQL Server to Oracle Migration)

Location: Pittsburgh, PA

Duration : 6 Months Contract

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

Required Skills & Experience
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

Success in This Role Looks Like
Stable and performance Oracle environment post-migration
Smooth migration with no disruption to ETL and reporting
Clean cutover and quick stabilization during hyper care