Design and implement scalable, normalized data architectures across SQL Server and PostgreSQL environments
Define and enforce enterprise data modeling standards, schema governance, and naming conventions
Develop and maintain canonical data models, ER diagrams, and data dictionaries
Identify and remediate legacy schema issues, driving migration to optimized and maintainable structures
Establish indexing strategies, query optimization standards, and performance tuning practices
Collaborate with software architects and engineering teams to align data architecture with application design
Design and enforce multi-tenant data isolation strategies for SaaS platforms
Integrate data security, compliance, and governance requirements into schema design
Implement and manage database change processes, including CI/CD pipeline integration
Analyze and define data access patterns to support scalable and low-latency systems
Evaluate and recommend tools for schema management, migration, and database evolution
Support microservices and API-driven architectures through well-designed data layers
Mentor developers on best practices in data modeling and database design
Ensure high availability, scalability, and performance of database systems
Drive continuous improvement in data architecture, governance, and engineering practices

Total experience 9+ years
Strong experience in Data Architecture / Data Modeling / Database Design
Deep expertise in SQL Server (Must Have) and PostgreSQL (Must Have)
Hands-on experience in database normalization, schema design, and data modeling (conceptual, logical, physical)
Experience in performance tuning, query optimization, and indexing strategies
Strong understanding of multi-tenant data architecture and data isolation strategies
Experience with database change management, schema versioning, and CI/CD integration
Knowledge of data governance, naming conventions, and referential integrity standards
Experience with data security practices (SOC2, RBAC, encryption, audit logging)
Familiarity with data modeling tools (Erwin, DbSchema, or equivalent)
Experience working with cloud platforms (Azure preferred)
Understanding of ETL/ELT processes and data integration patterns
Familiarity with .NET data access technologies (Entity Framework, ADO.NET)
Strong collaboration skills with architects, developers, and cross-functional teams
Excellent problem-solving, documentation, and communication skills.

Associate Principal Engineer, SQL Database

Key skills