Sr Database Engineer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Relevantz Technology Services, is seeking the following. Apply via Dice today!

Note :: Interview Process:

• L1 – Internal technical round (Virtual)
• L2 – Client discussion (In-person – Pittsburgh, PA)
  
  

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 performant Oracle environment post-migration
• Smooth migration with no disruption to ETL and reporting
• Clean cutover and quick stabilization during hyper care