Database Architect (Remote)

Tasks

• Collaborate with engineering product and analysts on data models
• Define and enforce database standards and best practices
• Define data modeling standards
• Define data pipelines for reporting
• Design and maintain database schemas
• Design and manage Snowflake data models
• Ensure data accuracy, consistency, and reliability
• Ensure high availability and disaster recovery
• Ensure transactional and analytical data consistency
• Establish data governance for quality and lineage
• Implement data validation rules constraints and relationships
• Implement indexing and data access improvements
• Maintain documentation of schemas data models and data flows
• Monitor and resolve performance bottlenecks
• Optimize database and warehouse query performance
• Plan for scalability partitioning replication and scaling
• Support backup restore and failover
• Track schema and warehouse changes over time

Perks/Benefits

• Attendance bonus
• Company-provided equipment
• HMO coverage
• Paid time off
• Training and career growth

Skills/Tech-stack

AWS | Data Governance | Data Integrity | Data Lineage | Data Modeling | Data Pipelines | Data Quality | Data Warehousing | Database monitoring | Database performance | Database performance tuning | Disaster Recovery | ELT | ETL | High Availability | Indexing | Partitioning | Performance Tuning | PostgreSQL | Query Optimization | Replication | SQL | SQL Server | Snowflake