Description

Oracle to SQL Server Migration

• Develop source-to-target mappings for migration to SQL Server 2025
• Translate Oracle database structures and logic into SQL Server-compatible objects
• Convert Oracle data types, sequences, procedures, triggers, and related objects
• Build migration scripts, transformation logic, and ETL/ELT processes
• Identify and resolve cross-platform compatibility issues
• Validate migrated data for completeness, accuracy, integrity, and consistency
• Support multiple migration cycles and incremental loads as needed

SQL Server Development

• Design, develop, and maintain SQL Server database components, including:
  • Tables
  • Relational structures
  • Primary and foreign keys
  • Constraints
  • Indexes
  • Views
  • Stored procedures
  • Functions
  • Triggers
  • Sequences
• Write advanced SQL Server code to support application and migration requirements
• Troubleshoot data integrity and performance issues
• Support testing and validation activities across the migration lifecycle

Required Skills and Experience

• Strong experience as a SQL Server Developer
• Deep hands-on expertise with Microsoft SQL Server and T-SQL
• Experience writing stored procedures, triggers, functions, and advanced SQL queries
• Strong understanding of relational database design
• Experience with data migration, data transformation, and data validation
• Strong troubleshooting skills related to data integrity, testing, and migration issues
• Experience with database performance tuning and query optimization
• Ability to work with technical teams, analysts, QA resources, and business stakeholders

Preferred Skills

• Experience analyzing or working with Oracle databases
• Prior experience supporting Oracle-to-SQL Server migrations
• Experience with repeatable migration cycles and large data sets

Key Skills

Education

Bachelor's degree