Role :Migration DBA Architect – Azure SQL Managed Instance to AWS Oracle RDS
Location :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 Summary
• We 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 Responsibilities
1) Discovery & Assessment
• Analyze 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 & Optimization
• Establish 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 & Reliability
• Implement 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 & Handover
• Create 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 Qualifications
• 8+ 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 Qualifications
• Experience 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)
Apply tot his job
Apply To this Job