Azure SQL Data Architect

A property management firm in New York City is looking to fill an immediate Remote need with the addition of a new Azure SQL Data Architect. Responsibilities: Design and maintain the data architecture, ensuring compliance with data-related policies and standards Analyze system integration challenges related to data and propose effective solutions Create Roadmaps for modernization of legacy data platforms Design, develop, and maintain SQL databases and ensure high levels of data availability Write optimized SQL queries for integration with applications and reporting Develop, implement, and optimize stored procedures and functions using T-SQL Analyze, design, and create database objects (tables, views, indexes, etc.) Collaborate with software developers, system administrators, and data analysts to meet project requirements Design and implement ETL processes to transform and load data between different environments and systems Administer and maintain Azure SQL databases, ensuring data integrity, security, and performance tuning Manage and monitor database performance and troubleshoot issues Automate tasks related to database management using Azure DevOps and other automation tools Work with Azure Data Factory, Azure Synapse, and other data-related services to implement end-to-end data pipelines Implement data security best practices in Azure, including data encryption, access management, and backup solutions Qualifications: 5+ years of experience in Data Management and Technology Proficiency in Azure data services, including Azure SQL, Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, and other related technologies Proficiency in migration from on-prem legacy SQL to Azure PaaS SQL Knowledge of migration technologies for SQL as well as workload migration Strong experience with Azure SQL Database, Azure Data Factory, and Azure DevOps Hands-on experience with database performance tuning, query optimization, and indexing Experience with cloud technologies and deploying databases in Microsoft Azure Familiarity with CI/CD pipelines and automated deployments in Azure environments Knowledge of Data Security principles and practices, especially in Cloud environments Desired Skills: Experience building and continually improving governance processes and tools Seniority level Mid-Senior level Employment type Full-time Job function Information Technology #J-18808-Ljbffr

Created: 2025-03-07