Principal Engineer, SQL Database

Seeking an experienced Data Architect with over 11 years of expertise in data modeling, database design, and enterprise data architecture, particularly in SQL Server and PostgreSQL environments. The role involves leading data architecture initiatives, ensuring compliance, and collaborating with cross-functional teams in a SaaS or enterprise setting.

Location: India

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.

Requirements

• Total experience 11+ years.
• Strong experience in Data Architecture, Data Modeling, and Database Design.
• Deep expertise in SQL Server and PostgreSQL.
• Hands-on experience in database normalization, schema design, and data modeling.
• Experience in performance tuning, query optimization, and indexing strategies.
• Experience designing and governing enterprise data models, naming conventions, and referential integrity standards.
• Understanding of multi-tenant data architecture and data isolation strategies.
• Experience with database change management, schema versioning, migration scripting, and CI/CD.
• Familiarity with data security and compliance including SOC2, RBAC, encryption, and audit logging.
• Experience with data modeling tools such as Erwin, DbSchema.
• Understanding of ETL/ELT processes and data integration patterns.
• Experience collaborating with Software Architects and development teams in enterprise or SaaS environments.
• Familiarity with .NET data access technologies like Entity Framework and ADO.NET.
• Experience with cloud platforms, preferably Azure.
• Strong communication, documentation, problem-solving, and stakeholder management skills.