Migration DBA Architect – Azure SQL Managed Instance to AWS Oracle RDS

Role :Migration DBA Architect – Azure SQL Managed Instance to AWS Oracle RDSLocation :Remote Position Type : Contract Job Description This role requires: AWS MS SQL to Oracle RDS, you need a heterogeneous migration approach using the AWS Schema Conversion Tool (AWS SCT) and the AWS Database Migration Service (AWS DMS).Role SummaryWe are seeking a hands-on Migration DBA with strong experience migrating Azure SQL Managed Instance (Azure SQL MI) workloads to AWS Oracle RDS. This role will lead and execute end-to-end database migration activities including assessment, design, schema/code conversion, data migration, cutover planning, performance tuning, security hardening, and post-migration validation. You will partner with application, infrastructure, security, and DevOps teams to ensure migrations are secure, resilient, performant, and compliant, with minimal downtime and strong operational readiness.Key Responsibilities1) Discovery & AssessmentAnalyze current-state Azure SQL MI environments: sizing, performance baselines, HA/DR, storage, networking, and operational dependencies.Assess database compatibility and migration complexity:SQL Server features (T-SQL constructs, CLR, SQL Agent jobs, SSIS/SSRS dependencies, linked servers, etc.)Oracle target constraints/features on Amazon RDS for Oracle (managed service limitations, options, licensing considerations, etc.)Create migration approach options: rehost/refactor, online vs. offline, phased migration, and rollback strategy.Produce migration artifacts: runbooks, cutover plans, rollback plans, risk log, and validation checklists.2) Migration Design & Execution (Cross-Platform)Design target-state Oracle database architecture on AWS:Oracle RDS instance class selection, storage layout, parameter groups, option groups, Multi-AZ, backup retention, monitoring strategy.Lead schema and code conversion from SQL Server to Oracle:Translate T-SQL to PL/SQL where required; rewrite stored procedures, functions, triggers, views, and sequences.Convert SQL Server-specific data types, constraints, and indexing strategies to Oracle equivalents.Execute data movement using enterprise tools and approaches (based on requirement):Bulk load and incremental replication patterns; staging and parallel load strategies.Coordinate with tools such as AWS DMS, native export/import approaches, or third-party migration tools.Plan and execute cutover with minimal downtime:Pre-cutover rehearsals, performance dry runs, and final sync timing.Application connection string changes, credential rotation, and DNS/endpoint switching.3) Performance Engineering & OptimizationEstablish pre/post migration baselines (CPU, IOPS, query latency, wait events, locking contention).Tune Oracle database performance post-migration:Index strategy adaptation, statistics management, query plan stabilization, and parameter tuning.Optimize workloads for AWS operational realities:Storage/I/O tuning, connection pool sizing, maintenance windows, backups, and patching.4) Security, Compliance & ReliabilityImplement security best practices across the migration lifecycle:Encryption in transit/at rest, key management integration, auditing, least privilege access, and secrets management.Configure monitoring and alerting:CloudWatch metrics/logs, Oracle diagnostics as permitted in RDS, and integration with enterprise observability tools.Ensure HA/DR readiness:Multi-AZ strategy, backup/restore drills, RPO/RTO alignment, and documented failover procedures.5) Operational Readiness & HandoverCreate operational runbooks and standard operating procedures:Backup/restore, patching, user provisioning, performance troubleshooting, and capacity planning.Support production hypercare and transition to steady-state operations.Mentor engineers and contribute to repeatable migration frameworks/templates.Required Qualifications8+ years of DBA experience with strong focus on migration delivery in enterprise environments.Proven experience migrating Azure SQL Managed Instance / SQL Server workloads to AWS, specifically Oracle on Amazon RDS.Deep SQL Server and Oracle knowledge:SQL Server: T-SQL, indexing, query tuning, SQL Agent, backup/restore, HA concepts.Oracle: PL/SQL, optimizer fundamentals, performance tuning, RMAN concepts (as applicable), user/security administration.Strong AWS and Azure fundamentals:AWS: RDS (Oracle), VPC, Security Groups, IAM, KMS, CloudWatch, networking basics.Azure: SQL MI architecture concepts, connectivity, backup/restore options, monitoring.Experience producing migration documentation: HLD/LLD, runbooks, validation scripts, cutover/rollback plans.Hands-on troubleshooting skills across network latency, connectivity, authentication, and performance bottlenecks.Technical Skills (Core)Azure SQL MI / SQL Server: performance tuning, HA/DR concepts, backup/restore, security, automation.Oracle (RDS): schema objects, PL/SQL, query tuning, parameter/option group configuration, monitoring.Migration Engineering: schema conversion, data movement, validation, reconciliation, rollback.Cloud Networking/Security: VPC/Subnets, routing, firewall rules, IAM roles/policies, encryption, secrets.Preferred QualificationsExperience with AWS DMS and/or other migration tooling (e.g., Qlik Replicate, Precisely, Ispirer, etc.).Prior involvement in large-scale platform migrations with multiple applications/databases.Knowledge of data integration patterns, CDC replication, and zero/low-downtime migrations.Experience with DevOps/IaC: Terraform/CloudFormation, CI/CD integration for database changes.Familiarity with compliance frameworks (SOX, PCI, HIPAA) and audit logging requirements.Oracle licensing knowledge (BYOL vs license-included where applicable) and managed service constraints.Best Regards,Bismillah Arzoo (AB)