DBA Architect - Aurora CosmoDB/DataLake (8-10 yrs)

We are seeking a skilled Senior Database Architect with a strong background in migrating legacy SQL databases to Azure PaaS and a proven track record of configuring Cosmos DB, Azure Data Lakes, and implementing modern data warehousing solutions such as Azure Synapse Analytics or similar tools.

This role requires a deep understanding of database architecture, cloud technologies, and hands-on experience in designing scalable and cost-effective solutions.

Responsibilities :

- Design and implement migration strategies to modernize legacy SQL databases to Azure PaaS (Azure SQL, Azure Managed Instance).

- Develop and optimize data architectures for scalable, high-performance solutions on Azure.

- Configure and manage Cosmos DB for NoSQL workloads, ensuring performance, consistency, and scalability.

- Implement and optimize Azure Data Lakes for large-scale data storage, processing, and analytics.

- Architect and implement data pipelines to integrate and transform data into enterprise-ready solutions using tools such as Azure Data Factory and Synapse Analytics.

- Provide expertise in database performance tuning, optimization, and monitoring for cloud-based environments.

- Design and manage end-to-end data workflows, including ingestion, transformation, and reporting layers.

- Collaborate with stakeholders to gather requirements and design data architectures that meet business needs.

- Ensure data security, compliance, and governance across all data solutions.

- Stay updated on emerging Azure services and tools, providing recommendations to enhance the organization's data architecture strategy.

Qualifications :

Experience :

- 8+ years in database architecture, data engineering, or a similar role.

- Extensive experience migrating legacy SQL databases (e.g, MS SQL Server, Oracle) to Azure PaaS solutions.

Technical Skills :

- Strong expertise in Azure SQL Database and Azure SQL Managed Instance.

- Proficiency in configuring and managing Cosmos DB for NoSQL applications.

- Hands-on experience with Azure Data Lake Storage for scalable data storage and analytics.

- Knowledge of modern data warehousing tools such as Azure Synapse Analytics, Snowflake, or Redshift.

- Expertise in data pipeline design using tools like Azure Data Factory or Databricks.

- Familiarity with database monitoring and performance tuning tools in Azure.

- Strong scripting and query optimization skills using T-SQL, Python, or PowerShell.

Cloud Expertise :

- Deep understanding of Azure cloud services, including networking, storage, and security.

- Experience with Infrastructure as Code (IaC) tools such as Terraform or Bicep for provisioning resources.

Soft Skills :

- Strong problem-solving and analytical skills.

- Excellent communication and collaboration skills to work with cross-functional teams.

- Leadership and mentoring experience.

Preferred Skills :

- Experience with multi-cloud environments or hybrid cloud strategies.

- Familiarity with data visualization tools like Power BI or Tableau.

- Azure certifications such as Azure Data Engineer Associate, Azure Solutions Architect Expert, or Cosmos DB Specialist.