What are the responsibilities and job description for the Azure SQL Data Architect position at Tandym?
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 :
Desired Skills :
Salary : $140,000
