Principal Engineer, SQL Database

This is a fully remote position, open to applicants in India.

📋 Description

• Guide the evaluation, design, and execution of normalized data architectures within SQL Server and PostgreSQL settings.

• Establish and uphold enterprise data modeling standards, schema governance, naming conventions, and practices for referential integrity.

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

• Detect and resolve legacy schema challenges, facilitating the transition to scalable and maintainable database structures.

• Develop indexing strategies, standards for query optimization, and best practices for performance tuning.

• Partner with Software Architects and engineering teams to ensure data architecture aligns with application and integration designs.

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

• Incorporate security, compliance, and governance requirements into database and schema designs.

• Establish and oversee processes for database change management, schema versioning, and CI/CD-driven deployments.

• Examine application and business data access patterns to support scalable, low-latency architectures.

• Assess and propose tools, frameworks, and best practices for schema management and database modernization.

• Facilitate support for microservices and API-driven architectures through effective data layer design.

• Offer technical leadership and guidance on database design and best practices in data modeling.

• Ensure the scalability, maintainability, performance, and reliability of enterprise database systems.

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

⛳️ Requirements

• A minimum of 11 years of total experience.

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

• Extensive expertise in SQL Server (Required) and PostgreSQL (Required).

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

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

• Experienced in designing and governing enterprise data models, naming conventions, and standards for referential integrity.

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

• Knowledge of database change management, schema versioning, migration scripting, and CI/CD integration.

• Familiarity with data security and compliance standards including SOC2, RBAC, encryption protocols, and audit logging.

• Experience with data modeling tools like Erwin, DbSchema, or similar.

• Understanding of ETL/ELT processes and data integration methodologies.

• Experience working alongside Software Architects and development teams in enterprise software or SaaS environments.

• Knowledge of .NET data access technologies such as Entity Framework and ADO.NET.

• Familiarity with cloud platforms, preferably Azure.

• Strong skills in communication, documentation, problem-solving, and stakeholder management.

🏝️ Benefits

• Competitive salary and performance-based bonuses.

• Comprehensive health, dental, and vision insurance.

• Generous paid time off and flexible working hours.

• Opportunities for professional development and career advancement.

• Collaborative and innovative work environment.