Associate Principal Engineer, SQL Database

📋 Description

• Create and execute scalable, normalized data architectures across SQL Server and PostgreSQL environments.

• Establish and uphold enterprise data modeling standards, schema governance, and naming conventions.

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

• Identify and resolve legacy schema challenges, facilitating migration to optimized and maintainable structures.

• Formulate indexing strategies, query optimization standards, and performance tuning practices.

• Collaborate with software architects and engineering teams to ensure data architecture aligns with application design.

• Design and implement multi-tenant data isolation strategies for SaaS platforms.

• Integrate data security, compliance, and governance requirements into schema design.

• Execute and manage database change processes, including CI/CD pipeline integration.

• Analyze and define data access patterns to support scalable and low-latency systems.

• Assess and recommend tools for schema management, migration, and database evolution.

• Support microservices and API-driven architectures through well-structured data layers.

• Mentor developers on best practices for data modeling and database design.

• Ensure high availability, scalability, and performance of database systems.

• Promote continuous improvement in data architecture, governance, and engineering practices.

⛳️ Requirements

• Minimum of 9 years of total experience.

• Extensive experience in Data Architecture, Data Modeling, and Database Design.

• Profound expertise in SQL Server (essential) and PostgreSQL (essential).

• Practical experience in database normalization, schema design, and data modeling (conceptual, logical, physical).

• Experience in performance tuning, query optimization, and indexing strategies.

• Strong knowledge of multi-tenant data architecture and data isolation strategies.

• Experience with database change management, schema versioning, and CI/CD integration.

• Familiarity with data governance, naming conventions, and standards of referential integrity.

• Experience with data security practices (SOC2, RBAC, encryption, audit logging).

• Knowledge of data modeling tools (such as 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 abilities.

🏝️ Benefits

• Competitive salary and performance-based bonuses.

• Comprehensive health, dental, and vision insurance.

• Flexible working hours and remote work options.

• Opportunities for professional development and training.

• Supportive and inclusive work environment.