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

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Government Systems Technologies Inc. (GSTi), is seeking the following. Apply via Dice today! 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: • 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 performance Oracle environment post-migration Smooth migration with no disruption to ETL and reporting Clean cutover and quick stabilization during hyper care