Oracle-to-Azure SQL Migration DBA

SRM Technologies LLC; United States; Remote; USD 90,000 - 140,000; Full time

Job summary

SRM Technologies is seeking a Database Administrator to analyze an Oracle database, recreate schemas in Azure SQL Managed Instance, and ensure performance, security, and availability. You will map Oracle structures to SQL Server equivalents and support validation across development, test, staging, and production environments.

The role requires 5–8+ years of experience with Oracle and SQL Server/Azure SQL, strong PL/SQL and T-SQL skills, and a focus on documentation and collaboration with backend

Qualifications

• 5–8+ years of database administration and/or database development experience.
• Strong practical experience with Oracle database schemas, data types, constraints, indexes, views, sequences, triggers, procedures, and functions.
• Hands-on experience with Microsoft SQL Server and/or Azure SQL Managed Instance, including schema creation and database administration.
• Ability to map Oracle structures to SQL Server/Azure SQL equivalents and understand platform differences.
• Strong SQL skills with PL/SQL and T-SQL.
• Experience with relational data modeling, keys, referential integrity, indexes, and constraints.
• Experience with performance analysis, query tuning, backups, and recovery.
• Strong troubleshooting, documentation, and cross-team communication skills.

Responsibilities

• Administer and support existing databases, including monitoring, access management, troubleshooting, and maintenance.
• Document Oracle structures and recreate equivalent schemas in Azure SQL Managed Instance.
• Map Oracle data types and objects to SQL Server/Azure SQL equivalents; identify gaps.
• Review Oracle features and convert to T-SQL or Azure SQL-compatible implementations.
• Create and maintain schemas, tables, constraints, indexes, views, procedures, and functions in target DB.
• Validate target objects against source structure for consistency.
• Prepare scripts for repeatable deployment across environments.
• Support data loading and validate record counts, keys, and data types.
• Analyze queries and execution plans to tune performance.
• Troubleshoot connectivity and query issues with backend teams.
• Manage permissions, backups, monitoring, storage, deadlocks; document decisions.

Skills

Oracle schemas

SQL Server

Azure SQL

PL/SQL

T-SQL

Data modeling

Performance tuning

Backup/Recovery

Documentation

Cross-team communication

Tools

SSMA for Oracle

Azure Portal

SSMS

Job description

SRM Technologies is seeking a Database Administrator to analyze an Oracle database, recreate schemas in Azure SQL Managed Instance, and ensure performance, security, and availability. You will map Oracle structures to SQL Server equivalents and support validation across development, test, staging, and production environments.

The role requires 5–8+ years of experience with Oracle and SQL Server/Azure SQL, strong PL/SQL and T-SQL skills, and a focus on documentation and collaboration with backend