Database Architect​/Data Modeler; Onsite

We are seeking an experienced Database Architect / Data Modeler to design, implement, and maintain scalable and efficient database systems while creating robust data models that align with organizational needs. The ideal candidate will have a deep understanding of database technologies, data architecture, data modeling principles, data security and business requirements, particularly in SQL-based database systems and .NET application modernization initiatives, ensuring data is stored, structured, and accessed optimally.

• Design and implement robust and scalable database systems to support application and business needs.
• Establish standards for database design, access, and maintenance.
• Define and implement data security protocols, backup strategies, and disaster recovery plans.
• Evaluate and implement database technologies for structured and unstructured data (e.g., SQL, No
  
  SQL, Azure Datastore).
• Define and optimize database schemas, indexes, and partitioning strategies.
• Optimize database performance, scalability, and reliability.
• Define the overall structure for how data is collected, stored, and accessed as per enterprise-wide data strategies and governance policies.
• Develop data integration workflows and pipelines.
• Ensure compliance with data privacy (PII) and security regulations (e.g., GDPR, CCPA).
• Establish data quality standards and validation processes.

• Create conceptual, logical, and physical data models to meet business and technical requirements.
• Conduct detailed Fit-Gap analysis on data models to identify discrepancies between current and target states.
• Optimize existing data models to enhance performance and scalability within SQL databases.
• Design and maintain entity-relationship (ER) diagrams, metadata repositories, data dictionaries and definitions.
• Define data relationships, primary/foreign keys, and constraints to ensure integrity.
• Collaborate with stakeholders to align data models with reporting and analytical needs.

• Design the architecture focused on modernizing legacy .NET systems and leveraging Azure services (e.g., Azure SQL, Azure Cosmos DB, ADLS, and Azure functions etc.).
• Design and deploy solutions in cloud-based environments using best practices.
• Monitor and troubleshoot Azure data workflows to ensure reliability and efficiency.

• Technical Skills
  • Must Have
  • Minimum 10 years of experience with 5+ years of experience in database design, data architecture, and data modeling.
  • Hands-on experience with relational and No
    
    SQL databases (e.g., MySQL, Postgre
    
    SQL, Mongo
    
    DB).
  • Proficiency with data modeling tools (e.g., ERwin, ER/Studio, Power Designer, Visio).
  • Strong knowledge of SQL, database design principles, and optimization techniques including performance tuning.
  • Expertise in data integration tools (e.g., Talend, Apache Kafka, Informatica).
  • Hands-on experience with Azure SQL, Data Factory, Synapse, and related services.
  • Prior experience in Agile/Scrum development methodologies is mandatory - sprint planning, stand-ups, and retrospectives.
  • Familiar with Azure Dev Ops and other Azure services.
  • Proficiency in creating and presenting documentation, diagrams, and reports.
• Nice to have
  • Familiarity with big data and data warehouse technologies (e.g., Hadoop, Spark, Redshift, Big Query) and ETL processes.
  • Familiarity with cloud data platforms (e.g., Snowflake, AWS Redshift, Azure SQL).
  • Knowledge of data governance frameworks and regulatory compliance.
  • Proficiency in scripting languages (e.g., Python, Shell) for automation and ETL processes.
• Soft Skills
  • Strong communication, interpersonal and stakeholder management skills.
  • Ability to work with cross-functional teams and drive consensus.
  • Strong analytical and problem-solving skills.
  • Work effectively in an onshore-offshore model, facilitating seamless collaboration and communication.
  • Ability to provide technical guidance and mentor junior team members.