Cloud Data Architect

Infinite Computer Solutions (ICS); United States; Remote; USD 150,000 - 190,000; Full time

Job summary

Infinite Computer Solutions seeks a Cloud Data Architect & Database Migration Engineer to lead end-to-end migration of mission-critical financial databases to Azure. You will design technical blueprints, ensure zero data loss, and enforce strict regulatory compliance (GDPR, PCI-DSS, SOX) with high availability.

You will architect migrations of SQL Server/Oracle, implement data governance, and orchestrate ETL/ELT pipelines using Azure Data Factory while coordinating across DBAs and audit teams

Qualifications

• Experience designing enterprise cloud data architectures for migrations to Azure.
• Strong SQL Server/T-SQL mastery with performance tuning and high availability.
• Familiarity with financial/regulatory data handling and compliance requirements.
• Experience with IaC and CI/CD tools for automated deployments.

Responsibilities

• Design technical blueprint for migrating complex databases from on-prem to Azure.
• Decommission data centers safely while mapping dependencies and cutover waves.
• Enforce security governance, encryption, RBAC, and private network isolation.
• Develop robust ETL/ELT pipelines using Azure Data Factory and manage CDC workflows.
• Refactor T-SQL, optimize schemas, and tune queries post-migration.
• Collaborate with DBAs, engineers, and audit/compliance teams as SME.

Skills

Cloud data architecture

Data migration

SQL Server

T-SQL

Performance tuning

Regulatory compliance

Azure security

Stakeholder collaboration

Tools

Azure Data Factory

Azure SQL Database

Azure SQL Managed Instance

ADLS Gen2

Terraform

Azure DevOps

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.