Data Architect MNR Solutions Pvt Ltd

About MNR Solutions Pvt Ltd

Job Description

• 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 highperformance schema design using both bottomup and topdown 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 longterm data strategies
  Excellent communication and leadership skills with the ability to direct teams effectively