MS SQL + MongoDB + AWS

Key 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 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 re-engineering existing databases to enhance performance based on load analysis.
•             Strong understanding of data schema design and ACID principles.
•             Hands-on 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 on-premises and cloud environments.
Qualifications: •             9-14 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