Principal Engineer,SQL Database

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.

Bachelor’s or master’s degree in