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 troubleshooting 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