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

• 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