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
We are a Digital Product Engineering company that is scaling in a big way! We build products, services, and experiences that inspire, excite, and delight. We work at scale across all devices and digital mediums, and our people exist everywhere in the world (17700+ experts across 39 countries, to be exact). Our work culture is dynamic and non-hierarchical. We are looking for great new colleagues. That is where you come in!
Originally posted on Himalayas