Data Architect - ETL

Description : Responsibilities :

• Design and implement high-performance database configurations using Microsoft SQL Server and MongoDB.
• Develop and manage ETL processes with SaaS services, data lakes, and data sources such as Dremio and Databricks.
• Collaborate with reporting and analytics teams to integrate systems like Power BI, Qlik, and Crystal Reports.
• Provide strategic direction for long-term data strategy and architecture.
• Understand and implement AWS cloud services related to database management.
• Identify and implement performance fixes and scalability solutions for existing systems.
• Troubleshoot and resolve performance issues in database systems.
• Develop and maintain data schemas while ensuring compliance with ACID rules.
• Lead hands-on implementation of both SQL Server and MongoDB.
• Optimize system performance and provide recommendations for improvements.
• Understand and implement PaaS, SaaS, and IaaS solutions in both on-premises and cloud environments.
• Manage security, user roles, and access controls within database systems.
• Provide guidance and direction to teams on data strategy and architecture best practices.
• Re-engineer existing databases based on load requirements and implement performance improvements.
• Document database designs, ER diagrams, and publish functional domain :
• Key Skills : Microsoft SQL Server Expertise.
• Proficient in writing and optimizing stored procedures, triggers, and complex queries.
• Strong understanding of indexes and their impact on performance.
• Ability to analyze and optimize execution plans for query performance.
• Experience in high-performance schema design using both bottom-up and top-down approaches.

Database Design and Performance :

Cloud and Integration :

(ref : hirist.tech)