New

DBA Architect

Ampcus, Inc
United States, Illinois, Chicago
201 West Lake Street (Show on map)
May 14, 2026
Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: DBA Architect Location(s): Chicago, IL (Remote) Key Requirement: This role requires cross-platform heterogeneous database migration expertise, specifically migrating Microsoft SQL Server/Azure SQL Managed Instance workloads to Amazon Oracle RDS using AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS). Role Summary Seeking a hands-on Migration DBA with strong experience leading Azure SQL Managed Instance (Azure SQL MI) to AWS Oracle RDS migrations. The role involves end-to-end migration ownership including discovery, assessment, schema/code conversion, data migration, cutover execution, performance optimization, security implementation, and operational handover. The ideal candidate must have deep expertise in heterogeneous migration methodologies using AWS SCT and AWS DMS to convert SQL Server schemas and migrate data into Oracle RDS environments with minimal downtime and high operational reliability. Key Responsibilities Discovery & Assessment Analyze existing Azure SQL MI environments including: Database sizing Performance baselines HA/DR architecture Storage and networking Operational dependencies Assess migration complexity including: T-SQL compatibility CLR usage SQL Agent jobs SSIS/SSRS dependencies Linked servers Oracle RDS constraints and managed service limitations Define migration approaches: Online vs offline migration Rehost/refactor strategies Phased migration Rollback planning Create migration deliverables: HLD/LLD documentation Runbooks Cutover plans Rollback plans Validation checklists Risk assessments Migration Design & Execution (Heterogeneous Migration) Design Oracle RDS target architecture on AWS: Instance sizing Storage configuration Parameter groups Option groups Multi-AZ setup Backup retention Monitoring strategy Perform heterogeneous schema conversion using AWS SCT: Convert SQL Server schema objects to Oracle-compatible structures Translate T-SQL into PL/SQL Rewrite procedures, triggers, functions, views, sequences, and jobs Convert SQL Server-specific data types and indexing strategies Execute data migration using AWS DMS: Full load and CDC replication Parallel load strategies Incremental synchronization Validation and reconciliation Coordinate migration tooling and approaches: AWS SCT AWS DMS Native export/import utilities Third-party replication tools where applicable Plan and execute production cutovers: Dry runs and rehearsal migrations Final synchronization timing DNS/endpoint switchovers Connection string updates Credential rotation Rollback readiness Performance Engineering & Optimization Establish pre/post migration performance baselines: CPU IOPS Query latency Wait events Locking/contention metrics Optimize Oracle RDS performance: Index tuning Statistics management Query plan stabilization Parameter tuning Optimize AWS operational performance: Storage throughput tuning Connection pooling Maintenance scheduling Backup and patch management Security, Compliance & Reliability Implement migration security best practices: Encryption at rest and in transit KMS integration IAM access controls Secrets management Auditing and logging Configure monitoring and observability: CloudWatch metrics and logs Oracle diagnostics supported in RDS Enterprise monitoring integrations Ensure HA/DR readiness: Multi-AZ deployments Backup and restore testing RPO/RTO compliance Failover procedures Operational Readiness & Handover Develop operational documentation: SOPs Backup/restore procedures Patching runbooks User provisioning Troubleshooting guides Capacity planning documentation Support production hypercare and operational transition Contribute reusable migration frameworks, templates, and automation standards Required Qualifications 8+ years of DBA experience with enterprise migration delivery Strong hands-on experience migrating Azure SQL MI / SQL Server to AWS Oracle RDS Proven heterogeneous migration expertise using: AWS SCT AWS DMS Deep SQL Server expertise: T-SQL Query tuning SQL Agent Backup/restore HA/DR concepts Strong Oracle expertise: PL/SQL Oracle optimizer fundamentals Performance tuning Security administration RMAN concepts Strong AWS fundamentals: Oracle RDS VPC Security Groups IAM KMS CloudWatch Networking Azure SQL MI operational knowledge: Architecture Connectivity Monitoring Backup/recovery Strong troubleshooting skills across: Network latency Authentication Connectivity Replication Performance bottlenecks Preferred Qualifications Experience with: Qlik Replicate Precisely Ispirer Other enterprise migration platforms Experience supporting large-scale multi-database migration programs Knowledge of: CDC replication Zero/low-downtime migrations DevOps and IaC Terraform CloudFormation CI/CD for database deployments Familiarity with compliance frameworks: SOX PCI HIPAA Understanding of Oracle licensing models: BYOL License Included RDS managed service limitations Core Technical Skills Azure SQL MI / SQL Server: Performance tuning HA/DR Security Backup/restore Automation Oracle RDS: PL/SQL Query tuning Monitoring Parameter and option groups Migration Engineering: AWS SCT AWS DMS Schema conversion Data migration Validation/reconciliation Rollback strategies Cloud Infrastructure & Security: VPC/Subnets Routing Firewall rules IAM roles/policies Encryption Secrets management Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.