Senior Database Developer / Engineer (SQL Server to Oracle Migration) – Pittsburgh, PA

Tech Mirrors; Pittsburgh (Allegheny County); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Relocation assistance

Job summary

Tech Mirrors in Pittsburgh, PA is seeking a Senior Database Developer/Engineer to lead a SQL Server to Oracle migration. The role is onsite, with relocation support, and focuses on converting database logic, handling dynamic SQL, migrating data, and maintaining ETL processes and reports.

The ideal candidate has 10+ years in database development, strong SQL Server and Oracle expertise, and hands-on experience with ETL tools (SSIS/SSRS) and data migration.

Qualifications

• 10+ years in database development/engineering.
• Hands-on with SQL Server (T-SQL, stored procedures, dynamic SQL, SSIS, SSRS).
• Hands-on with Oracle (PL/SQL, performance tuning).
• Experience migrating from SQL Server to Oracle or modernization projects.

Responsibilities

• End-to-end migration from SQL Server to Oracle with schema/table/index/function conversion.
• Convert complex T-SQL to PL/SQL and refactor dynamic SQL.
• Design and implement data movement strategies with minimal downtime.
• Validate ETL workflows and reports for Oracle compatibility (SSIS/SSRS).
• Tune performance: indexes, execution plans, and Oracle design.
• Support testing cycles and collaborate with QA/biz teams.
• Assist cutover and hyper-care production support.

Skills

SQL Server

Oracle

Dynamic SQL

ETL/SSIS

Query optimization

Migration experience

Troubleshooting

Cross-team collaboration

Production support

Tools

SSIS

SSRS

Oracle Data Pump

GoldenGate

Job description

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

Location – Pittsburgh, PA (Onsite) – Relocation fine

Migration and SQL to Oracle are strongly needed

Role Summary

We’re looking for a senior database engineer with strong experience inSQLServer,Oracle, andSSIS/SSRSto 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 withdynamic 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 withno 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 onlogic-driven conversion, especially dynamic SQL handling
• Comfortable working incritical 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