Principal Engineer, Database SQL

Job Description

• Total experience: 9 years
• Strong expertise in SQL Server and PostgreSQL with excellent database design and problem-solving skills.
• Hands-on experience in building scalable normalized data architectures across enterprise systems.
• Strong experience in schema design database normalization and relational data modeling.
• Experience in designing and developing enterprise-grade database solutions with high performance and scalability.
• Strong understanding of query optimization indexing strategies and performance tuning.
• Experience with multi-tenant SaaS architectures and enterprise customer data isolation strategies.
• Strong knowledge of data modeling methodologies (conceptual logical and physical).
• Experience with database migration schema refactoring and legacy system modernization.
• Experience with schema versioning migration scripting and CI/CD-based database deployments.
• Familiarity with data security standards including SOC 2 encryption RBAC and audit logging.
• Experience collaborating with Software Architects and development teams on API-driven and microservices-based systems.
• Familiarity with ETL/ELT processes and cross-product data integration strategies.
• Experience with cloud platforms like Azure (preferred).
• Familiarity ecosystem technologies (Entity Framework ) is a plus.
• Strong debugging analytical documentation and communication skills.
• Ability to collaborate with cross-functional and distributed teams.

RESPONSIBILITIES:

• Design assess and implement scalable normalized data architectures across SQL Server and PostgreSQL environments.
• Define and enforce enterprise data modeling standards naming conventions schema governance and referential integrity practices.
• Collaborate closely with Software Architects and Engineering teams on system design and architecture decisions.
• Develop and maintain canonical data models ER diagrams and data dictionaries.
• Identify and remediate structural technical debt in legacy database schemas.
• Design and optimize indexing strategies query access patterns and database performance.
• Implement secure multi-tenant data isolation strategies for SaaS platforms.
• Ensure data security compliance encryption RBAC and audit logging standards are followed.
• Implement best practices for schema versioning migration scripting CI/CD and database monitoring.
• Work closely with Engineering Product DevOps and Architecture teams.
• Manage and optimize database scalability reliability and maintainability.
• Troubleshoot complex database issues and perform root cause analysis.
• Mentor developers and provide technical leadership on data modeling and database design best practices.
• Ensure high standards of performance security and data quality.

Qualifications :

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

Remote Work :

Yes

Employment Type :

Full-time