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