Associate Principal Engineer, SQL Database

REQUIREMENTS:

• 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 data access technologies (Entity Framework )
• Strong collaboration skills with architects developers and cross-functional teams
• Excellent problem-solving documentation and communication skills

RESPONSIBILITIES:

• 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

Qualifications :

Bachelors or masters degree in computer science Information Technology or a related field

Remote Work :

Yes

Employment Type :

Full-time