onsite
Principal Engineer,SQL Database
Engineer,SQL Database
Principal Engineer,SQL Database position — see original posting for full details.
About the role
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