Cloud Data Architect

Role:
Cloud Data Architect

Fulltime/W2 - Infinite Computer Solutions

Remote Role

Project Type: Enterprise Data Center Exit / Cloud Modernization

Domain: Banking & Financial Services

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.

• 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.

• 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 Dev Ops) for automated deployments.