Principal Engineer,SQL Database

Job description

Company Description 👋🏼 We're Nagarro. We are a Digital Product Engineering company that is scaling in a big way! We build products, services, and experiences that inspire, excite, and delight. We work at scale across all devices and digital mediums, and our people exist everywhere in the world (18000+ experts across 39 countries, to be exact). Our work culture is dynamic and non-hierarchical. We're looking for great new colleagues. That's where you come in! Job Description REQUIREMENTS: • Total experience 11+ years. • Strong experience in Data Architecture, Data Modeling, and Database Design. • Deep expertise in SQL Server (Must Have) and PostgreSQL (Must Have). • Hands-on experience in database normalization, schema design, and conceptual, logical, and physical data modeling. • Strong experience in performance tuning, query optimization, and indexing strategies. • Experience designing and governing enterprise data models, naming conventions, and referential integrity standards. • Strong understanding of multi-tenant data architecture and data isolation strategies. • Experience with database change management, schema versioning, migration scripting, and CI/CD integration. • Familiarity with data security and compliance requirements including SOC2, RBAC, encryption standards, and audit logging. • Experience with data modeling tools such as Erwin, DbSchema, or equivalent. • Understanding of ETL/ELT processes and data integration patterns. • Experience collaborating with Software Architects and development teams in enterprise software or SaaS environments. • Familiarity with .NET data access technologies such as Entity Framework and ADO.NET. • Experience with cloud platforms, preferably Azure. • Strong communication, documentation, problem-solving, and stakeholder management skills. RESPONSIBILITIES: • Lead the assessment, design, and implementation of normalized data architectures across SQL Server and PostgreSQL environments. • Define and enforce enterprise data modeling standards, schema governance, naming conventions, and referential integrity practices. • Develop and maintain canonical data models, ER diagrams, and data dictionaries. • Identify and remediate legacy schema issues, driving migration to scalable and maintainable database structures. • Establish indexing strategies, query optimization standards, and performance tuning best practices. • Collaborate with Software Architects and engineering teams to align data architecture with application and integration designs. • Design and enforce multi-tenant data isolation strategies across SaaS platforms. • Integrate security, compliance, and governance requirements into database and schema designs. • Implement and manage database change management processes, schema versioning, and CI/CD-driven deployments. • Analyze application and business data access patterns to support scalable, low-latency architectures. • Evaluate and recommend tools, frameworks, and best practices for schema management and database modernization. • Support microservices and API-driven architectures through robust data layer design. • Provide technical leadership and mentorship on database design and data modeling best practices. • Ensure scalability, maintainability, performance, and reliability of enterprise database systems. • Drive continuous improvement initiatives in data architecture, governance, and engineering practices. Qualifications Bachelor’s or master’s degree in computer science, Information Technology, or a related field Additional Information Videos To Watch