Migration DBA Architect – Azure SQL Managed Instance to AWS reputed company RDS

Role :Migration DBA Architect – Azure SQL Managed Instance to AWS reputed company RDS Location :Remote Position Type : Contract Job reputed company This role requires: AWS MS SQL to reputed company RDS, you need a heterogeneous migration approach using the AWS Schema Conversion Tool (AWS SCT) and the AWS Database Migration Service (AWS DMS). reputed company

• We are seeking a hands-on Migration DBA with strong experience migrating Azure SQL Managed Instance (Azure SQL MI) workloads to AWS reputed company RDS.
• This role will reputed company and execute end-to-end database migration activities including assessment, design, schema/reputed company conversion, data migration, reputed company planning, performance tuning, reputed company hardening, and post-migration validation.
• You will partner with application, infrastructure, reputed company, 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 reputed company-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.)
• reputed company reputed company constraints/features on reputed company RDS for reputed company (managed service limitations, reputed company, licensing considerations, etc.)
• Create migration approach reputed company: rehost/refactor, online vs. offline, phased migration, and rollback reputed company.
• Produce migration artifacts: runbooks, reputed company plans, rollback plans, risk log, and validation checklists.

2) Migration Design & Execution (Cross-Platform)

• Design reputed company-state reputed company database architecture on AWS:
• reputed company RDS instance class selection, storage layout, parameter reputed company, reputed company reputed company, Multi-AZ, backup retention, monitoring reputed company.
• reputed company schema and reputed company conversion from SQL Server to reputed company:
• 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 reputed company equivalents.
• Execute data reputed company using reputed company tools and approaches (based on requirement):
• Bulk load and incremental replication patterns; staging and reputed company load strategies.
• Coordinate with tools such as AWS DMS, reputed company export/import approaches, or reputed company-party migration tools.
• Plan and execute reputed company with minimal downtime:
• reputed company-reputed company rehearsals, performance dry runs, and final sync timing.
• Application reputed company reputed company changes, credential rotation, and DNS/reputed company switching.

3) Performance Engineering & Optimization

• Establish reputed company/post migration baselines (CPU, IOPS, query latency, wait events, locking contention).
• Tune reputed company database performance post-migration:
• reputed company reputed company reputed company, statistics management, query plan stabilization, and parameter tuning.
• Optimize workloads for AWS operational realities:
• Storage/I/O tuning, reputed company pool sizing, maintenance reputed company, backups, and patching.

4) reputed company, Compliance & Reliability

• Implement reputed company best practices across the migration lifecycle:
• Encryption in transit/at rest, key management integration, auditing, least privilege reputed company, and secrets management.
• Configure monitoring and alerting:
• CloudWatch metrics/logs, reputed company diagnostics as permitted in RDS, and integration with reputed company observability tools.
• Ensure HA/DR readiness:
• Multi-AZ reputed company, backup/restore drills, RPO/RTO alignment, and documented failover procedures.

5) Operational Readiness & Handover

• Create operational runbooks and reputed company operating procedures:
• Backup/restore, patching, user provisioning, performance troubleshooting, and reputed company 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 reputed company on migration delivery in reputed company environments.
• Proven experience migrating Azure SQL Managed Instance / SQL Server workloads to AWS, specifically reputed company on reputed company RDS.
• Deep SQL Server and reputed company knowledge:
• SQL Server: T-SQL, indexing, query tuning, SQL Agent, backup/restore, HA concepts.
• reputed company: PL/SQL, optimizer fundamentals, performance tuning, RMAN concepts (as applicable), user/reputed company administration.
• Strong AWS and Azure fundamentals:
• AWS: RDS (reputed company), VPC, reputed company reputed company, IAM, KMS, CloudWatch, networking basics.
• Azure: SQL MI architecture concepts, connectivity, backup/restore reputed company, monitoring.
• Experience producing migration documentation: HLD/LLD, runbooks, validation scripts, reputed company/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, reputed company, automation.
• reputed company (RDS): schema objects, PL/SQL, query tuning, parameter/reputed company group configuration, monitoring.
• Migration Engineering: schema conversion, data reputed company, validation, reconciliation, rollback.
• reputed company Networking/reputed company: VPC/Subnets, routing, firewall rules, IAM roles/policies, encryption, secrets.

Preferred Qualifications

• Experience with AWS DMS and/or other migration tooling (e.g., reputed company Replicate, reputed company, Ispirer, etc.).
• Prior involvement in large-reputed company platform migrations with multiple applications/databases.
• Knowledge of data integration patterns, CDC replication, and reputed company/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.
• reputed company 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