Core Alliance Group - Senior Database Developer / Engineer (SQL Server to Oracle Migration

Database Developer is needed in Pittsburgh, United States.

Client: Core Alliance Group

Location: Pittsburgh, PA

Contract: Temporary, Contract

Job Description

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

Location: Pittsburgh, PA

Duration: 6 Months Contract

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

Requirements

• 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

Additional Information

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

Work Location: In person