Job Title: 80616 - Data Architect/Developer
Job Location: Boston MA 02210
Onsite Requirements:
- Proficiency in T-SQL scripting for creating complex stored procedures and queries. Hands-on experience with Azure services, including Azure Data Factories, Data Lakes, Data Bricks, SQL Server Managed Instance, and Azure Storage.
- Proven experience as a Database Architect/Developer with a minimum of 8 years in database design and development.
Job Description:
- Softworld client is seeking a Database Architect/Developer.
- The ideal candidate should possess a strong background in data modeling, RDMS, and data warehousing, along with extensive experience in creating and optimizing database structures and stored procedures using T-SQL.
- Proficiency in working with Azure services, particularly Azure Data Factories, Data Lakes, Data Bricks, SQL Server Managed Instance, and Azure Storage, is essential for this role.
SUMMARY OF RESPONSIBILITIES:
- Design and implement robust data models, relational database schemas, and data warehouses.
- Develop and deploy complex stored procedures, tables, views, functions, triggers, indexes, constraints, and sequences using T-SQL.
- Utilize Azure services for data-related tasks, including data ingestion, processing, and storage.\
- Collaborate with developers to provide necessary database support and guidance for their projects.
- Conduct comprehensive database reviews for development projects, ensuring adherence to standards and best practices.
- Experience with Microsoft infrastructures, including Azure resources, MS SQL Server (2014/2017/2019).
- Collaborate with stakeholders to understand business requirements and translate them into robust and scalable database architecture designs on the Azure Cloud platform.
- Lead the end-to-end database solution development lifecycle, including data modeling, data flow design,
- ETL processes, and database schema design.
- Utilize Azure Data Lakes and Data Warehouses to architect modern data storage solutions that enable efficient data ingestion, processing, and retrieval for analytical purposes.
- Evaluate and recommend appropriate data storage and database technologies within the Azure ecosystem to optimize performance and cost-efficiency.
- Design and implement data security and access controls to ensure data integrity and compliance with industry regulations.
- Work with the Data Governance team to develop strategies and best practices to maintain data quality and consistency across different databases and applications.
- Work closely with data engineers, data scientists, and other teams to ensure seamless integration of data sources and enable advanced analytics and reporting capabilities.
- Optimize database performance by fine-tuning queries, indexes, and configurations, and proactively monitor and address performance bottlenecks.
- Work with the system engineers to recommend and implement disaster recovery and backup strategies to ensure high availability and data resiliency.
- Stay up to date with the latest advancements in Azure Cloud database tools and recommend appropriate enhancements or migrations to improve the overall database architecture.
QUALIFICATIONS:
- Bachelor's degree in computer science, Information Technology, or a related field.
- Proven experience as a Database Architect/Developer with a minimum of 8 years in database design and development.
- Strong expertise in data modeling, relational databases, and data warehousing concepts.
- Proficiency in T-SQL scripting for creating complex stored procedures and queries.
- Hands-on experience with Azure services, including Azure Data Factories, Data Lakes, Data Bricks, SQL
- Server Managed Instance, and Azure Storage.
- Familiarity with Azure Cosmos is a plus.
- Ability to optimize database performance through code and structural improvements.
- Experience with ETL processes and data movement between databases.
- Knowledge of C# programming is a plus and may be beneficial in certain project contexts.
- Familiarity with Business Intelligence (BI) tools will be advantageous for integrating data analysis and visualization capabilities.
- Experience with Microsoft infrastructures, including Azure resources, MS SQL Server
- A proactive problem-solving attitude with the ability to troubleshoot and resolve database issues efficiently.
- Strong communication skills and the ability to work collaboratively in a team environment.
- Demonstrated adherence to best practices in database design, development, and management.