Principal Engineer, SQL Database

Role Overview

• 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 (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.

Tech Stack

• Azure
• Cloud
• Entity Framework
• ETL
• Microservices
• Postgres
• SQL
• .NET