Quick Overview
Seniority
Mid Senior
Work mode
Remote
Location
United States
Posted
5 days ago
OracleSQLSQL ServerT-SQLETLEncryptionAzureGDPRGitRESTTerraform
Job Description
Role: Cloud Data Architect
Fulltime/W2 - Infinite Computer Solutions
Remote Role
Project Type: Enterprise Data Center Exit / Cloud Modernization
Domain: Banking & Financial Services
About the Role
We are looking for an experienced Cloud Data Architect & Database Migration Engineer with a deep specialization in Microsoft Azure and SQL ecosystem,
In this role, you will lead the end-to-end design, planning, and secure execution of migrating mission-critical, highly sensitive financial databases and data warehouses from legacy on-premises data centers to Azure. You will ensure zero data loss, strict adherence to banking regulatory frameworks (such as GDPR, PCI-DSS, or SOX), and high availability with minimal business disruption.
Key Responsibilities
- Migration Strategy & Architecture: Design the overarching technical blueprint for migrating complex enterprise databases (SQL Server, Oracle) from physical data centers to Azure (Azure SQL Managed Instance, Azure SQL Database, and Azure Synapse Analytics).
- Data Center Decommissioning Support: Collaborate with infrastructure and network engineering teams to map data dependencies, sequence cutover waves, and retire legacy data center footprints safely.
- Performance & Security Governance: Implement enterprise-grade security, data encryption (at rest and in transit), Role-Based Access Control (RBAC), and network isolation (Private Endpoints, VNets) compliant with financial regulatory standards.
- Pipeline & Sync Orchestration: Design robust ETL/ELT workflows using Azure Data Factory (ADF) and manage hybrid data synchronization (Change Data Capture/CDC, dual-writes) to ensure business continuity during phased migrations.
- Advanced Optimization & Troubleshooting: Oversee complex T-SQL code refactoring, query performance tuning, and schema optimizations post-migration to ensure optimal performance in the cloud.
- Stakeholder & Vendor Collaboration: Act as the technical subject matter expert (SME), guiding internal engineering squads, database administrators (DBAs), and external audit/compliance teams.
Required Qualifications & Technical Skills
- Experience: 8+ years of progressive IT experience, with at least 5+ years tightly focused on cloud data architecture, database design, and large-scale data migrations.
- Core Database Mastery: Expert-level knowledge of Microsoft SQL Server and T-SQL, including advanced performance tuning, indexing strategies, high availability (Always On AG), and disaster recovery (DR).
- Azure Cloud Ecosystem: Hands-on architecture experience with Azure SQL Managed Instance, Azure SQL Database, Azure Data Lake Storage (ADLS Gen2), and Azure Data Factory.
- Migration Tooling: Proven track record of utilizing tools like Azure Database Migration Service (DMS), Data Migration Assistant (DMA), and custom scripting for schema conversions and data validation.
- Financial Domain Context: Prior working experience in banking, fintech, or highly regulated financial sectors, understanding data sensitivity, residency requirements, audit trails, and strict security compliance.
- Infrastructure & Automation: Familiarity with Infrastructure as Code (Terraform or Bicep) and version control tools (Git/Azure DevOps) for automated deployments.
Similar jobs
- NI
Network Engineer 4 with Security Clearance
NewNuAxis Innovations LLC
Washington, DC🇺🇸HybridYesterdayOracleTCP/IPDNSTechnology - MO
Cloud Azure Security Engineer
NewMonks
United States🇺🇸Hybrid9 hours agoExpressEncryptionMFA+13Technology - LA
Senior Cloud Infrastructure Engineer, Cloud Foundations
NewLambda
San Francisco Office (Fremont St)🇺🇸Hybrid6 hours agoGCPAWSMachine Learning+7Technology - NG
Cloud Integration Architect / Systems Architect
NewNMK Global Inc.
Albany, NY🇺🇸Hybrid6 hours agoAWSEncryptionLoad Balancing+5Technology - AT
Cloud Security Architect/Engineer with Security Clearance
NewAthena Technology Group, Inc.
Washington, DC🇺🇸HybridYesterdayHIPAAIoTTechnology - DD
AWS Cloud Data Engineer with Security Clearance
NewDNI Delaware Nation Industries
Dahlgren, VA🇺🇸$150k - $220k/yrOn-siteYesterdayDynamoDBAWSETL+8Technology
