Principal Engineer, Database SQL at Nagarro1

Job Description • Total experience: 9+ years • Strong expertise in SQL Server and PostgreSQL with excellent database design and problem-solving skills. • Hands-on experience in building scalable normalized data architectures across enterprise systems. • Strong experience in schema design, database normalization, and relational data modeling. • Experience in designing and developing enterprise-grade database solutions with high performance and scalability. • Strong understanding of query optimization, indexing strategies, and performance tuning. • Experience with multi-tenant SaaS architectures and enterprise customer data isolation strategies. • Strong knowledge of data modeling methodologies (conceptual, logical, and physical). • Experience with database migration, schema refactoring, and legacy system modernization. • Experience with schema versioning, migration scripting, and CI/CD-based database deployments. • Familiarity with data security standards including SOC 2, encryption, RBAC, and audit logging. • Experience collaborating with Software Architects and development teams on API-driven and microservices-based systems. • Familiarity with ETL/ELT processes and cross-product data integration strategies. • Experience with cloud platforms like Azure (preferred). • Familiarity with .NET ecosystem technologies (Entity Framework, ADO.NET) is a plus. • Strong debugging, analytical, documentation, and communication skills. • Ability to collaborate with cross-functional and distributed teams.RESPONSIBILITIES: • Design, assess, and implement scalable normalized data architectures across SQL Server and PostgreSQL environments. • Define and enforce enterprise data modeling standards, naming conventions, schema governance, and referential integrity practices. • Collaborate closely with Software Architects and Engineering teams on system design and architecture decisions. • Develop and maintain canonical data models, ER diagrams, and data dictionaries. • Identify and remediate structural technical debt in legacy database schemas. • Design and optimize indexing strategies, query access patterns, and database performance. • Implement secure multi-tenant data isolation strategies for SaaS platforms. • Ensure data security, compliance, encryption, RBAC, and audit logging standards are followed. • Implement best practices for schema versioning, migration scripting, CI/CD, and database monitoring. • Work closely with Engineering, Product, DevOps, and Architecture teams. • Manage and optimize database scalability, reliability, and maintainability. • Troubleshoot complex database issues and perform root cause analysis. • Mentor developers and provide technical leadership on data modeling and database design best practices. • Ensure high standards of performance, security, and data quality.