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 with .NET ecosystem technologies (Entity Framework, ADO.NET) 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.

Bachelor’s or master’s degree in computer science, Information Technology, or a related fields