AWS Databricks Architect

As a Data Architect you will be responsible for designing implementing and maintaining high performance database systems You will work closely with crossfunctional teams to develop data solutions that meet business needs Your expertise in both SQL and NoSQL databases along with your experience in ETL processes and cloud services will be crucial in driving our data architecture forward Key Responsibilities - Design and implement highperformance 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 longterm 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 handson 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 onpremises 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 - Reengineer existing databases based on load requirements and implement performance improvements - Document database designs ER diagrams and publish functional domain documentation - 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 - Expertise in reengineering existing databases to enhance performance based on load analysis - Strong understanding of data schema design and ACID principles - Handson experience with SQL and NoSQL database implementations particularly with MongoDB - Good understanding with security best practices and user management in database systems - Cloud and Integration - Good understanding of AWS cloud services related to database management - Experience with PaaS SaaS and IaaS concepts in both onpremises and cloud environments - Qualifications - 1520 years of experience in data architecture database design and implementation - Strong experience with ETL processes and data integration using SaaS services - Proficiency in reporting and analytics tools such as Power BI Qlik and Crystal Reports - Strategic mindset with the ability to develop and execute long term data strategies - Excellent communication and leadership skills with the ability to direct teams effectively