Job Description
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 wit
