Data Architect

As a Data Architect, you will be responsible for designing, implementing, and maintaining high-performance database systems. You will work closely with cross-functional teams to develop data solutions that meet business needs and support MMC Tech long-term data strategy. 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 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.

Requirements

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.

Desired Skills

• 15-20 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.

Education & Certifications:

B.Tech/M.Tech/MCA