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

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

Job summary

Tech Mirrors in Pittsburgh, PA is looking for a Senior Database Developer/Engineer to support a critical migration initiative from SQL Server to Oracle. The ideal candidate will have extensive experience with SQL Server, Oracle, and SSIS/SSRS, focusing on database logic conversion, data migration, and performance tuning.

This hands-on role requires 10+ years of experience and expertise in dynamic SQL handling. Success in this position ensures a stable and performant Oracle environment while maintaining existing ETL processes.

Qualifications

• 10+ years of experience in database development or engineering.
• Strong hands-on experience in SQL Server and Oracle.
• Solid understanding of differences between SQL Server and Oracle.

Responsibilities

• Work on end-to-end migration from SQL Server to Oracle.
• Convert complex T-SQL stored procedures and queries into PL/SQL.
• Support migration of large datasets with controlled downtime.

Skills

Database development/engineering

SQL Server (T-SQL, SSIS, SSRS)

Oracle (PL/SQL, performance tuning)

Database migration

Dynamic SQL handling

Job description

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

Location – Pittsburgh, PA (Onsite) – Relocation fine

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