Data Architect

We at Innovecture are hiring for a Data Architect to expand our team, this will be in Gurgaon or Noida. You will work across various Innovecture and client teams and apply your technical expertise to some of the most complex and challenging technology problems.

About Innovecture:

Founded in 2007 under the leadership of CEO Shreyas Kamat, Innovecture LLC, began as a U.S.-based Information Technology and Management Consulting Company focusing on technology consulting and services. With international development centers located in Salt Lake City, USA, and Pune, India, Innovecture leverages its Global Agile Delivery Model to effectively deliver client projects within budget scope and project deadline. The primary focus of Innovecture is to provide a unique wealth of expertise and experience to the IT and Management Consulting realm by utilizing various technologies across multiple industry domains. Innovecture uses best-in-class design processes and top-quality talent to ensure the highest quality deliverables. With innovation embedded in its consulting and services approach, Innovecture will continue to deliver outstanding results for its Fortune 500 clients and employees.

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:

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