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 No

SQL 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