Principal Engineer, Database SQL

📋 Description

• Design, evaluate, and implement scalable normalized data architectures.

• Establish and uphold enterprise data modeling standards.

• Work closely with Software Architects and Engineering teams.

• Create and maintain canonical data models, ER diagrams, and data dictionaries.

• Identify and address structural technical debt.

• Design and enhance indexing strategies, query access patterns, and database performance.

• Implement secure multi-tenant data isolation strategies.

• Ensure adherence to data security, compliance, encryption, RBAC, and audit logging standards.

• Apply best practices for schema versioning, migration scripting, CI/CD, and database monitoring.

• Oversee and enhance database scalability, reliability, and maintainability.

• Troubleshoot complex database issues and conduct root cause analysis.

• Mentor developers and deliver technical leadership on best practices.

• Maintain high standards for performance, security, and data quality.

⛳️ Requirements

• Total experience: 9+ years.

• Strong expertise in SQL Server and PostgreSQL.

• Exceptional database design and problem-solving abilities.

• Practical experience in constructing scalable normalized data architectures.

• Significant experience in schema design, database normalization, and relational data modeling.

• Experience in the design and development of enterprise-grade database solutions.

• Strong grasp of query optimization, indexing strategies, and performance tuning.

• Experience with multi-tenant SaaS architectures.

• Comprehensive knowledge of data modeling methodologies.

• Experience with database migration, schema refactoring, and modernizing legacy systems.

• Familiarity with data security standards.

• Experience collaborating with Software Architects and development teams.

• Familiarity with ETL/ELT processes.

• Experience with cloud platforms such as Azure.

• Strong skills in debugging, analysis, documentation, and communication.

• Ability to collaborate effectively with cross-functional and distributed teams.

🏝️ Benefits

• Employees can work remotely.