Associate Principal Engineer, SQL Database at Nagarro1

REQUIREMENTS: • Total experience 9+ years • Strong experience in Data Architecture / Data Modeling / Database Design • Deep expertise in SQL Server (Must Have) and PostgreSQL (Must Have) • Hands-on experience in database normalization, schema design, and data modeling (conceptual, logical, physical) • Experience in performance tuning, query optimization, and indexing strategies • Strong understanding of multi-tenant data architecture and data isolation strategies • Experience with database change management, schema versioning, and CI/CD integration • Knowledge of data governance, naming conventions, and referential integrity standards • Experience with data security practices (SOC2, RBAC, encryption, audit logging) • Familiarity with data modeling tools (Erwin, DbSchema, or equivalent) • Experience working with cloud platforms (Azure preferred) • Understanding of ETL/ELT processes and data integration patterns • Familiarity with .NET data access technologies (Entity Framework, ADO.NET) • Strong collaboration skills with architects, developers, and cross-functional teams • Excellent problem-solving, documentation, and communication skillsRESPONSIBILITIES: • Design and implement scalable, normalized data architectures across SQL Server and PostgreSQL environments • Define and enforce enterprise data modeling standards, schema governance, and naming conventions • Develop and maintain canonical data models, ER diagrams, and data dictionaries • Identify and remediate legacy schema issues, driving migration to optimized and maintainable structures • Establish indexing strategies, query optimization standards, and performance tuning practices • Collaborate with software architects and engineering teams to align data architecture with application design • Design and enforce multi-tenant data isolation strategies for SaaS platforms • Integrate data security, compliance, and governance requirements into schema design • Implement and manage database change processes, including CI/CD pipeline integration • Analyze and define data access patterns to support scalable and low-latency systems • Evaluate and recommend tools for schema management, migration, and database evolution • Support microservices and API-driven architectures through well-designed data layers • Mentor developers on best practices in data modeling and database design • Ensure high availability, scalability, and performance of database systems • Drive continuous improvement in data architecture, governance, and engineering practices